RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJEB3181", 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

  • PRJEB3181 · 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
56050 56050 PRJEB3181_P_NODE_7801_length_302_cov_3.450185_g7539_i0 PRJEB3181 7801 302 3.450185 10.4195587 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 115 3.5400000000000006e-21   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g7539 i0 77.103 29.1192052980132 214 40 69 7 95 302 5601 5391 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 8794 115 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
988867 988867 PRJEB3181_S_NODE_1881_length_377_cov_19183.558480_g1589_i0 PRJEB3181 1881 377 19183.55848 72322.0154696 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 90.1 3.03e-20   NR KAG7373989.1 303405 g1589 i0 53.6 7.31299734748011 84 38 66.8 1 18 269 48 130 KAG7373989.1 50S ribosomal protein L14e [Nitzschia inconspicua] diamond 2757 90.9 0.991199119911991 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
1330216 1330216 PRJEB3181_P_NODE_1142_length_569_cov_155.524164_g1001_i0 PRJEB3181 1142 569 155.524164 884.93249316 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 99 7.11e-16   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g1001 i0 79.87 1.30755711775044 154 16 27 8 60 211 46505 46645 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 744 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
12809481 12809481 PRJEB3181_P_NODE_21491_length_176_cov_2.289655_g21226_i0 PRJEB3181 21491 176 2.289655 4.0297928 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 139 1.11e-28   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g21226 i0 81.183 37.4659090909091 186 24 100 10 1 176 32424 32240 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 6594 139 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
15016708 15016708 PRJEB3181_S_NODE_2412_length_348_cov_20623.562300_g2119_i0 PRJEB3181 2412 348 20623.5623 71769.996804 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.83e-22   NR AID23573.1 2850 g2119 i0 82.4 0.879310344827586 51 9 44 0 2 154 61 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 306 94.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
15358030 15358030 PRJEB3181_P_NODE_113_length_1178_cov_65.511770_g83_i0 PRJEB3181 113 1178 65.51177 771.7286506 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 222 8.65e-53   NTclustered gi|2074156200|gb|MW413905.1| 216802 g83 i0 78.01 37.0288624787776 382 64 31 15 36 405 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43620 222 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
20456828 20456828 PRJEB3181_S_NODE_1117_length_450_cov_143.332530_g839_i0 PRJEB3181 1117 450 143.33253 644.996385 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 112 3.21e-29   NR AID23594.1 2850 g839 i0 78.8 0.44 66 14 44 0 450 253 32 97 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 198 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21732636 21732636 PRJEB3181_P_NODE_118_length_1165_cov_54.198413_g83_i1 PRJEB3181 118 1165 54.198413 631.41151145 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 222 8.55e-53   NTclustered gi|2074156200|gb|MW413905.1| 216802 g83 i1 78.01 37.4420600858369 382 64 32 15 36 405 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 43620 222 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
21732670 21732670 PRJEB3181_P_NODE_198_length_1004_cov_18.943474_g149_i0 PRJEB3181 198 1004 18.943474 190.19247896 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 158 2.1e-33   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g149 i0 75.401 24.7529880478088 374 67 36 19 24 387 27552 27910 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 24852 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
23008215 23008215 PRJEB3181_S_NODE_8839_length_212_cov_65.192090_g8546_i0 PRJEB3181 8839 212 65.19209 138.2072308 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 86.3 5.07e-18   NR CAJ1950770.1 2856 g8546 i0 69.8 3.79245283018868 53 16 75 0 2 160 279 331 CAJ1950770.1 unnamed protein product [Cylindrotheca closterium] diamond 804 86.7 0.995386389850058 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26678302 26678302 PRJEB3181_P_NODE_6561_length_324_cov_6.597270_g6302_i0 PRJEB3181 6561 324 6.59727 21.3751548 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 110 1.2e-28   NR AID23573.1 2850 g6302 i0 78.1 1.77777777777778 64 14 59.3 0 324 133 48 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 576 110 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26906758 26906758 PRJEB3181_P_NODE_20782_length_179_cov_7.297297_g20518_i0 PRJEB3181 20782 179 7.297297 13.06216163 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0439   NR XP_002295703.1 296543 g20518 i0 56.3 0.536312849162011 32 14 53.6 0 177 82 104 135 XP_002295703.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 96 40.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27690551 27690551 PRJEB3181_P_NODE_5104_length_358_cov_7.006116_g4855_i0 PRJEB3181 5104 358 7.006116 25.08189528 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 88.2 2.87e-19   NR KAL3823683.1 382380 g4855 i0 72.7 1.84357541899441 55 15 46.1 0 356 192 110 164 KAL3823683.1 hypothetical protein ACHAXA_007254 [Cyclostephanos tholiformis] diamond 660 88.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28423125 28423125 PRJEB3181_S_NODE_1326_length_423_cov_361.510309_g839_i1 PRJEB3181 1326 423 361.510309 1529.18860707 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 112 2.34e-29   NR AID23594.1 2850 g839 i1 78.8 0.468085106382979 66 14 46.8 0 1 198 32 97 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 198 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28959917 28959917 PRJEB3181_P_NODE_15828_length_211_cov_1.327778_g15564_i0 PRJEB3181 15828 211 1.327778 2.80161158 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 42 0.0251   NR VEU34762.1 183589 g15564 i0 43.9 0.582938388625592 41 23 58.3 0 210 88 105 145 VEU34762.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 123 42 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29016624 29016624 PRJEB3181_P_NODE_15188_length_216_cov_2.037838_g14924_i0 PRJEB3181 15188 216 2.037838 4.40173008 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 58.9 5.09e-8   NR KAG7352108.1 303405 g14924 i0 47.2 1.47222222222222 53 28 73.6 0 215 57 857 909 KAG7352108.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Nitzschia inconspicua] diamond 318 58.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29363729 29363729 PRJEB3181_P_NODE_3069_length_426_cov_6.356962_g2843_i0 PRJEB3181 3069 426 6.356962 27.08065812 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 184 3.99e-56   NR CAJ1966769.1 2856 g2843 i0 68.5 69.7323943661972 127 40 89.4 0 2 382 84 210 CAJ1966769.1 unnamed protein product [Cylindrotheca closterium] diamond 29706 185 0.994594594594595 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29963648 29963648 PRJEB3181_P_NODE_8911_length_284_cov_5.936759_g8647_i0 PRJEB3181 8911 284 5.936759 16.86039556 root 1 Root_unresolved Root_unresolved 55.5 3.49e-7   NR CAB9499426.1 568900 g8647 i0 92.3 3.02112676056338 26 2 27.5 0 2 79 112 137 CAB9499426.1 40S ribosomal protein S15a [Seminavis robusta] diamond 858 55.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30191158 30191158 PRJEB3181_P_NODE_17432_length_199_cov_2.017857_g17168_i0 PRJEB3181 17432 199 2.017857 4.01553543 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42 0.0388   NR KAL3930063.1 3061772 g17168 i0 51.1 0.678391959798995 45 10 49.7 2 199 101 290 334 KAL3930063.1 MAG: hypothetical protein SGBAC_011929 [Bacillariaceae sp.] diamond 135 42 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30381255 30381255 PRJEB3181_P_NODE_17233_length_200_cov_4.372781_g16969_i0 PRJEB3181 17233 200 4.372781 8.745562 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.38e-12   NR KAL3766514.1 259834 g16969 i0 61.4 1.71 57 22 85.5 0 199 29 982 1038 KAL3766514.1 hypothetical protein ACHAWU_000309 [Discostella pseudostelligera] diamond 342 71.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31512298 31512298 PRJEB3181_S_NODE_16316_length_161_cov_1.174603_g16023_i0 PRJEB3181 16316 161 1.174603 1.89111083 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.17e-7   NR EJK65315.1 159749 g16023 i0 54 3.70807453416149 50 21 89.4 2 9 152 124 173 EJK65315.1 hypothetical protein THAOC_13837 [Thalassiosira oceanica] diamond 597 55.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32713534 32713534 PRJEB3181_P_NODE_22120_length_173_cov_3.661972_g21855_i0 PRJEB3181 22120 173 3.661972 6.33521156 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 71.2 2.42e-13   NR KAL3805673.1 29204 g21855 i0 59.6 8.70520231213873 57 23 98.8 0 2 172 53 109 KAL3805673.1 hypothetical protein HJC23_005917 [Cyclotella cryptica] diamond 1506 71.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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