contig_metadata
19 rows where bioproject = "PRJNA495917" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 477573 | 477573 | PRJNA495917_S_NODE_5621_length_214_cov_5.089385_g5427_i0 | PRJNA495917 | 5621 | 214 | 5.089385 | 10.8912839 | Heterococcus caespitosus | 55585 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.59e-89 | NTclustered | gi|157411020|gb|EF990191.1| | 55585 | g5427 | i0 | 95.755 | 98.714953271028 | 212 | 8 | 99 | 1 | 3 | 214 | 1201 | 991 | Heterococcus caespitosus large subunit ribosomal RNA gene, partial sequence | blastn | 21125 | 340 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Heteropediaceae | Heterococcus | Heterococcus caespitosus | |||
| 1752372 | 1752372 | PRJNA495917_S_NODE_10842_length_170_cov_5.237037_g10648_i0 | PRJNA495917 | 10842 | 170 | 5.237037 | 8.9029629 | Heterococcus caespitosus | 55585 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 7.75e-70 | NTclustered | gi|157411020|gb|EF990191.1| | 55585 | g10648 | i0 | 95.906 | 84.6058823529412 | 171 | 5 | 100 | 2 | 1 | 170 | 2564 | 2395 | Heterococcus caespitosus large subunit ribosomal RNA gene, partial sequence | blastn | 14383 | 276 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Heteropediaceae | Heterococcus | Heterococcus caespitosus | |||
| 1752411 | 1752411 | PRJNA495917_S_NODE_12862_length_161_cov_5.301587_g12668_i0 | PRJNA495917 | 12862 | 161 | 5.301587 | 8.53555507 | Heterococcus caespitosus | 55585 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 9.5e-64 | NTclustered | gi|157411020|gb|EF990191.1| | 55585 | g12668 | i0 | 95.652 | 99.3105590062112 | 161 | 4 | 100 | 2 | 1 | 161 | 1405 | 1248 | Heterococcus caespitosus large subunit ribosomal RNA gene, partial sequence | blastn | 15989 | 255 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Heteropediaceae | Heterococcus | Heterococcus caespitosus | |||
| 3659160 | 3659160 | PRJNA495917_S_NODE_9463_length_178_cov_1.174825_g9269_i0 | PRJNA495917 | 9463 | 178 | 1.174825 | 2.0911885 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.259999999999999e-81 | NTclustered | gi|1238675774|gb|MF783088.1| | 4784 | g9269 | i0 | 100 | 94.9438202247191 | 169 | 0 | 95 | 0 | 1 | 169 | 927 | 759 | Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence | blastn | 16900 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 6855113 | 6855113 | PRJNA495917_S_NODE_1546_length_384_cov_17.584527_g1352_i0 | PRJNA495917 | 1546 | 384 | 17.584527 | 67.52458368 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1.1600000000000001e-91 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1352 | i0 | 85.112 | 43.5755208333333 | 356 | 38 | 91 | 11 | 36 | 384 | 4039 | 3692 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16733 | 350 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 8130593 | 8130593 | PRJNA495917_S_NODE_3107_length_278_cov_6.493827_g2913_i0 | PRJNA495917 | 3107 | 278 | 6.493827 | 18.05283906 | Tribonema sp. | 2679974 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 4.95e-79 | NTclustered | gi|2518133535|gb|OQ243223.1| | 2679974 | g2913 | i0 | 86.972 | 50.7553956834532 | 284 | 23 | 99 | 8 | 1 | 275 | 5886 | 6164 | Tribonema sp. strain GXU-A10 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and 28S-18S ribosomal RNA intergenic spacer, complete sequence | blastn | 14110 | 307 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema sp. | |||
| 8130624 | 8130624 | PRJNA495917_S_NODE_5247_length_220_cov_12.210811_g5053_i0 | PRJNA495917 | 5247 | 220 | 12.210811 | 26.8637842 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.7599999999999998e-72 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5053 | i0 | 89.912 | 37.8227272727273 | 228 | 14 | 99 | 4 | 1 | 219 | 1654 | 1881 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 8321 | 285 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 9405406 | 9405406 | PRJNA495917_S_NODE_14388_length_156_cov_3.950413_g14194_i0 | PRJNA495917 | 14388 | 156 | 3.950413 | 6.16264428 | Mischococcus sphaerocephalus | 55587 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9e-74 | NTclustered | gi|4106430|gb|AF083400.1|AF083400 | 55587 | g14194 | i0 | 100 | 99.2692307692308 | 156 | 0 | 100 | 0 | 1 | 156 | 1479 | 1634 | Mischococcus sphaerocephalus 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15486 | 289 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Mischococcaceae | Mischococcus | Mischococcus sphaerocephalus | |||
| 9405407 | 9405407 | PRJNA495917_S_NODE_14408_length_156_cov_2.743802_g14214_i0 | PRJNA495917 | 14408 | 156 | 2.743802 | 4.28033112 | Peronospora boni-henrici | 162100 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.1899999999999994e-72 | NTclustered | gi|33520207|gb|AY273952.1| | 162100 | g14214 | i0 | 99.359 | 100.00641025641 | 156 | 1 | 100 | 0 | 1 | 156 | 54 | 209 | Peronospora boni-henrici large subunit ribosomal RNA gene, partial sequence | blastn | 15601 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora boni-henrici | ||
| 10681096 | 10681096 | PRJNA495917_S_NODE_13409_length_159_cov_17.145161_g13215_i0 | PRJNA495917 | 13409 | 159 | 17.145161 | 27.26080599 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.22e-74 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g13215 | i0 | 99.371 | 100.786163522013 | 159 | 1 | 100 | 0 | 1 | 159 | 1187 | 1029 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 16025 | 289 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 11311056 | 11311056 | PRJNA495917_S_NODE_2689_length_298_cov_1.939163_g2495_i0 | PRJNA495917 | 2689 | 298 | 1.939163 | 5.77870574 | Chlorellidium | 240565 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.4099999999999993e-119 | NTclustered | gi|46020003|emb|AJ580949.1| | 243652 | g2495 | i0 | 93.624 | 99.9530201342282 | 298 | 16 | 100 | 2 | 1 | 298 | 357 | 63 | Chlorellidium tetrabotrys partial 18S rRNA gene, strain SAG 5.90 | blastn | 29786 | 442 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botryochloridaceae | Chlorellidium | Chlorellidium tetrabotrys | |||
| 12586782 | 12586782 | PRJNA495917_S_NODE_11090_length_169_cov_2.373134_g10896_i0 | PRJNA495917 | 11090 | 169 | 2.373134 | 4.01059646 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.31e-57 | NTclustered | gi|2307923332|ref|NC_066457.1| | 3016 | g10896 | i0 | 91.765 | 169.597633136095 | 170 | 12 | 99 | 2 | 1 | 168 | 119162 | 119331 | Sargassum fulvellum chloroplast, complete genome | blastn | 28662 | 235 | 1 | Eukaryota | Sar | Phaeophyceae | Fucales | Sargassaceae | Sargassum | Sargassum fulvellum | |||
| 13231309 | 13231309 | PRJNA495917_S_NODE_1331_length_409_cov_6.000000_g1137_i0 | PRJNA495917 | 1331 | 409 | 6 | 24.54 | Heterococcus caespitosus | 55585 | SAR_Eukaryotes | SAR_Eukaryotes | 630 | 3.9699999999999986e-176 | NTclustered | gi|157411020|gb|EF990191.1| | 55585 | g1137 | i0 | 94.621 | 101.408312958435 | 409 | 19 | 100 | 3 | 1 | 409 | 1858 | 1453 | Heterococcus caespitosus large subunit ribosomal RNA gene, partial sequence | blastn | 41476 | 630 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Heteropediaceae | Heterococcus | Heterococcus caespitosus | |||
| 13231457 | 13231457 | PRJNA495917_S_NODE_9351_length_178_cov_10.083916_g9157_i0 | PRJNA495917 | 9351 | 178 | 10.083916 | 17.94937048 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.23e-85 | NTclustered | gi|68271541|gb|DQ086722.1| | 45107 | g9157 | i0 | 100 | 100.544943820225 | 177 | 0 | 99 | 0 | 1 | 177 | 343 | 519 | Heteromita globosa isolate HETEGLOB large subunit ribosomal RNA gene, partial sequence | blastn | 17897 | 327 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 17054848 | 17054848 | PRJNA495917_S_NODE_2034_length_341_cov_18.209150_g1840_i0 | PRJNA495917 | 2034 | 341 | 18.20915 | 62.0932015 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 569 | 7.199999999999998e-158 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1840 | i0 | 96.774 | 99.2492668621701 | 341 | 11 | 100 | 0 | 1 | 341 | 1637 | 1297 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 33844 | 569 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 17054852 | 17054852 | PRJNA495917_S_NODE_2694_length_297_cov_3.912214_g2500_i0 | PRJNA495917 | 2694 | 297 | 3.912214 | 11.61927558 | uncultured Heterococcus (in: yellow-green algae) | 3049177 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 8.08e-147 | NTclustered | gi|2515376786|gb|OR101643.1| | 3049177 | g2500 | i0 | 98.99 | 100.680134680135 | 297 | 3 | 100 | 0 | 1 | 297 | 1407 | 1111 | Uncultured Heterococcus (in: yellow-green algae) clone xcl32_AM0914 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 | 29902 | 532 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Heteropediaceae | uncultured Heterococcus (in: yellow-green algae) | ||||
| 19603448 | 19603448 | PRJNA495917_S_NODE_2976_length_284_cov_3.767068_g2782_i0 | PRJNA495917 | 2976 | 284 | 3.767068 | 10.69847312 | Vaucheria litorea | 109269 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.04e-115 | NTclustered | gi|215400692|ref|NC_011600.1| | 109269 | g2782 | i0 | 94.014 | 202.654929577465 | 284 | 16 | 100 | 1 | 1 | 284 | 64398 | 64680 | Vaucheria litorea chloroplast, complete genome | blastn | 57554 | 429 | 1 | Eukaryota | Sar | Xanthophyceae | Vaucheriales | Vaucheriaceae | Vaucheria | Vaucheria litorea | |||
| 20879316 | 20879316 | PRJNA495917_S_NODE_14817_length_155_cov_1.983333_g14623_i0 | PRJNA495917 | 14817 | 155 | 1.983333 | 3.07416615 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 7.2e-45 | NTclustered | gi|325195820|emb|FR826611.1| | 890382 | g14623 | i0 | 92.029 | 25.7548387096774 | 138 | 10 | 89 | 1 | 2 | 139 | 74 | 210 | Albugo laibachii Nc14, genomic contig CONTIG_3778_NC14_v4_313_8 | blastn | 3992 | 193 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24059769 | 24059769 | PRJNA495917_S_NODE_1459_length_393_cov_12.136872_g1265_i0 | PRJNA495917 | 1459 | 393 | 12.136872 | 47.69790696 | Heteromita | 45106 | SAR_Eukaryotes | SAR_Eukaryotes | 710 | 0 | NTclustered | gi|46393899|gb|AY496043.1| | 45107 | g1265 | i0 | 99.237 | 100.045801526718 | 393 | 3 | 100 | 0 | 1 | 393 | 813 | 421 | Heteromita globosa strain SCCAP H251 small subunit ribosomal RNA gene, partial sequence | blastn | 39318 | 715 | 0.993006993006993 | 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);;