RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJEB43370" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 21 ✖

tax_clade 1

bioproject 1

  • PRJEB43370 · 21 ✖

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
60246 60246 PRJEB43370_P_NODE_7661_length_169_cov_0.866667_g7618_i0 PRJEB43370 7661 169 0.866667 1.46466723 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 100 8.5e-25   NR GFH54236.1 426638 g7618 i0 80.4 4.97041420118343 56 11 99.4 0 169 2 66 121 GFH54236.1 hypothetical protein CTEN210_10712 [Chaetoceros tenuissimus] diamond 840 101 0.99009900990099 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
5162532 5162532 PRJEB43370_P_NODE_5265_length_197_cov_1.756757_g5222_i0 PRJEB43370 5265 197 1.756757 3.46081129 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 87.4 1.02e-19   NR GAX14000.1 1519565 g5222 i0 73.6 6.80710659898477 53 14 80.7 0 161 3 2 54 GAX14000.1 large subunit ribosomal protein L11e [Fistulifera solaris] diamond 1341 87.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
8987300 8987300 PRJEB43370_P_NODE_1968_length_310_cov_1.517241_g1925_i0 PRJEB43370 1968 310 1.517241 4.7034471 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 149 3.05e-44   NR GKY92310.1 2872254 g1925 i0 79.3 3.35806451612903 87 18 84.2 0 48 308 1 87 GKY92310.1 hypothetical protein MPSEU_000202100 [Mayamaea pseudoterrestris] diamond 1041 149 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
10263021 10263021 PRJEB43370_P_NODE_5489_length_194_cov_1.075862_g5446_i0 PRJEB43370 5489 194 1.075862 2.08717228 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 93.5 9.87e-15   NTclustered gi|224004779|ref|XM_002296005.1| 296543 g5446 i0 85.714 0.469072164948454 91 9 46 4 46 134 201 113 Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA blastn 91 93.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
10263036 10263036 PRJEB43370_P_NODE_6869_length_175_cov_1.238095_g6826_i0 PRJEB43370 6869 175 1.238095 2.16666625 root 1 Root_unresolved Root_unresolved 108 3.71e-28   NR CAJ1952498.1 2856 g6826 i0 84.5 15.5657142857143 58 9 99.4 0 174 1 61 118 CAJ1952498.1 unnamed protein product [Cylindrotheca closterium] diamond 2724 108 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26621849 26621849 PRJEB43370_P_NODE_10161_length_163_cov_1.368421_g10118_i0 PRJEB43370 10161 163 1.368421 2.23052623 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 42 0.0232   NR KAI2497948.1 210448 g10118 i0 47.4 0.699386503067485 38 20 69.9 0 158 45 513 550 KAI2497948.1 aminoacyl-tRNA synthetase [Fragilaria crotonensis] diamond 114 42 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26716528 26716528 PRJEB43370_P_NODE_7381_length_169_cov_1.300000_g7338_i0 PRJEB43370 7381 169 1.3 2.197 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 72.4 4.57e-13   NR CAB9521928.1 568900 g7338 i0 58.2 1.95266272189349 55 22 95.9 1 167 6 185 239 CAB9521928.1 Aspartate aminotransferase, mitochondrial [Seminavis robusta] diamond 330 72.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27381318 27381318 PRJEB43370_P_NODE_8463_length_167_cov_0.881356_g8420_i0 PRJEB43370 8463 167 0.881356 1.47186452 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 85.5 9.12e-18   NR KAI2508213.1 210448 g8420 i0 74.1 4.79640718562874 54 14 97 0 6 167 369 422 KAI2508213.1 Type III restriction enzyme [Fragilaria crotonensis] diamond 801 85.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27942925 27942925 PRJEB43370_P_NODE_9065_length_166_cov_0.888889_g9022_i0 PRJEB43370 9065 166 0.888889 1.47555574 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.49e-17   NR XP_002185293.1 556484 g9022 i0 76.9 8.45783132530121 52 12 94 0 3 158 2660 2711 XP_002185293.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1404 85.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28258396 28258396 PRJEB43370_P_NODE_3346_length_239_cov_1.368421_g3303_i0 PRJEB43370 3346 239 1.368421 3.27052619 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00709   NR VEU34220.1 183589 g3303 i0 47.8 1.07949790794979 46 22 57.7 1 148 11 177 220 VEU34220.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 258 45.1 0.991130820399113 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28448195 28448195 PRJEB43370_P_NODE_7626_length_169_cov_0.866667_g7583_i0 PRJEB43370 7626 169 0.866667 1.46466723 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.32e-10   NR XP_002296825.1 296543 g7583 i0 58.9 4.66863905325444 56 23 99.4 0 1 168 102 157 XP_002296825.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 789 65.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29370376 29370376 PRJEB43370_P_NODE_10789_length_162_cov_0.920354_g10746_i0 PRJEB43370 10789 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00138   NR KAI2502717.1 210448 g10746 i0 34 4.90740740740741 53 35 98.1 0 3 161 429 481 KAI2502717.1 non-SMC mitotic condensation complex subunit 1 [Fragilaria crotonensis] diamond 795 45.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30191344 30191344 PRJEB43370_P_NODE_9312_length_165_cov_0.896552_g9269_i0 PRJEB43370 9312 165 0.896552 1.4793108 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 62 2.03e-9   NR KAG7361034.1 303405 g9269 i0 55.6 0.981818181818182 54 24 98.2 0 163 2 842 895 KAG7361034.1 hypothetical protein IV203_036134 [Nitzschia inconspicua] diamond 162 62 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30222970 30222970 PRJEB43370_P_NODE_10832_length_162_cov_0.920354_g10789_i0 PRJEB43370 10832 162 0.920354 1.49097348 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0433   NR KAK1739786.1 267567 g10789 i0 67.9 0.518518518518518 28 9 51.9 0 97 14 58 85 KAK1739786.1 NAD-dependent protein deacetylase sirtuin-1, partial [Skeletonema marinoi] diamond 84 41.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30475935 30475935 PRJEB43370_P_NODE_7633_length_169_cov_0.866667_g7590_i0 PRJEB43370 7633 169 0.866667 1.46466723 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0496   NR KAI2488909.1 210448 g7590 i0 51.5 0.585798816568047 33 14 58.6 1 100 2 623 653 KAI2488909.1 hypothetical protein MHU86_25963 [Fragilaria crotonensis] diamond 99 41.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30507450 30507450 PRJEB43370_P_NODE_7653_length_169_cov_0.866667_g7610_i0 PRJEB43370 7653 169 0.866667 1.46466723 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.73e-11   NR KAL3793521.1 29204 g7610 i0 57.1 1.95266272189349 56 24 99.4 0 168 1 286 341 KAL3793521.1 hypothetical protein HJC23_007261 [Cyclotella cryptica] diamond 330 67.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30633591 30633591 PRJEB43370_P_NODE_7933_length_168_cov_0.873950_g7890_i0 PRJEB43370 7933 168 0.87395 1.468236 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.19e-6   NR OEU22883.1 635003 g7890 i0 47.2 1.80357142857143 53 27 92.9 1 167 12 137 189 OEU22883.1 hypothetical protein FRACYDRAFT_179605 [Fragilariopsis cylindrus CCMP1102] diamond 303 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
31100900 31100900 PRJEB43370_P_NODE_5935_length_188_cov_1.122302_g5892_i0 PRJEB43370 5935 188 1.122302 2.10992776 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 99 2.26e-22   NR XP_002289081.1 296543 g5892 i0 70.5 8.76063829787234 61 18 97.3 0 4 186 413 473 XP_002289081.1 propionyl-coa carboxylase, partial [Thalassiosira pseudonana CCMP1335] diamond 1647 100 0.99 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31392460 31392460 PRJEB43370_P_NODE_2876_length_256_cov_1.207729_g2833_i0 PRJEB43370 2876 256 1.207729 3.09178624 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.94e-11   NR KAL3759614.1 259834 g2833 i0 52.4 0.9609375 82 39 96.1 0 255 10 664 745 KAL3759614.1 hypothetical protein ACHAWU_009761 [Discostella pseudostelligera] diamond 246 68.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32563077 32563077 PRJEB43370_P_NODE_2179_length_294_cov_1.273469_g2136_i0 PRJEB43370 2179 294 1.273469 3.74399886 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 149 1.39e-41   NR CAJ1937478.1 2856 g2136 i0 73.7 1.01020408163265 99 25 100 1 294 1 237 335 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 297 149 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32808039 32808039 PRJEB43370_P_NODE_4700_length_207_cov_1.316456_g4657_i0 PRJEB43370 4700 207 1.316456 2.72506392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.24e-9   NR XP_002182551.1 556484 g4657 i0 54.8 1.78260869565217 62 26 89.9 2 187 2 7 66 XP_002182551.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 369 61.2 0.993464052287582 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);;