RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1073712", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA1073712 · 5 ✖

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
23139880 23139880 PRJNA1073712_P_NODE_12639_length_248_cov_1.554286_g12556_i0 PRJNA1073712 12639 248 1.554286 3.85462928 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 302 2.02e-77   NTclustered gi|2874254066|emb|OY970149.1| 1672391 g12556 i0 88.71 95.0362903225806 248 27 99 1 1 247 566889 566642 MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 blastn 23569 302 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
27003989 27003989 PRJNA1073712_P_NODE_13022_length_248_cov_0.880000_g12939_i0 PRJNA1073712 13022 248 0.88 2.1824 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 144 6.73e-41   NR MFL5800462.1 2762507 g12939 i0 80.5 1.98387096774194 82 16 99.2 0 1 246 74 155 MFL5800462.1 membrane dipeptidase [Roseiflexaceae bacterium] diamond 492 144 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
29783074 29783074 PRJNA1073712_P_NODE_14511_length_245_cov_0.895349_g14428_i0 PRJNA1073712 14511 245 0.895349 2.19360505 Ktedonobacterales bacterium 2306968 Bacteria Bacteria 144 5.6e-40   NR HEX8728395.1 2306968 g14428 i0 97.5 1.98367346938776 81 2 99.2 0 1 243 25 105 HEX8728395.1 YafY family protein [Ktedonobacterales bacterium] diamond 486 144 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales     Ktedonobacterales bacterium
29972601 29972601 PRJNA1073712_P_NODE_2731_length_406_cov_1.498498_g2648_i0 PRJNA1073712 2731 406 1.498498 6.08390188 Chloroflexota bacterium 2026724 Bacteria Bacteria 61.2 6.99e-8   NR HEY3108085.1 2026724 g2648 i0 33.9 0.805418719211823 109 57 79.8 4 51 374 2 96 HEY3108085.1 FAD-binding oxidoreductase [Chloroflexota bacterium] diamond 327 61.2 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31268119 31268119 PRJNA1073712_P_NODE_2335_length_429_cov_1.280899_g2252_i0 PRJNA1073712 2335 429 1.280899 5.49505671 Ardenticatenia bacterium 2099665 Bacteria Bacteria 93.2 5.24e-19   NR RME08985.1 2099665 g2252 i0 44.8 1 143 74 98.6 4 5 427 5 144 RME08985.1 MAG: aspartate kinase [Ardenticatenia bacterium] diamond 429 93.2 1 Bacteria   Bacillati Chloroflexota Ardenticatenia       Ardenticatenia 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);;