RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA1013345" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA1013345 · 22 ✖

analysis 1

  • blastn · 22 ✖

tax_kingdom 0

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
2708881 2708881 PRJNA1013345_P_NODE_6743_length_238_cov_8.020942_g6613_i0 PRJNA1013345 6743 238 8.020942 19.08984196 Navicula tripunctata 431568 SAR_Eukaryotes SAR_Eukaryotes 429 8.45e-116   NTclustered gi|168145932|emb|AM710584.1| 431568 g6613 i0 99.16 99.5126050420168 238 2 100 0 1 238 51 288 Navicula tripunctata partial 28S rRNA gene, strain AT-202.01 blastn 23684 429 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tripunctata
2708898 2708898 PRJNA1013345_P_NODE_7383_length_230_cov_1.732240_g7253_i0 PRJNA1013345 7383 230 1.73224 3.984152 Psammodictyon constrictum 515483 SAR_Eukaryotes SAR_Eukaryotes 298 2.39e-76   NTclustered gi|2202538965|gb|OM891871.1| 515483 g7253 i0 90.086 80.3826086956522 232 20 100 3 1 230 4255 4485 Psammodictyon constrictum 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 18488 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
3553048 3553048 PRJNA1013345_P_NODE_1823_length_417_cov_5.878378_g1699_i0 PRJNA1013345 1823 417 5.878378 24.51283626 Fragilaria 33644 SAR_Eukaryotes SAR_Eukaryotes 566 1.16e-156   NTclustered gi|18698483|gb|AF417684.1| 185980 g1699 i0 95.751 84.6019184652278 353 11 84 4 66 417 384 35 Fragilaria capucina strain M1767 large subunit ribosomal RNA gene, partial sequence blastn 35279 566 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
4830499 4830499 PRJNA1013345_P_NODE_18984_length_173_cov_4.309524_g18854_i0 PRJNA1013345 18984 173 4.309524 7.45547652 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 315 1.68e-81   NTclustered gi|291495599|gb|GU823226.1| 152704 g18854 i0 99.422 100 173 1 100 0 1 173 1051 879 Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence blastn 17300 315 1 Eukaryota Sar             uncultured stramenopile
5260937 5260937 PRJNA1013345_P_NODE_11125_length_197_cov_1.993333_g10995_i0 PRJNA1013345 11125 197 1.993333 3.92686601 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 326 9.1e-85   NTclustered gi|820695469|tpe|LN714488.1| 572307 g10995 i0 96.447 4.94416243654822 197 7 100 0 1 197 117536 117732 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 974 326 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
5261024 5261024 PRJNA1013345_P_NODE_15405_length_181_cov_3.007463_g15275_i0 PRJNA1013345 15405 181 3.007463 5.44350803 Hydrurus foetidus 2996 SAR_Eukaryotes SAR_Eukaryotes 281 1.8e-71   NTclustered gi|219903754|emb|FM955257.1| 2996 g15275 i0 94.972 64.8674033149171 179 9 99 0 3 181 534 712 Hydrurus foetidus partial 28S rRNA gene blastn 11741 281 1 Eukaryota Sar     Chrysophyceae Hydrurales Hydruraceae Hydrurus Hydrurus foetidus
6536339 6536339 PRJNA1013345_P_NODE_14126_length_184_cov_2.722628_g13996_i0 PRJNA1013345 14126 184 2.722628 5.00963552 Fragilaria famelica 1003135 SAR_Eukaryotes SAR_Eukaryotes 230 6.749999999999998e-56   NTclustered gi|2862228909|gb|PQ645543.1| 1003135 g13996 i0 90.27 99.8858695652174 185 4 100 6 1 184 3402 3231 Fragilaria famelica isolate AGSB0425 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 18379 230 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria famelica
7380111 7380111 PRJNA1013345_P_NODE_17226_length_177_cov_3.353846_g17096_i0 PRJNA1013345 17226 177 3.353846 5.93630742 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 248 1.7799999999999998e-61   NTclustered gi|1862846707|emb|LR812489.1| 186038 g17096 i0 92.655 100.994350282486 177 6 100 1 1 177 7745 7914 Fragilariopsis kerguelensis, rDNA tandem repeat intergenic spacer region, 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 17876 248 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
7380146 7380146 PRJNA1013345_P_NODE_22126_length_167_cov_1.500000_g21996_i0 PRJNA1013345 22126 167 1.5 2.505 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 309 7.53e-80   NTclustered gi|1530728959|gb|MH356727.1| 568900 g21996 i0 100 198 167 0 100 0 1 167 76017 75851 Seminavis robusta strain D6 chloroplast, complete genome blastn 33066 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
7810980 7810980 PRJNA1013345_P_NODE_29387_length_159_cov_1.821429_g29257_i0 PRJNA1013345 29387 159 1.821429 2.89607211 Mallomonas annulata 52548 SAR_Eukaryotes SAR_Eukaryotes 196 5.75e-46   NTclustered gi|2757671057|gb|PQ008786.1| 52548 g29257 i0 89.241 96.5283018867924 158 15 99 2 1 158 292 137 Mallomonas annulata strain CZ34K internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 15348 196 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Mallomonas Mallomonas annulata
7810998 7810998 PRJNA1013345_P_NODE_30107_length_159_cov_0.910714_g29977_i0 PRJNA1013345 30107 159 0.910714 1.44803526 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 196 5.75e-46   NTclustered gi|820695469|tpe|LN714488.1| 572307 g29977 i0 89.241 2.0062893081761 158 15 100 2 1 157 80658 80502 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 319 196 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
9930651 9930651 PRJNA1013345_P_NODE_9348_length_209_cov_4.870370_g9218_i0 PRJNA1013345 9348 209 4.87037 10.1790733 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 377 2.66e-100   NTclustered gi|2202538974|gb|OM891880.1| 355634 g9218 i0 99.517 98.799043062201 207 1 99 0 1 207 3751 3957 Navicula arenaria 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 20649 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
11205711 11205711 PRJNA1013345_P_NODE_10809_length_199_cov_8.171053_g10679_i0 PRJNA1013345 10809 199 8.171053 16.26039547 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 368 1.51e-97   NTclustered gi|1389852305|gb|MH356257.1| 185980 g10679 i0 100 100.005025125628 199 0 100 0 1 199 333 135 Fragilaria capucina isolate HYU-D008 small subunit ribosomal RNA gene, partial sequence blastn 19901 368 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
11637012 11637012 PRJNA1013345_P_NODE_28290_length_160_cov_1.805310_g28160_i0 PRJNA1013345 28290 160 1.80531 2.888496 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 285 1.2e-72   NTclustered gi|820695469|tpe|LN714488.1| 572307 g28160 i0 98.75 3.55 160 2 100 0 1 160 117549 117390 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 568 285 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
16304959 16304959 PRJNA1013345_P_NODE_19873_length_171_cov_4.653226_g19743_i0 PRJNA1013345 19873 171 4.653226 7.95701646 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 316 4.6e-82   NTclustered gi|1169296927|gb|KY364697.1| 29204 g19743 i0 100 100 171 0 100 0 1 171 5289 5119 Cyclotella cryptica 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 17100 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
18009891 18009891 PRJNA1013345_P_NODE_10035_length_205_cov_5.151899_g9905_i0 PRJNA1013345 10035 205 5.151899 10.56139295 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 335 1.5899999999999992e-87   NTclustered gi|2862228887|gb|PQ645521.1| 2508070 g9905 i0 96.098 65.9268292682927 205 8 100 0 1 205 3893 4097 Tabularia sp. isolate AGSB0382 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 13515 335 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
20128965 20128965 PRJNA1013345_P_NODE_5976_length_250_cov_4.310345_g5846_i0 PRJNA1013345 5976 250 4.310345 10.7758625 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 451 1.91e-122   NTclustered gi|268633306|gb|GQ844874.1| 29207 g5846 i0 99.2 100 250 2 100 0 1 250 167 416 Stephanodiscus hantzschii isolate UTCC 267 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 25000 451 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
21835362 21835362 PRJNA1013345_P_NODE_7018_length_235_cov_0.978723_g6888_i0 PRJNA1013345 7018 235 0.978723 2.29999905 Neospora caninum 29176 SAR_Eukaryotes SAR_Eukaryotes 209 1.18e-49   NTclustered gi|820695469|tpe|LN714488.1| 572307 g6888 i0 88.439 27.7446808510638 173 20 99 0 19 191 301089 301261 TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome blastn 6520 209 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Neospora Neospora caninum
23954837 23954837 PRJNA1013345_P_NODE_23919_length_164_cov_2.461538_g23789_i0 PRJNA1013345 23919 164 2.461538 4.03692232 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 294 2.06e-75   NTclustered gi|2194766164|gb|OK505009.1| 2856 g23789 i0 99.383 195.878048780488 162 1 99 0 3 164 19736 19575 Cylindrotheca closterium chloroplast, complete genome blastn 32124 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23954840 23954840 PRJNA1013345_P_NODE_24779_length_163_cov_6.250000_g24649_i0 PRJNA1013345 24779 163 6.25 10.1875 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 302 1.22e-77   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g24649 i0 100 198.343558282209 163 0 100 0 1 163 70099 70261 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 32330 302 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
25228701 25228701 PRJNA1013345_P_NODE_13340_length_186_cov_1.856115_g13210_i0 PRJNA1013345 13340 186 1.856115 3.4523739 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 333 5.069999999999999e-87   NTclustered gi|2202538974|gb|OM891880.1| 355634 g13210 i0 98.93 82.4247311827957 187 1 100 1 1 186 4385 4199 Navicula arenaria 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 15331 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
25228798 25228798 PRJNA1013345_P_NODE_4500_length_282_cov_3.510638_g4371_i0 PRJNA1013345 4500 282 3.510638 9.89999916 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 505 1.6599999999999995e-138   NTclustered gi|768321723|gb|KJ961668.1| 355634 g4371 i0 99.283 98.3794326241135 279 2 99 0 4 282 291 13 Navicula arenaria 18S ribosomal RNA gene, partial sequence blastn 27743 510 0.990196078431373 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;