contig_metadata
4 rows where bioproject = "PRJNA902848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 882108 | 882108 | PRJNA902848_P_NODE_2921_length_453_cov_1.500000_g2871_i0 | PRJNA902848 | 2921 | 453 | 1.5 | 6.795 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 322 | 3.03e-83 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g2871 | i0 | 81.081 | 78.448123620309 | 407 | 73 | 89 | 4 | 4 | 408 | 651 | 247 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 35537 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 3432583 | 3432583 | PRJNA902848_P_NODE_15603_length_249_cov_0.886364_g15553_i0 | PRJNA902848 | 15603 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | Fungi | Fungi | 109 | 1.5e-25 | NR | KAI8847627.1 | 64509 | g15553 | i0 | 57.5 | 4.79518072289157 | 80 | 34 | 96.4 | 0 | 248 | 9 | 1323 | 1402 | KAI8847627.1 armadillo-type protein [Chytridium lagenaria] | diamond | 1194 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 28666587 | 28666587 | PRJNA902848_P_NODE_4607_length_382_cov_3.339806_g4557_i0 | PRJNA902848 | 4607 | 382 | 3.339806 | 12.75805892 | Chytridium lagenaria | 64509 | Fungi | Fungi | 142 | 4.01e-41 | NR | KAI8853041.1 | 64509 | g4557 | i0 | 64.2 | 0.965968586387435 | 123 | 44 | 96.6 | 0 | 14 | 382 | 1 | 123 | KAI8853041.1 ribosomal L29 protein-domain-containing protein [Chytridium lagenaria] | diamond | 369 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 31327330 | 31327330 | PRJNA902848_P_NODE_9555_length_290_cov_1.433180_g9505_i0 | PRJNA902848 | 9555 | 290 | 1.43318 | 4.156222 | Boothiomyces | 451452 | Fungi | Fungi | 94.7 | 2.67e-23 | NR | KAJ3261498.1 | 261099 | g9505 | i0 | 81.3 | 2.00689655172414 | 64 | 11 | 66.2 | 1 | 207 | 16 | 7 | 69 | KAJ3261498.1 40S ribosomal protein S28 [Boothiomyces macroporosus] | diamond | 582 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces macroporosus |
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);;