contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370276 | 370276 | PRJNA270367_P_NODE_9681_length_428_cov_9.279683_g9479_i0 | PRJNA270367 | 9681 | 428 | 9.279683 | 39.71704324 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 169 | 3.93e-37 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g9479 | i0 | 77.244 | 47.4906542056075 | 312 | 55 | 70 | 9 | 73 | 373 | 337 | 31 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 20326 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8023220 | 8023220 | PRJNA270367_P_NODE_10067_length_419_cov_7.208108_g9865_i0 | PRJNA270367 | 10067 | 419 | 7.208108 | 30.20197252 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 121 | 1.09e-22 | NTclustered | gi|575480991|ref|XM_006679727.1| | 684364 | g9865 | i0 | 81.046 | 0.861575178997613 | 153 | 27 | 36 | 2 | 50 | 201 | 25 | 176 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_12294), partial mRNA | blastn | 361 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 10573921 | 10573921 | PRJNA270367_P_NODE_1669_length_1086_cov_8.503375_g1517_i0 | PRJNA270367 | 1669 | 1086 | 8.503375 | 92.3466525 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 645 | 3.979999999999999e-180 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g1517 | i0 | 80.44 | 80.183241252302 | 864 | 153 | 79 | 13 | 166 | 1021 | 1069 | 214 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 87079 | 645 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 10574275 | 10574275 | PRJNA270367_P_NODE_9149_length_442_cov_2.470738_g8950_i0 | PRJNA270367 | 9149 | 442 | 2.470738 | 10.92066196 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 278 | 6.48e-70 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g8950 | i0 | 79.455 | 40.0814479638009 | 404 | 73 | 90 | 7 | 35 | 433 | 1066 | 668 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 17716 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11848745 | 11848745 | PRJNA270367_P_NODE_37370_length_175_cov_1.650794_g37165_i0 | PRJNA270367 | 37370 | 175 | 1.650794 | 2.8888895 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 89.8 | 1.12e-13 | NTclustered | gi|2432143050|ref|XM_053110573.1| | 110093 | g37165 | i0 | 84.043 | 0.537142857142857 | 94 | 13 | 53 | 2 | 19 | 111 | 639 | 731 | Polychytrium aggregatum ribosomal family S4e (BJ171DRAFT_500618), mRNA | blastn | 94 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16947364 | 16947364 | PRJNA270367_P_NODE_26574_length_221_cov_0.906977_g26369_i0 | PRJNA270367 | 26574 | 221 | 0.906977 | 2.00441917 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 182 | 2.39e-41 | NTclustered | gi|2432131152|ref|XM_053108251.1| | 110093 | g26369 | i0 | 83.168 | 10.2579185520362 | 202 | 30 | 90 | 3 | 2 | 201 | 714 | 515 | Polychytrium aggregatum putative succinyl-CoA synthetase alpha chain, gdp-forming (BJ171DRAFT_454445), mRNA | blastn | 2267 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19496218 | 19496218 | PRJNA270367_P_NODE_8856_length_450_cov_1.002494_g8657_i0 | PRJNA270367 | 8856 | 450 | 1.002494 | 4.511223 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 261 | 6.65e-65 | NTclustered | gi|2432051426|ref|XM_053072055.1| | 1396493 | g8657 | i0 | 77.384 | 22.9333333333333 | 451 | 94 | 99 | 8 | 4 | 450 | 585 | 139 | Fimicolochytrium jonesii ribosomal family S4e-domain-containing protein (EV422DRAFT_563332), partial mRNA | blastn | 10320 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 20771522 | 20771522 | PRJNA270367_P_NODE_31317_length_198_cov_1.275168_g31112_i0 | PRJNA270367 | 31317 | 198 | 1.275168 | 2.52483264 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 84.2 | 6.09e-12 | NTclustered | gi|2432075625|ref|XM_053068329.1| | 1396493 | g31112 | i0 | 85.366 | 0.414141414141414 | 82 | 10 | 41 | 2 | 5 | 85 | 1843 | 1923 | Fimicolochytrium jonesii Fungalysin metallopeptidase-domain-containing protein (EV422DRAFT_50326), mRNA | blastn | 82 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 23321920 | 23321920 | PRJNA270367_P_NODE_18399_length_286_cov_1.586498_g18194_i0 | PRJNA270367 | 18399 | 286 | 1.586498 | 4.53738428 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 165 | 3.25e-36 | NTclustered | gi|1759158146|ref|XM_031170386.1| | 1806994 | g18194 | i0 | 81.818 | 3.17832167832168 | 198 | 35 | 69 | 1 | 82 | 278 | 1225 | 1422 | Synchytrium microbalum uncharacterized protein (SmJEL517_g04458), partial mRNA | blastn | 909 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 23321927 | 23321927 | PRJNA270367_P_NODE_18779_length_282_cov_1.085837_g18574_i0 | PRJNA270367 | 18779 | 282 | 1.085837 | 3.06206034 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 89.8 | 1.98e-13 | NTclustered | gi|2432152228|ref|XM_053111343.1| | 110093 | g18574 | i0 | 84.615 | 0.776595744680851 | 91 | 12 | 32 | 2 | 44 | 133 | 249 | 160 | Polychytrium aggregatum ribosomal protein L30, ferredoxin-like fold domain-containing protein (BJ171DRAFT_509118), mRNA | blastn | 219 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;