contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9212517 | 9212517 | PRJNA1136505_P_NODE_35608_length_591_cov_2.808880_g28791_i0 | PRJNA1136505 | 35608 | 591 | 2.80888 | 16.6004808 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 344 | 8.61e-90 | NTclustered | gi|1160575900|ref|XM_020582690.1| | 670386 | g28791 | i0 | 79.352 | 58.5651438240271 | 494 | 98 | 83 | 4 | 59 | 550 | 504 | 13 | Polysphondylium pallidum PN500 Rab GTPase (rab7A), partial mRNA | blastn | 34612 | 344 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 10488055 | 10488055 | PRJNA1136505_P_NODE_158749_length_225_cov_4.309211_g151889_i0 | PRJNA1136505 | 158749 | 225 | 4.309211 | 9.69572475 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 241 | 3.9800000000000004e-59 | NTclustered | gi|470266101|ref|XM_004361626.1| | 261658 | g151889 | i0 | 87.5 | 82.4311111111111 | 208 | 26 | 92 | 0 | 1 | 208 | 208 | 1 | Cavenderia fasciculata uncharacterized protein (DFA_05968), partial mRNA | blastn | 18547 | 241 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 15587401 | 15587401 | PRJNA1136505_P_NODE_31153_length_676_cov_3.019900_g24400_i0 | PRJNA1136505 | 31153 | 676 | 3.0199 | 20.414524 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 486 | 1.5599999999999998e-132 | NTclustered | gi|831757464|ref|XM_012893584.1| | 1410327 | g24400 | i0 | 84.413 | 71.0502958579882 | 494 | 77 | 73 | 0 | 183 | 676 | 512 | 19 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 48030 | 486 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 20685938 | 20685938 | PRJNA1136505_P_NODE_82217_length_322_cov_0.919679_g75357_i0 | PRJNA1136505 | 82217 | 322 | 0.919679 | 2.96136638 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 235 | 2.8e-57 | NTclustered | gi|831768659|ref|XM_012897017.1| | 1410327 | g75357 | i0 | 87.019 | 1.96894409937888 | 208 | 27 | 65 | 0 | 94 | 301 | 608 | 815 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 634 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;