RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA564013" 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

  • PRJNA564013 · 6 ✖

analysis 1

  • blastn · 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
550143 550143 PRJNA564013_P_NODE_274261_length_243_cov_1.423077_g271409_i0 PRJNA564013 274261 243 1.423077 3.45807711 Tepidiforma bonchosmolovskayae 2601677 Bacteria Bacteria 377 3.18e-100   NTclustered gi|1756502384|gb|CP042829.1| 2601677 g271409 i0 97.297 1.60082304526749 222 6 91 0 22 243 1105520 1105299 Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome blastn 389 377 1 Bacteria   Bacillati Chloroflexota Tepidiformia Tepidiformales Tepidiformaceae Tepidiforma Tepidiforma bonchosmolovskayae
552165 552165 PRJNA564013_P_NODE_42021_length_600_cov_29.243043_g39298_i0 PRJNA564013 42021 600 29.243043 175.458258 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 475 2.97e-129   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g39298 i0 82.143 11.69 560 94 93 5 23 579 1844735 1844179 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 7014 475 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
5651547 5651547 PRJNA564013_P_NODE_155165_length_347_cov_2.398601_g152316_i0 PRJNA564013 155165 347 2.398601 8.32314547 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 217 1.1e-51   NTclustered gi|2874253812|emb|OY969796.1| 1672391 g152316 i0 82.745 1.12968299711816 255 32 72 10 77 326 2050368 2050121 MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 blastn 392 217 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
5654318 5654318 PRJNA564013_P_NODE_291505_length_231_cov_1.558824_g288653_i0 PRJNA564013 291505 231 1.558824 3.60088344 Ktedonobacterales bacterium 2306968 Bacteria Bacteria 63.9 9.54e-6   NTclustered gi|2513924934|gb|CP126532.1| 2306968 g288653 i0 97.368 5.16450216450216 38 0 16 1 131 168 940107 940143 MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome blastn 1193 63.9 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales     Ktedonobacterales bacterium
12029309 12029309 PRJNA564013_P_NODE_276810_length_241_cov_2.061111_g273958_i0 PRJNA564013 276810 241 2.061111 4.96727751 Roseiflexus castenholzii 120962 Bacteria Bacteria 106 1.64e-18   NTclustered gi|156231356|gb|CP000804.1| 383372 g273958 i0 94.286 16.0912863070539 70 3 45 1 31 99 3078307 3078376 Roseiflexus castenholzii DSM 13941, complete genome blastn 3878 106 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus castenholzii
20955093 20955093 PRJNA564013_P_NODE_8417_length_1178_cov_6.941808_g6893_i0 PRJNA564013 8417 1178 6.941808 81.77449824 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 545 4.52e-150   NTclustered gi|2874253981|emb|OY970306.1| 1672391 g6893 i0 82.099 15.5203735144312 648 107 92 5 517 1158 1410578 1409934 MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 blastn 18283 545 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia 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);;