RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJEB12982 · 16 ✖

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
20864 20864 PRJEB12982_P_NODE_1201_length_710_cov_2.093797_g1062_i0 PRJEB12982 1201 710 2.093797 14.8659587 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 344 1.0499999999999999e-89   NTclustered gi|657012367|gb|KF302531.1| 2850 g1062 i0 83.377 21.6169014084507 379 55 53 8 52 426 390 16 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 15348 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
3536301 3536301 PRJEB12982_P_NODE_2983_length_445_cov_1.722222_g2822_i0 PRJEB12982 2983 445 1.722222 7.6638879 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 228 6.669999999999997e-55   NTclustered gi|2074156200|gb|MW413905.1| 216802 g2822 i0 78.272 90.1528089887641 382 64 83 15 1 371 24229 24602 Guinardia delicatula mitochondrion, complete genome blastn 40118 228 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
6399118 6399118 PRJEB12982_P_NODE_1986_length_554_cov_1.431683_g1827_i0 PRJEB12982 1986 554 1.431683 7.93152382 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 246 1.41e-74   NR GFH44192.1 426638 g1827 i0 64.9 14.0036101083032 185 64 99.6 1 1 552 475 659 GFH44192.1 hypothetical protein CTEN210_00666 [Chaetoceros tenuissimus] diamond 7758 248 0.991935483870968 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
10223764 10223764 PRJEB12982_P_NODE_2629_length_476_cov_1.906323_g2468_i0 PRJEB12982 2629 476 1.906323 9.07409748 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 238 4.25e-76   NR CAJ1931814.1 2856 g2468 i0 75.5 13.0336134453782 147 36 92.6 0 442 2 7 153 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 6204 240 0.991666666666667 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
11189019 11189019 PRJEB12982_P_NODE_18469_length_165_cov_0.879310_g18306_i0 PRJEB12982 18469 165 0.87931 1.4508615 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 74.3 9.58e-14   NR KAL3762657.1 259834 g18306 i0 80.5 0.745454545454545 41 8 74.5 0 40 162 1 41 KAL3762657.1 hypothetical protein ACHAWU_001602 [Discostella pseudostelligera] diamond 123 74.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
19146552 19146552 PRJEB12982_P_NODE_6096_length_299_cov_1.224000_g5933_i0 PRJEB12982 6096 299 1.224 3.65976 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 120 2.9199999999999996e-32   NR KAL3928702.1 3061772 g5933 i0 74.3 2.22742474916388 74 19 74.2 0 299 78 91 164 KAL3928702.1 MAG: hypothetical protein SGBAC_012534 [Bacillariaceae sp.] diamond 666 120 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27532245 27532245 PRJEB12982_P_NODE_14763_length_181_cov_1.128788_g14600_i0 PRJEB12982 14763 181 1.128788 2.04310628 root 1 Root_unresolved Root_unresolved 114 8.98e-29   NR VEU40821.1 183589 g14600 i0 76.7 16.9060773480663 60 14 99.4 0 181 2 55 114 VEU40821.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 3060 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27791309 27791309 PRJEB12982_P_NODE_18644_length_165_cov_0.879310_g18481_i0 PRJEB12982 18644 165 0.87931 1.4508615 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0458   NR XP_002177677.1 556484 g18481 i0 64 0.454545454545455 25 9 45.5 0 3 77 730 754 XP_002177677.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 75 41.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27847859 27847859 PRJEB12982_P_NODE_5664_length_312_cov_1.946768_g5501_i0 PRJEB12982 5664 312 1.946768 6.07391616 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 2.47e-25   NR XP_002179384.1 556484 g5501 i0 47.9 4.39423076923077 94 48 89.4 1 3 281 147 240 XP_002179384.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1371 108 0.990740740740741 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28763552 28763552 PRJEB12982_P_NODE_5267_length_325_cov_1.391304_g5104_i0 PRJEB12982 5267 325 1.391304 4.521738 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 117 3.16e-28   NR KAG7371210.1 303405 g5104 i0 46.6 2.43692307692308 133 46 99.7 1 324 1 249 381 KAG7371210.1 DEAD/DEAH box helicase domain protein [Nitzschia inconspicua] diamond 792 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29085881 29085881 PRJEB12982_P_NODE_6188_length_296_cov_1.392713_g6025_i0 PRJEB12982 6188 296 1.392713 4.12243048 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.62e-13   NR AID23596.1 2850 g6025 i0 48.7 0.77027027027027 76 39 77 0 19 246 42 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 228 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29338385 29338385 PRJEB12982_P_NODE_20449_length_162_cov_0.902655_g20286_i0 PRJEB12982 20449 162 0.902655 1.4623011 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 57.4 8.62e-8   NR XP_002178938.1 556484 g20286 i0 59.6 1.68518518518519 47 18 87 1 1 141 267 312 XP_002178938.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 273 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29527833 29527833 PRJEB12982_P_NODE_19070_length_164_cov_0.886957_g18907_i0 PRJEB12982 19070 164 0.886957 1.45460948 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.15e-4   NR CAJ1950057.1 2856 g18907 i0 49.1 1.00609756097561 55 24 98.8 2 162 1 143 194 CAJ1950057.1 unnamed protein product [Cylindrotheca closterium] diamond 165 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31012495 31012495 PRJEB12982_P_NODE_20435_length_162_cov_0.902655_g20272_i0 PRJEB12982 20435 162 0.902655 1.4623011 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 85.9 4.88e-18   NR KAG7361563.1 303405 g20272 i0 67.3 0.907407407407407 49 16 90.7 0 149 3 51 99 KAG7361563.1 peptidase C1A, papain family protein [Nitzschia inconspicua] diamond 147 85.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31044438 31044438 PRJEB12982_P_NODE_13895_length_187_cov_1.478261_g13732_i0 PRJEB12982 13895 187 1.478261 2.76434807 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 55.1 7.95e-7   NR KAL3944241.1 3061772 g13732 i0 48.2 0.898395721925134 56 28 88.2 1 183 19 70 125 KAL3944241.1 MAG: hypothetical protein SGBAC_001684 [Bacillariaceae sp.] diamond 168 55.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32151125 32151125 PRJEB12982_P_NODE_19298_length_164_cov_0.886957_g19135_i0 PRJEB12982 19298 164 0.886957 1.45460948 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 47.4 2.97e-4   NR CAB9497155.1 568900 g19135 i0 41.5 0.969512195121951 53 31 97 0 164 6 161 213 CAB9497155.1 Protein DETOXIFICATION [Seminavis robusta] diamond 159 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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