RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA738523", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA738523 · 18 ✖

analysis 1

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
7098230 7098230 PRJNA738523_P_NODE_15686_length_242_cov_0.911243_g15615_i0 PRJNA738523 15686 242 0.911243 2.20520806 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 126 1.9299999999999998e-32   NR GKY99532.1 2872254 g15615 i0 80 0.991735537190083 80 12 99.2 1 241 2 175 250 GKY99532.1 hypothetical protein MPSEU_000907300 [Mayamaea pseudoterrestris] diamond 240 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
12198943 12198943 PRJNA738523_P_NODE_5630_length_305_cov_1.327586_g5559_i0 PRJNA738523 5630 305 1.327586 4.0491373 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 156 3.1299999999999996e-42   NR XP_002184830.1 556484 g5559 i0 77.9 1.02295081967213 104 20 99.3 2 1 303 210 313 XP_002184830.1 carboxylase propionyl-coa carboxylase [Phaeodactylum tricornutum CCAP 1055/1] diamond 312 156 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27178702 27178702 PRJNA738523_P_NODE_10542_length_251_cov_0.865169_g10471_i0 PRJNA738523 10542 251 0.865169 2.17157419 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.1e-6   NR KAL3788719.1 382360 g10471 i0 53.2 0.561752988047809 47 18 51.4 1 248 120 109 155 KAL3788719.1 hypothetical protein ACHAWO_002715 [Cyclotella atomus] diamond 141 54.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27589749 27589749 PRJNA738523_P_NODE_11064_length_250_cov_0.870056_g10993_i0 PRJNA738523 11064 250 0.870056 2.17514 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 52 2.24e-5   NR VEU44076.1 183589 g10993 i0 41.8 0.804 67 38 80.4 1 250 50 353 418 VEU44076.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 201 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27905065 27905065 PRJNA738523_P_NODE_12505_length_248_cov_0.880000_g12434_i0 PRJNA738523 12505 248 0.88 2.1824 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 84 1.8e-17   NR GAX23798.1 1519565 g12434 i0 56.1 1.98387096774194 82 36 99.2 0 247 2 103 184 GAX23798.1 hypothetical protein FisN_12Hh380 [Fistulifera solaris] diamond 492 84 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27937009 27937009 PRJNA738523_P_NODE_7665_length_277_cov_1.509804_g7594_i0 PRJNA738523 7665 277 1.509804 4.18215708 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 168 3.03e-46   NR KAG7369131.1 303405 g7594 i0 89 0.985559566787004 91 10 98.6 0 275 3 162 252 KAG7369131.1 glutathione-regulated potassium-efflux system protein [Nitzschia inconspicua] diamond 273 168 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28094773 28094773 PRJNA738523_P_NODE_12925_length_247_cov_0.885057_g12854_i0 PRJNA738523 12925 247 0.885057 2.18609079 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 67 1.12e-10   NR GKZ01031.1 2872254 g12854 i0 35 0.97165991902834 80 52 97.2 0 240 1 644 723 GKZ01031.1 hypothetical protein MPSEU_001054500 [Mayamaea pseudoterrestris] diamond 240 67 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28473754 28473754 PRJNA738523_P_NODE_7246_length_281_cov_1.918269_g7175_i0 PRJNA738523 7246 281 1.918269 5.39033589 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 105 2.39e-26   NR GAX18269.1 1519565 g7175 i0 84.1 1.34519572953737 63 10 67.3 0 13 201 117 179 GAX18269.1 hypothetical protein FisN_20Lh031 [Fistulifera solaris] diamond 378 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28568297 28568297 PRJNA738523_P_NODE_14447_length_244_cov_0.900585_g14376_i0 PRJNA738523 14447 244 0.900585 2.1974274 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 95.5 1.05e-20   NR GKY96451.1 2872254 g14376 i0 59.5 0.971311475409836 79 31 97.1 1 4 240 797 874 GKY96451.1 hypothetical protein MPSEU_000604600 [Mayamaea pseudoterrestris] diamond 237 95.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28600084 28600084 PRJNA738523_P_NODE_12807_length_247_cov_0.885057_g12736_i0 PRJNA738523 12807 247 0.885057 2.18609079 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.51e-8   NR GKY92114.1 2872254 g12736 i0 45.6 0.692307692307692 57 28 69.2 1 51 221 447 500 GKY92114.1 hypothetical protein MPSEU_000182800 [Mayamaea pseudoterrestris] diamond 171 58.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29083832 29083832 PRJNA738523_P_NODE_11188_length_250_cov_0.870056_g11117_i0 PRJNA738523 11188 250 0.870056 2.17514 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 98.6 5.090000000000001e-22   NR XP_002183439.1 556484 g11117 i0 59.8 1.896 82 26 98.4 1 4 249 127 201 XP_002183439.1 glucokinase [Phaeodactylum tricornutum CCAP 1055/1] diamond 474 98.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29452142 29452142 PRJNA738523_P_NODE_9050_length_264_cov_1.418848_g8979_i0 PRJNA738523 9050 264 1.418848 3.74575872 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 95.1 4.81e-22   NR KAI2501223.1 210448 g8979 i0 77 0.693181818181818 61 13 68.2 1 262 83 146 206 KAI2501223.1 Rab-like small GTPase [Fragilaria crotonensis] diamond 183 95.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29483768 29483768 PRJNA738523_P_NODE_8270_length_271_cov_1.555556_g8199_i0 PRJNA738523 8270 271 1.555556 4.21555676 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 119 6.51e-32   NR XP_002184061.1 556484 g8199 i0 67.8 0.996309963099631 90 29 99.6 0 270 1 56 145 XP_002184061.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 270 119 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29714854 29714854 PRJNA738523_P_NODE_13270_length_246_cov_0.890173_g13199_i0 PRJNA738523 13270 246 0.890173 2.18982558 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 139 3.2e-38   NR XP_002178531.1 556484 g13199 i0 74.1 2.96341463414634 81 21 98.8 0 246 4 136 216 XP_002178531.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 729 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30273950 30273950 PRJNA738523_P_NODE_3752_length_353_cov_1.100000_g3681_i0 PRJNA738523 3752 353 1.1 3.883 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0062   NR KAL3912790.1 3061772 g3681 i0 52.8 0.45042492917847 53 13 45 2 163 5 20 60 KAL3912790.1 MAG: hypothetical protein SGARI_000975 [Bacillariaceae sp.] diamond 159 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31000433 31000433 PRJNA738523_P_NODE_12234_length_248_cov_0.880000_g12163_i0 PRJNA738523 12234 248 0.88 2.1824 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.92e-16   NR GAX10483.1 1519565 g12163 i0 58.3 0.870967741935484 72 29 85.9 1 246 34 112 183 GAX10483.1 hypothetical protein FisN_21Lh184 [Fistulifera solaris] diamond 216 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31358323 31358323 PRJNA738523_P_NODE_6396_length_290_cov_1.410138_g6325_i0 PRJNA738523 6396 290 1.410138 4.0894002 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 139 1.03e-36   NR CAB9512466.1 568900 g6325 i0 62.4 4.88275862068966 93 35 96.2 0 282 4 296 388 CAB9512466.1 Metallophosphoesterase domain-containing protein 1 [Seminavis robusta] diamond 1416 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31442937 31442937 PRJNA738523_P_NODE_12176_length_248_cov_0.880000_g12105_i0 PRJNA738523 12176 248 0.88 2.1824 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 70.9 4.86e-12   NR CAB9513705.1 568900 g12105 i0 46.9 1.94758064516129 81 32 98 1 244 2 346 415 CAB9513705.1 expressed unknown protein [Seminavis robusta] diamond 483 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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