RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB30004" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB30004 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26906714 26906714 PRJEB30004_P_NODE_369182_length_241_cov_2.341584_g353555_i0 PRJEB30004 369182 241 2.341584 5.64321744 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 43.9 0.0145   NR HEV8378168.1 2876886 g353555 i0 36.8 1.69294605809129 87 48 99.6 1 241 2 556 642 HEV8378168.1 serine/threonine-protein kinase [Tepidisphaeraceae bacterium] diamond 408 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
27254399 27254399 PRJEB30004_P_NODE_402063_length_226_cov_1.550802_g386436_i0 PRJEB30004 402063 226 1.550802 3.50481252 Phycisphaerae bacterium 2026778 Bacteria Bacteria 58.9 5.05e-8   NR HVP12053.1 2026778 g386436 i0 62.8 0.570796460176991 43 16 57.1 0 131 3 101 143 HVP12053.1 tyrosine-type recombinase/integrase [Phycisphaerae bacterium] diamond 129 58.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27349608 27349608 PRJEB30004_P_NODE_615923_length_163_cov_2.870968_g600296_i0 PRJEB30004 615923 163 2.870968 4.67967784 Planctomycetales bacterium 2053591 Bacteria Bacteria 62.8 1.05e-9   NR HBI42287.1 2053591 g600296 i0 49.1 0.975460122699387 53 27 97.5 0 159 1 197 249 HBI42287.1 hypothetical protein [Planctomycetales bacterium] diamond 159 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
27753538 27753538 PRJEB30004_P_NODE_529324_length_183_cov_2.097222_g513697_i0 PRJEB30004 529324 183 2.097222 3.83791626 Bacteria 2 Bacteria Bacteria 90.1 3.88e-20   NR MEM1422484.1 2026780 g513697 i0 71.2 4.81967213114754 59 17 96.7 0 3 179 132 190 MEM1422484.1 dienelactone hydrolase family protein [Planctomycetota bacterium] diamond 882 90.9 0.991199119911991 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28707174 28707174 PRJEB30004_P_NODE_323167_length_267_cov_1.250000_g307540_i0 PRJEB30004 323167 267 1.25 3.3375 Gemmatales bacterium 2838789 Bacteria Bacteria 45.4 0.00549   NR HMP58027.1 2838789 g307540 i0 39.7 0.707865168539326 63 33 68.5 3 12 194 234 293 HMP58027.1 hypothetical protein [Gemmatales bacterium] diamond 189 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
28921417 28921417 PRJEB30004_P_NODE_361788_length_245_cov_1.684466_g346161_i0 PRJEB30004 361788 245 1.684466 4.1269417 Bacteria 2 Bacteria Bacteria 117 7.7699999999999995e-31   NR HZZ76997.1 2052164 g346161 i0 74.1 1.98367346938776 81 21 99.2 0 243 1 39 119 HZZ76997.1 response regulator transcription factor [Gemmataceae bacterium] diamond 486 117 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29149490 29149490 PRJEB30004_P_NODE_344189_length_254_cov_2.418605_g328562_i0 PRJEB30004 344189 254 2.418605 6.1432567 Planctomycetia bacterium 2052181 Bacteria Bacteria 62.8 3.63e-9   NR MBI2826893.1 2052181 g328562 i0 42.7 1.0511811023622 89 42 99.2 2 252 1 235 319 MBI2826893.1 hypothetical protein [Planctomycetia bacterium] diamond 267 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
29843753 29843753 PRJEB30004_P_NODE_473891_length_199_cov_2.200000_g458264_i0 PRJEB30004 473891 199 2.2 4.378 Planctomycetota bacterium 2026780 Bacteria Bacteria 60.5 1.18e-8   NR RLT20878.1 2026780 g458264 i0 48.1 1.58291457286432 54 28 81.4 0 4 165 635 688 RLT20878.1 MAG: TonB-dependent receptor [Planctomycetota bacterium] diamond 315 60.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30311629 30311629 PRJEB30004_P_NODE_668792_length_153_cov_3.122807_g653165_i0 PRJEB30004 668792 153 3.122807 4.77789471 Pseudomonadati 3379134 Bacteria Bacteria 45.1 2.01e-4   NR MBI3830601.1 2026780 g653165 i0 61.3 2.19607843137255 31 12 60.8 0 4 96 33 63 MBI3830601.1 helix-turn-helix transcriptional regulator [Planctomycetota bacterium] diamond 336 45.4 0.993392070484582 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30696669 30696669 PRJEB30004_P_NODE_447194_length_208_cov_2.343195_g431567_i0 PRJEB30004 447194 208 2.343195 4.8738456 Planctomycetia bacterium 2052181 Bacteria Bacteria 55.5 2.76e-7   NR MCX7427065.1 2052181 g431567 i0 75 1.00961538461538 36 9 51.9 0 1 108 76 111 MCX7427065.1 flavin reductase family protein [Planctomycetia bacterium] diamond 210 55.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
30918113 30918113 PRJEB30004_P_NODE_330474_length_262_cov_2.022422_g314847_i0 PRJEB30004 330474 262 2.022422 5.29874564 Blastopirellula sp. 2024826 Bacteria Bacteria 109 1.71e-26   NR PHR85915.1 2024826 g314847 i0 57.8 0.950381679389313 83 35 95 0 8 256 219 301 PHR85915.1 MAG: hypothetical protein COA78_38645, partial [Blastopirellula sp.] diamond 249 109 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula sp.
31265589 31265589 PRJEB30004_P_NODE_524675_length_184_cov_4.317241_g509048_i0 PRJEB30004 524675 184 4.317241 7.94372344 Planctomycetota bacterium 2026780 Bacteria Bacteria 47.8 2.21e-4   NR MEO1129876.1 2026780 g509048 i0 52.6 2.52717391304348 38 18 62 0 115 2 14 51 MEO1129876.1 response regulator [Planctomycetota bacterium] diamond 465 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31455431 31455431 PRJEB30004_P_NODE_499476_length_192_cov_0.980392_g483849_i0 PRJEB30004 499476 192 0.980392 1.88235264 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0371   NR MSR63606.1 2026780 g483849 i0 43.2 0.6875 44 21 62.5 1 168 49 334 377 MSR63606.1 hypothetical protein [Planctomycetota bacterium] diamond 132 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31803118 31803118 PRJEB30004_P_NODE_229097_length_343_cov_2.108553_g213470_i0 PRJEB30004 229097 343 2.108553 7.23233679 Planctomycetota bacterium 2026780 Bacteria Bacteria 97.4 7.54e-21   NR HLX60309.1 2026780 g213470 i0 57.7 0.848396501457726 97 38 84.8 2 50 340 382 475 HLX60309.1 DUF3560 domain-containing protein [Planctomycetota bacterium] diamond 291 97.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31898168 31898168 PRJEB30004_P_NODE_450777_length_207_cov_1.750000_g435150_i0 PRJEB30004 450777 207 1.75 3.6225 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 69.7 4.15e-12   NR HEV8604292.1 2876886 g435150 i0 87.9 0.478260869565217 33 4 47.8 0 100 2 1 33 HEV8604292.1 polyphosphate kinase 2 family protein [Tepidisphaeraceae bacterium] diamond 99 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32151346 32151346 PRJEB30004_P_NODE_342718_length_255_cov_2.000000_g327091_i0 PRJEB30004 342718 255 2 5.1 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.00462   NR MBX3464435.1 2026780 g327091 i0 41.4 0.682352941176471 58 29 68.2 1 59 232 294 346 MBX3464435.1 MFS transporter [Planctomycetota bacterium] diamond 174 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32562896 32562896 PRJEB30004_P_NODE_589679_length_169_cov_1.261538_g574052_i0 PRJEB30004 589679 169 1.261538 2.13199922 Planctomycetota bacterium 2026780 Bacteria Bacteria 59.3 1.96e-8   NR MBI3818226.1 2026780 g574052 i0 59.3 0.958579881656805 54 20 94.1 2 11 169 61 113 MBI3818226.1 hypothetical protein [Planctomycetota bacterium] diamond 162 59.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;