RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1245487", 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

  • PRJNA1245487 · 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
2901943 2901943 PRJNA1245487_P_NODE_18563_length_257_cov_1.695652_g18225_i0 PRJNA1245487 18563 257 1.695652 4.35782564 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 130 1.8299999999999997e-35   NR KAL3796718.1 29204 g18225 i0 76.3 5.39299610894942 80 17 93.4 1 16 255 173 250 KAL3796718.1 hypothetical protein HJC23_010018 [Cyclotella cryptica] diamond 1386 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
4879564 4879564 PRJNA1245487_P_NODE_5364_length_541_cov_11.784188_g5029_i0 PRJNA1245487 5364 541 11.784188 63.75245708 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 754 0   NTclustered gi|2547135572|gb|OR286793.1| 2856 g5029 i0 100 75.7504621072089 408 0 75 0 2 409 408 1 Cylindrotheca closterium strain WAP12A small subunit ribosomal RNA gene, partial sequence blastn 40981 754 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
4879573 4879573 PRJNA1245487_P_NODE_5704_length_522_cov_9.668151_g5368_i0 PRJNA1245487 5704 522 9.668151 50.46774822 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 776 0   NTclustered gi|1450486418|gb|MH763768.1| 303400 g5368 i0 93.654 99.5785440613027 520 32 99 1 1 519 117 636 Nitzschia palea isolate Wise_VA_USA internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 51980 776 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
5454519 5454519 PRJNA1245487_P_NODE_14505_length_298_cov_1.386667_g14167_i0 PRJNA1245487 14505 298 1.386667 4.13226766 Nitzschia ovalis 908985 SAR_Eukaryotes SAR_Eukaryotes 462 1.08e-125   NTclustered gi|2199203432|ref|NC_061046.1| 908985 g14167 i0 94.915 106.610738255034 295 15 99 0 4 298 67693 67399 Nitzschia ovalis chloroplast, complete genome blastn 31770 462 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia ovalis
5454634 5454634 PRJNA1245487_P_NODE_2945_length_725_cov_2.542945_g2632_i0 PRJNA1245487 2945 725 2.542945 18.43635125 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 1323 0   NTclustered gi|1540310873|gb|MH297491.1| 303400 g2632 i0 99.586 102.662068965517 725 3 100 0 1 725 33856 34580 Nitzschia palea mitochondrion, complete genome blastn 74430 1323 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
6728850 6728850 PRJNA1245487_P_NODE_14486_length_298_cov_1.946667_g14148_i0 PRJNA1245487 14486 298 1.946667 5.80106766 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 422 1.83e-113   NTclustered gi|2202538966|gb|OM891872.1| 3003 g14148 i0 92.282 72.5604026845638 298 22 100 1 1 298 5567 5863 Bacillaria paxillifer 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 21623 422 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
8004393 8004393 PRJNA1245487_P_NODE_17727_length_264_cov_4.361257_g17389_i0 PRJNA1245487 17727 264 4.361257 11.51371848 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 488 1.5499999999999999e-133   NTclustered gi|1540310873|gb|MH297491.1| 303400 g17389 i0 100 93.8409090909091 264 0 100 0 1 264 30830 31093 Nitzschia palea mitochondrion, complete genome blastn 24774 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
13804614 13804614 PRJNA1245487_P_NODE_11531_length_345_cov_5.702206_g11193_i0 PRJNA1245487 11531 345 5.702206 19.6726107 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 608 1.5399999999999993e-169   NTclustered gi|1538979133|gb|MH113811.1| 303400 g11193 i0 98.547 198.440579710145 344 5 99 0 1 344 70498 70841 Nitzschia palea chloroplast, complete genome blastn 68462 608 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
14380270 14380270 PRJNA1245487_P_NODE_21272_length_244_cov_4.052632_g20934_i0 PRJNA1245487 21272 244 4.052632 9.88842208 Hantzschia amphioxys 186034 SAR_Eukaryotes SAR_Eukaryotes 435 1.87e-117   NTclustered gi|694880079|gb|KM116088.1| 186034 g20934 i0 98.77 100.327868852459 244 3 100 0 1 244 325 82 Hantzschia amphioxys clone E01 18S ribosomal RNA gene, partial sequence blastn 24480 435 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
14380287 14380287 PRJNA1245487_P_NODE_22472_length_235_cov_6.413580_g22134_i0 PRJNA1245487 22472 235 6.41358 15.071913 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 427 3e-115   NTclustered gi|1095952960|gb|KU365993.1| 303400 g22134 i0 99.573 2.36170212765957 234 1 99 0 2 235 356 123 Nitzschia palea strain NGPC3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 555 427 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
16353860 16353860 PRJNA1245487_P_NODE_23213_length_217_cov_16.895833_g22875_i0 PRJNA1245487 23213 217 16.895833 36.66395761 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 396 7.689999999999997e-106   NTclustered gi|1803023461|gb|MN937452.1| 2850 g22875 i0 99.539 196.972350230415 217 1 100 0 1 217 68214 68430 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 42743 396 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16928433 16928433 PRJNA1245487_P_NODE_834_length_1203_cov_3.406195_g638_i0 PRJNA1245487 834 1203 3.406195 40.97652585 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 2209 0   NTclustered gi|1540310873|gb|MH297491.1| 303400 g638 i0 99.834 91.2177888611804 1202 2 99 0 1 1202 32249 31048 Nitzschia palea mitochondrion, complete genome blastn 109735 2209 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
18202801 18202801 PRJNA1245487_P_NODE_17915_length_263_cov_1.494737_g17577_i0 PRJNA1245487 17915 263 1.494737 3.93115831 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 486 5.5499999999999986e-133   NTclustered gi|1095952960|gb|KU365993.1| 303400 g17577 i0 100 33.4220532319392 263 0 100 0 1 263 316 578 Nitzschia palea strain NGPC3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 8790 486 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
21453340 21453340 PRJNA1245487_P_NODE_5277_length_546_cov_2.799154_g4942_i0 PRJNA1245487 5277 546 2.799154 15.28338084 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 728 0   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g4942 i0 90.876 199.150183150183 548 43 100 4 1 546 55924 55382 Bacillaria paxillifer chloroplast, complete genome blastn 108736 734 0.991825613079019 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
27831638 27831638 PRJNA1245487_P_NODE_14684_length_296_cov_0.946188_g14346_i0 PRJNA1245487 14684 296 0.946188 2.80071648 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 126 9.66e-35   NR XP_002180336.1 556484 g14346 i0 57.1 0.993243243243243 98 42 99.3 0 296 3 26 123 XP_002180336.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 294 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28134077 28134077 PRJNA1245487_P_NODE_20425_length_248_cov_0.891429_g20087_i0 PRJNA1245487 20425 248 0.891429 2.21074392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.1 1.75e-15   NR KAL3779346.1 29204 g20087 i0 42.7 8.98790322580645 82 46 98 1 5 247 262 343 KAL3779346.1 hypothetical protein HJC23_007476 [Cyclotella cryptica] diamond 2229 80.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29491566 29491566 PRJNA1245487_P_NODE_21790_length_243_cov_0.917647_g21452_i0 PRJNA1245487 21790 243 0.917647 2.22988221 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 112 1.14e-26   NR CAJ1934423.1 2856 g21452 i0 60 13.8271604938272 80 32 98.8 0 3 242 1063 1142 CAJ1934423.1 unnamed protein product [Cylindrotheca closterium] diamond 3360 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31559146 31559146 PRJNA1245487_P_NODE_12596_length_327_cov_1.661417_g12258_i0 PRJNA1245487 12596 327 1.661417 5.43283359 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 93.2 5.18e-20   NR VEU33732.1 183589 g12258 i0 60.3 0.623853211009174 68 27 62.4 0 325 122 261 328 VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 204 93.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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