RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA1068513 · 8 ✖

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
15484637 15484637 PRJNA1068513_S_NODE_8073_length_319_cov_3.121951_g8027_i0 PRJNA1068513 8073 319 3.121951 9.95902369 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g8027 i0 92.308 0.122257053291536 39 3 12 0 213 251 83898 83860 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 39 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
27193618 27193618 PRJNA1068513_S_NODE_9422_length_293_cov_1.600000_g9376_i0 PRJNA1068513 9422 293 1.6 4.688 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00294   NR XP_002288828.1 296543 g9376 i0 45.1 0.522184300341297 51 26 50.2 1 260 114 490 540 XP_002288828.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 153 46.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27636097 27636097 PRJNA1068513_S_NODE_1304_length_642_cov_8.191564_g1264_i0 PRJNA1068513 1304 642 8.191564 52.58984088 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 57.4 9.74e-6   NR GFH43913.1 426638 g1264 i0 31.2 0.509345794392523 109 67 47.2 3 404 102 318 426 GFH43913.1 hypothetical protein CTEN210_00387 [Chaetoceros tenuissimus] diamond 327 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29782987 29782987 PRJNA1068513_S_NODE_4391_length_430_cov_1.977591_g4346_i0 PRJNA1068513 4391 430 1.977591 8.5036413 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 60.5 1.78e-7   NR KAI2512359.1 210448 g4346 i0 34.6 2.68604651162791 127 68 80.9 5 7 354 495 617 KAI2512359.1 peptidase [Fragilaria crotonensis] diamond 1155 60.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30438276 30438276 PRJNA1068513_S_NODE_893_length_712_cov_9.092332_g855_i0 PRJNA1068513 893 712 9.092332 64.73740384 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.8 4.72e-5   NR GFH43913.1 426638 g855 i0 32 3.88061797752809 100 60 38.8 3 377 102 327 426 GFH43913.1 hypothetical protein CTEN210_00387 [Chaetoceros tenuissimus] diamond 2763 56.2 0.99288256227758 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31363027 31363027 PRJNA1068513_S_NODE_13936_length_217_cov_5.847222_g13890_i0 PRJNA1068513 13936 217 5.847222 12.68847174 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00117   NR KAL3912048.1 3061772 g13890 i0 69.6 0.63594470046083 23 7 31.8 0 155 87 36 58 KAL3912048.1 MAG: hypothetical protein SGILL_007040 [Bacillariaceae sp.] diamond 138 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31457892 31457892 PRJNA1068513_S_NODE_11716_length_257_cov_1.353261_g11670_i0 PRJNA1068513 11716 257 1.353261 3.47788077 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.62e-12   NR XP_002177403.1 556484 g11670 i0 54.9 1.79766536964981 51 20 59.5 1 3 155 1239 1286 XP_002177403.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 462 72.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32533633 32533633 PRJNA1068513_S_NODE_6199_length_367_cov_1.646259_g6153_i0 PRJNA1068513 6199 367 1.646259 6.04177053 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52 8.38e-5   NR KAL3944906.1 3061772 g6153 i0 32.1 0.686648501362398 84 55 68.7 2 12 263 622 703 KAL3944906.1 MAG: hypothetical protein SGBAC_000997 [Bacillariaceae sp.] diamond 252 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.

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