RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA289590 · 11 ✖

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
372591 372591 PRJNA289590_P_NODE_24001_length_178_cov_1.612403_g23777_i0 PRJNA289590 24001 178 1.612403 2.87007734 Fallacia monoculata 1003053 SAR_Eukaryotes SAR_Eukaryotes 296 6.3e-76   NTclustered gi|817090803|gb|KM009461.1| 1003053 g23777 i0 96.629 102.595505617978 178 6 100 0 1 178 268 445 Fallacia monoculata isolate FD254 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 18262 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Fallacia Fallacia monoculata
372783 372783 PRJNA289590_P_NODE_5541_length_417_cov_1.225543_g5317_i0 PRJNA289590 5541 417 1.225543 5.11051431 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 309 2.16e-79   NTclustered gi|657012367|gb|KF302531.1| 2850 g5317 i0 83.891 28.2685851318945 329 47 78 6 1 326 341 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 11788 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
1647088 1647088 PRJNA289590_P_NODE_13862_length_244_cov_1.528205_g13638_i0 PRJNA289590 13862 244 1.528205 3.7288202 Haslea provincialis 1764367 SAR_Eukaryotes SAR_Eukaryotes 374 4.1399999999999986e-99   NTclustered gi|2328347993|ref|NC_067579.1| 1764367 g13638 i0 94.309 100.094262295082 246 11 100 3 1 244 3254 3498 Haslea provincialis strain NCC 342 mitochondrion, complete genome blastn 24423 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea provincialis
12537930 12537930 PRJNA289590_P_NODE_23110_length_183_cov_1.216418_g22886_i0 PRJNA289590 23110 183 1.216418 2.22604494 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 316 5.009999999999999e-82   NTclustered gi|2325195844|gb|OM494341.1| 186043 g22886 i0 97.826 193.311475409836 184 2 100 2 1 183 89300 89118 Entomoneis sp. isolate C2 plastid, complete genome blastn 35376 316 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
18224107 18224107 PRJNA289590_P_NODE_18595_length_207_cov_2.867089_g18371_i0 PRJNA289590 18595 207 2.867089 5.93487423 Nitzschia ovalis 908985 SAR_Eukaryotes SAR_Eukaryotes 377 2.63e-100   NTclustered gi|2199203432|ref|NC_061046.1| 908985 g18371 i0 99.517 197.202898550725 207 1 100 0 1 207 60673 60467 Nitzschia ovalis chloroplast, complete genome blastn 40821 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia ovalis
20774192 20774192 PRJNA289590_P_NODE_31017_length_162_cov_0.920354_g30793_i0 PRJNA289590 31017 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 99 1.99e-22   NR KAI2505061.1 210448 g30793 i0 94.4 11 54 3 100 0 1 162 374 427 KAI2505061.1 Heat shock protein [Fragilaria crotonensis] diamond 1782 99 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
22048880 22048880 PRJNA289590_P_NODE_17538_length_214_cov_2.478788_g17314_i0 PRJNA289590 17538 214 2.478788 5.30460632 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 87 3.53e-18   NR XP_002291609.1 296543 g17314 i0 72.9 1.62616822429907 59 16 82.7 0 209 33 318 376 XP_002291609.1 calreticulin-like protein, partial [Thalassiosira pseudonana CCMP1335] diamond 348 87.4 0.995423340961098 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26694221 26694221 PRJNA289590_P_NODE_17481_length_215_cov_1.192771_g17257_i0 PRJNA289590 17481 215 1.192771 2.56445765 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 95.1 1.03e-21   NR KAI2505670.1 210448 g17257 i0 77.8 4.46511627906977 54 12 75.3 0 2 163 9 62 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 960 95.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27217969 27217969 PRJNA289590_P_NODE_14442_length_238_cov_1.878307_g14218_i0 PRJNA289590 14442 238 1.878307 4.47037066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 3.95e-35   NR AID23594.1 2850 g14218 i0 79.5 3.9327731092437 78 16 98.3 0 236 3 4 81 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 936 125 0.992 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27565556 27565556 PRJNA289590_P_NODE_23924_length_179_cov_0.961538_g23700_i0 PRJNA289590 23924 179 0.961538 1.72115302 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 75.1 6.16e-14   NR KAL3775830.1 29204 g23700 i0 62.1 4.89385474860335 58 22 97.2 0 178 5 655 712 KAL3775830.1 hypothetical protein HJC23_001522, partial [Cyclotella cryptica] diamond 876 75.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29333894 29333894 PRJNA289590_P_NODE_14489_length_238_cov_1.084656_g14265_i0 PRJNA289590 14489 238 1.084656 2.58148128 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 115 2.0099999999999999e-28   NR KAL3768831.1 259834 g14265 i0 67.9 2.96218487394958 78 24 97.1 1 3 233 19 96 KAL3768831.1 hypothetical protein ACHAWU_006932 [Discostella pseudostelligera] diamond 705 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera

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