contig_metadata
6 rows where bioproject = "PRJNA930380", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27277926 | 27277926 | PRJNA930380_P_NODE_6063_length_291_cov_1.412844_g6010_i0 | PRJNA930380 | 6063 | 291 | 1.412844 | 4.11137604 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 42 | 0.0412 | NR | KAH9270470.1 | 1357716 | g6010 | i0 | 40.4 | 0.484536082474227 | 47 | 28 | 48.5 | 0 | 204 | 64 | 23 | 69 | KAH9270470.1 hypothetical protein BASA83_007470 [Batrachochytrium salamandrivorans] | diamond | 141 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28130546 | 28130546 | PRJNA930380_P_NODE_10745_length_262_cov_1.328042_g10692_i0 | PRJNA930380 | 10745 | 262 | 1.328042 | 3.47947004 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 77.8 | 2.14e-15 | NR | KAH9244298.1 | 1357716 | g10692 | i0 | 47.6 | 0.938931297709924 | 82 | 43 | 93.9 | 0 | 16 | 261 | 27 | 108 | KAH9244298.1 hypothetical protein BASA81_018303 [Batrachochytrium salamandrivorans] | diamond | 246 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28162141 | 28162141 | PRJNA930380_P_NODE_12345_length_248_cov_0.880000_g12292_i0 | PRJNA930380 | 12345 | 248 | 0.88 | 2.1824 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 120 | 1.1799999999999999e-31 | NR | KAI8811748.1 | 109936 | g12292 | i0 | 66.7 | 2.93951612903226 | 81 | 27 | 98 | 0 | 245 | 3 | 57 | 137 | KAI8811748.1 ribosomal protein S6e-domain-containing protein [Cladochytrium replicatum] | diamond | 729 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 28446289 | 28446289 | PRJNA930380_P_NODE_13686_length_243_cov_0.905882_g13633_i0 | PRJNA930380 | 13686 | 243 | 0.905882 | 2.20129326 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 97.1 | 1.39e-21 | NR | KXS19860.1 | 1344416 | g13633 | i0 | 60 | 0.987654320987654 | 80 | 32 | 98.8 | 0 | 2 | 241 | 323 | 402 | KXS19860.1 N-terminal nucleophile aminohydrolase [Gonapodya prolifera JEL478] | diamond | 240 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 32269713 | 32269713 | PRJNA930380_P_NODE_8818_length_278_cov_1.502439_g8765_i0 | PRJNA930380 | 8818 | 278 | 1.502439 | 4.17678042 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 87.4 | 2.86e-19 | NR | KAH9268955.1 | 1357716 | g8765 | i0 | 45.6 | 1.7158273381295 | 90 | 49 | 97.1 | 0 | 4 | 273 | 65 | 154 | KAH9268955.1 hypothetical protein BASA83_009091 [Batrachochytrium salamandrivorans] | diamond | 477 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32301548 | 32301548 | PRJNA930380_P_NODE_12139_length_249_cov_0.875000_g12086_i0 | PRJNA930380 | 12139 | 249 | 0.875 | 2.17875 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 74.3 | 7.47e-14 | NR | KAJ3278050.1 | 2735257 | g12086 | i0 | 54.7 | 0.903614457831325 | 75 | 31 | 86.7 | 1 | 226 | 11 | 36 | 110 | KAJ3278050.1 hypothetical protein HK104_002705, partial [Borealophlyctis nickersoniae] | diamond | 225 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae |
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);;