RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA657343 · 22 ✖

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
622869 622869 PRJNA657343_P_NODE_19141_length_211_cov_1.086420_g19117_i0 PRJNA657343 19141 211 1.08642 2.2923462 root 1 Root_unresolved Root_unresolved 95.5 6.5700000000000005e-21   NR CAB9516456.1 568900 g19117 i0 70.7 2.34597156398104 58 16 81 1 204 34 449 506 CAB9516456.1 expressed unknown protein [Seminavis robusta] diamond 495 95.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
4450730 4450730 PRJNA657343_P_NODE_16784_length_221_cov_2.436047_g16760_i0 PRJNA657343 16784 221 2.436047 5.38366387 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 259 1.08e-64   NTclustered gi|657012465|gb|KF302574.1| 2850 g16760 i0 88.073 4.18552036199095 218 26 99 0 1 218 72 289 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 925 259 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5726641 5726641 PRJNA657343_P_NODE_47525_length_152_cov_3.000000_g47501_i0 PRJNA657343 47525 152 3 4.56 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 163 5.5e-36   NTclustered gi|657012511|gb|KF302595.1| 2850 g47501 i0 86.577 0.980263157894737 149 18 97 2 3 150 247 100 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 149 163 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13377215 13377215 PRJNA657343_P_NODE_3891_length_380_cov_3.422961_g3868_i0 PRJNA657343 3891 380 3.422961 13.0072518 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 268 3.2999999999999995e-67   NTclustered gi|657012369|gb|KF302532.1| 2850 g3868 i0 88.94 0.571052631578947 217 24 57 0 75 291 10 226 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 217 268 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17200826 17200826 PRJNA657343_P_NODE_1514_length_532_cov_11.633540_g1491_i0 PRJNA657343 1514 532 11.63354 61.8904328 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 202 3.05e-63   NR KAI2491056.1 210448 g1491 i0 61 7.05451127819549 154 58 86.3 2 34 492 16 168 KAI2491056.1 Ribosomal S17 N terminal [Fragilaria crotonensis] diamond 3753 202 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
18475342 18475342 PRJNA657343_P_NODE_34115_length_170_cov_2.471074_g34091_i0 PRJNA657343 34115 170 2.471074 4.2008258 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 91.3 4.34e-21   NR KAK1746763.1 267567 g34091 i0 75.5 2.82352941176471 53 13 93.5 0 10 168 48 100 KAK1746763.1 NADH dehydrogenase [ubiquinone] iron-sulfur protein 8 [Skeletonema marinoi] diamond 480 91.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
19750147 19750147 PRJNA657343_P_NODE_6296_length_318_cov_2.237918_g6272_i0 PRJNA657343 6296 318 2.237918 7.11657924 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 150 1.87e-40   NR EJK49661.1 159749 g6272 i0 69 17.2547169811321 100 31 94.3 0 313 14 108 207 EJK49661.1 hypothetical protein THAOC_31434 [Thalassiosira oceanica] diamond 5487 151 0.993377483443709 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
26860186 26860186 PRJNA657343_P_NODE_23481_length_195_cov_1.883562_g23457_i0 PRJNA657343 23481 195 1.883562 3.6729459 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 110 1.08e-28   NR KAL3775733.1 382360 g23457 i0 87.3 3.86153846153846 63 8 96.9 0 7 195 48 110 KAL3775733.1 hypothetical protein ACHAWO_000819 [Cyclotella atomus] diamond 753 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27030283 27030283 PRJNA657343_P_NODE_32062_length_174_cov_2.920000_g32038_i0 PRJNA657343 32062 174 2.92 5.0808 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.9 2.24e-14   NR KAL3805673.1 29204 g32038 i0 60.7 4.8448275862069 56 22 96.6 0 6 173 53 108 KAL3805673.1 hypothetical protein HJC23_005917 [Cyclotella cryptica] diamond 843 73.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28281287 28281287 PRJNA657343_P_NODE_20606_length_205_cov_1.948718_g20582_i0 PRJNA657343 20606 205 1.948718 3.9948719 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 55.8 5.41e-7   NR OEU18900.1 635003 g20582 i0 45.8 1.40487804878049 48 26 70.2 0 156 13 1 48 OEU18900.1 hypothetical protein FRACYDRAFT_182579 [Fragilariopsis cylindrus CCMP1102] diamond 288 55.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28767265 28767265 PRJNA657343_P_NODE_9407_length_274_cov_2.742222_g9383_i0 PRJNA657343 9407 274 2.742222 7.51368828 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 70.9 3.31e-12   NR VEU42620.1 183589 g9383 i0 69.4 1.60948905109489 49 15 53.6 0 272 126 63 111 VEU42620.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 441 71.6 0.990223463687151 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30207423 30207423 PRJNA657343_P_NODE_15912_length_226_cov_1.163842_g15888_i0 PRJNA657343 15912 226 1.163842 2.63028292 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 112 4.26e-30   NR AID23596.1 2850 g15888 i0 74.3 0.982300884955752 74 19 98.2 0 3 224 43 116 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 222 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30334544 30334544 PRJNA657343_P_NODE_34372_length_170_cov_1.297521_g34348_i0 PRJNA657343 34372 170 1.297521 2.2057857 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 78.6 2.07e-16   NR CAB9514451.1 568900 g34348 i0 75 0.847058823529412 48 12 84.7 0 168 25 28 75 CAB9514451.1 EFh [Seminavis robusta] diamond 144 78.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30397796 30397796 PRJNA657343_P_NODE_21813_length_201_cov_1.026316_g21789_i0 PRJNA657343 21813 201 1.026316 2.06289516 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 101 4.189999999999999e-24   NR XP_002184021.1 556484 g21789 i0 74.2 0.925373134328358 62 16 92.5 0 13 198 103 164 XP_002184021.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 186 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31218420 31218420 PRJNA657343_P_NODE_5215_length_341_cov_0.955479_g5192_i0 PRJNA657343 5215 341 0.955479 3.25818339 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 77 1.44e-14   NR CAJ1962951.1 2856 g5192 i0 61.5 0.571847507331378 65 25 57.2 0 341 147 145 209 CAJ1962951.1 unnamed protein product [Cylindrotheca closterium] diamond 195 77 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31472007 31472007 PRJNA657343_P_NODE_26476_length_187_cov_2.137681_g26452_i0 PRJNA657343 26476 187 2.137681 3.99746347 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.21e-17   NR GFH55061.1 426638 g26452 i0 69.8 0.850267379679144 53 16 85 0 7 165 172 224 GFH55061.1 peroxiredoxin [Chaetoceros tenuissimus] diamond 159 82.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31642061 31642061 PRJNA657343_P_NODE_1196_length_573_cov_2.297710_g1174_i0 PRJNA657343 1196 573 2.29771 13.1658783 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 144 1.44e-39   NR KAG7367708.1 303405 g1174 i0 53.1 3.46596858638743 130 57 68.1 2 181 570 68 193 KAG7367708.1 ubiquitin-conjugating enzyme [Nitzschia inconspicua] diamond 1986 144 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31756497 31756497 PRJNA657343_P_NODE_37817_length_167_cov_0.881356_g37793_i0 PRJNA657343 37817 167 0.881356 1.47186452 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 58.2 4.86e-8   NR GAX26841.1 1519565 g37793 i0 41.8 2.96407185628743 55 32 98.8 0 3 167 2905 2959 GAX26841.1 ubiquitin carboxyl-terminal hydrolase 9/24 [Fistulifera solaris] diamond 495 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31831779 31831779 PRJNA657343_P_NODE_30537_length_178_cov_1.155039_g30513_i0 PRJNA657343 30537 178 1.155039 2.05596942 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0214   NR KAI2497584.1 210448 g30513 i0 41.7 2.51123595505618 48 28 80.9 0 35 178 250 297 KAI2497584.1 enoyl-(acyl carrier protein) reductase [Fragilaria crotonensis] diamond 447 42.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31882923 31882923 PRJNA657343_P_NODE_2297_length_460_cov_3.043796_g2274_i0 PRJNA657343 2297 460 3.043796 14.0014616 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 93.2 1.36e-21   NR KAK1736198.1 267567 g2274 i0 62.9 0.456521739130435 70 24 45.7 2 25 234 21 88 KAK1736198.1 hypothetical protein QTG54_013334 [Skeletonema marinoi] diamond 210 93.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32464942 32464942 PRJNA657343_P_NODE_38099_length_167_cov_0.881356_g38075_i0 PRJNA657343 38099 167 0.881356 1.47186452 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.21e-4   NR XP_002180680.1 556484 g38075 i0 54.5 2.44311377245509 44 20 79 0 134 3 236 279 XP_002180680.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 408 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32641756 32641756 PRJNA657343_P_NODE_36340_length_168_cov_0.873950_g36316_i0 PRJNA657343 36340 168 0.87395 1.468236 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.52e-6   NR VEU39797.1 183589 g36316 i0 41.1 6.32142857142857 56 32 100 1 1 168 47 101 VEU39797.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1062 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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