contig_metadata
23 rows where bioproject = "PRJEB14803", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21422 | 21422 | PRJEB14803_P_NODE_18001_length_277_cov_5.793388_g17535_i0 | PRJEB14803 | 18001 | 277 | 5.793388 | 16.04768476 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.78e-73 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g17535 | i0 | 85.614 | 46.1480144404332 | 285 | 29 | 100 | 7 | 1 | 277 | 1881 | 1601 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 12783 | 289 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2571311 | 2571311 | PRJEB14803_P_NODE_26643_length_213_cov_42.191011_g26177_i0 | PRJEB14803 | 26643 | 213 | 42.191011 | 89.86685343 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.72e-100 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g26177 | i0 | 98.592 | 97.6244131455399 | 213 | 3 | 100 | 0 | 1 | 213 | 1549 | 1761 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 20794 | 377 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 3847617 | 3847617 | PRJEB14803_P_NODE_23944_length_229_cov_2.969072_g23478_i0 | PRJEB14803 | 23944 | 229 | 2.969072 | 6.79917488 | Sandona mutans | 563755 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 3.76e-114 | NTclustered | gi|224996445|gb|FJ654277.1| | 563755 | g23478 | i0 | 100 | 99.9825327510917 | 229 | 0 | 100 | 0 | 1 | 229 | 441 | 669 | Cercozoa sp. ATCC50314p145at3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 22896 | 424 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 5123853 | 5123853 | PRJEB14803_P_NODE_27845_length_207_cov_3.488372_g27379_i0 | PRJEB14803 | 27845 | 207 | 3.488372 | 7.22093004 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.08e-4 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g27379 | i0 | 90.909 | 3.57487922705314 | 44 | 4 | 21 | 0 | 1 | 44 | 2310 | 2267 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 740 | 60.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 6399525 | 6399525 | PRJEB14803_P_NODE_16986_length_288_cov_2.893281_g16520_i0 | PRJEB14803 | 16986 | 288 | 2.893281 | 8.33264928 | Thaumatomonas sp. DDM-2005 | 310812 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 8.56e-82 | NTclustered | gi|58414952|gb|AY748811.1| | 310812 | g16520 | i0 | 86.458 | 132.520833333333 | 288 | 39 | 100 | 0 | 1 | 288 | 17 | 304 | Thaumatomonas sp. DDM-2005 polyubiquitin (UBQ) gene, partial cds | blastn | 38166 | 316 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. DDM-2005 | ||
| 7673728 | 7673728 | PRJEB14803_P_NODE_37847_length_171_cov_1.470588_g37381_i0 | PRJEB14803 | 37847 | 171 | 1.470588 | 2.51470548 | Mesofila sp. ATCC PRA-54 | 439948 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.31e-25 | NTclustered | gi|160337346|gb|EF455768.1| | 439948 | g37381 | i0 | 83.824 | 26.1461988304094 | 136 | 20 | 79 | 2 | 34 | 168 | 794 | 928 | Dimorpha sp. ATCC PRA-54 alpha-tubulin (atub) gene, partial cds | blastn | 4471 | 128 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila sp. ATCC PRA-54 | ||||
| 11499372 | 11499372 | PRJEB14803_P_NODE_11830_length_365_cov_9.657576_g11365_i0 | PRJEB14803 | 11830 | 365 | 9.657576 | 35.2501524 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.959999999999999e-112 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11365 | i0 | 88.022 | 57.627397260274 | 359 | 36 | 98 | 6 | 9 | 365 | 4022 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21034 | 418 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15323756 | 15323756 | PRJEB14803_P_NODE_8493_length_452_cov_2.153477_g8032_i0 | PRJEB14803 | 8493 | 452 | 2.153477 | 9.73371604 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 2.1899999999999994e-129 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g8032 | i0 | 85.619 | 99.6703539823009 | 452 | 65 | 100 | 0 | 1 | 452 | 322 | 773 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 45051 | 475 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 16598288 | 16598288 | PRJEB14803_P_NODE_28694_length_203_cov_3.589286_g28228_i0 | PRJEB14803 | 28694 | 203 | 3.589286 | 7.28625058 | Glissomonad sp. Panama103 | 563749 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.319999999999999e-99 | NTclustered | gi|219524909|gb|EU709272.1| | 563749 | g28228 | i0 | 100 | 97.5812807881773 | 202 | 0 | 99 | 0 | 1 | 202 | 259 | 58 | Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence | blastn | 19809 | 374 | 1 | Eukaryota | Sar | Cercozoa | Glissomonad sp. Panama103 | ||||||
| 17873137 | 17873137 | PRJEB14803_P_NODE_42515_length_159_cov_3.483871_g42049_i0 | PRJEB14803 | 42515 | 159 | 3.483871 | 5.53935489 | Thaumatomastix sp. CC002-Boundary Bay | 741090 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.67e-44 | NTclustered | gi|290760490|gb|GQ144693.1| | 741090 | g42049 | i0 | 90.909 | 79.3018867924528 | 143 | 11 | 90 | 2 | 3 | 145 | 1826 | 1686 | Thaumatomastix sp. CC002-Boundary Bay large subunit ribosomal RNA gene, partial sequence | blastn | 12609 | 191 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. CC002-Boundary Bay | ||
| 20422100 | 20422100 | PRJEB14803_P_NODE_18417_length_273_cov_2.134454_g17951_i0 | PRJEB14803 | 18417 | 273 | 2.134454 | 5.82705942 | Paracercomonas sp. | 1979800 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 4.7799999999999996e-89 | NTclustered | gi|1326162414|gb|MG775634.1| | 1979800 | g17951 | i0 | 90 | 95.0879120879121 | 270 | 17 | 97 | 8 | 1 | 265 | 624 | 888 | Paracercomonas sp. strain SF61_P_Poa small subunit ribosomal RNA gene, partial sequence | blastn | 25959 | 340 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas sp. | |||
| 21698030 | 21698030 | PRJEB14803_P_NODE_11498_length_372_cov_5.094955_g11033_i0 | PRJEB14803 | 11498 | 372 | 5.094955 | 18.9532326 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.8499999999999997e-99 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11033 | i0 | 86.066 | 61.0188172043011 | 366 | 31 | 97 | 11 | 11 | 372 | 4018 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22699 | 375 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21698148 | 21698148 | PRJEB14803_P_NODE_27138_length_211_cov_1.454545_g26672_i0 | PRJEB14803 | 27138 | 211 | 1.454545 | 3.06908995 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 7.45e-15 | NR | MES1909649.1 | 1215613 | g26672 | i0 | 69.6 | 1.63507109004739 | 56 | 17 | 79.6 | 0 | 42 | 209 | 6 | 61 | MES1909649.1 Fructose-bisphosphate aldolase 6, cytosolic [Cercozoa sp. M6MM] | diamond | 345 | 77.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26652950 | 26652950 | PRJEB14803_P_NODE_20901_length_251_cov_2.032407_g20435_i0 | PRJEB14803 | 20901 | 251 | 2.032407 | 5.10134157 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.43e-6 | NR | MES1915844.1 | 1215613 | g20435 | i0 | 48.9 | 1.75697211155378 | 45 | 23 | 53.8 | 0 | 136 | 2 | 2 | 46 | MES1915844.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 441 | 53.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27033077 | 27033077 | PRJEB14803_P_NODE_41162_length_162_cov_10.937008_g40696_i0 | PRJEB14803 | 41162 | 162 | 10.937008 | 17.71795296 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.38e-18 | NR | MES1911722.1 | 1215613 | g40696 | i0 | 72.9 | 0.888888888888889 | 48 | 13 | 88.9 | 0 | 157 | 14 | 1 | 48 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 144 | 80.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27602036 | 27602036 | PRJEB14803_P_NODE_47584_length_150_cov_1.043478_g47118_i0 | PRJEB14803 | 47584 | 150 | 1.043478 | 1.565217 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00295 | NR | MES1908756.1 | 1215613 | g47118 | i0 | 40.9 | 0.88 | 44 | 26 | 88 | 0 | 2 | 133 | 388 | 431 | MES1908756.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 132 | 44.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28233058 | 28233058 | PRJEB14803_P_NODE_41246_length_162_cov_1.889764_g40780_i0 | PRJEB14803 | 41246 | 162 | 1.889764 | 3.06141768 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 2.48e-13 | NR | ADK47156.1 | 323453 | g40780 | i0 | 72.1 | 0.796296296296296 | 43 | 12 | 79.6 | 0 | 32 | 160 | 1 | 43 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 129 | 69.7 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29811860 | 29811860 | PRJEB14803_P_NODE_40811_length_163_cov_1.921875_g40345_i0 | PRJEB14803 | 40811 | 163 | 1.921875 | 3.13265625 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 6.23e-11 | NR | MES1907262.1 | 1215613 | g40345 | i0 | 58.5 | 2.9079754601227 | 53 | 22 | 97.5 | 0 | 161 | 3 | 611 | 663 | MES1907262.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 474 | 66.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30127597 | 30127597 | PRJEB14803_P_NODE_14572_length_319_cov_1.672535_g14106_i0 | PRJEB14803 | 14572 | 319 | 1.672535 | 5.33538665 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 1.87e-22 | NR | MES1911396.1 | 1215613 | g14106 | i0 | 45.3 | 0.893416927899687 | 95 | 49 | 89.3 | 1 | 22 | 306 | 141 | 232 | MES1911396.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 285 | 98.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30222616 | 30222616 | PRJEB14803_P_NODE_35272_length_179_cov_1.277778_g34806_i0 | PRJEB14803 | 35272 | 179 | 1.277778 | 2.28722262 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 2.56e-15 | NR | MES1907718.1 | 1215613 | g34806 | i0 | 62.7 | 0.988826815642458 | 59 | 22 | 98.9 | 0 | 3 | 179 | 17 | 75 | MES1907718.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 177 | 77.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32587761 | 32587761 | PRJEB14803_P_NODE_13179_length_340_cov_2.114754_g12714_i0 | PRJEB14803 | 13179 | 340 | 2.114754 | 7.1901636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 4.71e-17 | NR | MES1915627.1 | 1215613 | g12714 | i0 | 50.7 | 2.57647058823529 | 73 | 36 | 64.4 | 0 | 327 | 109 | 355 | 427 | MES1915627.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 876 | 87 | 0.991954022988506 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32594065 | 32594065 | PRJEB14803_P_NODE_18300_length_274_cov_3.543933_g17834_i0 | PRJEB14803 | 18300 | 274 | 3.543933 | 9.71037642 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 6.4e-16 | NR | MES1916707.1 | 1215613 | g17834 | i0 | 50.7 | 1.5 | 67 | 33 | 73.4 | 0 | 252 | 52 | 180 | 246 | MES1916707.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 411 | 80.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32625336 | 32625336 | PRJEB14803_P_NODE_23840_length_230_cov_1.641026_g23374_i0 | PRJEB14803 | 23840 | 230 | 1.641026 | 3.7743598 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 1.56e-15 | NR | MES1914773.1 | 1215613 | g23374 | i0 | 68 | 0.652173913043478 | 50 | 16 | 65.2 | 0 | 229 | 80 | 72 | 121 | MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 150 | 75.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;