contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 599168 | 599168 | PRJNA627467_P_NODE_20701_length_155_cov_3.452830_g20632_i0 | PRJNA627467 | 20701 | 155 | 3.45283 | 5.3518865 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 1.93e-70 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g20632 | i0 | 99.351 | 0.993548387096774 | 154 | 0 | 99 | 1 | 3 | 155 | 554 | 401 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 154 | 278 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3149975 | 3149975 | PRJNA627467_P_NODE_11883_length_181_cov_2.545455_g11814_i0 | PRJNA627467 | 11883 | 181 | 2.545455 | 4.60727355 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 5.19e-47 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g11814 | i0 | 87.079 | 32.0773480662983 | 178 | 21 | 98 | 2 | 4 | 181 | 3687 | 3862 | Colpoda sp. isolate JGP15 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 | 5806 | 200 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 3149996 | 3149996 | PRJNA627467_P_NODE_13183_length_177_cov_1.562500_g13114_i0 | PRJNA627467 | 13183 | 177 | 1.5625 | 2.765625 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 6.7600000000000005e-21 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13114 | i0 | 83.077 | 22.7401129943503 | 130 | 16 | 73 | 5 | 5 | 134 | 3793 | 3916 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4025 | 113 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 3150083 | 3150083 | PRJNA627467_P_NODE_19663_length_160_cov_2.423423_g19594_i0 | PRJNA627467 | 19663 | 160 | 2.423423 | 3.8774768 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 2.6599999999999995e-54 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g19594 | i0 | 92.5 | 24.375 | 160 | 6 | 98 | 2 | 1 | 156 | 72 | 229 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 3900 | 224 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 3702416 | 3702416 | PRJNA627467_P_NODE_17643_length_164_cov_2.365217_g17574_i0 | PRJNA627467 | 17643 | 164 | 2.365217 | 3.87895588 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.59e-76 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g17574 | i0 | 100 | 53.219512195122 | 161 | 0 | 98 | 0 | 1 | 161 | 1650 | 1490 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 8728 | 298 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4426830 | 4426830 | PRJNA627467_P_NODE_19904_length_159_cov_2.300000_g19835_i0 | PRJNA627467 | 19904 | 159 | 2.3 | 3.657 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.1999999999999998e-67 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g19835 | i0 | 97.468 | 35.1635220125786 | 158 | 2 | 98 | 2 | 1 | 156 | 1966 | 1809 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 5591 | 268 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 6977543 | 6977543 | PRJNA627467_P_NODE_10146_length_187_cov_2.369565_g10077_i0 | PRJNA627467 | 10146 | 187 | 2.369565 | 4.43108655 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|116222178|gb|DQ980465.1| | 407209 | g10077 | i0 | 100 | 0.160427807486631 | 30 | 0 | 16 | 0 | 154 | 183 | 681 | 652 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 6977664 | 6977664 | PRJNA627467_P_NODE_21226_length_153_cov_2.721154_g21157_i0 | PRJNA627467 | 21226 | 153 | 2.721154 | 4.16336562 | Colponema vietnamica | 1492817 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 7.23e-30 | NTclustered | gi|1280963088|gb|MG202006.1| | 1492817 | g21157 | i0 | 84.211 | 100.281045751634 | 152 | 19 | 97 | 5 | 5 | 153 | 11107 | 11256 | Colponema vietnamica strain Colp-7a mitochondrion | blastn | 15343 | 143 | 1 | Eukaryota | Sar | Colponemida | Colponemidia | Colponema | Colponema vietnamica | ||||
| 8252255 | 8252255 | PRJNA627467_P_NODE_1127_length_350_cov_2.109635_g1060_i0 | PRJNA627467 | 1127 | 350 | 2.109635 | 7.3837225 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4.01e-46 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1060 | i0 | 97.414 | 12.98 | 116 | 3 | 50 | 0 | 232 | 347 | 3820 | 3705 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4543 | 198 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 9527688 | 9527688 | PRJNA627467_P_NODE_8988_length_194_cov_1.565517_g8919_i0 | PRJNA627467 | 8988 | 194 | 1.565517 | 3.03710298 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 6.860000000000001e-91 | NTclustered | gi|325194239|emb|FR825095.1| | 890382 | g8919 | i0 | 99.474 | 97.860824742268 | 190 | 1 | 98 | 0 | 5 | 194 | 1438 | 1249 | Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 | blastn | 18985 | 346 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 10079350 | 10079350 | PRJNA627467_P_NODE_2848_length_316_cov_2.329588_g2780_i0 | PRJNA627467 | 2848 | 316 | 2.329588 | 7.36149808 | root | 1 | Root_unresolved | Root_unresolved | 180 | 1.3e-40 | NTclustered | gi|194476495|ref|NC_011087.1| | 39717 | g2780 | i0 | 99 | 102.072784810127 | 100 | 1 | 62 | 0 | 217 | 316 | 307535 | 307436 | Paulinella chromatophora chromatophore, complete genome | blastn | 32255 | 180 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 12078518 | 12078518 | PRJNA627467_P_NODE_15050_length_171_cov_1.090164_g14981_i0 | PRJNA627467 | 15050 | 171 | 1.090164 | 1.86418044 | Cylindrotheca closterium | 2856 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.02e-58 | NTclustered | gi|2862228858|gb|PQ645492.1| | 2856 | g14981 | i0 | 92.308 | 98.906432748538 | 169 | 11 | 98 | 2 | 1 | 167 | 3479 | 3647 | Cylindrotheca closterium isolate AGSB0341 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 | 16913 | 239 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 16453552 | 16453552 | PRJNA627467_P_NODE_17133_length_165_cov_2.405172_g17064_i0 | PRJNA627467 | 17133 | 165 | 2.405172 | 3.9685338 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 1.66e-51 | NTclustered | gi|16326553|gb|AF409121.1| | 64707 | g17064 | i0 | 91.667 | 66.0121212121212 | 156 | 12 | 94 | 1 | 7 | 161 | 3831 | 3676 | Chrysolepidomonas dendrolepidota internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 10892 | 215 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chrysolepidomonadaceae | Chrysolepidomonas | Chrysolepidomonas dendrolepidota | |||
| 17177043 | 17177043 | PRJNA627467_P_NODE_12294_length_180_cov_1.526718_g12225_i0 | PRJNA627467 | 12294 | 180 | 1.526718 | 2.7480924 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 3.79e-83 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g12225 | i0 | 99.432 | 64.7111111111111 | 176 | 1 | 98 | 0 | 1 | 176 | 2500 | 2325 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 11648 | 320 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17728732 | 17728732 | PRJNA627467_P_NODE_4434_length_316_cov_1.749064_g4366_i0 | PRJNA627467 | 4434 | 316 | 1.749064 | 5.52704224 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.3e-40 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g4366 | i0 | 99.01 | 29.1392405063291 | 101 | 0 | 62 | 1 | 1 | 100 | 18 | 118 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 9208 | 180 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 23551643 | 23551643 | PRJNA627467_P_NODE_10699_length_185_cov_2.242647_g10630_i0 | PRJNA627467 | 10699 | 185 | 2.242647 | 4.14889695 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.44e-67 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g10630 | i0 | 93.011 | 69.5945945945946 | 186 | 9 | 100 | 4 | 1 | 185 | 2413 | 2595 | Rosculus vulgaris isolate CCA sequence | blastn | 12875 | 268 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 24102633 | 24102633 | PRJNA627467_P_NODE_17199_length_165_cov_1.750000_g17130_i0 | PRJNA627467 | 17199 | 165 | 1.75 | 2.8875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 7.57e-65 | NTclustered | gi|2735011|gb|U82204.1|BTU82204 | 55726 | g17130 | i0 | 95.679 | 98.9030303030303 | 162 | 6 | 98 | 1 | 1 | 162 | 344 | 184 | Bursaria truncatella small subunit ribosomal RNA gene, complete cds | blastn | 16319 | 259 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Bursariomorphida | Bursariidae | Bursaria | Bursaria truncatella |
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);;