contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1073005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186991 | 186991 | PRJNA1073005_P_NODE_7021_length_322_cov_1.855422_g6902_i0 | PRJNA1073005 | 7021 | 322 | 1.855422 | 5.97445884 | Strongylidium orientale | 1286065 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 5.56e-114 | NTclustered | gi|759083295|gb|KM221972.1| | 1286065 | g6902 | i0 | 90.402 | 94.3447204968944 | 323 | 29 | 100 | 2 | 1 | 322 | 352 | 31 | Strongylidium orientale voucher CXM2009120301 alpha-tubulin gene, partial cds | blastn | 30379 | 424 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Spirofilidae | Strongylidium | Strongylidium orientale | ||
| 2737545 | 2737545 | PRJNA1073005_P_NODE_8703_length_259_cov_1.102151_g8584_i0 | PRJNA1073005 | 8703 | 259 | 1.102151 | 2.85457109 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 6.149999999999998e-48 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g8584 | i0 | 81.008 | 82.023166023166 | 258 | 47 | 99 | 2 | 3 | 259 | 1226 | 970 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 21244 | 204 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 4013416 | 4013416 | PRJNA1073005_P_NODE_3804_length_524_cov_1.447894_g3685_i0 | PRJNA1073005 | 3804 | 524 | 1.447894 | 7.58696456 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 952 | 0 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g3685 | i0 | 99.616 | 78.9885496183206 | 521 | 2 | 99 | 0 | 1 | 521 | 521 | 1 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 41390 | 952 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4013427 | 4013427 | PRJNA1073005_P_NODE_8544_length_264_cov_1.502618_g8425_i0 | PRJNA1073005 | 8544 | 264 | 1.502618 | 3.96691152 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.5499999999999999e-133 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g8425 | i0 | 100 | 1 | 264 | 0 | 100 | 0 | 1 | 264 | 34024 | 33761 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 264 | 488 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 5289755 | 5289755 | PRJNA1073005_P_NODE_2945_length_626_cov_2.549729_g2828_i0 | PRJNA1073005 | 2945 | 626 | 2.549729 | 15.96130354 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 776 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g2828 | i0 | 89.103 | 97.7108626198083 | 624 | 68 | 99 | 0 | 1 | 624 | 1135 | 512 | Pyrocystis lunula actin mRNA, complete cds | blastn | 61167 | 776 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 6564943 | 6564943 | PRJNA1073005_P_NODE_6186_length_362_cov_1.415225_g6067_i0 | PRJNA1073005 | 6186 | 362 | 1.415225 | 5.1231145 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 669 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g6067 | i0 | 100 | 7.04419889502762 | 362 | 0 | 100 | 0 | 1 | 362 | 479 | 118 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2550 | 669 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 6564946 | 6564946 | PRJNA1073005_P_NODE_7086_length_319_cov_1.565041_g6967_i0 | PRJNA1073005 | 7086 | 319 | 1.565041 | 4.99248079 | Euplotes vannus | 5939 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 1.25e-75 | NTclustered | gi|409187347|gb|JQ289914.1| | 5939 | g6967 | i0 | 84.211 | 153.736677115987 | 304 | 48 | 99 | 0 | 2 | 305 | 515 | 212 | Euplotes vannus clone eu568c1 polyubiquitin gene, partial cds; macronuclear | blastn | 49042 | 296 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vannus | ||
| 7393678 | 7393678 | PRJNA1073005_P_NODE_5086_length_422_cov_1.263610_g4967_i0 | PRJNA1073005 | 5086 | 422 | 1.26361 | 5.3324342 | Pseudo-nitzschia | 41953 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 3.1e-13 | NTclustered | gi|2852238308|gb|PQ498360.1| | 189737 | g4967 | i0 | 98.039 | 7.03080568720379 | 51 | 1 | 12 | 0 | 321 | 371 | 33791 | 33841 | Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome | blastn | 2967 | 89.8 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Pseudo-nitzschia | Pseudo-nitzschia galaxiae | ||
| 7393756 | 7393756 | PRJNA1073005_P_NODE_9546_length_247_cov_0.885057_g9427_i0 | PRJNA1073005 | 9546 | 247 | 0.885057 | 2.18609079 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.519999999999999e-96 | NTclustered | gi|530758434|gb|KF524393.1| | 60850 | g9427 | i0 | 92.509 | 101.914979757085 | 267 | 0 | 100 | 1 | 1 | 247 | 179 | 445 | Vorticella convallaria isolate Gzpop 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25173 | 364 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 7839599 | 7839599 | PRJNA1073005_P_NODE_5567_length_392_cov_2.197492_g5448_i0 | PRJNA1073005 | 5567 | 392 | 2.197492 | 8.61416864 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 725 | 0 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g5448 | i0 | 100 | 105.408163265306 | 392 | 0 | 100 | 0 | 1 | 392 | 14622 | 15013 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 41320 | 725 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 11665634 | 11665634 | PRJNA1073005_P_NODE_6270_length_357_cov_1.897887_g6151_i0 | PRJNA1073005 | 6270 | 357 | 1.897887 | 6.77545659 | Aspidisca lynceus | 2035364 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 3.59e-141 | NTclustered | gi|2328859120|gb|OP828525.1| | 2035364 | g6151 | i0 | 97.659 | 36.8543417366947 | 299 | 7 | 84 | 0 | 59 | 357 | 1750 | 1452 | Aspidisca lynceus isolate LCY2015101602 large subunit ribosomal RNA gene, partial sequence | blastn | 13157 | 514 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Aspidiscidae | Aspidisca | Aspidisca lynceus | ||
| 11665637 | 11665637 | PRJNA1073005_P_NODE_7110_length_318_cov_1.240816_g6991_i0 | PRJNA1073005 | 7110 | 318 | 1.240816 | 3.94579488 | Entodinium caudatum | 47911 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 1.2099999999999999e-95 | NTclustered | gi|92790163|emb|AJ965267.1| | 47911 | g6991 | i0 | 87.54 | 175.424528301887 | 313 | 39 | 98 | 0 | 6 | 318 | 449 | 137 | Entodinium caudatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 55785 | 363 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium caudatum | ||
| 15489607 | 15489607 | PRJNA1073005_P_NODE_1193_length_1045_cov_1.737654_g1117_i0 | PRJNA1073005 | 1193 | 1045 | 1.737654 | 18.1584843 | Guinardia delicatula | 1244696 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.6e-74 | NTclustered | gi|2074156200|gb|MW413905.1| | 216802 | g1117 | i0 | 74.827 | 50.3837320574163 | 723 | 147 | 75 | 28 | 1 | 703 | 24572 | 23865 | Guinardia delicatula mitochondrion, complete genome | blastn | 52651 | 294 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Rhizosoleniales | Rhizosoleniaceae | Guinardia | Guinardia delicatula | ||
| 16318420 | 16318420 | PRJNA1073005_P_NODE_4473_length_465_cov_1.747449_g4354_i0 | PRJNA1073005 | 4473 | 465 | 1.747449 | 8.12563785 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 797 | 0 | NTclustered | gi|269993986|dbj|AB520724.1| | 183512 | g4354 | i0 | 97.639 | 100.243010752688 | 466 | 8 | 100 | 3 | 1 | 465 | 536 | 999 | Uncultured chrysophyte gene for 18S ribosomal RNA, partial sequence, clone: 10182008-Euk18S-Clone9 | blastn | 46613 | 797 | 1 | Eukaryota | Sar | Chrysophyceae | uncultured Chrysophyceae | ||||||
| 16318523 | 16318523 | PRJNA1073005_P_NODE_9513_length_247_cov_0.885057_g9394_i0 | PRJNA1073005 | 9513 | 247 | 0.885057 | 2.18609079 | Euplotida | 33831 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.04e-67 | NTclustered | gi|399146186|gb|JQ736722.1| | 577312 | g9394 | i0 | 86.235 | 64.3198380566802 | 247 | 34 | 100 | 0 | 1 | 247 | 296 | 50 | Aspidisca magna isolate B272 alpha-tubulin gene, partial cds; macronuclear | blastn | 15887 | 268 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Aspidiscidae | Aspidisca | Aspidisca magna | ||
| 18038695 | 18038695 | PRJNA1073005_P_NODE_895_length_1203_cov_3.023894_g830_i0 | PRJNA1073005 | 895 | 1203 | 3.023894 | 36.37744482 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 2106 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g830 | i0 | 99.739 | 98.1936824605154 | 1149 | 3 | 96 | 0 | 1 | 1149 | 90 | 1238 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 118127 | 2106 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 20588035 | 20588035 | PRJNA1073005_P_NODE_2637_length_672_cov_15.874791_g2523_i0 | PRJNA1073005 | 2637 | 672 | 15.874791 | 106.67859552 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 1085 | 0 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g2523 | i0 | 95.833 | 91.8616071428571 | 672 | 27 | 100 | 1 | 1 | 672 | 1000 | 1670 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 61731 | 1085 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 21863837 | 21863837 | PRJNA1073005_P_NODE_7258_length_312_cov_3.004184_g7139_i0 | PRJNA1073005 | 7258 | 312 | 3.004184 | 9.37305408 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 3.89e-160 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g7139 | i0 | 100 | 42.9358974358974 | 312 | 0 | 100 | 0 | 1 | 312 | 15685 | 15996 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 13396 | 577 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 21863839 | 21863839 | PRJNA1073005_P_NODE_7378_length_307_cov_2.286325_g7259_i0 | PRJNA1073005 | 7378 | 307 | 2.286325 | 7.01901775 | Extubocellulus spinifer | 265572 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.69e-14 | NTclustered | gi|2632235321|gb|OR922703.1| | 265572 | g7259 | i0 | 79.021 | 0.931596091205212 | 143 | 24 | 47 | 6 | 165 | 307 | 5288 | 5424 | Extubocellulus spinifer strain AGSB0090 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 | 286 | 93.5 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Cymatosirales | Cymatosiraceae | Extubocellulus | Extubocellulus spinifer |
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);;