RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA527965", tax_kingdom = "Bacillati" 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

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA527965 · 4 ✖

analysis 1

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
11975665 11975665 PRJNA527965_S_NODE_4510_length_177_cov_2.098592_g4427_i0 PRJNA527965 4510 177 2.098592 3.71450784 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 80.5 6.86e-11   NTclustered gi|2893358391|emb|OZ220682.1| 2026734 g4427 i0 91.525 0.333333333333333 59 4 33 1 35 92 1257390 1257332 MAG: Dehalococcoidia bacterium isolate 0d331d3b-d7ed-4eba-809e-4bb0832fe511 genome assembly, chromosome: 1 blastn 59 80.5 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
11975710 11975710 PRJNA527965_S_NODE_950_length_375_cov_3.820588_g867_i0 PRJNA527965 950 375 3.820588 14.327205 Leptolinea sp. HRD-7 2830982 Bacteria Bacteria 359 1.88e-94   NTclustered gi|2250018340|dbj|AP024710.1| 2830982 g867 i0 96.33 86.8933333333333 218 8 58 0 1 218 1246108 1245891 Leptolinea sp. HRD-7 DNA, complete genome blastn 32585 359 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Leptolinea Leptolinea sp. HRD-7
15799533 15799533 PRJNA527965_S_NODE_4253_length_183_cov_3.864865_g4170_i0 PRJNA527965 4253 183 3.864865 7.07270295 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 294 2.35e-75   NTclustered gi|2874253704|emb|OY969431.1| 1672391 g4170 i0 95.628 279.16393442623 183 8 100 0 1 183 65060 64878 MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1 blastn 51087 294 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
17074197 17074197 PRJNA527965_S_NODE_4714_length_173_cov_0.992754_g4631_i0 PRJNA527965 4714 173 0.992754 1.71746442 Anaerolineales bacterium 2073117 Bacteria Bacteria 193 8.21e-45   NTclustered gi|2108400823|gb|CP070639.1| 2073117 g4631 i0 86.857 7.26011560693642 175 19 99 3 1 172 3337058 3336885 MAG: Anaerolineales bacterium isolate bin917 chromosome blastn 1256 193 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);;