RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA939369 · 13 ✖

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
11459902 11459902 PRJNA939369_S_NODE_6549_length_492_cov_0.880668_g6132_i0 PRJNA939369 6549 492 0.880668 4.33288656 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 865 0   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g6132 i0 98.374 99.4227642276423 492 8 100 0 1 492 109675 110166 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 48916 865 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
12393545 12393545 PRJNA939369_S_NODE_42030_length_272_cov_1.934673_g41613_i0 PRJNA939369 42030 272 1.934673 5.26231056 Minidiscus spinulatus 2593073 SAR_Eukaryotes SAR_Eukaryotes 470 5.81e-128   NTclustered gi|2328369080|ref|NC_067956.1| 2593073 g41613 i0 98.496 93.7095588235294 266 4 98 0 1 266 1223 1488 Minidiscus spinulatus chloroplast, complete genome blastn 25489 470 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus spinulatus
12735447 12735447 PRJNA939369_S_NODE_26070_length_313_cov_0.962500_g25653_i0 PRJNA939369 26070 313 0.9625 3.012625 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 501 2.4199999999999993e-137   NTclustered gi|180088843|gb|DQ514715.2| 340022 g25653 i0 95.527 99.9137380191693 313 14 100 0 1 313 889 577 Thalassiosira minima strain CCMP990 PSbC (psbC) gene, partial cds blastn 31273 501 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira minima
15284064 15284064 PRJNA939369_S_NODE_992_length_1044_cov_6.739444_g711_i0 PRJNA939369 992 1044 6.739444 70.35979536 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 1879 0   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g711 i0 99.138 158.877394636015 1044 9 100 0 1 1044 15852 14809 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 165868 1890 0.994179894179894 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
16558637 16558637 PRJNA939369_S_NODE_8953_length_441_cov_2.179348_g8536_i0 PRJNA939369 8953 441 2.179348 9.61092468 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 688 0   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g8536 i0 94.785 96.3106575963719 441 23 100 0 1 441 9980 9540 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 42473 688 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
18766041 18766041 PRJNA939369_S_NODE_3415_length_627_cov_2.054152_g3012_i0 PRJNA939369 3415 627 2.054152 12.87953304 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|657012562|gb|KF302618.1| 2850 g3012 i0 89.258 93.6698564593301 633 58 100 6 1 627 692 64 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 58731 784 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18766123 18766123 PRJNA939369_S_NODE_45535_length_266_cov_0.922280_g45118_i0 PRJNA939369 45535 266 0.92228 2.4532648 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 440 4.439999999999998e-119   NTclustered gi|2065945486|gb|MW845778.1| 426638 g45118 i0 96.604 98.8007518796992 265 9 99 0 1 265 1755 1491 Chaetoceros tenuissimus chloroplast, complete genome blastn 26281 440 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
21316364 21316364 PRJNA939369_S_NODE_33877_length_290_cov_1.778802_g33460_i0 PRJNA939369 33877 290 1.778802 5.1585258 Skeletonema costatum 2843 SAR_Eukaryotes SAR_Eukaryotes 503 6.17e-138   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g33460 i0 97.931 100.162068965517 290 6 100 0 1 290 119076 119365 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 29047 503 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
22933863 22933863 PRJNA939369_S_NODE_18858_length_344_cov_1.206642_g18441_i0 PRJNA939369 18858 344 1.206642 4.15084848 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 597 3.329999999999999e-166   NTclustered gi|700082471|ref|NC_025310.1| 156587 g18441 i0 97.965 98.5959302325581 344 7 100 0 1 344 54820 54477 Chaetoceros simplex chloroplast, complete genome blastn 33917 603 0.990049751243781 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros simplex
22933892 22933892 PRJNA939369_S_NODE_31978_length_295_cov_1.545045_g31561_i0 PRJNA939369 31978 295 1.545045 4.55788275 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 512 1.04e-140   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g31561 i0 97.966 99.871186440678 295 6 100 0 1 295 74781 75075 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 29462 512 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
25482681 25482681 PRJNA939369_S_NODE_69460_length_244_cov_0.900585_g69043_i0 PRJNA939369 69460 244 0.900585 2.1974274 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 407 4.08e-109   NTclustered gi|180088843|gb|DQ514715.2| 340022 g69043 i0 96.721 99.3360655737705 244 8 100 0 1 244 248 5 Thalassiosira minima strain CCMP990 PSbC (psbC) gene, partial cds blastn 24238 407 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira minima
26968632 26968632 PRJNA939369_S_NODE_31162_length_297_cov_2.714286_g30745_i0 PRJNA939369 31162 297 2.714286 8.06142942 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 77.4 4.45e-16   NR AID23594.1 2850 g30745 i0 91.9 0.747474747474748 37 3 37.4 0 295 185 63 99 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 222 77.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32743443 32743443 PRJNA939369_S_NODE_25440_length_315_cov_1.272727_g25023_i0 PRJNA939369 25440 315 1.272727 4.00909005 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 146 4.05e-43   NR AID23596.1 2850 g25023 i0 76.3 0.885714285714286 93 22 88.6 0 2 280 25 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 279 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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