RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

bioproject 1

  • PRJEB11748 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
15459 15459 PRJEB11748_P_NODE_180481_length_301_cov_8.950000_g178298_i0 PRJEB11748 180481 301 8.95 26.9395 Nitzschia sp. LFS-2014 1574098 SAR_Eukaryotes SAR_Eukaryotes 237 7.210000000000001e-58   NTclustered gi|725539113|gb|KM407586.1| 1574098 g178298 i0 85.294 32.4950166112957 238 26 79 7 1 238 350 122 Nitzschia sp. LFS-2014 isolate Ant015-G04 28S ribosomal RNA gene, partial sequence blastn 9781 237 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. LFS-2014
1293948 1293948 PRJEB11748_P_NODE_60622_length_545_cov_8.714876_g58488_i0 PRJEB11748 60622 545 8.714876 47.4960742 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 732 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g58488 i0 91.541 94.2018348623853 532 43 97 2 15 545 4363 4893 Naviculales sp. strain SZCZO2114 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 51340 732 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
2259575 2259575 PRJEB11748_P_NODE_317702_length_211_cov_5.306667_g315519_i0 PRJEB11748 317702 211 5.306667 11.19706737 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 350 5.869999999999999e-92   NTclustered gi|2633304288|gb|OR795085.1| 1923966 g315519 i0 98.485 89.085308056872 198 3 94 0 1 198 9952 9755 Navicula sp. strain SZCZEY2262 plastid, complete genome blastn 18797 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
2260112 2260112 PRJEB11748_P_NODE_401482_length_164_cov_11.388350_g399299_i0 PRJEB11748 401482 164 11.38835 18.676894 Hantzschia 186033 SAR_Eukaryotes SAR_Eukaryotes 292 7.41e-75   NTclustered gi|694880079|gb|KM116088.1| 186034 g399299 i0 98.78 99.9756097560976 164 2 100 0 1 164 520 683 Hantzschia amphioxys clone E01 18S ribosomal RNA gene, partial sequence blastn 16396 292 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
6395663 6395663 PRJEB11748_P_NODE_289846_length_224_cov_8.705521_g287663_i0 PRJEB11748 289846 224 8.705521 19.50036704 Fragilariopsis kerguelensis 186038 SAR_Eukaryotes SAR_Eukaryotes 401 1.7199999999999994e-107   NTclustered gi|1862846707|emb|LR812489.1| 186038 g287663 i0 99.103 99.5535714285714 223 2 99 0 2 224 6574 6352 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 22300 401 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
11186927 11186927 PRJEB11748_P_NODE_21869_length_978_cov_5.055616_g20305_i0 PRJEB11748 21869 978 5.055616 49.44392448 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 5.76e-24   NTclustered gi|2127877007|ref|NC_058782.1| 44446 g20305 i0 93.023 8.85685071574642 86 6 9 0 531 616 94367 94282 Pseudo-nitzschia americana isolate CNS00138 chloroplast, complete genome blastn 8662 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia americana
11494490 11494490 PRJEB11748_P_NODE_229450_length_260_cov_10.653266_g227267_i0 PRJEB11748 229450 260 10.653266 27.6984916 Cymbella proxima 431352 SAR_Eukaryotes SAR_Eukaryotes 435 2.01e-117   NTclustered gi|2162236528|gb|OL780383.1| 431352 g227267 i0 99.582 91.6384615384615 239 0 92 1 23 260 45 283 Cymbella proxima strain CBac2019049 large subunit ribosomal RNA gene, partial sequence blastn 23826 435 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Cymbella Cymbella proxima
11495053 11495053 PRJEB11748_P_NODE_260470_length_240_cov_10.642458_g258287_i0 PRJEB11748 260470 240 10.642458 25.5418992 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 228 3.3399999999999996e-55   NTclustered gi|2202538971|gb|OM891877.1| 1003062 g258287 i0 90.751 73.5125 173 12 72 4 69 240 5626 5457 Hemiaulus sinensis 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 17643 228 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
12769189 12769189 PRJEB11748_P_NODE_188091_length_294_cov_5.064378_g185908_i0 PRJEB11748 188091 294 5.064378 14.88927132 Cyclotella kingstonii 2794061 SAR_Eukaryotes SAR_Eukaryotes 99 3.45e-16   NTclustered gi|1939493327|gb|MW327043.1| 2794061 g185908 i0 88.889 27.0884353741497 81 8 28 1 2 82 205 126 Cyclotella kingstonii strain AJA246-42 large subunit ribosomal RNA gene, partial sequence blastn 7964 99 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella kingstonii
12772259 12772259 PRJEB11748_P_NODE_353931_length_196_cov_2.029630_g351748_i0 PRJEB11748 353931 196 2.02963 3.9780748 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 252 1.56e-62   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g351748 i0 91.351 6.62244897959184 185 15 94 1 2 186 48788 48971 Navicula incertata mitochondrion, complete genome blastn 1298 252 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
12773078 12773078 PRJEB11748_P_NODE_52271_length_592_cov_6.811676_g50162_i0 PRJEB11748 52271 592 6.811676 40.32512192 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 213 2.54e-50   NTclustered gi|2633304288|gb|OR795085.1| 1923966 g50162 i0 82.258 5.68243243243243 248 42 42 2 159 405 28920 29166 Navicula sp. strain SZCZEY2262 plastid, complete genome blastn 3364 213 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
14044820 14044820 PRJEB11748_P_NODE_245952_length_249_cov_6.234043_g243769_i0 PRJEB11748 245952 249 6.234043 15.52276707 Nitzschia dissipata 303402 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.03e-10   NTclustered gi|2248495830|ref|NC_063456.1| 303402 g243769 i0 90.476 0.253012048192771 63 3 25 3 176 238 17821 17762 Nitzschia dissipata isolate Qingdao in China mitochondrion, complete genome blastn 63 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
15322649 15322649 PRJEB11748_P_NODE_91773_length_437_cov_3.186170_g89605_i0 PRJEB11748 91773 437 3.18617 13.9235629 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 311 6.31e-80   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g89605 i0 81.174 30.604118993135 409 57 92 15 23 424 49529 49134 Navicula incertata mitochondrion, complete genome blastn 13374 311 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
16593012 16593012 PRJEB11748_P_NODE_214834_length_271_cov_7.328571_g212651_i0 PRJEB11748 214834 271 7.328571 19.86042741 Cyclophora castracanei 1158071 SAR_Eukaryotes SAR_Eukaryotes 172 1.8299999999999999e-38   NTclustered gi|379645503|gb|JN975271.1| 1158071 g212651 i0 90.769 45.3247232472325 130 11 48 1 140 268 745 874 Cyclophora castracanei strain GU44AB-6-Cycast photosystem II CP43 protein (psbC) gene, partial cds; chloroplast blastn 12283 172 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Cyclophorales Cyclophoraceae Cyclophora Cyclophora castracanei
16593443 16593443 PRJEB11748_P_NODE_237554_length_255_cov_1.896907_g235371_i0 PRJEB11748 237554 255 1.896907 4.83711285 Hantzschia amphioxys 186034 SAR_Eukaryotes SAR_Eukaryotes 455 1.51e-123   NTclustered gi|328750674|gb|HQ912404.1| 1003059 g235371 i0 98.824 100.043137254902 255 3 100 0 1 255 586 840 Hantzschia amphioxys var. major strain A4 18S small subunit ribosomal RNA gene, partial sequence blastn 25511 455 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
17865852 17865852 PRJEB11748_P_NODE_113435_length_390_cov_10.474164_g111261_i0 PRJEB11748 113435 390 10.474164 40.8492396 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 158 7.6799999999999995e-34   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g111261 i0 75.698 14.9153846153846 358 63 89 18 42 390 27910 27568 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 5817 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
21387657 21387657 PRJEB11748_P_NODE_9797_length_1540_cov_65.138607_g8823_i0 PRJEB11748 9797 1540 65.138607 1003.1345478 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 274 3.1e-68   NTclustered gi|2156401020|dbj|LC537470.1| 426638 g8823 i0 78.414 30.4577922077922 454 74 29 19 417 857 32706 32264 Chaetoceros tenuissimus NIES-3715 mitochondrial DNA, complete genome blastn 46905 274 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
21693042 21693042 PRJEB11748_P_NODE_225458_length_263_cov_7.851485_g223275_i0 PRJEB11748 225458 263 7.851485 20.64940555 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 342 1.2699999999999996e-89   NTclustered gi|2444483253|gb|OP718170.1| 97227 g223275 i0 92.531 96.3231939163498 241 15 91 3 22 260 4522 4761 Gomphonema parvulum mitochondrion, complete genome blastn 25333 342 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
21694182 21694182 PRJEB11748_P_NODE_286238_length_226_cov_4.266667_g284055_i0 PRJEB11748 286238 226 4.266667 9.64266742 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 298 2.34e-76   NTclustered gi|1549146932|gb|MH810167.1| 1487565 g284055 i0 90.789 79.0619469026549 228 14 100 5 1 226 7051 7273 Halamphora coffeaeformis voucher JPK7977-AMPH101 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 17868 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
24241995 24241995 PRJEB11748_P_NODE_211220_length_274_cov_7.056338_g209037_i0 PRJEB11748 211220 274 7.056338 19.33436612 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 462 9.81e-126   NTclustered gi|659666242|emb|HF679184.1| 303405 g209037 i0 100 92.6131386861314 250 0 91 0 1 250 262 13 Nitzschia inconspicua partial 28S rRNA gene, strain G6_1 blastn 25376 462 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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