RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA293022 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
26852947 26852947 PRJNA293022_P_NODE_78621_length_162_cov_1.398230_g77884_i0 PRJNA293022 78621 162 1.39823 2.2651326 Urbifossiella sp. 2807431 Bacteria Bacteria 54.7 5.11e-7   NR HEX4606642.1 2807431 g77884 i0 48 1.83333333333333 50 26 92.6 0 151 2 96 145 HEX4606642.1 TIGR02996 domain-containing protein [Urbifossiella sp.] diamond 297 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella sp.
28197091 28197091 PRJNA293022_P_NODE_76006_length_164_cov_0.904348_g75269_i0 PRJNA293022 76006 164 0.904348 1.48313072 Pseudomonadati 3379134 Bacteria Bacteria 92 3.05e-20   NR TXT34745.1 2026780 g75269 i0 84.9 1.9390243902439 53 8 97 0 161 3 76 128 TXT34745.1 MAG: adenylate kinase [Planctomycetota bacterium] diamond 318 92 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28810735 28810735 PRJNA293022_P_NODE_30348_length_255_cov_1.000000_g29611_i0 PRJNA293022 30348 255 1 2.55 Pirellulales bacterium 2715253 Bacteria Bacteria 58.2 1.61e-7   NR MCH2116316.1 2715253 g29611 i0 33.8 0.835294117647059 71 47 83.5 0 3 215 260 330 MCH2116316.1 trypsin-like serine protease [Pirellulales bacterium] diamond 213 58.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
28986851 28986851 PRJNA293022_P_NODE_67568_length_169_cov_0.866667_g66831_i0 PRJNA293022 67568 169 0.866667 1.46466723 Pseudomonadati 3379134 Bacteria Bacteria 71.6 1.37e-13   NR MBN1511991.1 2026778 g66831 i0 58.8 1.86390532544379 51 21 90.5 0 162 10 61 111 MBN1511991.1 peroxiredoxin [Phycisphaerae bacterium] diamond 315 71.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29333904 29333904 PRJNA293022_P_NODE_79089_length_162_cov_0.920354_g78352_i0 PRJNA293022 79089 162 0.920354 1.49097348 Pseudomonadati 3379134 Bacteria Bacteria 52.8 3.54e-6   NR HCO21516.1 122 g78352 i0 51.1 5.46296296296296 47 23 87 0 153 13 145 191 HCO21516.1 hypothetical protein [Gimesia maris] diamond 885 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia maris
29568810 29568810 PRJNA293022_P_NODE_73310_length_165_cov_1.775862_g72573_i0 PRJNA293022 73310 165 1.775862 2.9301723 Phycisphaerae bacterium SM23_33 1703412 Bacteria Bacteria 44.3 0.00363   NR KPK79959.1 1703412 g72573 i0 43.5 1.8 46 21 83.6 1 163 26 238 278 KPK79959.1 MAG: hypothetical protein AMJ81_12595 [Phycisphaerae bacterium SM23_33] diamond 297 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium SM23_33
29694842 29694842 PRJNA293022_P_NODE_49170_length_199_cov_1.020000_g48433_i0 PRJNA293022 49170 199 1.02 2.0298 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0139   NR MEY2806385.1 2026780 g48433 i0 43.1 0.768844221105528 51 26 72.4 2 151 8 53 103 MEY2806385.1 hypothetical protein [Planctomycetota bacterium] diamond 153 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32823864 32823864 PRJNA293022_P_NODE_9760_length_458_cov_8.687042_g9027_i0 PRJNA293022 9760 458 8.687042 39.78665236 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 45.4 0.0236   NR MCP4478562.1 2026779 g9027 i0 52.8 0.53056768558952 36 17 23.6 0 304 411 142 177 MCP4478562.1 hypothetical protein [Planctomycetaceae bacterium] diamond 243 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   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);;