RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB48872 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28763685 28763685 PRJEB48872_P_NODE_629347_length_162_cov_1.894309_g613535_i0 PRJEB48872 629347 162 1.894309 3.06878058 PVC group 1783257 Bacteria Bacteria 106 5.42e-25   NR WP_278812108.1 61435 g613535 i0 86.8 16.6666666666667 53 7 98.1 0 159 1 402 454 WP_278812108.1 hypothetical protein [Dehalococcoides mccartyi] diamond 2700 106 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales Dehalococcoidaceae Dehalococcoides Dehalococcoides mccartyi
29812250 29812250 PRJEB48872_P_NODE_375951_length_242_cov_1.211823_g360139_i0 PRJEB48872 375951 242 1.211823 2.93261166 Chloroflexota bacterium 2026724 Bacteria Bacteria 86.3 9.99e-18   NR MBA3779679.1 2026724 g360139 i0 52.5 2.96280991735537 80 38 99.2 0 3 242 239 318 MBA3779679.1 ATP-binding cassette domain-containing protein [Chloroflexota bacterium] diamond 717 86.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31265820 31265820 PRJEB48872_P_NODE_531255_length_185_cov_1.376712_g515443_i0 PRJEB48872 531255 185 1.376712 2.5469172 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 49.3 5.4e-5   NR HXS93067.1 2952938 g515443 i0 80 1.42702702702703 30 6 48.6 0 182 93 172 201 HXS93067.1 dephospho-CoA kinase [Candidatus Limnocylindrales bacterium] diamond 264 49.3 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
31613703 31613703 PRJEB48872_P_NODE_380796_length_239_cov_2.345000_g364984_i0 PRJEB48872 380796 239 2.345 5.60455 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 97.1 1.95e-21   NR HEU4326632.1 2762507 g364984 i0 60.3 1.92050209205021 78 31 97.9 0 238 5 30 107 HEU4326632.1 diaminopimelate decarboxylase [Roseiflexaceae bacterium] diamond 459 97.1 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
31740071 31740071 PRJEB48872_P_NODE_344337_length_259_cov_1.150000_g328525_i0 PRJEB48872 344337 259 1.15 2.9785 Candidatus Amarobacter glycogenicus 3140699 Bacteria Bacteria 43.5 0.0251   NR WP_343384692.1 3140699 g328525 i0 40 1.04247104247104 45 23 52.1 1 91 225 718 758 WP_343384692.1 flippase activity-associated protein Agl23 [Candidatus Amarobacter glycogenicus] diamond 270 43.5 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Candidatus Amarobacter Candidatus Amarobacter glycogenicus
31859913 31859913 PRJEB48872_P_NODE_499177_length_194_cov_1.374194_g483365_i0 PRJEB48872 499177 194 1.374194 2.66593636 Bacteria 2 Bacteria Bacteria 45.8 0.0014   NR NLF01012.1 2073117 g483365 i0 63.3 1.36082474226804 30 11 46.4 0 103 192 1 30 NLF01012.1 ABC transporter ATP-binding protein [Anaerolineales bacterium] diamond 264 46.2 0.991341991341991 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);;