contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax_phylum = "Mucoromycota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5738475 | 5738475 | PRJNA669701_P_NODE_113565_length_249_cov_1.681818_g113170_i0 | PRJNA669701 | 113565 | 249 | 1.681818 | 4.18772682 | Rhizophagus irregularis DAOM 197198w | 1432141 | Fungi | Fungi | 121 | 1.13e-32 | NR | EXX72708.1 | 1432141 | g113170 | i0 | 69.9 | 2 | 83 | 23 | 100 | 1 | 249 | 1 | 88 | 168 | EXX72708.1 Rpb7p [Rhizophagus irregularis DAOM 197198w] | diamond | 498 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 19762597 | 19762597 | PRJNA669701_P_NODE_33196_length_408_cov_2.026866_g32801_i0 | PRJNA669701 | 33196 | 408 | 2.026866 | 8.26961328 | Zychaea mexicana | 64656 | Fungi | Fungi | 80.9 | 9.83e-15 | NR | XP_052976334.1 | 64656 | g32801 | i0 | 43.4 | 4.71323529411765 | 99 | 46 | 72.8 | 2 | 311 | 15 | 362 | 450 | XP_052976334.1 P-loop containing nucleoside triphosphate hydrolase protein [Zychaea mexicana] | diamond | 1923 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 27113071 | 27113071 | PRJNA669701_P_NODE_149262_length_205_cov_6.659091_g148867_i0 | PRJNA669701 | 149262 | 205 | 6.659091 | 13.65113655 | Entrophospora sp. SA1 | 1920922 | Fungi | Fungi | 42.4 | 0.00521 | NR | CAJ0837394.1 | 2562287 | g148867 | i0 | 51.9 | 0.936585365853659 | 27 | 13 | 39.5 | 0 | 200 | 120 | 27 | 53 | CAJ0837394.1 7784_t:CDS:2, partial [Entrophospora sp. SA101] | diamond | 192 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora sp. SA101 | |
| 27156508 | 27156508 | PRJNA669701_P_NODE_85462_length_275_cov_2.277228_g85067_i0 | PRJNA669701 | 85462 | 275 | 2.277228 | 6.262377 | root | 1 | Root_unresolved | Root_unresolved | 77.4 | 6.28e-15 | NR | KAG2172719.1 | 91625 | g85067 | i0 | 44 | 7.96363636363636 | 91 | 50 | 99.3 | 1 | 2 | 274 | 131 | 220 | KAG2172719.1 hypothetical protein INT43_000066 [Umbelopsis isabellina] | diamond | 2190 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 27630886 | 27630886 | PRJNA669701_P_NODE_50484_length_339_cov_0.868421_g50089_i0 | PRJNA669701 | 50484 | 339 | 0.868421 | 2.94394719 | Eukaryota | 2759 | Fungi | Fungi | 96.3 | 7.340000000000001e-21 | NR | KAF0463799.1 | 4874 | g50089 | i0 | 45.1 | 12.9026548672566 | 113 | 60 | 99.1 | 2 | 2 | 337 | 195 | 306 | KAF0463799.1 PCI-domain-containing protein [Gigaspora margarita] | diamond | 4374 | 96.7 | 0.995863495346432 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 27713854 | 27713854 | PRJNA669701_P_NODE_41424_length_369_cov_0.770270_g41029_i0 | PRJNA669701 | 41424 | 369 | 0.77027 | 2.8422963 | Mortierella claussenii | 1343614 | Fungi | Fungi | 46.2 | 0.00878 | NR | KAI1320976.1 | 1343614 | g41029 | i0 | 47.3 | 1.26016260162602 | 55 | 24 | 43.1 | 2 | 172 | 14 | 37 | 88 | KAI1320976.1 hypothetical protein EDD11_009299 [Mortierella claussenii] | diamond | 465 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella claussenii | |
| 27839549 | 27839549 | PRJNA669701_P_NODE_140144_length_241_cov_1.904762_g139749_i0 | PRJNA669701 | 140144 | 241 | 1.904762 | 4.59047642 | Gongronella butleri | 101105 | Fungi | Fungi | 112 | 1.12e-26 | NR | KAI8062694.1 | 101105 | g139749 | i0 | 65 | 1.9792531120332 | 80 | 28 | 99.6 | 0 | 1 | 240 | 67 | 146 | KAI8062694.1 indole-3-glycerol phosphate synthase-domain-containing protein [Gongronella butleri] | diamond | 477 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Gongronella | Gongronella butleri | |
| 27902695 | 27902695 | PRJNA669701_P_NODE_144585_length_236_cov_2.736196_g144190_i0 | PRJNA669701 | 144585 | 236 | 2.736196 | 6.45742256 | Entrophospora candida | 984092 | Fungi | Fungi | 47.8 | 5.85e-4 | NR | CAG8581682.1 | 984092 | g144190 | i0 | 44.2 | 1.09322033898305 | 43 | 24 | 54.7 | 0 | 234 | 106 | 552 | 594 | CAG8581682.1 1987_t:CDS:10 [Entrophospora candida] | diamond | 258 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora candida | |
| 27997741 | 27997741 | PRJNA669701_P_NODE_110085_length_250_cov_2.615819_g109690_i0 | PRJNA669701 | 110085 | 250 | 2.615819 | 6.5395475 | Mortierella sp. 14UC | 1896178 | Fungi | Fungi | 42.4 | 0.0276 | NR | KAF9133577.1 | 1896178 | g109690 | i0 | 32.1 | 0.972 | 81 | 44 | 97.2 | 3 | 243 | 1 | 37 | 106 | KAF9133577.1 hypothetical protein BGW39_009430 [Mortierella sp. 14UC] | diamond | 243 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. 14UC | |
| 29323638 | 29323638 | PRJNA669701_P_NODE_71829_length_292_cov_1.940639_g71434_i0 | PRJNA669701 | 71829 | 292 | 1.940639 | 5.66666588 | Rhizophagus irregularis DAOM 197198w | 1432141 | Fungi | Fungi | 155 | 3.31e-45 | NR | EXX78763.1 | 1432141 | g71434 | i0 | 76.3 | 0.996575342465753 | 97 | 23 | 99.7 | 0 | 2 | 292 | 49 | 145 | EXX78763.1 hypothetical protein RirG_012220 [Rhizophagus irregularis DAOM 197198w] | diamond | 291 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 30283631 | 30283631 | PRJNA669701_P_NODE_71612_length_292_cov_6.114155_g71217_i0 | PRJNA669701 | 71612 | 292 | 6.114155 | 17.8533326 | Eukaryota | 2759 | Fungi | Fungi | 70.1 | 8.92e-13 | NR | XP_021883363.1 | 64571 | g71217 | i0 | 56.1 | 10.9417808219178 | 66 | 29 | 67.8 | 0 | 41 | 238 | 50 | 115 | XP_021883363.1 PDCD5-related protein [Lobosporangium transversale] | diamond | 3195 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 32168287 | 32168287 | PRJNA669701_P_NODE_142778_length_241_cov_0.916667_g142383_i0 | PRJNA669701 | 142778 | 241 | 0.916667 | 2.20916747 | Syncephalastrum racemosum | 13706 | Fungi | Fungi | 53.5 | 4.78e-6 | NR | ORY94180.1 | 13706 | g142383 | i0 | 46.8 | 1.99170124481328 | 79 | 40 | 98.3 | 1 | 239 | 3 | 73 | 149 | ORY94180.1 hypothetical protein BCR43DRAFT_477744 [Syncephalastrum racemosum] | diamond | 480 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum racemosum | |
| 32421280 | 32421280 | PRJNA669701_P_NODE_79479_length_282_cov_2.889952_g79084_i0 | PRJNA669701 | 79479 | 282 | 2.889952 | 8.14966464 | Funneliformis caledonium | 1117310 | Fungi | Fungi | 77 | 5.39e-14 | NR | CAG8620809.1 | 1117310 | g79084 | i0 | 40.9 | 0.936170212765957 | 88 | 52 | 93.6 | 0 | 1 | 264 | 570 | 657 | CAG8620809.1 2408_t:CDS:2 [Funneliformis caledonium] | diamond | 264 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis caledonium | |
| 32516360 | 32516360 | PRJNA669701_P_NODE_137279_length_242_cov_1.366864_g136884_i0 | PRJNA669701 | 137279 | 242 | 1.366864 | 3.30781088 | Rhizophagus irregularis DAOM 197198w | 1432141 | Fungi | Fungi | 116 | 1.17e-29 | NR | EXX79684.1 | 1432141 | g136884 | i0 | 71.3 | 0.991735537190083 | 80 | 23 | 99.2 | 0 | 241 | 2 | 24 | 103 | EXX79684.1 hypothetical protein RirG_003220 [Rhizophagus irregularis DAOM 197198w] | diamond | 240 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 32811680 | 32811680 | PRJNA669701_P_NODE_119900_length_247_cov_1.770115_g119505_i0 | PRJNA669701 | 119900 | 247 | 1.770115 | 4.37218405 | Fungi | 4751 | Fungi | Fungi | 89.4 | 1.58e-18 | NR | KAF9277334.1 | 64518 | g119505 | i0 | 55.4 | 47.5748987854251 | 74 | 33 | 89.9 | 0 | 246 | 25 | 754 | 827 | KAF9277334.1 serine/threonine-protein kinase HAL4/sat4 [Mortierella alpina] | diamond | 11751 | 90.1 | 0.992230854605993 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;