contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290094 | 290094 | PRJNA1146029_P_NODE_18941_length_246_cov_1.341040_g18660_i0 | PRJNA1146029 | 18941 | 246 | 1.34104 | 3.2989584 | Eukaryota | 2759 | Fungi | Fungi | 107 | 2.58e-26 | NR | KAL0080976.1 | 4837 | g18660 | i0 | 59.3 | 155.890243902439 | 81 | 33 | 98.8 | 0 | 244 | 2 | 153 | 233 | KAL0080976.1 P-loop containing nucleoside triphosphate hydrolase protein [Phycomyces blakesleeanus] | diamond | 38349 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 1564650 | 1564650 | PRJNA1146029_P_NODE_1202_length_813_cov_1.664865_g966_i0 | PRJNA1146029 | 1202 | 813 | 1.664865 | 13.53535245 | root | 1 | Root_unresolved | Root_unresolved | 397 | 3.17e-136 | NR | Q96UF1.1 | 29924 | g966 | i0 | 73.9 | 34 | 272 | 69 | 100 | 2 | 1 | 813 | 47 | 317 | Q96UF1.1 RecName: Full=Glyceraldehyde-3-phosphate dehydrogenase 3; Short=GAPDH 3 [Mucor lusitanicus] | diamond | 27642 | 401 | 0.99002493765586 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor lusitanicus | |
| 11768952 | 11768952 | PRJNA1146029_P_NODE_9550_length_295_cov_1.180180_g9269_i0 | PRJNA1146029 | 9550 | 295 | 1.18018 | 3.481531 | Mucorales | 4827 | Fungi | Fungi | 174 | 6.13e-51 | NR | XP_051422807.1 | 64574 | g9269 | i0 | 84 | 42.2135593220339 | 94 | 15 | 95.6 | 0 | 283 | 2 | 2 | 95 | XP_051422807.1 peptidyl-prolyl cis-trans isomerase D [Radiomyces spectabilis] | diamond | 12453 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 13043890 | 13043890 | PRJNA1146029_P_NODE_6011_length_359_cov_1.076923_g5733_i0 | PRJNA1146029 | 6011 | 359 | 1.076923 | 3.86615357 | Mucorales | 4827 | Fungi | Fungi | 110 | 7.29e-28 | NR | GAA5815844.1 | 439312 | g5733 | i0 | 58.8 | 7.91364902506964 | 97 | 36 | 81.1 | 1 | 3 | 293 | 37 | 129 | GAA5815844.1 hypothetical protein MFLAVUS_009360 [Mucor flavus] | diamond | 2841 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor flavus | |
| 23242465 | 23242465 | PRJNA1146029_P_NODE_18119_length_248_cov_0.880000_g17838_i0 | PRJNA1146029 | 18119 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | Fungi | Fungi | 82.4 | 3.2e-17 | NR | ORZ01536.1 | 13706 | g17838 | i0 | 63.2 | 5.51612903225806 | 57 | 21 | 69 | 0 | 6 | 176 | 148 | 204 | ORZ01536.1 hypothetical protein BCR43DRAFT_181949 [Syncephalastrum racemosum] | diamond | 1368 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum racemosum | |
| 27639435 | 27639435 | PRJNA1146029_P_NODE_12704_length_273_cov_2.280000_g12423_i0 | PRJNA1146029 | 12704 | 273 | 2.28 | 6.2244 | Gigaspora rosea | 44941 | Fungi | Fungi | 49.3 | 2.72e-4 | NR | RIB18321.1 | 44941 | g12423 | i0 | 54.1 | 2.03296703296703 | 37 | 17 | 40.7 | 0 | 4 | 114 | 556 | 592 | RIB18321.1 vault protein inter-alpha-trypsin domain-containing protein [Gigaspora rosea] | diamond | 555 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora rosea | |
| 27975433 | 27975433 | PRJNA1146029_P_NODE_21665_length_242_cov_0.911243_g21384_i0 | PRJNA1146029 | 21665 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Fungi | Fungi | 131 | 1.5e-34 | NR | RCH97612.1 | 4846 | g21384 | i0 | 72.5 | 18.8305785123967 | 80 | 22 | 99.2 | 0 | 241 | 2 | 155 | 234 | RCH97612.1 NAD-dependent isocitrate dehydrogenase, partial [Rhizopus stolonifer] | diamond | 4557 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 28164969 | 28164969 | PRJNA1146029_P_NODE_8825_length_306_cov_1.321888_g8544_i0 | PRJNA1146029 | 8825 | 306 | 1.321888 | 4.04497728 | Archaeosporales | 1133283 | Fungi | Fungi | 130 | 8.57e-33 | NR | KAG9305652.1 | 50956 | g8544 | i0 | 62.1 | 4.65686274509804 | 95 | 36 | 93.1 | 0 | 1 | 285 | 590 | 684 | KAG9305652.1 hypothetical protein G9A89_022574 [Geosiphon pyriformis] | diamond | 1425 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 28838966 | 28838966 | PRJNA1146029_P_NODE_17008_length_250_cov_0.870056_g16727_i0 | PRJNA1146029 | 17008 | 250 | 0.870056 | 2.17514 | Paraglomus occultum | 144539 | Fungi | Fungi | 52.8 | 1.28e-6 | NR | CAG8494296.1 | 144539 | g16727 | i0 | 45.5 | 0.528 | 44 | 24 | 52.8 | 0 | 173 | 42 | 60 | 103 | CAG8494296.1 1117_t:CDS:2 [Paraglomus occultum] | diamond | 132 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus occultum | |
| 30196786 | 30196786 | PRJNA1146029_P_NODE_11732_length_280_cov_1.212560_g11451_i0 | PRJNA1146029 | 11732 | 280 | 1.21256 | 3.395168 | Dissophora ornata | 979620 | Fungi | Fungi | 99.8 | 6.77e-24 | NR | KAI8605313.1 | 979620 | g11451 | i0 | 55.4 | 0.889285714285714 | 83 | 37 | 88.9 | 0 | 252 | 4 | 24 | 106 | KAI8605313.1 ammecr1 protein [Dissophora ornata] | diamond | 249 | 99.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Dissophora | Dissophora ornata | |
| 30470377 | 30470377 | PRJNA1146029_P_NODE_4873_length_392_cov_2.090909_g4595_i0 | PRJNA1146029 | 4873 | 392 | 2.090909 | 8.19636328 | Opisthokonta | 33154 | Fungi | Fungi | 193 | 1.39e-60 | NR | ORZ18059.1 | 90262 | g4595 | i0 | 74.6 | 43.7295918367347 | 130 | 33 | 99.5 | 0 | 2 | 391 | 4 | 133 | ORZ18059.1 60S ribosomal protein L12 [Absidia repens] | diamond | 17142 | 194 | 0.994845360824742 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia repens | |
| 31007362 | 31007362 | PRJNA1146029_P_NODE_20974_length_243_cov_0.905882_g20693_i0 | PRJNA1146029 | 20974 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.03e-5 | NR | RIA81677.1 | 658196 | g20693 | i0 | 53.5 | 2.93827160493827 | 43 | 20 | 53.1 | 0 | 151 | 23 | 5 | 47 | RIA81677.1 hypothetical protein C1645_836594 [Glomus cerebriforme] | diamond | 714 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Glomus | Glomus cerebriforme | |
| 31682223 | 31682223 | PRJNA1146029_P_NODE_14177_length_263_cov_1.621053_g13896_i0 | PRJNA1146029 | 14177 | 263 | 1.621053 | 4.26336939 | Parasitella parasitica | 35722 | Fungi | Fungi | 45.4 | 0.00486 | NR | CEP09563.1 | 35722 | g13896 | i0 | 37.5 | 0.547528517110266 | 48 | 30 | 54.8 | 0 | 239 | 96 | 46 | 93 | CEP09563.1 hypothetical protein [Parasitella parasitica] | diamond | 144 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Parasitella | Parasitella parasitica | |
| 32177684 | 32177684 | PRJNA1146029_P_NODE_17578_length_249_cov_0.875000_g17297_i0 | PRJNA1146029 | 17578 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 83.2 | 1.49e-16 | NR | KAG0220522.1 | 90253 | g17297 | i0 | 49.4 | 3.74698795180723 | 77 | 39 | 92.8 | 0 | 232 | 2 | 87 | 163 | KAG0220522.1 hypothetical protein BGW41_007884, partial [Actinomortierella wolfii] | diamond | 933 | 84 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Actinomortierella | Actinomortierella wolfii |
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);;