contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1944790 | 1944790 | PRJNA689790_S_NODE_4582_length_283_cov_3.939024_g4467_i0 | PRJNA689790 | 4582 | 283 | 3.939024 | 11.14743792 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 163 | 1.16e-35 | NTclustered | gi|1026971811|ref|XM_016751649.1| | 645134 | g4467 | i0 | 80 | 32.4628975265018 | 225 | 41 | 79 | 3 | 1 | 223 | 278 | 500 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S23 (SPPG_03379), mRNA | blastn | 9187 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 3219598 | 3219598 | PRJNA689790_S_NODE_3403_length_337_cov_5.040000_g3288_i0 | PRJNA689790 | 3403 | 337 | 5.04 | 16.9848 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 196 | 1.39e-45 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g3288 | i0 | 79.779 | 33.412462908011904 | 272 | 53 | 80 | 2 | 67 | 337 | 680 | 410 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 11260 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 7047363 | 7047363 | PRJNA689790_S_NODE_7066_length_223_cov_1.860215_g6951_i0 | PRJNA689790 | 7066 | 223 | 1.860215 | 4.14827945 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 128 | 3.1999999999999997e-25 | NTclustered | gi|1026973001|ref|XM_016751749.1| | 645134 | g6951 | i0 | 88.679 | 49.5784753363229 | 106 | 11 | 47 | 1 | 1 | 105 | 685 | 790 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L8 (SPPG_03486), mRNA | blastn | 11056 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 8321827 | 8321827 | PRJNA689790_S_NODE_1147_length_623_cov_3.819113_g1054_i0 | PRJNA689790 | 1147 | 623 | 3.819113 | 23.79307399 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 436 | 1.4600000000000002e-117 | NTclustered | gi|2432168590|ref|XM_053112370.1| | 110093 | g1054 | i0 | 83.721 | 32.9775280898876 | 473 | 65 | 75 | 12 | 2 | 468 | 2014 | 2480 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_519711), mRNA | blastn | 20545 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 10872791 | 10872791 | PRJNA689790_S_NODE_3049_length_360_cov_3.916409_g2934_i0 | PRJNA689790 | 3049 | 360 | 3.916409 | 14.0990724 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 200 | 1.15e-46 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g2934 | i0 | 79.643 | 31.7083333333333 | 280 | 55 | 78 | 2 | 1 | 279 | 410 | 688 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 11415 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 13422659 | 13422659 | PRJNA689790_S_NODE_8211_length_206_cov_1.615385_g8096_i0 | PRJNA689790 | 8211 | 206 | 1.615385 | 3.3276931 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 200 | 6.079999999999999e-47 | NTclustered | gi|2432171462|ref|XM_053112561.1| | 110093 | g8096 | i0 | 85 | 81.4417475728155 | 200 | 26 | 96 | 3 | 2 | 199 | 1976 | 1779 | Polychytrium aggregatum heat shock protein 90 kDa (BJ171DRAFT_524257), mRNA | blastn | 16777 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22346126 | 22346126 | PRJNA689790_S_NODE_8358_length_204_cov_2.329341_g8243_i0 | PRJNA689790 | 8358 | 204 | 2.329341 | 4.75185564 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 113 | 8.050000000000001e-21 | NTclustered | gi|2432137874|ref|XM_053110081.1| | 110093 | g8243 | i0 | 77.487 | 3.07352941176471 | 191 | 41 | 93 | 2 | 15 | 204 | 125 | 314 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_495094), mRNA | blastn | 627 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24894941 | 24894941 | PRJNA689790_S_NODE_3920_length_310_cov_4.619048_g3805_i0 | PRJNA689790 | 3920 | 310 | 4.619048 | 14.3190488 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 4.68e-25 | NTclustered | gi|2432058563|ref|XM_053065718.1| | 1396493 | g3805 | i0 | 79.558 | 2.67096774193548 | 181 | 35 | 58 | 2 | 88 | 267 | 259 | 80 | Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA | blastn | 828 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;