RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Latescibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Latescibacterota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123436 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
7931850 7931850 PRJNA1123436_P_NODE_109087_length_247_cov_0.885057_g107873_i0 PRJNA1123436 109087 247 0.885057 2.18609079 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 187 5.87e-43   NTclustered gi|2108033339|gb|CP070763.1| 2053570 g107873 i0 82.71 2.00404858299595 214 33 86 4 31 242 2641351 2641562 MAG: Candidatus Latescibacterota bacterium isolate bin260 chromosome blastn 495 187 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
10484159 10484159 PRJNA1123436_P_NODE_88969_length_261_cov_1.606383_g87755_i0 PRJNA1123436 88969 261 1.606383 4.19265963 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 174 4.87e-39   NTclustered gi|2575820357|emb|OY730476.1| 2053570 g87755 i0 88.356 42.9195402298851 146 15 56 2 117 261 4466683 4466827 MAG: Candidatus Latescibacteria bacterium isolate 667a1def-a863-4bf2-9b98-94036fb31650 genome assembly, chromosome: 1 blastn 11202 174 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
13032605 13032605 PRJNA1123436_P_NODE_112831_length_246_cov_0.867052_g111617_i0 PRJNA1123436 112831 246 0.867052 2.13294792 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 84.2 7.88e-12   NTclustered gi|2874254090|emb|OY970173.1| 2053570 g111617 i0 86.047 0.349593495934959 86 2 33 7 143 224 1042754 1042675 MAG: Candidatus Latescibacteria bacterium isolate MFD02242.bin.1.32 genome assembly, chromosome: 1 blastn 86 84.2 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota bacterium
14307796 14307796 PRJNA1123436_P_NODE_110472_length_246_cov_0.890173_g109258_i0 PRJNA1123436 110472 246 0.890173 2.18982558 Candidatus Latescibacterota bacterium 2053570 Bacteria Bacteria 276 1.21e-69   NTclustered gi|2874254090|emb|OY970173.1| 2053570 g109258 i0 87.448 1.98780487804878 239 30 97 0 4 242 2690686 2690448 MAG: Candidatus Latescibacteria bacterium isolate MFD02242.bin.1.32 genome assembly, chromosome: 1 blastn 489 276 1 Bacteria FCB group Pseudomonadati Candidatus Latescibacterota         Candidatus Latescibacterota 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);;