contig_metadata
6 rows where bioproject = "PRJNA1111448", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4044549 | 4044549 | PRJNA1111448_S_NODE_14404_length_520_cov_2.588367_g13597_i0 | PRJNA1111448 | 14404 | 520 | 2.588367 | 13.4595084 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 187 | 1.3399999999999996e-42 | NTclustered | gi|2468790865|gb|OQ702874.1| | 2058121 | g13597 | i0 | 80 | 31.1057692307692 | 275 | 38 | 52 | 14 | 5 | 273 | 4383 | 4120 | Lobulomycetales sp. isolate PSC090 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 | 16175 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 5321009 | 5321009 | PRJNA1111448_S_NODE_64685_length_319_cov_2.109756_g63862_i0 | PRJNA1111448 | 64685 | 319 | 2.109756 | 6.73012164 | Opisthokonta | 33154 | Fungi | Fungi | 139 | 1.53e-38 | NR | KAI8851906.1 | 64509 | g63862 | i0 | 67.7 | 9.74294670846395 | 96 | 31 | 90.3 | 0 | 1 | 288 | 165 | 260 | KAI8851906.1 40S ribosomal protein s2 [Chytridium lagenaria] | diamond | 3108 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 13775698 | 13775698 | PRJNA1111448_S_NODE_108271_length_263_cov_1.026316_g107448_i0 | PRJNA1111448 | 108271 | 263 | 1.026316 | 2.69921108 | root | 1 | Root_unresolved | Root_unresolved | 167 | 5.929999999999999e-47 | NR | KAI8855110.1 | 64509 | g107448 | i0 | 93.1 | 52.5969581749049 | 87 | 6 | 99.2 | 0 | 1 | 261 | 371 | 457 | KAI8855110.1 carboxyl transferase [Chytridium lagenaria] | diamond | 13833 | 168 | 0.994047619047619 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 28732881 | 28732881 | PRJNA1111448_S_NODE_61367_length_325_cov_1.698413_g60544_i0 | PRJNA1111448 | 61367 | 325 | 1.698413 | 5.51984225 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.42e-27 | NR | KAJ3199733.1 | 109932 | g60544 | i0 | 80.6 | 3.09230769230769 | 67 | 13 | 61.8 | 0 | 325 | 125 | 533 | 599 | KAJ3199733.1 hypothetical protein HDU82_000197 [Entophlyctis luteolus] | diamond | 1005 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 31774481 | 31774481 | PRJNA1111448_S_NODE_94657_length_278_cov_1.048780_g93834_i0 | PRJNA1111448 | 94657 | 278 | 1.04878 | 2.9156084 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 102 | 1.98e-25 | NR | KAJ3087312.1 | 2654861 | g93834 | i0 | 55.7 | 0.949640287769784 | 88 | 39 | 95 | 0 | 1 | 264 | 49 | 136 | KAJ3087312.1 hypothetical protein HK102_011368 [Quaeritorhiza haematococci] | diamond | 264 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 32903047 | 32903047 | PRJNA1111448_S_NODE_133560_length_244_cov_0.900585_g132737_i0 | PRJNA1111448 | 133560 | 244 | 0.900585 | 2.1974274 | Fungi | 4751 | Fungi | Fungi | 115 | 4.65e-28 | NR | KAJ3093415.1 | 109957 | g132737 | i0 | 66.7 | 4.89344262295082 | 78 | 26 | 95.9 | 0 | 5 | 238 | 287 | 364 | KAJ3093415.1 hypothetical protein HK100_006622 [Physocladia obscura] | diamond | 1194 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura |
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);;