contig_metadata
8 rows where bioproject = "PRJEB25789" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14051176 | 14051176 | PRJEB25789_S_NODE_11672_length_288_cov_1.613953_g11593_i0 | PRJEB25789 | 11672 | 288 | 1.613953 | 4.64818464 | Bifiguratus adelaidae | 1938954 | Fungi | Fungi | 132 | 3.1899999999999997e-37 | NR | OZJ05041.1 | 1938954 | g11593 | i0 | 69.9 | 1.9375 | 93 | 27 | 95.8 | 1 | 1 | 276 | 44 | 136 | OZJ05041.1 60S ribosomal protein L27-A [Bifiguratus adelaidae] | diamond | 558 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Bifiguratus | Bifiguratus adelaidae | ||
| 27532285 | 27532285 | PRJEB25789_S_NODE_15743_length_256_cov_2.103825_g15664_i0 | PRJEB25789 | 15743 | 256 | 2.103825 | 5.385792 | Fungi | 4751 | Fungi | Fungi | 110 | 2.69e-29 | NR | KAL0088032.1 | 4837 | g15664 | i0 | 80.9 | 35.9296875 | 68 | 13 | 79.7 | 0 | 254 | 51 | 39 | 106 | KAL0088032.1 40S ribosomal protein S28-like protein [Phycomyces blakesleeanus] | diamond | 9198 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 28201583 | 28201583 | PRJEB25789_S_NODE_19246_length_243_cov_0.905882_g19167_i0 | PRJEB25789 | 19246 | 243 | 0.905882 | 2.20129326 | Dissophora ornata | 979620 | Fungi | Fungi | 87 | 7.99e-18 | NR | KAI8603295.1 | 979620 | g19167 | i0 | 58.7 | 1.85185185185185 | 75 | 31 | 92.6 | 0 | 227 | 3 | 289 | 363 | KAI8603295.1 P-loop containing nucleoside triphosphate hydrolase protein [Dissophora ornata] | diamond | 450 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Dissophora | Dissophora ornata | |
| 29086021 | 29086021 | PRJEB25789_S_NODE_11328_length_291_cov_2.472477_g11249_i0 | PRJEB25789 | 11328 | 291 | 2.472477 | 7.19490807 | Rhizopus azygosporus | 86630 | Fungi | Fungi | 63.9 | 1.67e-10 | NR | RCH99285.1 | 86630 | g11249 | i0 | 50 | 0.783505154639175 | 76 | 29 | 77.3 | 2 | 291 | 67 | 44 | 111 | RCH99285.1 hypothetical protein CU097_015083 [Rhizopus azygosporus] | diamond | 228 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus azygosporus | |
| 29900515 | 29900515 | PRJEB25789_S_NODE_9391_length_312_cov_2.255230_g9312_i0 | PRJEB25789 | 9391 | 312 | 2.25523 | 7.0363176 | Eukaryota | 2759 | Fungi | Fungi | 114 | 9.45e-29 | NR | KAG9292942.1 | 50956 | g9312 | i0 | 65.3 | 4.69230769230769 | 101 | 33 | 96.2 | 2 | 12 | 311 | 35 | 134 | KAG9292942.1 hypothetical protein G9A89_016304 [Geosiphon pyriformis] | diamond | 1464 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 30001736 | 30001736 | PRJEB25789_S_NODE_15511_length_258_cov_1.108108_g15432_i0 | PRJEB25789 | 15511 | 258 | 1.108108 | 2.85891864 | Apophysomyces ossiformis | 679940 | Fungi | Fungi | 77.8 | 1.57e-14 | NR | KAF7728951.1 | 679940 | g15432 | i0 | 47 | 3.90697674418605 | 83 | 42 | 94.2 | 1 | 248 | 6 | 24 | 106 | KAF7728951.1 Curved DNA-binding protein (42 kDa protein) [Apophysomyces ossiformis] | diamond | 1008 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Apophysomyces | Apophysomyces ossiformis | |
| 31670157 | 31670157 | PRJEB25789_S_NODE_15437_length_258_cov_1.600000_g15358_i0 | PRJEB25789 | 15437 | 258 | 1.6 | 4.128 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0326 | NR | YP_010480827.1 | 483437 | g15358 | i0 | 53.5 | 1.11627906976744 | 43 | 20 | 50 | 0 | 239 | 111 | 46 | 88 | YP_010480827.1 NADH dehydrogenase subunit 6 [Gongronella sp. w5] | diamond | 288 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Gongronella | Gongronella sp. w5 | |
| 32182959 | 32182959 | PRJEB25789_S_NODE_8778_length_320_cov_1.392713_g8699_i0 | PRJEB25789 | 8778 | 320 | 1.392713 | 4.4566816 | Rhizophagus sp. MUCL 43196 | 1803374 | Fungi | Fungi | 48.1 | 2.16e-4 | NR | RGB32078.1 | 1803374 | g8699 | i0 | 64.1 | 1.725 | 92 | 31 | 86.3 | 1 | 307 | 32 | 25 | 114 | RGB32078.1 60s acidic ribosomal protein [Rhizophagus diaphanus] [Rhizophagus sp. MUCL 43196] | diamond | 552 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus sp. MUCL 43196 |
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);;