RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1164198" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1164198 · 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
13792836 13792836 PRJNA1164198_P_NODE_9311_length_408_cov_2.259701_g9046_i0 PRJNA1164198 9311 408 2.259701 9.21958008 Planctopirus 1649480 Bacteria Bacteria 749 0   NTclustered gi|470485078|ref|NR_076683.1| 120 g9046 i0 99.755 133.252450980392 408 1 100 0 1 408 2794 2387 Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence blastn 54367 754 0.993368700265252 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctopirus Planctopirus limnophila
18163607 18163607 PRJNA1164198_P_NODE_28835_length_245_cov_0.906977_g28566_i0 PRJNA1164198 28835 245 0.906977 2.22209365 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 298 2.57e-76   NTclustered gi|2874253749|emb|OY969623.1| 1914239 g28566 i0 88.71 247.408163265306 248 23 100 3 1 245 7051213 7051458 MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1 blastn 60615 298 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
19437961 19437961 PRJNA1164198_P_NODE_29136_length_245_cov_0.906977_g28867_i0 PRJNA1164198 29136 245 0.906977 2.22209365 Planctopirus limnophila 120 Bacteria Bacteria 137 5.93e-28   NTclustered gi|296012614|gb|CP001744.1| 521674 g28867 i0 97.5 1.11428571428571 80 2 55 0 166 245 2052389 2052468 Planctopirus limnophila DSM 3776 chromosome, complete genome blastn 273 137 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctopirus Planctopirus limnophila
20713330 20713330 PRJNA1164198_P_NODE_27937_length_247_cov_0.896552_g27668_i0 PRJNA1164198 27937 247 0.896552 2.21448344 Urbifossiella limnaea 2528023 Bacteria Bacteria 255 1.59e-63   NTclustered gi|1712585314|gb|CP036273.1| 2528023 g27668 i0 85.714 5.05668016194332 245 31 98 4 5 247 204870 204628 Urbifossiella limnaea strain ETA_A1 chromosome, complete genome blastn 1249 255 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella limnaea

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