contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1037795 | 1037795 | PRJNA1158727_P_NODE_88501_length_317_cov_1.032787_g81040_i0 | PRJNA1158727 | 88501 | 317 | 1.032787 | 3.27393479 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 427 | 4.22e-115 | NTclustered | gi|330840543|ref|XM_003292226.1| | 5786 | g81040 | i0 | 91.586 | 97.6214511041009 | 309 | 26 | 97 | 0 | 9 | 317 | 437 | 129 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92832), mRNA | blastn | 30946 | 429 | 0.995337995337995 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4865730 | 4865730 | PRJNA1158727_P_NODE_57764_length_440_cov_1.117166_g50303_i0 | PRJNA1158727 | 57764 | 440 | 1.117166 | 4.9155304 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 551 | 3.4399999999999983e-152 | NTclustered | gi|330841829|ref|XM_003292845.1| | 5786 | g50303 | i0 | 89.607 | 97.2772727272727 | 433 | 45 | 98 | 0 | 7 | 439 | 1042 | 610 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA | blastn | 42802 | 556 | 0.991007194244604 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18155428 | 18155428 | PRJNA1158727_P_NODE_125615_length_261_cov_1.367021_g118154_i0 | PRJNA1158727 | 125615 | 261 | 1.367021 | 3.56792481 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 399 | 7.379999999999998e-107 | NTclustered | gi|2467140639|dbj|LC720133.1| | 668358 | g118154 | i0 | 94.253 | 52.5210727969349 | 261 | 15 | 100 | 0 | 1 | 261 | 11 | 271 | Tychosporium acutostipes YIP-60 gene for 18S rRNA, partial sequence | blastn | 13708 | 399 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 18158002 | 18158002 | PRJNA1158727_P_NODE_72095_length_366_cov_1.576792_g64634_i0 | PRJNA1158727 | 72095 | 366 | 1.576792 | 5.77105872 | Arcyria cinerea | 137621 | Evosea | other_Eukaryota | 231 | 4.16e-56 | NTclustered | gi|2772191635|gb|PQ014995.1| | 137621 | g64634 | i0 | 78.857 | 71.0027322404372 | 350 | 68 | 95 | 6 | 17 | 363 | 170 | 516 | Arcyria cinerea voucher TUF105910 translation elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 25987 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria cinerea | ||
| 19432768 | 19432768 | PRJNA1158727_P_NODE_90316_length_312_cov_2.577406_g82855_i0 | PRJNA1158727 | 90316 | 312 | 2.577406 | 8.04150672 | Tychosporium acutostipes | 668358 | Evosea | other_Eukaryota | 483 | 8.729999999999998e-132 | NTclustered | gi|256550195|gb|FJ792703.1| | 668358 | g82855 | i0 | 94.551 | 21.9711538461538 | 312 | 17 | 100 | 0 | 1 | 312 | 542 | 853 | Tychosporium acutostipes strain KE11AL small subunit ribosomal RNA gene, partial sequence | blastn | 6855 | 483 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Tychosporium | Tychosporium acutostipes | |||
| 21979907 | 21979907 | PRJNA1158727_P_NODE_100618_length_292_cov_1.050228_g93157_i0 | PRJNA1158727 | 100618 | 292 | 1.050228 | 3.06666576 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|330795589|ref|XM_003285807.1| | 5786 | g93157 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 244 | 271 | 951 | 978 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_94041), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;