RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA795983 · 17 ✖

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
9708484 9708484 PRJNA795983_S_NODE_4568_length_518_cov_2.182022_g4445_i0 PRJNA795983 4568 518 2.182022 11.30287396 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 335 4.5e-87   NTclustered gi|225685848|dbj|AB461922.1| 33640 g4445 i0 78.812 29.5888030888031 505 101 97 6 1 502 22 523 Asterionellopsis glacialis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 15327 335 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
10984026 10984026 PRJNA795983_S_NODE_24129_length_288_cov_2.311628_g24004_i0 PRJNA795983 24129 288 2.311628 6.65748864 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 92 3.6000000000000003e-22   NR EJK59273.1 159749 g24004 i0 63.5 6.40625 63 23 65.6 0 98 286 9 71 EJK59273.1 hypothetical protein THAOC_20528, partial [Thalassiosira oceanica] diamond 1845 92 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
14808786 14808786 PRJNA795983_S_NODE_40092_length_245_cov_0.889535_g39967_i0 PRJNA795983 40092 245 0.889535 2.17936075 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 97.1 3.01e-21   NR GFH54775.1 426638 g39967 i0 62 0.96734693877551 79 30 96.7 0 3 239 271 349 GFH54775.1 hypothetical protein CTEN210_11251 [Chaetoceros tenuissimus] diamond 237 97.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
18631498 18631498 PRJNA795983_S_NODE_15275_length_335_cov_2.419847_g15150_i0 PRJNA795983 15275 335 2.419847 8.10648745 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 166 2.71e-49   NR KAI2502075.1 210448 g15150 i0 71.2 8.43582089552239 104 30 93.1 0 314 3 38 141 KAI2502075.1 ribosomal uS7-like protein [Fragilaria crotonensis] diamond 2826 167 0.994011976047904 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
18631514 18631514 PRJNA795983_S_NODE_16895_length_324_cov_3.027888_g16770_i0 PRJNA795983 16895 324 3.027888 9.81035712 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 120 8.66e-30   NR KAI2503236.1 210448 g16770 i0 56.3 0.953703703703704 103 39 95.4 3 316 8 160 256 KAI2503236.1 High choriolytic enzyme 1-like [Fragilaria crotonensis] diamond 309 120 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
23732831 23732831 PRJNA795983_S_NODE_17459_length_321_cov_1.657258_g17334_i0 PRJNA795983 17459 321 1.657258 5.31979818 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 152 5.12e-44   NR KAL3808679.1 382380 g17334 i0 73.5 10.0467289719626 98 26 91.6 0 295 2 27 124 KAL3808679.1 hypothetical protein ACHAXA_009232 [Cyclostephanos tholiformis] diamond 3225 153 0.993464052287582 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
26619770 26619770 PRJNA795983_S_NODE_28421_length_273_cov_1.295000_g28296_i0 PRJNA795983 28421 273 1.295 3.53535 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 108 7.06e-27   NR KAK1736061.1 267567 g28296 i0 70.1 5.12087912087912 67 20 73.6 0 202 2 141 207 KAK1736061.1 sig3-like protein [Skeletonema marinoi] diamond 1398 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27085505 27085505 PRJNA795983_S_NODE_34562_length_254_cov_1.618785_g34437_i0 PRJNA795983 34562 254 1.618785 4.1117139 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.97e-4   NR CAB9512561.1 568900 g34437 i0 47.9 3.49606299212598 48 25 56.7 0 253 110 669 716 CAB9512561.1 phosphoesterase RecJ domain protein [Seminavis robusta] diamond 888 48.9 0.991820040899796 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28190618 28190618 PRJNA795983_S_NODE_32326_length_260_cov_2.470588_g32201_i0 PRJNA795983 32326 260 2.470588 6.4235288 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 130 8.810000000000001e-33   NR KAI2500171.1 210448 g32201 i0 62.2 4.86923076923077 82 31 94.6 0 260 15 213 294 KAI2500171.1 DUF5107-containing protein [Fragilaria crotonensis] diamond 1266 130 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28389356 28389356 PRJNA795983_S_NODE_18186_length_317_cov_1.618852_g18061_i0 PRJNA795983 18186 317 1.618852 5.13176084 root 1 Root_unresolved Root_unresolved 79.7 9.15e-15   NR GAX17011.1 1519565 g18061 i0 52.6 1.57097791798107 78 34 71.9 3 229 2 292 368 GAX17011.1 hypothetical protein FisN_5Hh393 [Fistulifera solaris] diamond 498 80.1 0.995006242197254 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29138326 29138326 PRJNA795983_S_NODE_43049_length_241_cov_0.916667_g42924_i0 PRJNA795983 43049 241 0.916667 2.20916747 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 102 1.41e-23   NR KAG7338595.1 303405 g42924 i0 64.8 0.883817427385892 71 25 88.4 0 5 217 199 269 KAG7338595.1 hypothetical protein IV203_004850 [Nitzschia inconspicua] diamond 213 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30433335 30433335 PRJNA795983_S_NODE_23653_length_290_cov_2.087558_g23528_i0 PRJNA795983 23653 290 2.087558 6.0539182 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.54e-17   NR KAG7366721.1 303405 g23528 i0 45.7 1.9448275862069 94 49 97.2 1 290 9 55 146 KAG7366721.1 ribosomal protein 50S-L18Ae/60S-L20/60S-L18A [Nitzschia inconspicua] diamond 564 84.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30473855 30473855 PRJNA795983_S_NODE_34073_length_255_cov_2.335165_g33948_i0 PRJNA795983 34073 255 2.335165 5.95467075 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 79.7 4.59e-16   NR KAI2494408.1 210448 g33948 i0 49.4 2.78823529411765 81 33 95.3 1 2 244 137 209 KAI2494408.1 hypothetical protein MHU86_20137 [Fragilaria crotonensis] diamond 711 79.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31222665 31222665 PRJNA795983_S_NODE_41555_length_243_cov_0.905882_g41430_i0 PRJNA795983 41555 243 0.905882 2.20129326 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 124 1.19e-31   NR KAG7374687.1 303405 g41430 i0 70.1 0.950617283950617 77 23 95.1 0 11 241 298 374 KAG7374687.1 fatty acid desaturase, type 2 [Nitzschia inconspicua] diamond 231 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31485280 31485280 PRJNA795983_S_NODE_25976_length_281_cov_2.057692_g25851_i0 PRJNA795983 25976 281 2.057692 5.78211452 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 2.7199999999999997e-35   NR EJK48626.1 159749 g25851 i0 66.3 7.8576512455516 92 31 98.2 0 277 2 13 104 EJK48626.1 hypothetical protein THAOC_32560, partial [Thalassiosira oceanica] diamond 2208 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31832790 31832790 PRJNA795983_S_NODE_11317_length_372_cov_1.214047_g11192_i0 PRJNA795983 11317 372 1.214047 4.51625484 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 84 7.28e-18   NR KAL3762786.1 2934178 g11192 i0 53.2 6.2741935483871 79 36 63.7 1 3 239 53 130 KAL3762786.1 hypothetical protein ACHAW5_001314 [Stephanodiscus triporus] diamond 2334 84 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
32686556 32686556 PRJNA795983_S_NODE_33720_length_256_cov_2.316940_g33595_i0 PRJNA795983 33720 256 2.3169400000000002 5.9313664 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 115 5.63e-28   NR KAK1737933.1 267567 g33595 i0 63.1 28.74609375 84 29 98.4 1 252 1 214 295 KAK1737933.1 AP-1 complex subunit mu-1 [Skeletonema marinoi] diamond 7359 116 0.991379310344828 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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