RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA743294 · 4 ✖

analysis 1

  • blastn · 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
13952313 13952313 PRJNA743294_P_NODE_57551_length_237_cov_3.914634_g57095_i0 PRJNA743294 57551 237 3.914634 9.27768258 Thermodesulfobacteriota 200940 Bacteria Bacteria 231 2.55e-56   NTclustered gi|662020026|ref|NR_121913.1| 891 g57095 i0 84.583 245.291139240506 240 29 100 8 1 237 1095 861 Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence blastn 58134 233 0.991416309012876 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfuromonadia Desulfuromonadales Desulfuromonadaceae Desulfuromonas Desulfuromonas acetoxidans
14751012 14751012 PRJNA743294_P_NODE_41472_length_264_cov_4.931937_g41016_i0 PRJNA743294 41472 264 4.931937 13.02031368 uncultured Syntrophobacter sp. 281272 Bacteria Bacteria 372 1.63e-98   NTclustered gi|2621703986|emb|OY762941.1| 281272 g41016 i0 92.045 256.757575757576 264 21 100 0 1 264 1625588 1625325 MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1 blastn 67784 372 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter uncultured Syntrophobacter sp.
16024686 16024686 PRJNA743294_P_NODE_40753_length_266_cov_4.082902_g40297_i0 PRJNA743294 40753 266 4.082902 10.86051932 uncultured Syntrophobacter sp. 281272 Bacteria Bacteria 435 2.07e-117   NTclustered gi|2621703986|emb|OY762941.1| 281272 g40297 i0 96.226 171.492481203008 265 10 99 0 1 265 1624586 1624322 MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1 blastn 45617 435 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter uncultured Syntrophobacter sp.
19050099 19050099 PRJNA743294_P_NODE_4715_length_701_cov_3.995223_g4292_i0 PRJNA743294 4715 701 3.995223 28.00651323 Syntrophobacter 29526 Bacteria Bacteria 935 0   NTclustered gi|470481149|ref|NR_076457.1| 119484 g4292 i0 90.483 191.603423680457 725 45 100 11 1 701 556 1280 Syntrophobacter fumaroxidans strain MPOB 23S ribosomal RNA gene, complete sequence blastn 134314 935 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Syntrophobacteria Syntrophobacterales Syntrophobacteraceae Syntrophobacter Syntrophobacter fumaroxidans

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);;