contig_metadata
12 rows where bioproject = "PRJNA493244", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3006679 | 3006679 | PRJNA493244_P_NODE_1523043_length_237_cov_10.267045_g1499918_i0 | PRJNA493244 | 1523043 | 237 | 10.267045 | 24.33289665 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.48e-19 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g1499918 | i0 | 94.286 | 0.29535864978903 | 70 | 4 | 30 | 0 | 104 | 173 | 2861 | 2792 | Rosculus vulgaris isolate CCA sequence | blastn | 70 | 108 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 5559741 | 5559741 | PRJNA493244_P_NODE_1647405_length_210_cov_3.302013_g1624280_i0 | PRJNA493244 | 1647405 | 210 | 3.302013 | 6.9342273 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 7.93e-56 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g1624280 | i0 | 94.04 | 12.6285714285714 | 151 | 9 | 72 | 0 | 60 | 210 | 1582 | 1732 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2652 | 230 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 6832836 | 6832836 | PRJNA493244_P_NODE_1230546_length_318_cov_30.015564_g1207422_i0 | PRJNA493244 | 1230546 | 318 | 30.015564 | 95.44949352 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 4.24e-115 | NTclustered | gi|2666517884|gb|PP258995.1| | 2231160 | g1207422 | i0 | 94.035 | 41.9559748427673 | 285 | 12 | 88 | 4 | 38 | 318 | 1 | 284 | Rosculus sp. strain SARCA10 small subunit ribosomal RNA gene, partial sequence | blastn | 13342 | 427 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 6833178 | 6833178 | PRJNA493244_P_NODE_1388026_length_271_cov_5.366667_g1364901_i0 | PRJNA493244 | 1388026 | 271 | 5.366667 | 14.54366757 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.7099999999999996e-121 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g1364901 | i0 | 98.431 | 5.45018450184502 | 255 | 3 | 94 | 1 | 18 | 271 | 103 | 357 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 1477 | 448 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 7477791 | 7477791 | PRJNA493244_P_NODE_1428786_length_260_cov_29.924623_g1405661_i0 | PRJNA493244 | 1428786 | 260 | 29.924623 | 77.8040198 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.07e-20 | NTclustered | gi|88792586|gb|DQ386167.1| | 188980 | g1405661 | i0 | 93.506 | 190.288461538462 | 77 | 4 | 29 | 1 | 182 | 257 | 2721 | 2797 | Thaumatomastix sp. ATCC 50250 28S ribosomal RNA gene, partial sequence | blastn | 49475 | 113 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. ATCC 50250 | ||
| 14483816 | 14483816 | PRJNA493244_P_NODE_1230552_length_318_cov_25.673152_g1207428_i0 | PRJNA493244 | 1230552 | 318 | 25.673152 | 81.64062336 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.38e-162 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1207428 | i0 | 100 | 99.6006289308176 | 316 | 0 | 99 | 0 | 3 | 318 | 345 | 30 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 31673 | 584 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15758951 | 15758951 | PRJNA493244_P_NODE_1676593_length_206_cov_4.503448_g1653468_i0 | PRJNA493244 | 1676593 | 206 | 4.503448 | 9.27710288 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 3.84e-9 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g1653468 | i0 | 74.468 | 1.58252427184466 | 188 | 41 | 90 | 6 | 1 | 185 | 2292 | 2109 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 326 | 75 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 17035156 | 17035156 | PRJNA493244_P_NODE_984894_length_413_cov_8.693182_g961820_i0 | PRJNA493244 | 984894 | 413 | 8.693182 | 35.90284166 | Chlorarachniophyceae sp. P314 | 467060 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.29e-29 | NTclustered | gi|220983378|dbj|AB453014.1| | 467060 | g961820 | i0 | 87.805 | 27.6150121065375 | 123 | 14 | 46 | 1 | 274 | 396 | 1892 | 1771 | Chlorarachniophyceae sp. P314 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 11405 | 143 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. P314 | |||||
| 18307857 | 18307857 | PRJNA493244_P_NODE_1660475_length_208_cov_2.945578_g1637350_i0 | PRJNA493244 | 1660475 | 208 | 2.945578 | 6.12680224 | Rosculus philanguis | 2231163 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 6.059999999999999e-57 | NTclustered | gi|1402550480|gb|MH488766.1| | 2231163 | g1637350 | i0 | 89.305 | 8.20192307692308 | 187 | 18 | 89 | 2 | 2 | 186 | 440 | 254 | Rosculus philanguis isolate HAS small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1706 | 233 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus philanguis | ||||
| 18308432 | 18308432 | PRJNA493244_P_NODE_31755_length_2114_cov_325.855334_g28889_i0 | PRJNA493244 | 31755 | 2114 | 325.855334 | 6888.58176076 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 3687 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g28889 | i0 | 98.515 | 28.0591296121097 | 2087 | 25 | 99 | 5 | 5 | 2090 | 2085 | 4 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 59317 | 3687 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 22777109 | 22777109 | PRJNA493244_P_NODE_1747558_length_185_cov_5.201613_g1724433_i0 | PRJNA493244 | 1747558 | 185 | 5.201613 | 9.62298405 | Helkesimastix | 310813 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2e-16 | NTclustered | gi|1002343660|gb|KU738538.1| | 175275 | g1724433 | i0 | 88.75 | 4.34594594594595 | 80 | 9 | 43 | 0 | 17 | 96 | 25 | 104 | Uncultured Cercozoa clone Cow/sheep_dung1 18S ribosomal RNA gene, partial sequence | blastn | 804 | 99 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 24681649 | 24681649 | PRJNA493244_P_NODE_1444260_length_256_cov_36.707692_g1421135_i0 | PRJNA493244 | 1444260 | 256 | 36.707692 | 93.97169152 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 7.909999999999997e-42 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1421135 | i0 | 82.273 | 57.34765625 | 220 | 32 | 86 | 3 | 20 | 239 | 3840 | 3628 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14681 | 183 | 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);;