contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1597390 | 1597390 | PRJNA1196384_S_NODE_942_length_395_cov_3.064246_g878_i0 | PRJNA1196384 | 942 | 395 | 3.064246 | 12.1037717 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 209 | 2.12e-49 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g878 | i0 | 78.846 | 3.37215189873418 | 312 | 64 | 79 | 2 | 81 | 391 | 677 | 367 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 1332 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 2873466 | 2873466 | PRJNA1196384_S_NODE_4063_length_197_cov_2.325000_g3999_i0 | PRJNA1196384 | 4063 | 197 | 2.325 | 4.58025 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 126 | 9.91e-25 | NTclustered | gi|2432083867|ref|XM_053064558.1| | 1396493 | g3999 | i0 | 87.273 | 10.5177664974619 | 110 | 14 | 56 | 0 | 55 | 164 | 1077 | 1186 | Fimicolochytrium jonesii mitochondrial carrier protein (EV422DRAFT_106782), mRNA | blastn | 2072 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 2873485 | 2873485 | PRJNA1196384_S_NODE_5183_length_179_cov_4.669014_g5119_i0 | PRJNA1196384 | 5183 | 179 | 4.669014 | 8.35753506 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 100 | 5.34e-17 | NTclustered | gi|575484485|ref|XM_006681474.1| | 684364 | g5119 | i0 | 92.754 | 1.11731843575419 | 69 | 5 | 39 | 0 | 105 | 173 | 198 | 130 | Batrachochytrium dendrobatidis JAM81 ribosomal 60S subunit protein L39 (BATDEDRAFT_91214), partial mRNA | blastn | 200 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 3593592 | 3593592 | PRJNA1196384_S_NODE_5343_length_177_cov_2.128571_g5279_i0 | PRJNA1196384 | 5343 | 177 | 2.128571 | 3.76757067 | Fungi | 4751 | Fungi | Fungi | 134 | 5.190000000000001e-27 | NTclustered | gi|2432131463|ref|XM_053113103.1| | 110093 | g5279 | i0 | 91.667 | 55.683615819209 | 96 | 8 | 54 | 0 | 74 | 169 | 213 | 118 | Polychytrium aggregatum translation protein SH3-like domain-containing protein (BJ171DRAFT_557634), partial mRNA | blastn | 9856 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6700572 | 6700572 | PRJNA1196384_S_NODE_3726_length_204_cov_3.964072_g3662_i0 | PRJNA1196384 | 3726 | 204 | 3.964072 | 8.08670688 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 159 | 1.02e-34 | NTclustered | gi|2432132805|ref|XM_053109589.1| | 110093 | g3662 | i0 | 81.188 | 11.6372549019608 | 202 | 34 | 98 | 3 | 1 | 200 | 579 | 380 | Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_490208), mRNA | blastn | 2374 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9250562 | 9250562 | PRJNA1196384_S_NODE_2148_length_265_cov_1.622807_g2084_i0 | PRJNA1196384 | 2148 | 265 | 1.6228070000000001 | 4.30043855 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 113 | 1.1e-20 | NTclustered | gi|2432164628|ref|XM_053113621.1| | 110093 | g2084 | i0 | 81.69 | 37.2490566037736 | 142 | 20 | 52 | 3 | 127 | 265 | 1408 | 1270 | Polychytrium aggregatum Adenosylhomocysteinase (BJ171DRAFT_570225), mRNA | blastn | 9871 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9250688 | 9250688 | PRJNA1196384_S_NODE_988_length_385_cov_5.600575_g924_i0 | PRJNA1196384 | 988 | 385 | 5.600575 | 21.56221375 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 156 | 2.72e-33 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g924 | i0 | 79.812 | 40.6077922077922 | 213 | 43 | 55 | 0 | 55 | 267 | 64 | 276 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 15634 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18174391 | 18174391 | PRJNA1196384_S_NODE_895_length_406_cov_3.658537_g831_i0 | PRJNA1196384 | 895 | 406 | 3.658537 | 14.85366022 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 274 | 7.64e-69 | NTclustered | gi|2432131875|ref|XM_053109384.1| | 110093 | g831 | i0 | 83.673 | 64.8669950738916 | 294 | 44 | 72 | 4 | 78 | 369 | 416 | 125 | Polychytrium aggregatum 40S ribosomal protein S20 (BJ171DRAFT_488555), mRNA | blastn | 26336 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23274924 | 23274924 | PRJNA1196384_S_NODE_3539_length_209_cov_1.552326_g3475_i0 | PRJNA1196384 | 3539 | 209 | 1.552326 | 3.24436134 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 135 | 1.7700000000000002e-27 | NTclustered | gi|2432150950|ref|XM_053107694.1| | 110093 | g3475 | i0 | 82.781 | 2.21052631578947 | 151 | 26 | 72 | 0 | 1 | 151 | 2683 | 2533 | Polychytrium aggregatum elongation factor EF-3 (BJ171DRAFT_424968), partial mRNA | blastn | 462 | 135 | 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);;