RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA358490 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
1673776 1673776 PRJNA358490_P_NODE_502_length_1632_cov_3.912743_g455_i0 PRJNA358490 502 1632 3.912743 63.85596576 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 1509 0   NTclustered gi|2874253757|emb|OY969698.1| 100233 g455 i0 85.587 128.217524509804 1464 183 88 20 171 1610 4421417 4422876 MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1 blastn 209251 1509 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
4226234 4226234 PRJNA358490_P_NODE_3184_length_803_cov_10.293194_g2977_i0 PRJNA358490 3184 803 10.293194 82.65434782 uncultured Phycisphaerales bacterium 904075 Bacteria Bacteria 1007 0   NTclustered gi|2874253847|emb|OY969903.1| 904075 g2977 i0 90.064 175.657534246575 785 66 97 11 24 803 1830359 1831136 MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1 blastn 141053 1007 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     uncultured Phycisphaerales bacterium
4901155 4901155 PRJNA358490_P_NODE_14984_length_183_cov_1.138889_g14640_i0 PRJNA358490 14984 183 1.138889 2.08416687 Engelhardtia 139931 Bacteria Bacteria 135 1.5e-27   NTclustered gi|1712638177|gb|CP036287.1| 2528011 g14640 i0 82.166 16.6010928961749 157 28 86 0 27 183 410860 411016 Planctomycetes bacterium Pla133 chromosome, complete genome blastn 3038 135 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia     Engelhardtia Engelhardtia mirabilis
5502686 5502686 PRJNA358490_P_NODE_5725_length_564_cov_1.695238_g5419_i0 PRJNA358490 5725 564 1.695238 9.56114232 Humisphaera borealis 2807512 Bacteria Bacteria 283 1.81e-71   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g5419 i0 79.009 4.24290780141844 424 81 74 7 133 552 5794461 5794880 Humisphaera borealis strain M1803 chromosome, complete genome blastn 2393 283 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
6176178 6176178 PRJNA358490_P_NODE_10925_length_290_cov_2.195219_g10583_i0 PRJNA358490 10925 290 2.195219 6.3661351 Limnoglobus 2731450 Bacteria Bacteria 344 3.959999999999999e-90   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g10583 i0 93.22 301.579310344828 236 12 81 4 37 270 318453 318686 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 87458 344 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
6776649 6776649 PRJNA358490_P_NODE_17326_length_158_cov_1.252101_g16982_i0 PRJNA358490 17326 158 1.252101 1.97831958 Lacipirellula parvula 2650471 Bacteria Bacteria 248 1.55e-61   NTclustered gi|1761017769|dbj|AP021861.1| 2650471 g16982 i0 94.937 37.9430379746835 158 8 100 0 1 158 5164059 5164216 Lacipirellula parvula PX69 DNA, complete genome blastn 5995 248 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula parvula
8052332 8052332 PRJNA358490_P_NODE_487_length_1650_cov_3.726257_g440_i0 PRJNA358490 487 1650 3.726257 61.4832405 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 2037 0   NTclustered gi|2874254106|emb|OY970189.1| 100233 g440 i0 89.043 152.758181818182 1661 139 99 32 1 1637 5937647 5936006 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 252051 2037 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
16976488 16976488 PRJNA358490_P_NODE_574_length_1567_cov_3.848822_g440_i1 PRJNA358490 574 1567 3.848822 60.31104074 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 1840 0   NTclustered gi|2874254106|emb|OY970189.1| 100233 g440 i1 90.968 157.498404594767 1384 100 87 21 187 1554 5937380 5936006 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 246800 1840 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
18250643 18250643 PRJNA358490_P_NODE_17275_length_158_cov_2.042017_g16931_i0 PRJNA358490 17275 158 2.042017 3.22638686 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 183 4.4399999999999996e-42   NTclustered gi|2874253948|emb|OY970273.1| 100233 g16931 i0 88.235 3.0253164556962 153 18 97 0 6 158 2403247 2403399 MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1 blastn 478 183 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae 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);;