RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA917598" 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

  • PRJNA917598 · 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
896131 896131 PRJNA917598_P_NODE_47701_length_332_cov_1.378378_g46757_i0 PRJNA917598 47701 332 1.378378 4.57621496 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 77.4 2.9e-15   NR XP_002178631.1 556484 g46757 i0 46 1.57228915662651 100 52 90.4 1 330 31 47 144 XP_002178631.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 522 77.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
7629849 7629849 PRJNA917598_P_NODE_92166_length_243_cov_0.905882_g91222_i0 PRJNA917598 92166 243 0.905882 2.20129326 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 85.1 3.84e-17   NR KAG7366422.1 303405 g91222 i0 75.5 9.22222222222222 53 13 65.4 0 82 240 94 146 KAG7366422.1 NAD-dependent epimerase/dehydratase [Nitzschia inconspicua] diamond 2241 85.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
8549994 8549994 PRJNA917598_P_NODE_84647_length_248_cov_0.880000_g83703_i0 PRJNA917598 84647 248 0.88 2.1824 Nitzschia sp. IriIs04 1444690 SAR_Eukaryotes SAR_Eukaryotes 206 1.6299999999999998e-48   NTclustered gi|944186118|dbj|LC052646.1| 1444690 g83703 i0 84.878 4.85483870967742 205 29 82 2 1 204 1229 1026 Nitzschia sp. IriIs04 hCdc48-1 mRNA for host cell division cycle protein, complete cds blastn 1204 206 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
8550140 8550140 PRJNA917598_P_NODE_91027_length_244_cov_0.900585_g90083_i0 PRJNA917598 91027 244 0.900585 2.1974274 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 135 7.12e-38   NR KAI2502075.1 210448 g90083 i0 74.1 7.9672131147541 81 21 99.6 0 1 243 51 131 KAI2502075.1 ribosomal uS7-like protein [Fragilaria crotonensis] diamond 1944 135 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
12375509 12375509 PRJNA917598_P_NODE_55990_length_304_cov_1.333333_g55046_i0 PRJNA917598 55990 304 1.333333 4.05333232 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 134 9.83e-27   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g55046 i0 80.105 14.1513157894737 191 28 61 8 118 303 17744 17929 Coscinodiscus granii mitochondrion, complete sequence blastn 4302 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
13650908 13650908 PRJNA917598_P_NODE_94271_length_242_cov_0.911243_g93327_i0 PRJNA917598 94271 242 0.911243 2.20520806 Minidiscus trioculatus 265540 SAR_Eukaryotes SAR_Eukaryotes 448 2.3799999999999995e-121   NTclustered gi|817090737|gb|KM009428.1| 265540 g93327 i0 100 130.99173553719 242 0 100 0 1 242 313 72 Minidiscus trioculatus isolate CCMP495 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 31700 448 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus trioculatus
14923978 14923978 PRJNA917598_P_NODE_43652_length_347_cov_5.029197_g42708_i0 PRJNA917598 43652 347 5.029197 17.45131359 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 121 8.879999999999999e-23   NTclustered gi|1418586621|ref|NC_037987.1| 1458866 g42708 i0 78.191 3.78386167146974 188 41 54 0 145 332 5914 5727 Eunotia naegelii strain UTEX FD354 mitochondrion, complete genome blastn 1313 121 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
16199569 16199569 PRJNA917598_P_NODE_67673_length_277_cov_1.122549_g66729_i0 PRJNA917598 67673 277 1.122549 3.10946073 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 119 2.48e-22   NTclustered gi|2046217437|gb|MW729336.1| 451786 g66729 i0 81.333 33.956678700361 150 24 53 4 3 149 38482 38334 Attheya longicornis mitochondrion, complete genome blastn 9406 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
17473523 17473523 PRJNA917598_P_NODE_14974_length_608_cov_2.542056_g14040_i0 PRJNA917598 14974 608 2.542056 15.45570048 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.76e-10   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g14040 i0 76.433 1.14309210526316 157 31 25 6 6 160 4414 4566 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 695 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
18748264 18748264 PRJNA917598_P_NODE_6715_length_934_cov_1.562137_g5945_i0 PRJNA917598 6715 934 1.562137 14.59035958 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 113 4.27e-20   NTclustered gi|2074156200|gb|MW413905.1| 216802 g5945 i0 78.075 2.42826552462527 187 35 20 6 717 900 15113 15296 Guinardia delicatula mitochondrion, complete genome blastn 2268 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
19102864 19102864 PRJNA917598_P_NODE_47155_length_334_cov_1.467433_g46211_i0 PRJNA917598 47155 334 1.467433 4.90122622 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 130 1.41e-25   NTclustered gi|2739942907|dbj|LC814767.1| 2843 g46211 i0 89.524 23.2125748502994 105 8 31 3 96 198 7689 7586 Skeletonema costatum SCHP35 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial and complete sequence blastn 7753 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
21299289 21299289 PRJNA917598_P_NODE_96277_length_241_cov_0.863095_g95333_i0 PRJNA917598 96277 241 0.863095 2.08005895 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 407 4.0199999999999995e-109   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g95333 i0 97.095 198.609958506224 241 7 100 0 1 241 122028 121788 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 47865 407 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
21653387 21653387 PRJNA917598_P_NODE_29837_length_421_cov_1.959770_g28893_i0 PRJNA917598 29837 421 1.95977 8.2506317 root 1 Root_unresolved Root_unresolved 99 5.13e-16   NTclustered gi|2846854574|gb|PQ459335.1| 37318 g28893 i0 78.481 32.9311163895487 158 28 37 6 17 171 34236 34390 Pseudo-nitzschia pungens isolate CNS00055 mitochondrion, complete genome blastn 13864 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
25478290 25478290 PRJNA917598_P_NODE_83620_length_249_cov_0.875000_g82676_i0 PRJNA917598 83620 249 0.875 2.17875 Actinocyclus 49230 SAR_Eukaryotes SAR_Eukaryotes 411 3.2299999999999996e-110   NTclustered gi|511649001|gb|KC309668.1| 1335100 g82676 i0 96.386 99.9638554216867 249 9 100 0 1 249 289 41 Actinocyclus sp. 1 MPA-2013 isolate ECT3899tinydrum photosystem II CP43 protein (psbC) gene, partial cds; plastid blastn 24891 411 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. 1 MPA-2013
26771479 26771479 PRJNA917598_P_NODE_96101_length_241_cov_0.916667_g95157_i0 PRJNA917598 96101 241 0.916667 2.20916747 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 78.6 1.9e-16   NR XP_002186290.1 556484 g95157 i0 61.9 0.784232365145228 63 24 78.4 0 49 237 4 66 XP_002186290.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 189 78.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26936898 26936898 PRJNA917598_P_NODE_71042_length_270_cov_1.172589_g70098_i0 PRJNA917598 71042 270 1.172589 3.1659903 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.1 3.35e-22   NR GFH59293.1 426638 g70098 i0 54.8 4.68888888888889 84 35 93.3 1 14 265 1 81 GFH59293.1 RL9, ribosomal protein 9 [Chaetoceros tenuissimus] diamond 1266 95.9 0.991657977059437 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30126511 30126511 PRJNA917598_P_NODE_68472_length_275_cov_1.485149_g67528_i0 PRJNA917598 68472 275 1.485149 4.08415975 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.1 6.9e-17   NR KAK1737196.1 267567 g67528 i0 46.3 2.57454545454545 80 39 82.9 1 274 47 321 400 KAK1737196.1 U2 snRNP-associated SURP motif-containing protein [Skeletonema marinoi] diamond 708 85.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30341100 30341100 PRJNA917598_P_NODE_37272_length_376_cov_1.524752_g36328_i0 PRJNA917598 37272 376 1.524752 5.73306752 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 105 6.54e-26   NR CAB9514451.1 568900 g36328 i0 43.3 0.957446808510638 120 67 94.9 1 357 1 5 124 CAB9514451.1 EFh [Seminavis robusta] diamond 360 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32086675 32086675 PRJNA917598_P_NODE_88158_length_246_cov_0.890173_g87214_i0 PRJNA917598 88158 246 0.890173 2.18982558 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 115 7.5599999999999995e-28   NR KAL3768771.1 259834 g87214 i0 69.1 4.96341463414634 81 25 98.8 0 243 1 1267 1347 KAL3768771.1 hypothetical protein ACHAWU_006872 [Discostella pseudostelligera] diamond 1221 116 0.991379310344828 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32174509 32174509 PRJNA917598_P_NODE_66038_length_280_cov_1.115942_g65094_i0 PRJNA917598 66038 280 1.115942 3.1246376 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0148   NR YP_003359455.1 1436140 g65094 i0 33.8 0.825 77 36 66.4 1 232 47 49 125 YP_003359455.1 ribosomal protein S8 [Ulnaria acus] diamond 231 43.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
32876136 32876136 PRJNA917598_P_NODE_88720_length_245_cov_1.563953_g87776_i0 PRJNA917598 88720 245 1.563953 3.83168485 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.46e-9   NR CAJ1909979.1 2856 g87776 i0 54.7 6.53877551020408 53 24 64.9 0 2 160 383 435 CAJ1909979.1 unnamed protein product [Cylindrotheca closterium] diamond 1602 63.5 0.995275590551181 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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