contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3105049 | 3105049 | PRJNA564810_S_NODE_623_length_463_cov_5.899497_g601_i0 | PRJNA564810 | 623 | 463 | 5.899497 | 27.31467111 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 66.2 | 8.69e-10 | NR | KAJ3038683.1 | 64517 | g601 | i0 | 45 | 0.83585313174946 | 80 | 42 | 51.8 | 1 | 463 | 224 | 163 | 240 | KAJ3038683.1 hypothetical protein HDV00_000432 [Rhizophlyctis rosea] | diamond | 387 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 10758539 | 10758539 | PRJNA564810_S_NODE_3609_length_282_cov_1.843318_g3587_i0 | PRJNA564810 | 3609 | 282 | 1.843318 | 5.19815676 | root | 1 | Root_unresolved | Root_unresolved | 110 | 3.67e-26 | NR | XP_031026059.1 | 1806994 | g3587 | i0 | 74.7 | 3.98936170212766 | 75 | 19 | 79.8 | 0 | 3 | 227 | 405 | 479 | XP_031026059.1 uncharacterized protein SmJEL517_g02169 [Synchytrium microbalum] | diamond | 1125 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 26636057 | 26636057 | PRJNA564810_S_NODE_6001_length_237_cov_1.697674_g5979_i0 | PRJNA564810 | 6001 | 237 | 1.697674 | 4.02348738 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 88.2 | 2.49e-18 | NR | KAI9019052.1 | 82268 | g5979 | i0 | 49.3 | 1.82278481012658 | 75 | 38 | 94.9 | 0 | 12 | 236 | 328 | 402 | KAI9019052.1 hypothetical protein DFJ74DRAFT_708251 [Hyaloraphidium curvatum] | diamond | 432 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 27995366 | 27995366 | PRJNA564810_S_NODE_6685_length_227_cov_1.679012_g6663_i0 | PRJNA564810 | 6685 | 227 | 1.679012 | 3.81135724 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 107 | 1.38e-25 | NR | KAI9361196.1 | 2211651 | g6663 | i0 | 62.3 | 0.911894273127753 | 69 | 26 | 91.2 | 0 | 3 | 209 | 312 | 380 | KAI9361196.1 cytochrome P450 [Zopfochytrium polystomum] | diamond | 207 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 28184487 | 28184487 | PRJNA564810_S_NODE_4766_length_258_cov_1.020725_g4744_i0 | PRJNA564810 | 4766 | 258 | 1.020725 | 2.6334705 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 68.9 | 2.58e-11 | NR | KAI9347176.1 | 2211651 | g4744 | i0 | 77.5 | 2.32558139534884 | 40 | 9 | 46.5 | 0 | 257 | 138 | 481 | 520 | KAI9347176.1 acyl-CoA dehydrogenase/oxidase [Zopfochytrium polystomum] | diamond | 600 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 29429610 | 29429610 | PRJNA564810_S_NODE_1209_length_384_cov_2.849530_g1187_i0 | PRJNA564810 | 1209 | 384 | 2.84953 | 10.9421952 | Fungi | 4751 | Fungi | Fungi | 173 | 1.4299999999999996e-52 | NR | KAI8800735.1 | 109936 | g1187 | i0 | 65.4 | 2.953125 | 127 | 44 | 99.2 | 0 | 2 | 382 | 41 | 167 | KAI8800735.1 AAA domain-containing protein [Cladochytrium replicatum] | diamond | 1134 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 30269152 | 30269152 | PRJNA564810_S_NODE_2192_length_328_cov_2.844106_g2170_i0 | PRJNA564810 | 2192 | 328 | 2.844106 | 9.32866768 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 63.5 | 4.88e-9 | NR | KAJ3120073.1 | 2732418 | g2170 | i0 | 48.3 | 2.77134146341463 | 60 | 27 | 54.9 | 1 | 182 | 3 | 1 | 56 | KAJ3120073.1 spindle assembly checkpoint kinase [Nowakowskiella sp. JEL0407] | diamond | 909 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0407 | |
| 31975845 | 31975845 | PRJNA564810_S_NODE_1378_length_371_cov_1.892157_g1356_i0 | PRJNA564810 | 1378 | 371 | 1.892157 | 7.01990247 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 74.7 | 9.58e-13 | NR | KAI9021058.1 | 82268 | g1356 | i0 | 45.4 | 0.784366576819407 | 97 | 48 | 76.8 | 4 | 3 | 287 | 411 | 504 | KAI9021058.1 hypothetical protein DFJ74DRAFT_671656 [Hyaloraphidium curvatum] | diamond | 291 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 32324303 | 32324303 | PRJNA564810_S_NODE_3879_length_276_cov_1.265403_g3857_i0 | PRJNA564810 | 3879 | 276 | 1.265403 | 3.49251228 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 63.5 | 2.36e-9 | NR | KAH9259650.1 | 1357716 | g3857 | i0 | 58.2 | 1.17391304347826 | 55 | 22 | 59.8 | 1 | 1 | 165 | 298 | 351 | KAH9259650.1 hypothetical protein BASA81_002072 [Batrachochytrium salamandrivorans] | diamond | 324 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;