RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1046144 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28488104 28488104 PRJNA1046144_P_NODE_51607_length_244_cov_1.645714_g51312_i0 PRJNA1046144 51607 244 1.645714 4.01554216 Ktedonobacter sp. 1932716 Bacteria Bacteria 47 0.00121   NR HCI82275.1 1932716 g51312 i0 37.7 0.75 61 30 75 1 5 187 63 115 HCI82275.1 hypothetical protein [Ktedonobacter sp.] diamond 183 47 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae Ktedonobacter Ktedonobacter sp.
29056495 29056495 PRJNA1046144_P_NODE_70968_length_219_cov_2.233333_g70673_i0 PRJNA1046144 70968 219 2.233333 4.89099927 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 130 2.3e-33   NR HEY6287430.1 2740538 g70673 i0 87.5 1.97260273972603 72 9 98.6 0 217 2 347 418 HEY6287430.1 phospholipase D family protein [Ktedonobacteraceae bacterium] diamond 432 130 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
30856686 30856686 PRJNA1046144_P_NODE_38614_length_275_cov_2.470874_g38319_i0 PRJNA1046144 38614 275 2.470874 6.7949035 Anaerolineales bacterium 2073117 Bacteria Bacteria 75.5 4.12e-15   NR MBL8094112.1 2073117 g38319 i0 83.3 0.458181818181818 42 7 45.8 0 273 148 69 110 MBL8094112.1 winged helix-turn-helix transcriptional regulator [Anaerolineales bacterium] diamond 126 75.5 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31172385 31172385 PRJNA1046144_P_NODE_48675_length_250_cov_2.977901_g48380_i0 PRJNA1046144 48675 250 2.977901 7.4447525 Anaerolineales bacterium 2073117 Bacteria Bacteria 87.8 4.05e-18   NR MBV6392155.1 2073117 g48380 i0 52.9 3.048 85 37 98.4 1 5 250 277 361 MBV6392155.1 hypothetical protein [Anaerolineales bacterium] diamond 762 87.8 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales 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);;