contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5578146 | 5578146 | PRJNA493828_P_NODE_20805_length_284_cov_4.123223_g20386_i0 | PRJNA493828 | 20805 | 284 | 4.123223 | 11.70995332 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 78.7 | 4.33e-10 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g20386 | i0 | 97.778 | 4.83450704225352 | 45 | 1 | 16 | 0 | 237 | 281 | 6131 | 6175 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1373 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 6852090 | 6852090 | PRJNA493828_P_NODE_12346_length_330_cov_70.416342_g11927_i0 | PRJNA493828 | 12346 | 330 | 70.416342 | 232.3739286 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 599 | 8.849999999999995e-167 | NTclustered | gi|82398309|gb|DQ273787.1| | 64517 | g11927 | i0 | 99.694 | 84.430303030303 | 327 | 1 | 99 | 0 | 1 | 327 | 2280 | 1954 | Rhizophlyctis rosea isolate AFTOL-ID 43 28S ribosomal RNA gene, partial sequence | blastn | 27862 | 599 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 8759281 | 8759281 | PRJNA493828_P_NODE_11387_length_341_cov_42.208955_g10968_i0 | PRJNA493828 | 11387 | 341 | 42.208955 | 143.93253655 | root | 1 | Root_unresolved | Root_unresolved | 350 | 1.0200000000000001e-91 | NTclustered | gi|1866582754|gb|MT730929.1| | 64517 | g10968 | i0 | 98.98 | 84.8709677419355 | 196 | 0 | 90 | 1 | 4 | 197 | 1423 | 1618 | Rhizophlyctis rosea isolate KP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28941 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 10678190 | 10678190 | PRJNA493828_P_NODE_21969_length_280_cov_4.043478_g21550_i0 | PRJNA493828 | 21969 | 280 | 4.043478 | 11.3217384 | Harpochytrium sp. JEL196 | 1485251 | Fungi | Fungi | 226 | 1.4399999999999994e-54 | NTclustered | gi|675391975|gb|KJ668089.1| | 1485251 | g21550 | i0 | 82.206 | 100.828571428571 | 281 | 33 | 99 | 14 | 4 | 280 | 1807 | 1540 | Harpochytrium sp. JEL196 28S ribosomal RNA gene, partial sequence | blastn | 28232 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Harpochytriaceae | Harpochytrium | Harpochytrium sp. JEL196 | |
| 13228784 | 13228784 | PRJNA493828_P_NODE_45931_length_211_cov_5.840580_g45512_i0 | PRJNA493828 | 45931 | 211 | 5.84058 | 12.3236238 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 248 | 2.2e-61 | NTclustered | gi|2897841418|gb|CP161937.1| | 109871 | g45512 | i0 | 87.793 | 108.625592417062 | 213 | 24 | 100 | 2 | 1 | 211 | 40870 | 40658 | Batrachochytrium dendrobatidis strain JEL423 chromosome 15 | blastn | 22920 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 18958276 | 18958276 | PRJNA493828_P_NODE_45515_length_214_cov_11.836879_g45096_i0 | PRJNA493828 | 45515 | 214 | 11.836879 | 25.33092106 | Rhizophlyctis | 64515 | Fungi | Fungi | 355 | 1.28e-93 | NTclustered | gi|1866582754|gb|MT730929.1| | 64517 | g45096 | i0 | 99.487 | 91.107476635514 | 195 | 1 | 91 | 0 | 17 | 211 | 1476 | 1282 | Rhizophlyctis rosea isolate KP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19497 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 19600374 | 19600374 | PRJNA493828_P_NODE_13116_length_322_cov_1.546185_g12697_i0 | PRJNA493828 | 13116 | 322 | 1.546185 | 4.9787157 | Dendrochytridium crassum | 1352835 | Fungi | Fungi | 119 | 2.94e-22 | NTclustered | gi|82398285|gb|DQ273785.1| | 1352835 | g12697 | i0 | 87.379 | 4.03416149068323 | 103 | 13 | 32 | 0 | 4 | 106 | 1982 | 1880 | Dendrochytridium crassum isolate AFTOL-ID 41 28S ribosomal RNA gene, partial sequence | blastn | 1299 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dendrochytridium | Dendrochytridium crassum | |
| 19600757 | 19600757 | PRJNA493828_P_NODE_3896_length_548_cov_3.378947_g3518_i0 | PRJNA493828 | 3896 | 548 | 3.378947 | 18.51662956 | Synchytrium sp. | 1971732 | Fungi | Fungi | 93.5 | 3.18e-14 | NTclustered | gi|1168020523|gb|KY800404.1| | 1971732 | g3518 | i0 | 83.168 | 0.786496350364963 | 101 | 17 | 18 | 0 | 424 | 524 | 906 | 1006 | Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence | blastn | 431 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium sp. |
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);;