contig_metadata
4 rows where bioproject = "PRJNA306153", tax_clade = "Opisthokonta" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18228054 | 18228054 | PRJNA306153_S_NODE_615_length_298_cov_15.914498_g602_i0 | PRJNA306153 | 615 | 298 | 15.914498 | 47.42520404 | Tieghemiomyces parasiticus | 78921 | Fungi | Fungi | 78.7 | 4.57e-10 | NTclustered | gi|666440457|gb|KF848916.1| | 78921 | g602 | i0 | 95.833 | 0.161073825503356 | 48 | 2 | 16 | 0 | 251 | 298 | 334 | 287 | Tieghemiomyces parasiticus strain NRRL 2924 28S ribosomal RNA gene, partial sequence | blastn | 48 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Tieghemiomyces | Tieghemiomyces parasiticus | |
| 29853172 | 29853172 | PRJNA306153_S_NODE_1131_length_226_cov_3.192893_g1118_i0 | PRJNA306153 | 1131 | 226 | 3.192893 | 7.21593818 | Kickxella alabastrina | 61397 | Fungi | Fungi | 78.6 | 2.49e-16 | NR | KAJ1892345.1 | 61397 | g1118 | i0 | 61.5 | 0.86283185840708 | 65 | 24 | 85 | 1 | 6 | 197 | 51 | 115 | KAJ1892345.1 hypothetical protein LPJ66_006400 [Kickxella alabastrina] | diamond | 195 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 30850067 | 30850067 | PRJNA306153_S_NODE_2614_length_155_cov_3.134921_g2601_i0 | PRJNA306153 | 2614 | 155 | 3.134921 | 4.85912755 | Eukaryota | 2759 | Fungi | Fungi | 81.3 | 5.19e-18 | NR | RKP11106.1 | 78915 | g2601 | i0 | 77.1 | 22.6258064516129 | 48 | 11 | 92.9 | 0 | 12 | 155 | 55 | 102 | RKP11106.1 60S ribosomal protein L32 [Thamnocephalis sphaerospora] | diamond | 3507 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 32209945 | 32209945 | PRJNA306153_S_NODE_758_length_274_cov_3.673469_g745_i0 | PRJNA306153 | 758 | 274 | 3.673469 | 10.06530506 | Harpellales | 61421 | Fungi | Fungi | 101 | 1.57e-25 | NR | PVU85474.1 | 61424 | g745 | i0 | 69.2 | 2.15693430656934 | 65 | 20 | 71.2 | 0 | 266 | 72 | 43 | 107 | PVU85474.1 hypothetical protein BB559_007000 [Furculomyces boomerangus] | diamond | 591 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus |
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);;