contig_metadata
21 rows where bioproject = "PRJNA1245487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1625726 | 1625726 | PRJNA1245487_P_NODE_12002_length_336_cov_4.463878_g11664_i0 | PRJNA1245487 | 12002 | 336 | 4.463878 | 14.99863008 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 6.21e-69 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11664 | i0 | 93.122 | 58.0297619047619 | 189 | 10 | 55 | 3 | 151 | 336 | 3846 | 3658 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19498 | 274 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 1625739 | 1625739 | PRJNA1245487_P_NODE_13062_length_319_cov_2.174797_g12724_i0 | PRJNA1245487 | 13062 | 319 | 2.174797 | 6.93760243 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 1.23e-85 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g12724 | i0 | 85.58 | 92.4670846394984 | 319 | 41 | 99 | 4 | 1 | 316 | 1657 | 1973 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 29497 | 329 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 1625856 | 1625856 | PRJNA1245487_P_NODE_22762_length_231_cov_3.518987_g22424_i0 | PRJNA1245487 | 22762 | 231 | 3.518987 | 8.12885997 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 2.9399999999999998e-115 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g22424 | i0 | 100 | 83.051948051948 | 231 | 0 | 100 | 0 | 1 | 231 | 1475 | 1705 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 19185 | 427 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2902018 | 2902018 | PRJNA1245487_P_NODE_4163_length_615_cov_1.590406_g3833_i0 | PRJNA1245487 | 4163 | 615 | 1.590406 | 9.7809969 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1024 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g3833 | i0 | 98.951 | 97.219512195122 | 572 | 6 | 93 | 0 | 44 | 615 | 837 | 266 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 59790 | 1024 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4178348 | 4178348 | PRJNA1245487_P_NODE_19524_length_251_cov_1.668539_g19186_i0 | PRJNA1245487 | 19524 | 251 | 1.668539 | 4.18803289 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 2.47e-126 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g19186 | i0 | 100 | 32.1354581673307 | 251 | 0 | 100 | 0 | 1 | 251 | 2149 | 2399 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8066 | 464 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 5454535 | 5454535 | PRJNA1245487_P_NODE_15965_length_281_cov_2.750000_g15627_i0 | PRJNA1245487 | 15965 | 281 | 2.75 | 7.7275 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.9e-94 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g15627 | i0 | 89.716 | 34.864768683274 | 282 | 26 | 100 | 2 | 1 | 281 | 2503 | 2224 | Rosculus vulgaris isolate CCA sequence | blastn | 9797 | 357 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 5454655 | 5454655 | PRJNA1245487_P_NODE_6065_length_507_cov_2.497696_g5729_i0 | PRJNA1245487 | 6065 | 507 | 2.497696 | 12.66331872 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 7.679999999999999e-55 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g5729 | i0 | 75.911 | 27.465483234714 | 494 | 92 | 96 | 17 | 1 | 485 | 7820 | 8295 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 13925 | 228 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 6728827 | 6728827 | PRJNA1245487_P_NODE_12566_length_327_cov_3.937008_g12228_i0 | PRJNA1245487 | 12566 | 327 | 3.937008 | 12.87401616 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 1.8799999999999993e-168 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g12228 | i0 | 100 | 100.207951070336 | 327 | 0 | 100 | 0 | 1 | 327 | 19 | 345 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 32768 | 604 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6728837 | 6728837 | PRJNA1245487_P_NODE_13746_length_309_cov_1.673729_g13408_i0 | PRJNA1245487 | 13746 | 309 | 1.673729 | 5.17182261 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 571 | 1.7899999999999995e-158 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g13408 | i0 | 100 | 23.4563106796117 | 309 | 0 | 100 | 0 | 1 | 309 | 357 | 665 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 7248 | 571 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6728990 | 6728990 | PRJNA1245487_P_NODE_4706_length_578_cov_2.994059_g4374_i0 | PRJNA1245487 | 4706 | 578 | 2.994059 | 17.30566102 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 1057 | 0 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g4374 | i0 | 99.654 | 43.742214532872 | 578 | 2 | 100 | 0 | 1 | 578 | 1506 | 2083 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 25283 | 1057 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 6728991 | 6728991 | PRJNA1245487_P_NODE_486_length_1476_cov_5.569494_g339_i0 | PRJNA1245487 | 486 | 1476 | 5.569494 | 82.20573144 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 546 | 7.069999999999999e-190 | NR | MES1909605.1 | 1215613 | g339 | i0 | 74.1 | 3.65853658536585 | 352 | 91 | 71.5 | 0 | 1475 | 420 | 82 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 5400 | 548 | 0.996350364963504 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 6729001 | 6729001 | PRJNA1245487_P_NODE_5966_length_511_cov_1.105023_g5630_i0 | PRJNA1245487 | 5966 | 511 | 1.105023 | 5.64666753 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 251 | 3.77e-81 | NR | ADK26624.1 | 323453 | g5630 | i0 | 77.4 | 0.933463796477495 | 159 | 36 | 93.3 | 0 | 6 | 482 | 118 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 477 | 251 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 9979451 | 9979451 | PRJNA1245487_P_NODE_22428_length_236_cov_2.932515_g22090_i0 | PRJNA1245487 | 22428 | 236 | 2.932515 | 6.9207354 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 3.23e-65 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g22090 | i0 | 99.306 | 75.0805084745763 | 144 | 1 | 61 | 0 | 1 | 144 | 3274 | 3417 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 17719 | 261 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13104983 | 13104983 | PRJNA1245487_P_NODE_18071_length_261_cov_3.047872_g17733_i0 | PRJNA1245487 | 18071 | 261 | 3.047872 | 7.95494592 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.12e-132 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g17733 | i0 | 100 | 34.4942528735632 | 261 | 0 | 100 | 0 | 1 | 261 | 1112 | 1372 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 9003 | 483 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 14380273 | 14380273 | PRJNA1245487_P_NODE_21352_length_244_cov_1.637427_g21014_i0 | PRJNA1245487 | 21352 | 244 | 1.637427 | 3.99532188 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 4.7e-9 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g21014 | i0 | 84.615 | 14.3524590163934 | 78 | 9 | 32 | 3 | 98 | 175 | 1825 | 1751 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 3502 | 75 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 15654009 | 15654009 | PRJNA1245487_P_NODE_10933_length_357_cov_2.373239_g10595_i0 | PRJNA1245487 | 10933 | 357 | 2.373239 | 8.47246323 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 6.49e-84 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10595 | i0 | 84.034 | 12.859943977591 | 357 | 36 | 99 | 10 | 1 | 356 | 3685 | 4021 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4591 | 324 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 16928216 | 16928216 | PRJNA1245487_P_NODE_10574_length_364_cov_4.704467_g10236_i0 | PRJNA1245487 | 10574 | 364 | 4.704467 | 17.12425988 | Glissomonad sp. Panama103 | 563749 | SAR_Eukaryotes | SAR_Eukaryotes | 671 | 0 | NTclustered | gi|219524909|gb|EU709272.1| | 563749 | g10236 | i0 | 100 | 70.9615384615385 | 363 | 0 | 99 | 0 | 1 | 363 | 499 | 861 | Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence | blastn | 25830 | 671 | 1 | Eukaryota | Sar | Cercozoa | Glissomonad sp. Panama103 | ||||||
| 16928330 | 16928330 | PRJNA1245487_P_NODE_19774_length_250_cov_1.762712_g19436_i0 | PRJNA1245487 | 19774 | 250 | 1.762712 | 4.40678 | Glissomonad sp. Panama103 | 563749 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.1099999999999985e-124 | NTclustered | gi|219524909|gb|EU709272.1| | 563749 | g19436 | i0 | 99.6 | 99.856 | 250 | 1 | 100 | 0 | 1 | 250 | 266 | 17 | Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence | blastn | 24964 | 457 | 1 | Eukaryota | Sar | Cercozoa | Glissomonad sp. Panama103 | ||||||
| 18202780 | 18202780 | PRJNA1245487_P_NODE_1615_length_935_cov_7.259861_g1344_i0 | PRJNA1245487 | 1615 | 935 | 7.259861 | 67.87970035 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 2.1899999999999998e-132 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1344 | i0 | 83.152 | 57.8427807486631 | 552 | 74 | 59 | 16 | 204 | 751 | 1400 | 864 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 54083 | 486 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19477137 | 19477137 | PRJNA1245487_P_NODE_14796_length_294_cov_2.751131_g14458_i0 | PRJNA1245487 | 14796 | 294 | 2.751131 | 8.08832514 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 1.7299999999999995e-143 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g14458 | i0 | 98.639 | 101.387755102041 | 294 | 4 | 100 | 0 | 1 | 294 | 2970 | 2677 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 29808 | 521 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24577336 | 24577336 | PRJNA1245487_P_NODE_13120_length_318_cov_2.089796_g12782_i0 | PRJNA1245487 | 13120 | 318 | 2.089796 | 6.64555128 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 2.0999999999999997e-68 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g12782 | i0 | 83.072 | 53.2138364779874 | 319 | 35 | 99 | 12 | 4 | 318 | 4001 | 3698 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16922 | 272 | 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);;