contig_metadata
2 rows where analysis = "blastn", bioproject = "PRJNA986547" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10200923 | 10200923 | PRJNA986547_P_NODE_7248_length_259_cov_4.193548_g7166_i0 | PRJNA986547 | 7248 | 259 | 4.193548 | 10.86128932 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 309 | 1.2700000000000002e-79 | NTclustered | gi|330795360|ref|XM_003285694.1| | 5786 | g7166 | i0 | 88.372 | 98.9305019305019 | 258 | 28 | 99 | 2 | 1 | 257 | 872 | 616 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91566), mRNA | blastn | 25623 | 309 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 15002069 | 15002069 | PRJNA986547_P_NODE_15272_length_216_cov_4.321678_g15190_i0 | PRJNA986547 | 15272 | 216 | 4.321678 | 9.33482448 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 95.3 | 3.12e-15 | NTclustered | gi|1160570464|ref|XM_020574726.1| | 670386 | g15190 | i0 | 92.424 | 0.513888888888889 | 66 | 5 | 31 | 0 | 134 | 199 | 365 | 430 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 111 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;