contig_metadata
22 rows where bioproject = "PRJNA1160211", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 309656 | 309656 | PRJNA1160211_S_NODE_191021_length_321_cov_3.108871_g189788_i0 | PRJNA1160211 | 191021 | 321 | 3.108871 | 9.97947591 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 588 | 1.8599999999999994e-163 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g189788 | i0 | 99.688 | 54.8847352024922 | 321 | 1 | 100 | 0 | 1 | 321 | 1687 | 2007 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 17618 | 588 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 310940 | 310940 | PRJNA1160211_S_NODE_96261_length_464_cov_16.166240_g95036_i0 | PRJNA1160211 | 96261 | 464 | 16.16624 | 75.0113536 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 765 | 0 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g95036 | i0 | 97.964 | 6.63362068965517 | 442 | 7 | 95 | 2 | 24 | 464 | 124 | 564 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 3078 | 765 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 1584842 | 1584842 | PRJNA1160211_S_NODE_273682_length_246_cov_0.890173_g272449_i0 | PRJNA1160211 | 273682 | 246 | 0.890173 | 2.18982558 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 9.77e-41 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g272449 | i0 | 88.667 | 29.5325203252033 | 150 | 13 | 61 | 3 | 88 | 237 | 3869 | 3724 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 7265 | 180 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 1585013 | 1585013 | PRJNA1160211_S_NODE_300122_length_202_cov_5.255814_g298889_i0 | PRJNA1160211 | 300122 | 202 | 5.255814 | 10.61674428 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 3.5e-59 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g298889 | i0 | 88.293 | 55.4306930693069 | 205 | 19 | 100 | 5 | 1 | 202 | 2585 | 2787 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 11197 | 241 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 2861758 | 2861758 | PRJNA1160211_S_NODE_97023_length_463_cov_3.828205_g95798_i0 | PRJNA1160211 | 97023 | 463 | 3.828205 | 17.72458915 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 2e-30 | NTclustered | gi|238617607|gb|FJ973382.1| | 39717 | g95798 | i0 | 94.681 | 22.2894168466523 | 94 | 5 | 34 | 0 | 1 | 94 | 1255 | 1348 | Paulinella chromatophora strain MO88/a 28S ribosomal RNA gene, partial sequence | blastn | 10320 | 147 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 5412147 | 5412147 | PRJNA1160211_S_NODE_12205_length_783_cov_16.097183_g11360_i0 | PRJNA1160211 | 12205 | 783 | 16.097183 | 126.04094289 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 1290 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g11360 | i0 | 96.911 | 16.6666666666667 | 777 | 11 | 98 | 9 | 18 | 783 | 547 | 1321 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 13050 | 1290 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 5412905 | 5412905 | PRJNA1160211_S_NODE_225985_length_283_cov_5.290476_g224752_i0 | PRJNA1160211 | 225985 | 283 | 5.290476 | 14.97204708 | Helkesimastix marina | 645121 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 8.33e-87 | NTclustered | gi|237687967|gb|FJ410915.1| | 645121 | g224752 | i0 | 89.552 | 0.946996466431095 | 268 | 15 | 92 | 8 | 3 | 261 | 394 | 131 | Helkesimastix sp. ATCC 50328 18S ribosomal RNA gene, partial sequence | blastn | 268 | 333 | 1 | Eukaryota | Sar | Cercozoa | Helkesimastigidae | Helkesimastix | Helkesimastix marina | ||||
| 7962694 | 7962694 | PRJNA1160211_S_NODE_170507_length_346_cov_12.575092_g169274_i0 | PRJNA1160211 | 170507 | 346 | 12.575092 | 43.50981832 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 1.1e-51 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g169274 | i0 | 78.698 | 30.8323699421965 | 338 | 62 | 95 | 8 | 4 | 332 | 2535 | 2199 | Rosculus vulgaris isolate CCA sequence | blastn | 10668 | 217 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 7963512 | 7963512 | PRJNA1160211_S_NODE_284387_length_239_cov_15.415663_g283154_i0 | PRJNA1160211 | 284387 | 239 | 15.415663 | 36.84343457 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4099999999999996e-118 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g283154 | i0 | 100 | 92.5564853556485 | 237 | 0 | 99 | 0 | 1 | 237 | 2681 | 2917 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 22121 | 438 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 8691457 | 8691457 | PRJNA1160211_S_NODE_209347_length_300_cov_5.810573_g208114_i0 | PRJNA1160211 | 209347 | 300 | 5.810573 | 17.431719 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.36e-51 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g208114 | i0 | 86.364 | 60.9033333333333 | 198 | 25 | 66 | 2 | 3 | 200 | 1481 | 1286 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 18271 | 217 | 0.990783410138249 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10513810 | 10513810 | PRJNA1160211_S_NODE_259249_length_254_cov_3.596685_g258016_i0 | PRJNA1160211 | 259249 | 254 | 3.596685 | 9.1355799 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.52e-118 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g258016 | i0 | 97.665 | 49.7637795275591 | 257 | 3 | 100 | 3 | 1 | 254 | 1727 | 1983 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 12640 | 438 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 11789019 | 11789019 | PRJNA1160211_S_NODE_298390_length_209_cov_5.661765_g297157_i0 | PRJNA1160211 | 298390 | 209 | 5.661765 | 11.83308885 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 8.06e-41 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g297157 | i0 | 92.126 | 59.0956937799043 | 127 | 10 | 61 | 0 | 83 | 209 | 2607 | 2481 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 12351 | 180 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 13063719 | 13063719 | PRJNA1160211_S_NODE_258311_length_255_cov_2.115385_g257078_i0 | PRJNA1160211 | 258311 | 255 | 2.115385 | 5.39423175 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.67e-34 | NR | AAT09066.1 | 227086 | g257078 | i0 | 69.6 | 1.90588235294118 | 79 | 23 | 92.9 | 1 | 237 | 1 | 53 | 130 | AAT09066.1 GTP binding nuclear protein RAN [Bigelowiella natans] | diamond | 486 | 127 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 14337930 | 14337930 | PRJNA1160211_S_NODE_106612_length_444_cov_54.097035_g105384_i0 | PRJNA1160211 | 106612 | 444 | 54.097035 | 240.1908354 | Viridiuvalis adhaerens | 1977046 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 1.88e-45 | NTclustered | gi|1248454657|dbj|LC229572.1| | 1977046 | g105384 | i0 | 80.669 | 34.2905405405405 | 269 | 39 | 59 | 11 | 9 | 271 | 804 | 1065 | Viridiuvalis adhaerens gene for 28S ribosomal RNA, partial sequence | blastn | 15225 | 196 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Viridiuvalis | Viridiuvalis adhaerens | ||||
| 14339040 | 14339040 | PRJNA1160211_S_NODE_249612_length_262_cov_2.190476_g248379_i0 | PRJNA1160211 | 249612 | 262 | 2.190476 | 5.73904712 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.56e-123 | NTclustered | gi|2651357801|gb|PP174314.1| | 1979794 | g248379 | i0 | 98.092 | 99.6374045801527 | 262 | 4 | 100 | 1 | 1 | 262 | 3196 | 3456 | Cercomonas sp. isolate P5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26105 | 455 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 14339247 | 14339247 | PRJNA1160211_S_NODE_286632_length_236_cov_5.546012_g285399_i0 | PRJNA1160211 | 286632 | 236 | 5.546012 | 13.08858832 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 5.07e-108 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g285399 | i0 | 100 | 75.6525423728814 | 218 | 0 | 92 | 0 | 1 | 218 | 1468 | 1685 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 17854 | 403 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15612069 | 15612069 | PRJNA1160211_S_NODE_146553_length_379_cov_17.937908_g145320_i0 | PRJNA1160211 | 146553 | 379 | 17.937908 | 67.98467132 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 3.229999999999999e-82 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g145320 | i0 | 82.933 | 95.6358839050132 | 375 | 43 | 96 | 13 | 18 | 379 | 2200 | 2566 | Rosculus vulgaris isolate CCA sequence | blastn | 36246 | 318 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 16887809 | 16887809 | PRJNA1160211_S_NODE_68814_length_524_cov_17.008869_g67609_i0 | PRJNA1160211 | 68814 | 524 | 17.008869 | 89.12647356 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 926 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g67609 | i0 | 100 | 4.87213740458015 | 501 | 0 | 96 | 0 | 24 | 524 | 58 | 558 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2553 | 926 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 18161055 | 18161055 | PRJNA1160211_S_NODE_166755_length_351_cov_17.564748_g165522_i0 | PRJNA1160211 | 166755 | 351 | 17.564748 | 61.65226548 | Helkesimastix marina | 645121 | SAR_Eukaryotes | SAR_Eukaryotes | 556 | 5.769999999999999e-154 | NTclustered | gi|237687967|gb|FJ410915.1| | 645121 | g165522 | i0 | 99.349 | 33.1566951566952 | 307 | 2 | 87 | 0 | 24 | 330 | 777 | 1083 | Helkesimastix sp. ATCC 50328 18S ribosomal RNA gene, partial sequence | blastn | 11638 | 556 | 1 | Eukaryota | Sar | Cercozoa | Helkesimastigidae | Helkesimastix | Helkesimastix marina | ||||
| 19435097 | 19435097 | PRJNA1160211_S_NODE_122096_length_417_cov_79.436047_g120867_i0 | PRJNA1160211 | 122096 | 417 | 79.436047 | 331.24831599 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 7.649999999999999e-89 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g120867 | i0 | 83.508 | 31.5107913669065 | 382 | 45 | 90 | 14 | 19 | 394 | 2566 | 2197 | Rosculus vulgaris isolate CCA sequence | blastn | 13140 | 340 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 19436339 | 19436339 | PRJNA1160211_S_NODE_296_length_1987_cov_13.332811_g208_i0 | PRJNA1160211 | 296 | 1987 | 13.332811 | 264.92295457 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.45e-67 | NTclustered | gi|1402550486|gb|MH488772.1| | 2231170 | g208 | i0 | 84.752 | 18.3900352289884 | 282 | 31 | 20 | 8 | 1236 | 1513 | 1266 | 1539 | Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence | blastn | 36541 | 272 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 24535193 | 24535193 | PRJNA1160211_S_NODE_13320_length_769_cov_13.333333_g12456_i0 | PRJNA1160211 | 13320 | 769 | 13.333333 | 102.53333077 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 1177 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g12456 | i0 | 94.595 | 16.5305591677503 | 777 | 15 | 98 | 17 | 1 | 752 | 1321 | 547 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 12712 | 1177 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. |
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);;