contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985837 | 985837 | PRJEB17675_P_NODE_12241_length_240_cov_2.507317_g11937_i0 | PRJEB17675 | 12241 | 240 | 2.507317 | 6.0175608 | Chytridiomycetes | 451435 | Fungi | Fungi | 189 | 1.58e-43 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g11937 | i0 | 81.982 | 88.7375 | 222 | 40 | 93 | 0 | 1 | 222 | 284 | 505 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 21297 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 5124094 | 5124094 | PRJEB17675_P_NODE_4285_length_472_cov_4.670481_g3988_i0 | PRJEB17675 | 4285 | 472 | 4.670481 | 22.04467032 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 440 | 8.389999999999998e-119 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g3988 | i0 | 84.738 | 88.9661016949153 | 439 | 67 | 93 | 0 | 34 | 472 | 578 | 140 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 41992 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6399796 | 6399796 | PRJEB17675_P_NODE_23746_length_156_cov_1.652893_g23442_i0 | PRJEB17675 | 23746 | 156 | 1.652893 | 2.57851308 | Monoblepharella sp. M15 | 252809 | Fungi | Fungi | 82.4 | 1.64e-11 | NTclustered | gi|82792147|gb|DQ282605.1| | 252809 | g23442 | i0 | 78.195 | 11.7628205128205 | 133 | 25 | 84 | 4 | 18 | 148 | 505 | 635 | Monoblepharella sp. M15 isolate AFTOL-ID 25 elongation factor 1-alpha (EF1-alpha) gene, partial cds | blastn | 1835 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Monoblepharidaceae | Monoblepharella | Monoblepharella sp. M15 | |
| 6399803 | 6399803 | PRJEB17675_P_NODE_2546_length_618_cov_5.238422_g2301_i0 | PRJEB17675 | 2546 | 618 | 5.238422 | 32.37344796 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 252 | 5.63e-62 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g2301 | i0 | 80.606 | 6.22168284789644 | 330 | 61 | 53 | 3 | 112 | 440 | 508 | 181 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 3845 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus |
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);;