RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Altimarinota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Altimarinota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1237347 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 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
344832 344832 PRJNA1237347_P_NODE_534001_length_243_cov_1.811765_g527428_i0 PRJNA1237347 534001 243 1.811765 4.40258895 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 327 3.25e-85   NTclustered gi|2621785933|emb|OY782391.1| 2044595 g527428 i0 90.947 89.6378600823045 243 22 100 0 1 243 138146 138388 MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1 blastn 21782 327 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota bacterium
6716260 6716260 PRJNA1237347_P_NODE_200326_length_433_cov_1.627778_g193754_i0 PRJNA1237347 200326 433 1.627778 7.04827874 Candidatus Gracilibacteria bacterium 28_42_T64 1862133 Bacteria Bacteria 322 2.89e-83   NTclustered gi|1769783243|gb|CP042461.1| 1862133 g193754 i0 82.609 69.1270207852194 368 60 85 4 5 370 1295114 1295479 Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome blastn 29932 322 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Gracilibacteria bacterium 28_42_T64
11819898 11819898 PRJNA1237347_P_NODE_333590_length_312_cov_2.564854_g327017_i0 PRJNA1237347 333590 312 2.564854 8.00234448 Candidatus Altimarinota bacterium 2044595 Bacteria Bacteria 246 1.25e-60   NTclustered gi|2621785933|emb|OY782391.1| 2044595 g327017 i0 84.109 62.9294871794872 258 37 81 3 1 254 139629 139372 MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1 blastn 19634 246 1 Bacteria Bacteria candidate phyla   Candidatus Altimarinota         Candidatus Altimarinota 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);;