RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA884104" and tax_phylum = "Fibrobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fibrobacterota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA884104 · 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
28231640 28231640 PRJNA884104_S_NODE_9666_length_649_cov_5.159722_g8959_i0 PRJNA884104 9666 649 5.159722 33.48659578 Pseudomonadati 3379134 Bacteria Bacteria 50.8 0.00161   NR MBI4720665.1 2660710 g8959 i0 33 1.29429892141757 91 41 42.1 3 3 275 79 149 MBI4720665.1 hypothetical protein [Chitinivibrionia bacterium] diamond 840 50.8 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia       Chitinivibrionia bacterium
29779010 29779010 PRJNA884104_S_NODE_67391_length_253_cov_1.283333_g66648_i0 PRJNA884104 67391 253 1.283333 3.24683249 Fibrobacter 832 Bacteria Bacteria 99 7.06e-22   NR MDR1759822.1 35828 g66648 i0 57.3 4.83794466403162 82 35 97.2 0 7 252 419 500 MDR1759822.1 elongation factor G [Fibrobacter sp.] diamond 1224 99 1 Bacteria FCB group Pseudomonadati Fibrobacterota Fibrobacteria Fibrobacterales Fibrobacteraceae Fibrobacter Fibrobacter sp.
30497828 30497828 PRJNA884104_S_NODE_4873_length_917_cov_3.501185_g4334_i0 PRJNA884104 4873 917 3.501185 32.10586645 Chitinivibrionales bacterium 2663014 Bacteria Bacteria 280 7.2599999999999995e-90   NR MBD3419113.1 2663014 g4334 i0 46.6 2.86259541984733 294 155 95.5 1 917 42 2 295 MBD3419113.1 phospholipase [Chitinivibrionales bacterium] diamond 2625 280 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinivibrionia Chitinivibrionales     Chitinivibrionales bacterium
31667225 31667225 PRJNA884104_S_NODE_81877_length_243_cov_1.729412_g81134_i0 PRJNA884104 81877 243 1.729412 4.20247116 Chitinispirillaceae bacterium 2813024 Bacteria Bacteria 57 3.64e-8   NR MFP4417456.1 2813024 g81134 i0 32.9 0.938271604938272 76 51 93.8 0 228 1 20 95 MFP4417456.1 phenylpyruvate tautomerase MIF-related protein [Chitinispirillaceae bacterium] diamond 228 57 1 Bacteria FCB group Pseudomonadati Fibrobacterota Chitinispirillia Chitinispirillales Chitinispirillaceae   Chitinispirillaceae bacterium

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