contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4681548 | 4681548 | PRJNA876641_P_NODE_18444_length_247_cov_2.689655_g18370_i0 | PRJNA876641 | 18444 | 247 | 2.689655 | 6.64344785 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 158 | 4.6e-34 | NTclustered | gi|575484485|ref|XM_006681474.1| | 684364 | g18370 | i0 | 86.207 | 13.5222672064777 | 145 | 20 | 59 | 0 | 5 | 149 | 54 | 198 | Batrachochytrium dendrobatidis JAM81 ribosomal 60S subunit protein L39 (BATDEDRAFT_91214), partial mRNA | blastn | 3340 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 5956574 | 5956574 | PRJNA876641_P_NODE_5685_length_336_cov_1.555133_g5611_i0 | PRJNA876641 | 5685 | 336 | 1.555133 | 5.22524688 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 185 | 2.9999999999999996e-42 | NTclustered | gi|2432155310|ref|XM_053111519.1| | 110093 | g5611 | i0 | 78.648 | 5.26785714285714 | 281 | 58 | 83 | 2 | 12 | 291 | 335 | 56 | Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA | blastn | 1770 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7231294 | 7231294 | PRJNA876641_P_NODE_13086_length_265_cov_0.916667_g13012_i0 | PRJNA876641 | 13086 | 265 | 0.916667 | 2.42916755 | Rhizophydium sp. JEL138 | 139068 | Fungi | Fungi | 228 | 3.7499999999999994e-55 | NTclustered | gi|30088555|gb|AY138786.1| | 139068 | g13012 | i0 | 82.946 | 97.0075471698113 | 258 | 38 | 96 | 5 | 11 | 265 | 476 | 222 | Rhizophydium sp. JEL138 alpha-tubulin (atub) gene, partial cds | blastn | 25707 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiaceae | Rhizophydium | Rhizophydium sp. JEL138 | |
| 8506253 | 8506253 | PRJNA876641_P_NODE_7027_length_313_cov_2.183333_g6953_i0 | PRJNA876641 | 7027 | 313 | 2.183333 | 6.83383229 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 154 | 7.8e-33 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g6953 | i0 | 80 | 0.670926517571885 | 210 | 40 | 67 | 2 | 2 | 210 | 469 | 677 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 210 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11056960 | 11056960 | PRJNA876641_P_NODE_2529_length_447_cov_1.689840_g2455_i0 | PRJNA876641 | 2529 | 447 | 1.68984 | 7.5535848 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 250 | 1.4299999999999998e-61 | NTclustered | gi|2432156890|ref|XM_053107738.1| | 110093 | g2455 | i0 | 78.74 | 71.4832214765101 | 381 | 75 | 85 | 6 | 70 | 447 | 71 | 448 | Polychytrium aggregatum 60S ribosomal protein L2 (BJ171DRAFT_425809), partial mRNA | blastn | 31953 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17431254 | 17431254 | PRJNA876641_P_NODE_12154_length_270_cov_1.172589_g12080_i0 | PRJNA876641 | 12154 | 270 | 1.172589 | 3.1659903 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 152 | 2.3699999999999998e-32 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g12080 | i0 | 83.133 | 2.62962962962963 | 166 | 28 | 61 | 0 | 10 | 175 | 346 | 181 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 710 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 17431507 | 17431507 | PRJNA876641_P_NODE_6454_length_322_cov_1.779116_g6380_i0 | PRJNA876641 | 6454 | 322 | 1.779116 | 5.72875352 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 185 | 2.86e-42 | NTclustered | gi|2432131389|ref|XM_053109302.1| | 110093 | g6380 | i0 | 78.333 | 24.6490683229814 | 300 | 55 | 92 | 8 | 27 | 321 | 105 | 399 | Polychytrium aggregatum ribosomal protein S3Ae (BJ171DRAFT_487525), mRNA | blastn | 7937 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18704692 | 18704692 | PRJNA876641_P_NODE_4795_length_356_cov_4.501767_g4721_i0 | PRJNA876641 | 4795 | 356 | 4.501767 | 16.02629052 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 5.400000000000001e-30 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g4721 | i0 | 76.866 | 58.0561797752809 | 268 | 54 | 74 | 6 | 1 | 264 | 13 | 276 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 20668 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;