RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJEB50332 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
15421771 15421771 PRJEB50332_P_NODE_15573_length_206_cov_0.896552_g15491_i0 PRJEB50332 15573 206 0.896552 1.84689712 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.47e-16   NR GAX17832.1 1519565 g15491 i0 61 6.14563106796117 59 23 85.9 0 11 187 28 86 GAX17832.1 translation initiation factor 1 [Fistulifera solaris] diamond 1266 77 0.990909090909091 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
26590053 26590053 PRJEB50332_P_NODE_2601_length_353_cov_2.037671_g2519_i0 PRJEB50332 2601 353 2.037671 7.19297863 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 77.4 9.11e-15   NR OEU22359.1 635003 g2519 i0 38.6 3.82436260623229 114 65 95.2 3 338 3 1 111 OEU22359.1 snare-like protein [Fragilariopsis cylindrus CCMP1102] diamond 1350 77.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
26615109 26615109 PRJEB50332_P_NODE_7341_length_239_cov_2.264045_g7259_i0 PRJEB50332 7341 239 2.264045 5.41106755 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 113 1.11e-28   NR KAI2505670.1 210448 g7259 i0 80.6 5.0836820083682 67 13 84.1 0 39 239 6 72 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 1215 113 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28644338 28644338 PRJEB50332_P_NODE_11327_length_217_cov_1.660256_g11245_i0 PRJEB50332 11327 217 1.660256 3.60275552 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 72.8 5.06e-13   NR CAJ1934395.1 2856 g11245 i0 73.3 1.83870967741935 45 12 62.2 0 5 139 300 344 CAJ1934395.1 unnamed protein product [Cylindrotheca closterium] diamond 399 72.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29181137 29181137 PRJEB50332_P_NODE_5569_length_262_cov_1.263682_g5487_i0 PRJEB50332 5569 262 1.263682 3.31084684 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 91.7 2.72e-19   NR CAB9521928.1 568900 g5487 i0 52.9 0.973282442748092 85 36 96.2 3 3 254 198 279 CAB9521928.1 Aspartate aminotransferase, mitochondrial [Seminavis robusta] diamond 255 91.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30065014 30065014 PRJEB50332_P_NODE_12152_length_212_cov_2.377483_g12070_i0 PRJEB50332 12152 212 2.377483 5.04026396 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 48.1 3.13e-4   NR GFH59097.1 426638 g12070 i0 36.2 0.976415094339623 69 44 97.6 0 6 212 749 817 GFH59097.1 hypothetical protein CTEN210_15573 [Chaetoceros tenuissimus] diamond 207 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30444426 30444426 PRJEB50332_P_NODE_4233_length_290_cov_1.633188_g4151_i0 PRJEB50332 4233 290 1.633188 4.7362452 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.44e-13   NR AID23596.1 2850 g4151 i0 48.7 0.786206896551724 76 39 78.6 0 261 34 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
30690226 30690226 PRJEB50332_P_NODE_8793_length_231_cov_1.711765_g8711_i0 PRJEB50332 8793 231 1.711765 3.95417715 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 92.8 7.51e-20   NR OEU08331.1 635003 g8711 i0 52.7 4.7012987012987 74 35 96.1 0 229 8 520 593 OEU08331.1 leucyl-tRNA synthetase [Fragilariopsis cylindrus CCMP1102] diamond 1086 93.6 0.991452991452991 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus

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