RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Deferribacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deferribacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 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
27001998 27001998 PRJEB64798_P_NODE_72942_length_226_cov_3.531073_g71177_i0 PRJEB64798 72942 226 3.531073 7.98022498 Flexistipes sinusarabici 2352 Bacteria Bacteria 65.5 2.4e-10   NR WP_013886089.1 2352 g71177 i0 58.9 2.11061946902655 56 19 69 1 7 162 225 280 WP_013886089.1 Fe(3+) ABC transporter substrate-binding protein [Flexistipes sinusarabici] diamond 477 65.5 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Flexistipitaceae Flexistipes Flexistipes sinusarabici
30981820 30981820 PRJEB64798_P_NODE_209674_length_165_cov_0.896552_g207908_i0 PRJEB64798 209674 165 0.896552 1.4793108 Mucispirillum schaedleri ASF457 1379858 Bacteria Bacteria 45.1 1.99e-4   NR SIW06123.1 1379858 g207908 i0 60 0.727272727272727 40 15 70.9 1 127 11 25 64 SIW06123.1 hypothetical protein MCSV2_20152 [Mucispirillum schaedleri ASF457] diamond 120 45.1 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum schaedleri
31006311 31006311 PRJEB64798_P_NODE_97414_length_212_cov_3.662577_g95648_i0 PRJEB64798 97414 212 3.662577 7.76466324 Pseudomonadati 3379134 Bacteria Bacteria 64.7 9.87e-11   NR MCI6476336.1 1965235 g95648 i0 84.8 64.372641509434 33 5 46.7 0 99 1 8 40 MCI6476336.1 lyase family protein [Mucispirillum sp.] diamond 13647 64.7 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum 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);;