contig_metadata
8 rows where bioproject = "PRJDB12578" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3357 | 3357 | PRJDB12578_S_NODE_180481_length_177_cov_2.429688_g157423_i0 | PRJDB12578 | 180481 | 177 | 2.429688 | 4.30054776 | Bodomorpha sp. Panama105 | 555789 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.2199999999999996e-85 | NTclustered | gi|219524917|gb|EU709280.1| | 555789 | g157423 | i0 | 100 | 77.5367231638418 | 177 | 0 | 100 | 0 | 1 | 177 | 1380 | 1556 | Bodomorpha sp. Panama105 18S ribosomal RNA gene, partial sequence | blastn | 13724 | 327 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama105 | |||
| 2557511 | 2557511 | PRJDB12578_S_NODE_79663_length_396_cov_2.043228_g56606_i0 | PRJDB12578 | 79663 | 396 | 2.043228 | 8.09118288 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 732 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g56606 | i0 | 100 | 88.1818181818182 | 396 | 0 | 100 | 0 | 1 | 396 | 2112 | 1717 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 34920 | 732 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7655123 | 7655123 | PRJDB12578_S_NODE_166427_length_188_cov_1.589928_g143369_i0 | PRJDB12578 | 166427 | 188 | 1.589928 | 2.98906464 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 8.539999999999999e-90 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g143369 | i0 | 99.468 | 99.3297872340426 | 188 | 1 | 100 | 0 | 1 | 188 | 324 | 137 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 18674 | 342 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14030028 | 14030028 | PRJDB12578_S_NODE_142552_length_211_cov_1.240741_g119494_i0 | PRJDB12578 | 142552 | 211 | 1.240741 | 2.61796351 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.4799999999999995e-99 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g119494 | i0 | 98.578 | 32.6255924170616 | 211 | 3 | 100 | 0 | 1 | 211 | 2699 | 2909 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6884 | 374 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15302410 | 15302410 | PRJDB12578_S_NODE_100753_length_289_cov_1.716667_g77695_i0 | PRJDB12578 | 100753 | 289 | 1.716667 | 4.96116763 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.03e-135 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g77695 | i0 | 97.586 | 23.7162629757785 | 290 | 6 | 100 | 1 | 1 | 289 | 652 | 363 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6854 | 496 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15306362 | 15306362 | PRJDB12578_S_NODE_206093_length_164_cov_3.130435_g183035_i0 | PRJDB12578 | 206093 | 164 | 3.130435 | 5.1339134 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g183035 | i0 | 100 | 100.798780487805 | 164 | 0 | 100 | 0 | 1 | 164 | 829 | 992 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 16531 | 303 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20107259 | 20107259 | PRJDB12578_S_NODE_126176_length_232_cov_3.005464_g103118_i0 | PRJDB12578 | 126176 | 232 | 3.005464 | 6.97267648 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.2e-116 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g103118 | i0 | 100 | 96.1853448275862 | 232 | 0 | 100 | 0 | 1 | 232 | 795 | 1026 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 22315 | 429 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24226581 | 24226581 | PRJDB12578_S_NODE_111620_length_260_cov_1.545024_g88562_i0 | PRJDB12578 | 111620 | 260 | 1.545024 | 4.0170624 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.98e-71 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g88562 | i0 | 94.475 | 77.7730769230769 | 181 | 10 | 70 | 0 | 1 | 181 | 3669 | 3849 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20221 | 279 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis |
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);;