RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA407087 · 18 ✖

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
1081713 1081713 PRJNA407087_S_NODE_4221_length_267_cov_4.180672_g3758_i0 PRJNA407087 4221 267 4.180672 11.16239424 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 131 1.73e-33   NR CAJ1903596.1 2856 g3758 i0 72.4 325.573033707865 87 24 97.8 0 262 2 235 321 CAJ1903596.1 unnamed protein product [Cylindrotheca closterium] diamond 86928 132 0.992424242424242 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
5518691 5518691 PRJNA407087_S_NODE_10085_length_150_cov_1.867769_g9622_i0 PRJNA407087 10085 150 1.867769 2.8016535 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 96.7 2.7900000000000003e-22   NR CAJ1946716.1 2856 g9622 i0 87.5 30.74 48 6 96 0 5 148 190 237 CAJ1946716.1 unnamed protein product [Cylindrotheca closterium] diamond 4611 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
13168751 13168751 PRJNA407087_S_NODE_8891_length_160_cov_3.519084_g8428_i0 PRJNA407087 8891 160 3.519084 5.6305344 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.35e-12   NR KAL3915903.1 3061772 g8428 i0 59.6 4.875 52 21 97.5 0 3 158 285 336 KAL3915903.1 MAG: hypothetical protein SGILL_005430 [Bacillariaceae sp.] diamond 780 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
16992490 16992490 PRJNA407087_S_NODE_5234_length_226_cov_2.116751_g4771_i0 PRJNA407087 5234 226 2.116751 4.7838572599999996 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.36e-20   NR KAK1732416.1 267567 g4771 i0 68.8 0.849557522123894 64 20 85 0 225 34 441 504 KAK1732416.1 DnaJ domain-containing protein [Skeletonema marinoi] diamond 192 94.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
19540748 19540748 PRJNA407087_S_NODE_5816_length_210_cov_2.618785_g5353_i0 PRJNA407087 5816 210 2.618785 5.4994485 root 1 Root_unresolved Root_unresolved 98.2 2.16e-22   NR GAX11011.1 1519565 g5353 i0 69.2 6.51428571428571 65 20 92.9 0 9 203 286 350 GAX11011.1 GDPmannose 4,6-dehydratase [Fistulifera solaris] diamond 1368 99 0.991919191919192 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
22091400 22091400 PRJNA407087_S_NODE_1158_length_657_cov_4.391720_g786_i0 PRJNA407087 1158 657 4.39172 28.8536004 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 288 8.959999999999999e-96   NR CAJ1953473.1 2856 g786 i0 87.2 4.19178082191781 149 19 68 0 26 472 68 216 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 2754 290 0.993103448275862 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23367015 23367015 PRJNA407087_S_NODE_1319_length_609_cov_11.870690_g926_i0 PRJNA407087 1319 609 11.87069 72.2925021 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 368 5.27e-97   NTclustered gi|657012367|gb|KF302531.1| 2850 g926 i0 86.93 19.8456486042693 329 41 54 2 1 328 58 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 12086 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24641387 24641387 PRJNA407087_S_NODE_5160_length_229_cov_2.705000_g4697_i0 PRJNA407087 5160 229 2.705 6.19445 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 92.4 5.85e-20   NR KAG7366511.1 303405 g4697 i0 57.3 7.79475982532751 75 32 98.3 0 227 3 46 120 KAG7366511.1 chaperone protein DnaJ [Nitzschia inconspicua] diamond 1785 92.8 0.995689655172414 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28117606 28117606 PRJNA407087_S_NODE_9105_length_158_cov_2.728682_g8642_i0 PRJNA407087 9105 158 2.728682 4.31131756 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0305   NR KAL3912172.1 3061772 g8642 i0 38.8 0.930379746835443 49 29 91.1 1 5 148 495 543 KAL3912172.1 MAG: hypothetical protein SGILL_006988 [Bacillariaceae sp.] diamond 147 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29302645 29302645 PRJNA407087_S_NODE_8609_length_163_cov_3.208955_g8146_i0 PRJNA407087 8609 163 3.208955 5.23059665 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.1 4.5e-14   NR CAJ1951130.1 2856 g8146 i0 61.1 12.5521472392638 54 21 99.4 0 162 1 100 153 CAJ1951130.1 unnamed protein product [Cylindrotheca closterium] diamond 2046 75.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29712732 29712732 PRJNA407087_S_NODE_6530_length_195_cov_2.439759_g6067_i0 PRJNA407087 6530 195 2.439759 4.75753005 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 73.9 2.05e-13   NR KAL3815567.1 382380 g6067 i0 44.6 5.06153846153846 65 36 100 0 1 195 3788 3852 KAL3815567.1 hypothetical protein ACHAXA_000299 [Cyclostephanos tholiformis] diamond 987 73.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30012410 30012410 PRJNA407087_S_NODE_2591_length_392_cov_12.008264_g2130_i0 PRJNA407087 2591 392 12.008264 47.07239488 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 122 3.54e-33   NR AID23594.1 2850 g2130 i0 75 0.642857142857143 84 19 62.8 1 3 248 9 92 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 252 122 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30376904 30376904 PRJNA407087_S_NODE_7092_length_184_cov_2.574194_g6629_i0 PRJNA407087 7092 184 2.574194 4.73651696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82 5.74e-17   NR CAJ1963759.1 2856 g6629 i0 63.9 20.8858695652174 61 22 99.5 0 184 2 51 111 CAJ1963759.1 unnamed protein product [Cylindrotheca closterium] diamond 3843 82.8 0.990338164251208 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30833731 30833731 PRJNA407087_S_NODE_5834_length_209_cov_11.522222_g5371_i0 PRJNA407087 5834 209 11.522222 24.08144398 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 104 3.25e-27   NR AID23594.1 2850 g5371 i0 80.3 2.00956937799043 71 12 99 1 3 209 9 79 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 420 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31529332 31529332 PRJNA407087_S_NODE_5696_length_213_cov_2.934783_g5233_i0 PRJNA407087 5696 213 2.934783 6.25108779 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 87.8 3.24e-18   NR XP_002184983.1 556484 g5233 i0 57.4 1.91549295774648 68 29 95.8 0 2 205 404 471 XP_002184983.1 transport protein Sec61 alpha subunit [Phaeodactylum tricornutum CCAP 1055/1] diamond 408 87.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31750446 31750446 PRJNA407087_S_NODE_5137_length_230_cov_2.626866_g4674_i0 PRJNA407087 5137 230 2.626866 6.0417918 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 117 1.4e-28   NR KAG7361359.1 303405 g4674 i0 70.7 139.891304347826 75 22 97.8 0 6 230 252 326 KAG7361359.1 translation elongation factor EF-1 subunit alpha [Nitzschia inconspicua] diamond 32175 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32589999 32589999 PRJNA407087_S_NODE_7539_length_177_cov_3.621622_g7076_i0 PRJNA407087 7539 177 3.621622 6.41027094 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.9e-5   NR XP_002183794.1 556484 g7076 i0 54.3 4.10169491525424 46 20 78 1 173 36 70 114 XP_002183794.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 726 50.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32635924 32635924 PRJNA407087_S_NODE_6060_length_204_cov_3.502857_g5597_i0 PRJNA407087 6060 204 3.502857 7.14582828 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.33e-9   NR KAL3790387.1 382360 g5597 i0 52 1.47058823529412 50 24 73.5 0 19 168 1 50 KAL3790387.1 hypothetical protein ACHAWO_011602 [Cyclotella atomus] diamond 300 58.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus

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