RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA929924" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA929924 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
1254183 1254183 PRJNA929924_P_NODE_17161_length_164_cov_0.904348_g16998_i0 PRJNA929924 17161 164 0.904348 1.48313072 Encyonema 216746 SAR_Eukaryotes SAR_Eukaryotes 303 3.42e-78   NTclustered gi|168145699|emb|AM501961.1| 431330 g16998 i0 100 100 164 0 100 0 1 164 272 109 Encyonema minutum 18S rRNA gene, strain AT-137.13 blastn 16400 303 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
2184379 2184379 PRJNA929924_P_NODE_6922_length_411_cov_1.599448_g6759_i0 PRJNA929924 6922 411 1.599448 6.57373128 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.81e-10   NTclustered gi|2248495872|ref|NC_063457.1| 2018706 g6759 i0 86.486 1.74695863746959 74 8 18 2 18 89 38569 38496 Haslea tsukamotoi isolate Qingdao in China mitochondrion, complete genome blastn 718 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
2529873 2529873 PRJNA929924_P_NODE_15702_length_167_cov_1.762712_g15539_i0 PRJNA929924 15702 167 1.762712 2.94372904 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 309 7.53e-80   NTclustered gi|168145917|emb|AM710568.1| 431397 g15539 i0 100 100 167 0 100 0 1 167 73 239 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 16700 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
3806402 3806402 PRJNA929924_P_NODE_7223_length_386_cov_1.949555_g7060_i0 PRJNA929924 7223 386 1.949555 7.5252823 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 686 0   NTclustered gi|691189876|gb|KJ958480.1| 1549163 g7060 i0 98.705 197.103626943005 386 5 100 0 1 386 70329 69944 Cyclotella sp. L04_2 chloroplast, complete genome blastn 76082 686 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella sp. L04_2
6012110 6012110 PRJNA929924_P_NODE_11685_length_209_cov_0.906250_g11522_i0 PRJNA929924 11685 209 0.90625 1.8940625 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 342 9.709999999999999e-90   NTclustered gi|2862228875|gb|PQ645509.1| 1884248 g11522 i0 96.172 96.7655502392344 209 8 100 0 1 209 3871 3663 Nitzschia sp. (in: diatoms) isolate AGSB0363 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 20224 342 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
6358142 6358142 PRJNA929924_P_NODE_10265_length_238_cov_2.306878_g10102_i0 PRJNA929924 10265 238 2.306878 5.49036964 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 429 8.45e-116   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g10102 i0 99.16 195.016806722689 238 2 100 0 1 238 70619 70856 Cyclotella cryptica chloroplast, complete genome blastn 46414 429 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
8561821 8561821 PRJNA929924_P_NODE_18467_length_153_cov_3.721154_g18304_i0 PRJNA929924 18467 153 3.721154 5.69336562 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 283 4.0799999999999995e-72   NTclustered gi|66571056|emb|AJ878482.1| 29205 g18304 i0 100 97.1699346405229 153 0 100 0 1 153 96 248 Cyclotella meneghiniana partial 28S rRNA gene, strain Bpp02-9 blastn 14867 283 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
12733554 12733554 PRJNA929924_P_NODE_11690_length_208_cov_2.578616_g11527_i0 PRJNA929924 11690 208 2.578616 5.36352128 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 385 1.58e-102   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g11527 i0 100 199.870192307692 208 0 100 0 1 208 69748 69541 Cyclotella cryptica chloroplast, complete genome blastn 41573 385 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
13662697 13662697 PRJNA929924_P_NODE_8931_length_282_cov_2.231760_g8768_i0 PRJNA929924 8931 282 2.23176 6.2935632 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 438 1.7099999999999999e-118   NTclustered gi|2088232805|ref|NC_056793.1| 138539 g8768 i0 94.681 105.641843971631 282 15 100 0 1 282 22657 22376 Navicula veneta isolate SZCZR1826 mitochondrion, complete genome blastn 29791 438 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
15282154 15282154 PRJNA929924_P_NODE_17812_length_163_cov_0.912281_g17649_i0 PRJNA929924 17812 163 0.912281 1.48701803 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 248 1.61e-61   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g17649 i0 95.484 105.668711656442 155 7 95 0 7 161 47541 47387 Bacillaria paxillifer chloroplast, complete genome blastn 17224 248 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
17487142 17487142 PRJNA929924_P_NODE_12354_length_198_cov_1.093960_g12191_i0 PRJNA929924 12354 198 1.09396 2.1660408 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 344 2.53e-90   NTclustered gi|2633304288|gb|OR795085.1| 1923966 g12191 i0 97.98 199.116161616162 198 4 100 0 1 198 80402 80205 Navicula sp. strain SZCZEY2262 plastid, complete genome blastn 39425 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
17487325 17487325 PRJNA929924_P_NODE_8654_length_296_cov_1.311741_g8491_i0 PRJNA929924 8654 296 1.311741 3.88275336 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 542 1.34e-149   NTclustered gi|66571061|emb|AJ878487.1| 29205 g8491 i0 99.662 99.6385135135135 296 1 100 0 1 296 552 257 Cyclotella meneghiniana partial 28S rRNA gene, strain AT-cm4 blastn 29493 542 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
19105624 19105624 PRJNA929924_P_NODE_15975_length_167_cov_0.881356_g15812_i0 PRJNA929924 15975 167 0.881356 1.47186452 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 278 2.12e-70   NTclustered gi|74325165|ref|NC_007405.1| 35128 g15812 i0 96.97 96.7844311377246 165 5 99 0 1 165 12644 12480 Thalassiosira pseudonana mitochondrion, complete genome blastn 16163 278 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
20035464 20035464 PRJNA929924_P_NODE_11556_length_211_cov_1.925926_g11393_i0 PRJNA929924 11556 211 1.925926 4.06370386 Navicula capitatoradiata 431397 SAR_Eukaryotes SAR_Eukaryotes 381 2.0799999999999996e-101   NTclustered gi|168145917|emb|AM710568.1| 431397 g11393 i0 99.052 99.8151658767773 211 2 100 0 1 211 533 323 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 21061 381 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
20035522 20035522 PRJNA929924_P_NODE_17876_length_163_cov_0.912281_g17713_i0 PRJNA929924 17876 163 0.912281 1.48701803 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 180 5.97e-41   NTclustered gi|224009701|ref|XM_002293773.1| 296543 g17713 i0 86.503 1 163 22 100 0 1 163 314 152 Thalassiosira pseudonana CCMP1335 RS25, ribosomal protein 25 40S small ribosomal subunit (RS25), mRNA blastn 163 180 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24205774 24205774 PRJNA929924_P_NODE_16619_length_165_cov_1.758621_g16456_i0 PRJNA929924 16619 165 1.758621 2.90172465 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 305 9.59e-79   NTclustered gi|1418587827|ref|NC_038001.1| 186043 g16456 i0 100 99.2363636363636 165 0 100 0 1 165 105904 106068 Entomoneis sp. chloroplast, complete genome blastn 16374 305 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

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