RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA929952" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA929952 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
22586143 22586143 PRJNA929952_P_NODE_21198_length_192_cov_1.754601_g19904_i0 PRJNA929952 21198 192 1.754601 3.36883392 Runella sp. 1960881 Bacteria Bacteria 110 6.22e-29   NR WP_298352332.1 1960881 g19904 i0 82.8 1 64 11 100 0 1 192 54 117 WP_298352332.1 hypothetical protein [Runella sp.] diamond 192 110 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Runella Runella sp.
27941042 27941042 PRJNA929952_P_NODE_17245_length_242_cov_1.849765_g15951_i0 PRJNA929952 17245 242 1.849765 4.4764313 Lewinellaceae bacterium 2760807 Bacteria Bacteria 63.5 2.65e-11   NR MBK6997158.1 2760807 g15951 i0 100 0.371900826446281 30 0 37.2 0 91 2 28 57 MBK6997158.1 cold shock domain-containing protein [Lewinellaceae bacterium] diamond 90 63.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Lewinellaceae   Lewinellaceae bacterium
29898692 29898692 PRJNA929952_P_NODE_20471_length_203_cov_1.362069_g19177_i0 PRJNA929952 20471 203 1.362069 2.76500007 Bacteroidota bacterium 1898104 Bacteria Bacteria 132 1.46e-36   NR MCA0229517.1 1898104 g19177 i0 91 1.98029556650246 67 6 99 0 203 3 163 229 MCA0229517.1 hypothetical protein [Bacteroidota bacterium] diamond 402 132 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31099052 31099052 PRJNA929952_P_NODE_23175_length_167_cov_1.536232_g21881_i0 PRJNA929952 23175 167 1.536232 2.56550744 Dyadobacter sp. SG 1914288 Bacteria Bacteria 75.5 1.42e-15   NR SEJ28386.1 1855291 g21881 i0 84.1 1.47305389221557 44 7 79 0 35 166 36 79 SEJ28386.1 SSU ribosomal protein S10P [Dyadobacter sp. SG02] diamond 246 75.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Dyadobacter Dyadobacter sp. SG02

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