contig_metadata
10 rows where bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 970336 | 970336 | PRJNA983848_P_NODE_69281_length_380_cov_27.048860_g63398_i0 | PRJNA983848 | 69281 | 380 | 27.04886 | 102.785668 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 6.619999999999997e-119 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g63398 | i0 | 88.674 | 96.4473684210526 | 362 | 39 | 95 | 2 | 19 | 379 | 1222 | 1582 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 36650 | 440 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6071714 | 6071714 | PRJNA983848_P_NODE_167705_length_199_cov_6.714286_g161822_i0 | PRJNA983848 | 167705 | 199 | 6.714286 | 13.36142914 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 2.64e-65 | NTclustered | gi|1951968740|gb|MW430267.1| | 1979794 | g161822 | i0 | 90.404 | 53.2211055276382 | 198 | 19 | 99 | 0 | 2 | 199 | 202 | 5 | Cercomonas sp. isolate B_OTU_27 large subunit ribosomal RNA gene, partial sequence | blastn | 10591 | 261 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 6073186 | 6073186 | PRJNA983848_P_NODE_58805_length_428_cov_87.239437_g52924_i0 | PRJNA983848 | 58805 | 428 | 87.239437 | 373.38479036 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 791 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g52924 | i0 | 100 | 12.2546728971963 | 428 | 0 | 100 | 0 | 1 | 428 | 380 | 807 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 5245 | 791 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9896614 | 9896614 | PRJNA983848_P_NODE_167468_length_203_cov_11.815385_g161585_i0 | PRJNA983848 | 167468 | 203 | 11.815385 | 23.98523155 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 9.24e-100 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g161585 | i0 | 100 | 71.0541871921182 | 203 | 0 | 100 | 0 | 1 | 203 | 1497 | 1699 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 14424 | 375 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17545083 | 17545083 | PRJNA983848_P_NODE_130634_length_260_cov_34.112299_g124751_i0 | PRJNA983848 | 130634 | 260 | 34.112299 | 88.6919774 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 1.1899999999999999e-129 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g124751 | i0 | 99.615 | 96.4807692307692 | 260 | 1 | 100 | 0 | 1 | 260 | 332 | 73 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 25085 | 475 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17549321 | 17549321 | PRJNA983848_P_NODE_97814_length_306_cov_13.759657_g91931_i0 | PRJNA983848 | 97814 | 306 | 13.759657 | 42.10455042 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 562 | 1.07e-155 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g91931 | i0 | 100 | 97.3169934640523 | 304 | 0 | 99 | 0 | 1 | 304 | 666 | 969 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 29779 | 562 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20097268 | 20097268 | PRJNA983848_P_NODE_81796_length_341_cov_4.447761_g75913_i0 | PRJNA983848 | 81796 | 341 | 4.447761 | 15.16686501 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 2.7399999999999998e-117 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g75913 | i0 | 90.058 | 90.8651026392962 | 342 | 25 | 99 | 6 | 1 | 340 | 1934 | 1600 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 30985 | 435 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22646703 | 22646703 | PRJNA983848_P_NODE_49078_length_498_cov_46.378824_g43203_i0 | PRJNA983848 | 49078 | 498 | 46.378824 | 230.96654352 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 686 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g43203 | i0 | 99.213 | 65.4658634538153 | 381 | 1 | 100 | 2 | 1 | 380 | 2103 | 1724 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32602 | 686 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23923121 | 23923121 | PRJNA983848_P_NODE_74739_length_361_cov_33.649306_g68856_i0 | PRJNA983848 | 74739 | 361 | 33.649306 | 121.47399466 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 8.259999999999998e-103 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g68856 | i0 | 86.427 | 52.1634349030471 | 361 | 39 | 99 | 9 | 1 | 358 | 3680 | 4033 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18831 | 387 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 25196585 | 25196585 | PRJNA983848_P_NODE_70940_length_374_cov_5.411960_g65057_i0 | PRJNA983848 | 70940 | 374 | 5.41196 | 20.2407304 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 3.5899999999999984e-176 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g65057 | i0 | 97.059 | 101.171122994652 | 374 | 11 | 100 | 0 | 1 | 374 | 1601 | 1228 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 37838 | 630 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa |
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);;