contig_metadata
11 rows where bioproject = "PRJNA1248424", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26946982 | 26946982 | PRJNA1248424_P_NODE_79362_length_242_cov_0.911243_g73293_i0 | PRJNA1248424 | 79362 | 242 | 0.911243 | 2.20520806 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 92 | 5.66e-20 | NR | XP_069248254.1 | 911321 | g73293 | i0 | 49.4 | 3.23553719008264 | 89 | 36 | 99.2 | 1 | 2 | 241 | 154 | 242 | XP_069248254.1 uncharacterized protein VTP21DRAFT_5179 [Calcarisporiella thermophila] | diamond | 783 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 27453053 | 27453053 | PRJNA1248424_P_NODE_73683_length_247_cov_0.885057_g67614_i0 | PRJNA1248424 | 73683 | 247 | 0.885057 | 2.18609079 | Linnemannia exigua | 604196 | Fungi | Fungi | 48.1 | 4.94e-4 | NR | KAG0265242.1 | 604196 | g67614 | i0 | 34.7 | 5.39271255060729 | 75 | 47 | 88.7 | 1 | 235 | 17 | 344 | 418 | KAG0265242.1 hypothetical protein BGZ95_003387 [Linnemannia exigua] | diamond | 1332 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia exigua | |
| 27926456 | 27926456 | PRJNA1248424_P_NODE_75785_length_245_cov_0.895349_g69716_i0 | PRJNA1248424 | 75785 | 245 | 0.895349 | 2.19360505 | Rhizophagus sp. MUCL 43196 | 1803374 | Fungi | Fungi | 48.5 | 2.92e-4 | NR | RGB40866.1 | 1803374 | g69716 | i0 | 34.1 | 1.00408163265306 | 82 | 42 | 99.2 | 2 | 245 | 3 | 57 | 127 | RGB40866.1 hypothetical protein C1646_649898 [Rhizophagus diaphanus] [Rhizophagus sp. MUCL 43196] | diamond | 246 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus sp. MUCL 43196 | |
| 28052680 | 28052680 | PRJNA1248424_P_NODE_78245_length_243_cov_0.905882_g72176_i0 | PRJNA1248424 | 78245 | 243 | 0.905882 | 2.20129326 | Rhizopus delemar | 936053 | Fungi | Fungi | 48.9 | 2.21e-4 | NR | KAG1439187.1 | 936053 | g72176 | i0 | 39.3 | 0.753086419753086 | 61 | 34 | 75.3 | 1 | 32 | 214 | 203 | 260 | KAG1439187.1 hypothetical protein G6F56_012370 [Rhizopus delemar] | diamond | 183 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 28526532 | 28526532 | PRJNA1248424_P_NODE_51687_length_300_cov_1.669604_g45619_i0 | PRJNA1248424 | 51687 | 300 | 1.669604 | 5.008812 | Rhizophagus clarus | 94130 | Fungi | Fungi | 51.6 | 2.26e-5 | NR | GBB86912.1 | 94130 | g45619 | i0 | 40 | 2.73 | 70 | 40 | 69 | 2 | 209 | 3 | 63 | 131 | GBB86912.1 hypothetical protein RclHR1_13360009 [Rhizophagus clarus] | diamond | 819 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus | |
| 29396919 | 29396919 | PRJNA1248424_P_NODE_57149_length_283_cov_1.247619_g51081_i0 | PRJNA1248424 | 57149 | 283 | 1.247619 | 3.53076177 | Eukaryota | 2759 | Fungi | Fungi | 48.1 | 7.56e-4 | NR | CAG8566638.1 | 144538 | g51081 | i0 | 70 | 1.48409893992933 | 30 | 9 | 31.8 | 0 | 155 | 66 | 838 | 867 | CAG8566638.1 1145_t:CDS:10 [Paraglomus brasilianum] | diamond | 420 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus brasilianum | |
| 29884247 | 29884247 | PRJNA1248424_P_NODE_57091_length_283_cov_1.380952_g51023_i0 | PRJNA1248424 | 57091 | 283 | 1.380952 | 3.90809416 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 43.5 | 0.0332 | NR | CAG8547830.1 | 94023 | g51023 | i0 | 31.4 | 0.742049469964664 | 70 | 48 | 74.2 | 0 | 219 | 10 | 286 | 355 | CAG8547830.1 6137_t:CDS:10 [Acaulospora morrowiae] | diamond | 210 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 31228908 | 31228908 | PRJNA1248424_P_NODE_65015_length_262_cov_1.185185_g58946_i0 | PRJNA1248424 | 65015 | 262 | 1.185185 | 3.1051847 | Opisthokonta | 33154 | Fungi | Fungi | 54.3 | 2.84e-6 | NR | CAG8851177.1 | 4874 | g58946 | i0 | 40.2 | 9.56106870229008 | 87 | 48 | 96.2 | 2 | 3 | 254 | 26 | 111 | CAG8851177.1 7007_t:CDS:2, partial [Gigaspora margarita] | diamond | 2505 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 32146533 | 32146533 | PRJNA1248424_P_NODE_59478_length_277_cov_1.254902_g53410_i0 | PRJNA1248424 | 59478 | 277 | 1.254902 | 3.47607854 | Funneliformis | 1117308 | Fungi | Fungi | 110 | 3.55e-26 | NR | CAG8494461.1 | 1117310 | g53410 | i0 | 68.5 | 13.4187725631769 | 73 | 23 | 79.1 | 0 | 271 | 53 | 356 | 428 | CAG8494461.1 10122_t:CDS:10, partial [Funneliformis caledonium] | diamond | 3717 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis caledonium | |
| 32368218 | 32368218 | PRJNA1248424_P_NODE_65299_length_261_cov_1.313830_g59230_i0 | PRJNA1248424 | 65299 | 261 | 1.31383 | 3.4290963 | Eukaryota | 2759 | Fungi | Fungi | 43.1 | 0.0328 | NR | XP_051439793.1 | 101096 | g59230 | i0 | 40 | 1.26436781609195 | 50 | 25 | 51.7 | 1 | 124 | 258 | 210 | 259 | XP_051439793.1 uncharacterized protein B0P05DRAFT_521617 [Gilbertella persicaria] | diamond | 330 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 32778133 | 32778133 | PRJNA1248424_P_NODE_70060_length_250_cov_1.101695_g63991_i0 | PRJNA1248424 | 70060 | 250 | 1.101695 | 2.7542375 | Eukaryota | 2759 | Fungi | Fungi | 45.8 | 0.00331 | NR | KAG1140714.1 | 64495 | g63991 | i0 | 39.1 | 8.112 | 64 | 35 | 76.8 | 1 | 3 | 194 | 1070 | 1129 | KAG1140714.1 hypothetical protein G6F38_008919 [Rhizopus arrhizus] | diamond | 2028 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus |
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);;