contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 954351 | 954351 | PRJNA980585_P_NODE_10501_length_414_cov_4.697947_g10247_i0 | PRJNA980585 | 10501 | 414 | 4.697947 | 19.44950058 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 154 | 1.06e-32 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g10247 | i0 | 82.418 | 41.0821256038647 | 182 | 26 | 43 | 6 | 235 | 414 | 5975 | 5798 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17008 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 3505312 | 3505312 | PRJNA980585_P_NODE_32963_length_271_cov_1.717172_g32709_i0 | PRJNA980585 | 32963 | 271 | 1.717172 | 4.65353612 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 182 | 3.04e-41 | NTclustered | gi|2432146242|ref|XM_053110900.1| | 110093 | g32709 | i0 | 80.242 | 10.2029520295203 | 248 | 43 | 90 | 4 | 12 | 256 | 315 | 71 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_503834), mRNA | blastn | 2765 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 4783065 | 4783065 | PRJNA980585_P_NODE_39644_length_253_cov_1.283333_g39390_i0 | PRJNA980585 | 39644 | 253 | 1.283333 | 3.24683249 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 154 | 6.12e-33 | NTclustered | gi|311235598|ref|NG_027613.1| | 110093 | g39390 | i0 | 90.164 | 55.4189723320158 | 122 | 6 | 61 | 3 | 1 | 122 | 2480 | 2595 | Polychytrium aggregatum JEL 109 28S rRNA gene, partial sequence; from reference material | blastn | 14021 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 4783457 | 4783457 | PRJNA980585_P_NODE_8104_length_460_cov_3.563307_g7850_i0 | PRJNA980585 | 8104 | 460 | 3.563307 | 16.3912122 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 7.21e-25 | NTclustered | gi|2432097581|ref|XM_053071233.1| | 1396493 | g7850 | i0 | 82.313 | 4.23913043478261 | 147 | 26 | 32 | 0 | 286 | 432 | 229 | 83 | Fimicolochytrium jonesii 30S ribosomal protein S30e (EV422DRAFT_541825), mRNA | blastn | 1950 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 6057834 | 6057834 | PRJNA980585_P_NODE_20605_length_320_cov_1.246964_g20351_i0 | PRJNA980585 | 20605 | 320 | 1.246964 | 3.9902848 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 215 | 3.62e-51 | NTclustered | gi|2432132805|ref|XM_053109589.1| | 110093 | g20351 | i0 | 79.167 | 20.525 | 312 | 63 | 97 | 2 | 5 | 315 | 340 | 650 | Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_490208), mRNA | blastn | 6568 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7333039 | 7333039 | PRJNA980585_P_NODE_7366_length_479_cov_2.098522_g7112_i0 | PRJNA980585 | 7366 | 479 | 2.098522 | 10.05192038 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 235 | 4.32e-57 | NTclustered | gi|2432149348|ref|XM_053111166.1| | 110093 | g7112 | i0 | 79.876 | 18.7035490605428 | 323 | 63 | 67 | 2 | 1 | 322 | 519 | 198 | Polychytrium aggregatum ribosomal protein S19-domain-containing protein (BJ171DRAFT_506928), mRNA | blastn | 8959 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9882602 | 9882602 | PRJNA980585_P_NODE_18808_length_331_cov_1.193798_g18554_i0 | PRJNA980585 | 18808 | 331 | 1.193798 | 3.95147138 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 259 | 1.71e-64 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g18554 | i0 | 82.594 | 123.90332326284 | 293 | 51 | 89 | 0 | 9 | 301 | 247 | 539 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 41012 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 11158118 | 11158118 | PRJNA980585_P_NODE_29469_length_281_cov_1.341346_g29215_i0 | PRJNA980585 | 29469 | 281 | 1.341346 | 3.76918226 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 4.15e-30 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g29215 | i0 | 76.604 | 64.4448398576512 | 265 | 60 | 94 | 2 | 2 | 265 | 13 | 276 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 18109 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 12433791 | 12433791 | PRJNA980585_P_NODE_23810_length_302_cov_1.340611_g23556_i0 | PRJNA980585 | 23810 | 302 | 1.340611 | 4.04864522 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 230 | 1.2099999999999995e-55 | NTclustered | gi|575480435|ref|XM_006679449.1| | 684364 | g23556 | i0 | 82.222 | 46.9072847682119 | 270 | 45 | 89 | 3 | 27 | 295 | 6 | 273 | Batrachochytrium dendrobatidis JAM81 peptidyl-prolyl cis-trans isomerase (BATDEDRAFT_30184), partial mRNA | blastn | 14166 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 16257509 | 16257509 | PRJNA980585_P_NODE_24893_length_296_cov_1.946188_g24639_i0 | PRJNA980585 | 24893 | 296 | 1.946188 | 5.76071648 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 75 | 5.87e-9 | NTclustered | gi|2432062422|ref|XM_053069653.1| | 1396493 | g24639 | i0 | 81.818 | 0.402027027027027 | 88 | 16 | 30 | 0 | 11 | 98 | 414 | 501 | Fimicolochytrium jonesii cytochrome c-like domain-containing protein (EV422DRAFT_520015), mRNA | blastn | 119 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 22947136 | 22947136 | PRJNA980585_P_NODE_61438_length_238_cov_2.800000_g61184_i0 | PRJNA980585 | 61438 | 238 | 2.8 | 6.664 | Fungi | 4751 | Fungi | Fungi | 86.1 | 2.11e-12 | NTclustered | gi|1866582795|gb|MT730970.1| | 4814 | g61184 | i0 | 94.643 | 24.7058823529412 | 56 | 2 | 24 | 1 | 1 | 56 | 4495 | 4441 | Chytriomyces hyalinus isolate PLAUS Ob-1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 5880 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus |
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);;