RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJEB11748", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 31 ✖

tax_clade 1

  • Sar · 31 ✖

bioproject 1

  • PRJEB11748 · 31 ✖

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
7670007 7670007 PRJEB11748_P_NODE_30547_length_803_cov_15.766846_g28706_i0 PRJEB11748 30547 803 15.766846 126.60777338 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 146 1.56e-39   NR CAB9510960.1 568900 g28706 i0 48.9 4.16189290161893 141 72 52.7 0 699 277 2 142 CAB9510960.1 Receptor expression-enhancing protein 5 [Seminavis robusta] diamond 3342 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
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
28353110 28353110 PRJEB11748_P_NODE_25186_length_899_cov_40.554893_g23511_i0 PRJEB11748 25186 899 40.554893 364.58848807 root 1 Root_unresolved Root_unresolved 110 2.32e-25   NR YP_010208168.1 37318 g23511 i0 35 6.51056729699666 163 103 53.4 2 415 894 1 163 YP_010208168.1 ribosomal protein L6 [Pseudo-nitzschia pungens] diamond 5853 111 0.990990990990991 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
29464130 29464130 PRJEB11748_P_NODE_73310_length_492_cov_9.535963_g71158_i0 PRJEB11748 73310 492 9.535963 46.91693796 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 53.9 5.57e-5   NR KAK1735154.1 267567 g71158 i0 37.8 0.5 82 46 47 2 26 256 474 555 KAK1735154.1 hypothetical protein QTG54_014220 [Skeletonema marinoi] diamond 246 53.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30001363 30001363 PRJEB11748_P_NODE_156951_length_327_cov_2.304511_g154769_i0 PRJEB11748 156951 327 2.304511 7.53575097 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.95e-9   NR CAB9521483.1 568900 g154769 i0 57.4 0.495412844036697 54 21 49.5 1 1 162 393 444 CAB9521483.1 expressed unknown protein [Seminavis robusta] diamond 162 64.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30033042 30033042 PRJEB11748_P_NODE_356631_length_194_cov_5.969925_g354448_i0 PRJEB11748 356631 194 5.969925 11.5816545 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 100 1.2399999999999999e-23   NR VEU43442.1 183589 g354448 i0 76.8 0.865979381443299 56 13 86.6 0 193 26 275 330 VEU43442.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 168 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30538433 30538433 PRJEB11748_P_NODE_369993_length_187_cov_11.055556_g367810_i0 PRJEB11748 369993 187 11.055556 20.67388972 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 56.2 3.14e-7   NR KAK1740316.1 267567 g367810 i0 59.5 0.593582887700535 37 15 59.4 0 56 166 107 143 KAK1740316.1 hypothetical protein QTG54_009266 [Skeletonema marinoi] diamond 111 56.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30854377 30854377 PRJEB11748_P_NODE_355394_length_195_cov_2.947761_g353211_i0 PRJEB11748 355394 195 2.947761 5.74813395 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52 9.3e-6   NR KAL3910417.1 3061772 g353211 i0 45.3 1.64615384615385 53 29 81.5 0 33 191 221 273 KAL3910417.1 MAG: hypothetical protein SGARI_002135, partial [Bacillariaceae sp.] diamond 321 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31486802 31486802 PRJEB11748_P_NODE_286736_length_226_cov_2.272727_g284553_i0 PRJEB11748 286736 226 2.272727 5.13636302 Nitzschia supralitorea 303403 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.16e-6   NR YP_010133644.1 303403 g284553 i0 88 0.676991150442478 25 3 33.2 0 152 226 3 27 YP_010133644.1 hypothetical protein RF33 [Nitzschia supralitorea] diamond 153 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia supralitorea
31638413 31638413 PRJEB11748_P_NODE_66536_length_518_cov_14.794311_g64395_i0 PRJEB11748 66536 518 14.794311 76.63453098 root 1 Root_unresolved Root_unresolved 100 4.33e-22   NR CAB9531982.1 568900 g64395 i0 40.8 1.90540540540541 120 67 69.5 2 378 19 155 270 CAB9531982.1 Inherit from euNOG: Conserved hypothetical protein (Partial), partial [Seminavis robusta] diamond 987 101 0.99009900990099 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31992782 31992782 PRJEB11748_P_NODE_69798_length_505_cov_17.421171_g67651_i0 PRJEB11748 69798 505 17.421171 87.97691355 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.85e-7   NR KAL3811007.1 382380 g67651 i0 44.7 0.504950495049505 85 38 50.5 2 417 163 262 337 KAL3811007.1 hypothetical protein ACHAXA_002284 [Cyclostephanos tholiformis] diamond 255 60.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32246149 32246149 PRJEB11748_P_NODE_24958_length_904_cov_7.377224_g23294_i0 PRJEB11748 24958 904 7.377224 66.69010496 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 50.4 0.00686   NR KAK1749184.1 267567 g23294 i0 32.6 0.315265486725664 95 55 28.5 2 397 140 384 478 KAK1749184.1 2OG-Fe(II) oxygenase family protein [Skeletonema marinoi] diamond 285 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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