RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA896973", 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 · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA896973 · 18 ✖

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
1243971 1243971 PRJNA896973_P_NODE_20381_length_257_cov_3.195652_g20287_i0 PRJNA896973 20381 257 3.195652 8.21282564 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 475 1.1699999999999999e-129   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g20287 i0 100 198.249027237354 257 0 100 0 1 257 47723 47979 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 50950 475 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
4701805 4701805 PRJNA896973_P_NODE_24004_length_247_cov_1.402299_g23910_i0 PRJNA896973 24004 247 1.402299 3.46367853 Pseudo-nitzschia americana 44446 SAR_Eukaryotes SAR_Eukaryotes 429 8.83e-116   NTclustered gi|2852238151|gb|PQ498356.1| 44446 g23910 i0 97.976 92.5506072874494 247 5 100 0 1 247 34356 34602 Pseudo-nitzschia americana isolate CNS00138 mitochondrion, complete genome blastn 22860 429 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia americana
5072081 5072081 PRJNA896973_P_NODE_2184_length_660_cov_17.959114_g2098_i0 PRJNA896973 2184 660 17.959114 118.5301524 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 1208 0   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g2098 i0 99.697 199.025757575758 660 2 100 0 1 660 47259 46600 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 131357 1208 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
9801255 9801255 PRJNA896973_P_NODE_8608_length_367_cov_1.309524_g8514_i0 PRJNA896973 8608 367 1.309524 4.80595308 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 123 1.7499999999999998e-30   NR CAB9505866.1 568900 g8514 i0 59.8 2.19073569482289 92 36 74.4 1 332 60 366 457 CAB9505866.1 Acyl-lipid (7-3)-desaturase [Seminavis robusta] diamond 804 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
12723536 12723536 PRJNA896973_P_NODE_21490_length_251_cov_16.573034_g21396_i0 PRJNA896973 21490 251 16.573034 41.59831534 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 464 2.47e-126   NTclustered gi|2839792213|gb|PQ512811.1| 37318 g21396 i0 100 98.8645418326693 251 0 100 0 1 251 3637 3387 Pseudo-nitzschia pungens isolate CNS00141 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 24815 464 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
16175804 16175804 PRJNA896973_P_NODE_1613_length_750_cov_2.725258_g1530_i0 PRJNA896973 1613 750 2.725258 20.439435 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 1375 0   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g1530 i0 99.733 108.96 750 2 100 0 1 750 89109 88360 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 81720 1375 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
16546549 16546549 PRJNA896973_P_NODE_28593_length_234_cov_66.714286_g28499_i0 PRJNA896973 28593 234 66.714286 156.11142924 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 433 6.41e-117   NTclustered gi|2203480254|gb|OM913202.1| 37318 g28499 i0 100 99.9529914529915 234 0 100 0 1 234 570 337 Pseudo-nitzschia pungens strain CLMS28 large subunit ribosomal RNA gene, partial sequence blastn 23389 433 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
17451232 17451232 PRJNA896973_P_NODE_15554_length_287_cov_2.429907_g15460_i0 PRJNA896973 15554 287 2.429907 6.97383309 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 525 1.2999999999999995e-144   NTclustered gi|2846854574|gb|PQ459335.1| 37318 g15460 i0 99.652 95.9721254355401 287 1 100 0 1 287 33404 33690 Pseudo-nitzschia pungens isolate CNS00055 mitochondrion, complete genome blastn 27544 525 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
18724801 18724801 PRJNA896973_P_NODE_29195_length_206_cov_9.533835_g29101_i0 PRJNA896973 29195 206 9.533835 19.6397001 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 381 2.0199999999999994e-101   NTclustered gi|2839792213|gb|PQ512811.1| 37318 g29101 i0 100 100.266990291262 206 0 100 0 1 206 5029 4824 Pseudo-nitzschia pungens isolate CNS00141 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 20655 381 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
19999538 19999538 PRJNA896973_P_NODE_11036_length_331_cov_1.131783_g10942_i0 PRJNA896973 11036 331 1.131783 3.74620173 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 595 1.1499999999999998e-165   NTclustered gi|2127877134|ref|NC_058783.1| 37318 g10942 i0 99.094 114.625377643505 331 3 100 0 1 331 39591 39261 Pseudo-nitzschia pungens isolate CNS00141 chloroplast, complete genome blastn 37941 595 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
19999702 19999702 PRJNA896973_P_NODE_18816_length_266_cov_1.595855_g18722_i0 PRJNA896973 18816 266 1.595855 4.2449743 Thalassionema nitzschioides 33649 SAR_Eukaryotes SAR_Eukaryotes 137 6.53e-28   NTclustered gi|184185917|dbj|AB368774.1| 33649 g18722 i0 82.692 1.83458646616541 156 25 58 2 1 155 156 2 Thalassionema nitzschioides EFL mRNA for elongation factor-like, partial cds blastn 488 137 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Thalassionemales Thalassionemataceae Thalassionema Thalassionema nitzschioides
19999935 19999935 PRJNA896973_P_NODE_29236_length_202_cov_4.224806_g29142_i0 PRJNA896973 29236 202 4.224806 8.53410812 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 374 3.3e-99   NTclustered gi|2846854574|gb|PQ459335.1| 37318 g29142 i0 100 83.8465346534653 202 0 100 0 1 202 34954 34753 Pseudo-nitzschia pungens isolate CNS00055 mitochondrion, complete genome blastn 16937 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
21646219 21646219 PRJNA896973_P_NODE_9217_length_356_cov_27.367491_g9123_i0 PRJNA896973 9217 356 27.367491 97.42826796 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 636 7.31e-178   NTclustered gi|2839792213|gb|PQ512811.1| 37318 g9123 i0 98.876 100.688202247191 356 4 100 0 1 356 3936 4291 Pseudo-nitzschia pungens isolate CNS00141 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 35845 636 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
24195526 24195526 PRJNA896973_P_NODE_15639_length_287_cov_1.331776_g15545_i0 PRJNA896973 15639 287 1.331776 3.82219712 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 520 6.049999999999999e-143   NTclustered gi|532597122|gb|KF015198.1| 37318 g15545 i0 99.303 99.219512195122 287 2 100 0 1 287 312 26 Pseudo-nitzschia pungens isolate GGA1 18S ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 28476 520 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
25098972 25098972 PRJNA896973_P_NODE_11100_length_330_cov_1.198444_g11006_i0 PRJNA896973 11100 330 1.198444 3.9548652 uncultured diatom 137771 SAR_Eukaryotes SAR_Eukaryotes 405 2.07e-108   NTclustered gi|392522658|gb|JQ762465.1| 137771 g11006 i0 88.788 3.76363636363636 330 37 100 0 1 330 552 223 Uncultured diatom clone ECS_EFL02 translation elongation factor-like protein (EFL) gene, partial cds blastn 1242 405 1 Eukaryota Sar   Bacillariophyta         uncultured diatom
27024038 27024038 PRJNA896973_P_NODE_21962_length_251_cov_0.865169_g21868_i0 PRJNA896973 21962 251 0.865169 2.17157419 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 95.1 1.55e-20   NR OEU14324.1 635003 g21868 i0 62.7 0.896414342629482 75 27 88.4 1 226 5 497 571 OEU14324.1 hypothetical protein FRACYDRAFT_240859 [Fragilariopsis cylindrus CCMP1102] diamond 225 95.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27340336 27340336 PRJNA896973_P_NODE_23583_length_248_cov_0.880000_g23489_i0 PRJNA896973 23583 248 0.88 2.1824 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.42e-11   NR VEU45169.1 183589 g23489 i0 53.3 1.08870967741935 90 29 99.2 3 246 1 139 223 VEU45169.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 270 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27372113 27372113 PRJNA896973_P_NODE_26003_length_244_cov_0.900585_g25909_i0 PRJNA896973 26003 244 0.900585 2.1974274 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.23e-14   NR OEU05829.1 635003 g25909 i0 44.3 0.971311475409836 79 44 97.1 0 242 6 136 214 OEU05829.1 hypothetical protein FRACYDRAFT_266851 [Fragilariopsis cylindrus CCMP1102] diamond 237 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus

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