RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1233465 · 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
26220296 26220296 PRJNA1233465b_S_NODE_369694_length_161_cov_1.696429_g368009_i0 PRJNA1233465 369694 161 1.696429 2.73125069 Odontella sp. (in: diatoms) 40357 SAR_Eukaryotes SAR_Eukaryotes 148 1.6599999999999998e-31   NTclustered gi|1377545700|gb|MG835798.1| 40357 g368009 i0 84.277 2.06211180124224 159 17 98 6 5 161 679 831 Odontella sp. (in: Bacillariophyta) isolate SKLMP_B005 28S ribosomal RNA gene, partial sequence blastn 332 148 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Odontellaceae Odontella Odontella sp. (in: diatoms)
26298663 26298663 PRJNA1233465a_S_NODE_185598_length_179_cov_1.176923_g184324_i0 PRJNA1233465 185598 179 1.176923 2.10669217 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 139 1.13e-28   NTclustered gi|2172620591|ref|NC_059929.1| 671091 g184324 i0 89.908 134.938547486034 109 10 61 1 69 177 12336 12443 Coscinodiscus wailesii chloroplast, complete genome blastn 24154 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
32923435 32923435 PRJNA1233465a_S_NODE_83537_length_245_cov_2.362245_g82263_i0 PRJNA1233465 83537 245 2.362245 5.78750025 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 76.3 2.91e-14   NR KAL3793234.1 29204 g82263 i0 59.4 1.68979591836735 69 27 83.3 1 243 40 231 299 KAL3793234.1 hypothetical protein HJC23_000776 [Cyclotella cryptica] diamond 414 76.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32949118 32949118 PRJNA1233465a_S_NODE_75554_length_254_cov_3.439024_g74280_i0 PRJNA1233465 75554 254 3.439024 8.73512096 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 124 8.47e-31   NR KAK1749258.1 267567 g74280 i0 90.9 0.779527559055118 66 6 78 0 253 56 338 403 KAK1749258.1 ATP-dependent RNA helicase [Skeletonema marinoi] diamond 198 124 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32965798 32965798 PRJNA1233465a_S_NODE_120370_length_213_cov_1.506098_g119096_i0 PRJNA1233465 120370 213 1.506098 3.20798874 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 74.7 1.35e-13   NR KAK1733995.1 267567 g119096 i0 58.5 0.915492957746479 65 27 91.5 0 17 211 163 227 KAK1733995.1 leucine-rich repeat protein [Skeletonema marinoi] diamond 195 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32966164 32966164 PRJNA1233465a_S_NODE_252650_length_159_cov_3.336364_g251376_i0 PRJNA1233465 252650 159 3.336364 5.30481876 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 49.3 5.97e-5   NR KAK1739316.1 267567 g251376 i0 67.6 1.84905660377358 34 11 64.2 0 144 43 5 38 KAK1739316.1 putative AAA ATPase [Skeletonema marinoi] diamond 294 49.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32983193 32983193 PRJNA1233465a_S_NODE_259939_length_152_cov_2.990291_g258665_i0 PRJNA1233465 259939 152 2.990291 4.54524232 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.28e-12   NR KAK1735143.1 267567 g258665 i0 72.5 1.00657894736842 51 11 96.7 2 151 5 364 413 KAK1735143.1 hypothetical protein QTG54_014209 [Skeletonema marinoi] diamond 153 69.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32983363 32983363 PRJNA1233465a_S_NODE_92275_length_236_cov_2.454545_g91001_i0 PRJNA1233465 92275 236 2.454545 5.7927262 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 92.8 8.02e-20   NR KAK1738744.1 267567 g91001 i0 70.6 0.864406779661017 68 20 86.4 0 214 11 455 522 KAK1738744.1 hypothetical protein QTG54_010774 [Skeletonema marinoi] diamond 204 92.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32991907 32991907 PRJNA1233465a_S_NODE_155739_length_192_cov_2.083916_g154465_i0 PRJNA1233465 155739 192 2.083916 4.00111872 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 87.4 3.56e-18   NR XP_002290635.1 296543 g154465 i0 71.9 1.78125 57 16 89.1 0 192 22 384 440 XP_002290635.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 342 87.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
33017204 33017204 PRJNA1233465a_S_NODE_249092_length_161_cov_0.910714_g247818_i0 PRJNA1233465 249092 161 0.910714 1.46624954 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.7e-5   NR KAK1745797.1 267567 g247818 i0 42.3 0.968944099378882 52 30 96.9 0 160 5 945 996 KAK1745797.1 putative AAA ATPase [Skeletonema marinoi] diamond 156 50.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33085558 33085558 PRJNA1233465a_S_NODE_72550_length_258_cov_1.708134_g71276_i0 PRJNA1233465 72550 258 1.708134 4.40698572 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 126 6.66e-33   NR KAK1749057.1 267567 g71276 i0 88.4 2.5 69 8 80.2 0 207 1 101 169 KAK1749057.1 hypothetical protein QTG54_000996 [Skeletonema marinoi] diamond 645 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33119308 33119308 PRJNA1233465a_S_NODE_184343_length_179_cov_2.223077_g183069_i0 PRJNA1233465 184343 179 2.223077 3.97930783 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 107 3.45e-25   NR KAK1747784.1 267567 g183069 i0 96.6 0.988826815642458 59 2 98.9 0 3 179 339 397 KAK1747784.1 ABC transporter [Skeletonema marinoi] diamond 177 107 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33119441 33119441 PRJNA1233465a_S_NODE_236799_length_163_cov_1.622807_g235525_i0 PRJNA1233465 236799 163 1.6228070000000001 2.64517541 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 97.8 3.0800000000000003e-22   NR KAK1738451.1 267567 g235525 i0 87 0.993865030674847 54 7 99.4 0 1 162 379 432 KAK1738451.1 retinol dehydrogenase-related protein [Skeletonema marinoi] diamond 162 97.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33119567 33119567 PRJNA1233465a_S_NODE_56695_length_282_cov_1.785408_g55421_i0 PRJNA1233465 56695 282 1.785408 5.03485056 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 184 1.64e-51   NR KAK1736697.1 267567 g55421 i0 93.6 1 94 6 100 0 282 1 468 561 KAK1736697.1 transcriptional regulatory protein SIN3-like protein [Skeletonema marinoi] diamond 282 184 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33136744 33136744 PRJNA1233465a_S_NODE_76599_length_253_cov_1.955882_g75325_i0 PRJNA1233465 76599 253 1.955882 4.94838146 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 60.8 7.57e-9   NR KAK1735165.1 267567 g75325 i0 77.1 0.41501976284585 35 8 41.5 0 95 199 186 220 KAK1735165.1 EF-hand domain-containing protein [Skeletonema marinoi] diamond 105 60.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33137349 33137349 PRJNA1233465b_S_NODE_48783_length_355_cov_2.003268_g47098_i0 PRJNA1233465 48783 355 2.003268 7.1116014 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 126 8.190000000000001e-33   NR KAL3793234.1 29204 g47098 i0 63.8 2.69577464788732 105 37 87.9 1 351 40 195 299 KAL3793234.1 hypothetical protein HJC23_000776 [Cyclotella cryptica] diamond 957 126 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
33145350 33145350 PRJNA1233465a_S_NODE_107463_length_223_cov_0.902299_g106189_i0 PRJNA1233465 107463 223 0.902299 2.01212677 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 129 7.38e-33   NR KAL3775448.1 29204 g106189 i0 87.5 3.80717488789238 72 9 96.9 0 2 217 342 413 KAL3775448.1 hypothetical protein HJC23_006534 [Cyclotella cryptica] diamond 849 130 0.992307692307692 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
33153418 33153418 PRJNA1233465a_S_NODE_164040_length_188_cov_2.201439_g162766_i0 PRJNA1233465 164040 188 2.201439 4.13870532 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00148   NR EJK49784.1 159749 g162766 i0 55.2 0.462765957446808 29 13 46.3 0 187 101 578 606 EJK49784.1 hypothetical protein THAOC_31306 [Thalassiosira oceanica] diamond 87 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33170491 33170491 PRJNA1233465a_S_NODE_148632_length_196_cov_1.387755_g147358_i0 PRJNA1233465 148632 196 1.387755 2.7199998 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 97.4 7.7e-22   NR KAK1734848.1 267567 g147358 i0 64.6 0.994897959183674 65 23 99.5 0 1 195 318 382 KAK1734848.1 hypothetical protein QTG54_014308 [Skeletonema marinoi] diamond 195 97.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33170743 33170743 PRJNA1233465a_S_NODE_241592_length_162_cov_1.867257_g240318_i0 PRJNA1233465 241592 162 1.867257 3.02495634 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 64.3 6.18e-11   NR KAK1742498.1 267567 g240318 i0 81 0.777777777777778 42 8 77.8 0 161 36 140 181 KAK1742498.1 hypothetical protein QTG54_007063 [Skeletonema marinoi] diamond 126 64.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
33172098 33172098 PRJNA1233465d_S_NODE_78768_length_201_cov_1.486842_g77657_i0 PRJNA1233465 78768 201 1.486842 2.98855242 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 128 1.63e-32   NR KAL3760216.1 259834 g77657 i0 89.4 0.985074626865672 66 7 98.5 0 200 3 367 432 KAL3760216.1 hypothetical protein ACHAWU_001726 [Discostella pseudostelligera] diamond 198 128 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);;