RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA849172" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA849172 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
7214446 7214446 PRJNA849172_P_NODE_42606_length_317_cov_15.102459_g42246_i0 PRJNA849172 42606 317 15.102459 47.87479503 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 134 1.18e-37   NR KAI2488933.1 210448 g42246 i0 69.4 6.1608832807571 85 26 80.4 0 257 3 16 100 KAI2488933.1 putative GTP-ase activating proteins for the small GTPase [Fragilaria crotonensis] diamond 1953 134 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29423028 29423028 PRJNA849172_P_NODE_18649_length_479_cov_16.071429_g18290_i0 PRJNA849172 18649 479 16.071429 76.98214491 Stephanopyxis turris 515487 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.07e-11   NR QYC61879.1 515487 g18290 i0 43.8 0.81419624217119 130 67 79.5 3 6 386 284 410 QYC61879.1 NADH dehydrogenase subunit 2 [Stephanopyxis turris] diamond 390 73.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Stephanopyxidaceae Stephanopyxis Stephanopyxis turris
32267975 32267975 PRJNA849172_P_NODE_16498_length_512_cov_13.646925_g16139_i0 PRJNA849172 16498 512 13.646925 69.872256 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 187 3.84e-58   NR AID23596.1 2850 g16139 i0 76.9 0.685546875 117 27 68.6 0 4 354 1 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 351 187 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32718434 32718434 PRJNA849172_P_NODE_42600_length_317_cov_23.405738_g42240_i0 PRJNA849172 42600 317 23.405738 74.19618946 Cymbellales 97224 SAR_Eukaryotes SAR_Eukaryotes 108 4.97e-25   NR AVR57504.1 186043 g42240 i0 52.9 6.78548895899054 102 45 93.7 1 300 4 54 155 AVR57504.1 NADH dehydrogenase subunit 5 [Entomoneis sp.] diamond 2151 109 0.990825688073395 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.

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