contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14973286 | 14973286 | PRJNA975724_S_NODE_10972_length_441_cov_13.228261_g10791_i0 | PRJNA975724 | 10972 | 441 | 13.228261 | 58.33663101 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 206 | 3.0899999999999996e-48 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g10791 | i0 | 79.344 | 56.0340136054422 | 305 | 53 | 67 | 7 | 62 | 358 | 38 | 340 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 24711 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14974151 | 14974151 | PRJNA975724_S_NODE_46212_length_305_cov_1.836207_g46031_i0 | PRJNA975724 | 46212 | 305 | 1.836207 | 5.60043135 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 183 | 9.659999999999997e-42 | NTclustered | gi|1026953358|ref|XM_016749715.1| | 645134 | g46031 | i0 | 82.775 | 8.27540983606557 | 209 | 32 | 68 | 4 | 14 | 220 | 329 | 535 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S14 (SPPG_01396), mRNA | blastn | 2524 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 18797300 | 18797300 | PRJNA975724_S_NODE_14735_length_414_cov_13.149560_g14554_i0 | PRJNA975724 | 14735 | 414 | 13.14956 | 54.4391784 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 147 | 1.77e-30 | NTclustered | gi|2432156332|ref|XM_053115009.1| | 110093 | g14554 | i0 | 79.535 | 9.73671497584541 | 215 | 37 | 51 | 6 | 1 | 213 | 514 | 723 | Polychytrium aggregatum Manganese/iron superoxide dismutase (BJ171DRAFT_600410), mRNA | blastn | 4031 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19118187 | 19118187 | PRJNA975724_S_NODE_355_length_1088_cov_6.054187_g302_i0 | PRJNA975724 | 355 | 1088 | 6.054187 | 65.86955456 | Entophlyctis | 64501 | Fungi | Fungi | 172 | 8.139999999999999e-38 | NTclustered | gi|1866582500|gb|MT730675.1| | 109932 | g302 | i0 | 77.108 | 15.8556985294118 | 332 | 55 | 41 | 17 | 743 | 1063 | 4672 | 4351 | Entophlyctis luteolus isolate JEL0129 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 | 17251 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 23897810 | 23897810 | PRJNA975724_S_NODE_10859_length_442_cov_25.682927_g10678_i0 | PRJNA975724 | 10859 | 442 | 25.682927 | 113.51853734 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 6.71e-45 | NTclustered | gi|2432129762|ref|XM_053108984.1| | 110093 | g10678 | i0 | 82.128 | 1.60859728506787 | 235 | 34 | 52 | 7 | 32 | 262 | 104 | 334 | Polychytrium aggregatum 60S ribosomal protein L37 (BJ171DRAFT_484391), mRNA | blastn | 711 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 25171501 | 25171501 | PRJNA975724_S_NODE_11980_length_433_cov_35.630556_g11799_i0 | PRJNA975724 | 11980 | 433 | 35.630556 | 154.28030748 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 135 | 4.03e-27 | NTclustered | gi|2432139102|ref|XM_053107495.1| | 110093 | g11799 | i0 | 92.553 | 16.3741339491917 | 94 | 7 | 22 | 0 | 36 | 129 | 213 | 306 | Polychytrium aggregatum ribosomal protein L34e-domain-containing protein (BJ171DRAFT_421619), partial mRNA | blastn | 7090 | 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);;