RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA222400", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 2 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 2 ✖

bioproject 1

  • PRJNA222400 · 2 ✖

analysis 1

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
27990059 27990059 PRJNA222400_P_NODE_1565_length_408_cov_2.774373_g1532_i0 PRJNA222400 1565 408 2.774373 11.31944184 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 98.6 1.2399999999999999e-23   NR MFP4417456.1 2813024 g1532 i0 38.6 3.35294117647059 114 70 83.8 0 397 56 1 114 MFP4417456.1 phenylpyruvate tautomerase MIF-related protein [Chitinispirillaceae bacterium] diamond 1368 98.6 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae bacterium
32336601 32336601 PRJNA222400_P_NODE_7719_length_167_cov_0.881356_g7686_i0 PRJNA222400 7719 167 0.881356 1.47186452 Pseudomonadati 3379134 Bacteria Bacteria 54.7 7.83e-7   NR KMQ50226.1 1008392 g7686 i0 55.1 3.55688622754491 49 20 86.2 2 166 23 301 348 KMQ50226.1 Methyltransferase type 11 [Chitinispirillum alkaliphilum] diamond 594 54.7 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae Chitinispirillum Chitinispirillum alkaliphilum

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