RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1005695" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 23 ✖

bioproject 1

  • PRJNA1005695 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
17579053 17579053 PRJNA1005695_P_NODE_8054_length_551_cov_2.669456_g7216_i0 PRJNA1005695 8054 551 2.669456 14.70870256 Planctomycetota bacterium 2026780 Bacteria Bacteria 271 2.6699999999999996e-88   NR MFH0911687.1 2026780 g7216 i0 81.6 1.78039927404719 163 30 88.7 0 63 551 2 164 MFH0911687.1 class II fructose-bisphosphate aldolase [Planctomycetota bacterium] diamond 981 271 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26622855 26622855 PRJNA1005695_P_NODE_39661_length_243_cov_0.917647_g38809_i0 PRJNA1005695 39661 243 0.917647 2.22988221 Planctomyces sp. 37635 Bacteria Bacteria 166 1.08e-50   NR MBL8816608.1 37635 g38809 i0 98.7 0.938271604938272 76 1 93.8 0 15 242 1 76 MBL8816608.1 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Planctomyces sp.] diamond 228 166 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
27248293 27248293 PRJNA1005695_P_NODE_35343_length_251_cov_2.449438_g34491_i0 PRJNA1005695 35343 251 2.449438 6.14808938 Planctomycetota 203682 Bacteria Bacteria 85.1 5.1e-17   NR WP_207397605.1 980252 g34491 i0 55.4 5.95219123505976 83 33 99.2 2 2 250 138 216 WP_207397605.1 hypothetical protein [Bremerella alba] diamond 1494 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Bremerella Bremerella alba
27319103 27319103 PRJNA1005695_P_NODE_29963_length_272_cov_4.994975_g29111_i0 PRJNA1005695 29963 272 4.994975 13.586332 Candidatus Anoxychlamydiales bacterium 2705072 Bacteria Bacteria 43.1 0.0376   NR NGX48595.1 2705072 g29111 i0 32.3 0.716911764705882 65 44 71.7 0 260 66 123 187 NGX48595.1 hypothetical protein [Candidatus Anoxychlamydiales bacterium] diamond 195 43.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Candidatus Anoxychlamydiales     Candidatus Anoxychlamydiales bacterium
27603403 27603403 PRJNA1005695_P_NODE_39544_length_243_cov_0.917647_g38692_i0 PRJNA1005695 39544 243 0.917647 2.22988221 Planctomycetota bacterium 2026780 Bacteria Bacteria 65.9 2.65e-10   NR NOT32013.1 2026780 g38692 i0 47 1.02469135802469 83 36 98.8 3 2 241 519 596 NOT32013.1 hypothetical protein [Planctomycetota bacterium] diamond 249 65.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27792772 27792772 PRJNA1005695_P_NODE_40004_length_242_cov_0.923077_g39152_i0 PRJNA1005695 40004 242 0.923077 2.23384634 Phycisphaerae bacterium 2026778 Bacteria Bacteria 143 3.14e-39   NR MBL9001027.1 2026778 g39152 i0 88.8 0.991735537190083 80 9 99.2 0 2 241 88 167 MBL9001027.1 DNA polymerase III subunit beta [Phycisphaerae bacterium] diamond 240 143 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27918848 27918848 PRJNA1005695_P_NODE_29745_length_274_cov_1.243781_g28893_i0 PRJNA1005695 29745 274 1.243781 3.40795994 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.1 0.0385   NR MBN1342527.1 2026778 g28893 i0 36.5 0.81021897810219 74 44 77.7 1 45 257 202 275 MBN1342527.1 hypothetical protein [Phycisphaerae bacterium] diamond 222 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28202862 28202862 PRJNA1005695_P_NODE_34046_length_255_cov_1.434066_g33194_i0 PRJNA1005695 34046 255 1.434066 3.6568683 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.5 0.00882   NR HZY84477.1 2052164 g33194 i0 43.5 0.811764705882353 69 26 75.3 5 249 58 1 61 HZY84477.1 DUF202 domain-containing protein [Gemmataceae bacterium] diamond 207 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28297711 28297711 PRJNA1005695_P_NODE_14946_length_394_cov_1.171340_g14094_i0 PRJNA1005695 14946 394 1.17134 4.6150796 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 49.3 9.25e-4   NR MEM7011732.1 2026799 g14094 i0 42.6 0.357868020304569 47 24 35.8 1 379 239 93 136 MEM7011732.1 RICIN domain-containing protein [Verrucomicrobiota bacterium] diamond 141 49.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28424253 28424253 PRJNA1005695_P_NODE_37646_length_247_cov_0.896552_g36794_i0 PRJNA1005695 37646 247 0.896552 2.21448344 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 109 1.04e-28   NR MBS0634828.1 2026799 g36794 i0 81.7 0.728744939271255 60 11 72.9 0 182 3 1 60 MBS0634828.1 type II toxin-antitoxin system VapC family toxin [Verrucomicrobiota bacterium] diamond 180 109 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28582133 28582133 PRJNA1005695_P_NODE_19007_length_346_cov_3.175824_g18155_i0 PRJNA1005695 19007 346 3.175824 10.98835104 Phycisphaerales bacterium 2052180 Bacteria Bacteria 82 2.01e-15   NR MCI0366357.1 2052180 g18155 i0 58.5 0.563583815028902 65 27 56.4 0 197 3 634 698 MCI0366357.1 polyribonucleotide nucleotidyltransferase [Phycisphaerales bacterium] diamond 195 82 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28739876 28739876 PRJNA1005695_P_NODE_38427_length_245_cov_1.360465_g37575_i0 PRJNA1005695 38427 245 1.360465 3.33313925 Phycisphaerae bacterium 2026778 Bacteria Bacteria 85.1 4.6e-17   NR HUO07305.1 2026778 g37575 i0 52.2 3.30612244897959 67 32 82 0 224 24 57 123 HUO07305.1 glucosamine-6-phosphate deaminase [Phycisphaerae bacterium] diamond 810 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28771379 28771379 PRJNA1005695_P_NODE_38127_length_246_cov_0.901734_g37275_i0 PRJNA1005695 38127 246 0.901734 2.21826564 Planctomycetota bacterium 2026780 Bacteria Bacteria 158 2.77e-44   NR MBL8899322.1 2026780 g37275 i0 95.1 0.98780487804878 81 4 98.8 0 245 3 71 151 MBL8899322.1 hypothetical protein [Planctomycetota bacterium] diamond 243 158 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29529297 29529297 PRJNA1005695_P_NODE_30710_length_269_cov_2.173469_g29858_i0 PRJNA1005695 30710 269 2.173469 5.84663161 Phycisphaerales bacterium 2052180 Bacteria Bacteria 43.9 0.02   NR UCG58142.1 2052180 g29858 i0 42.2 0.713754646840149 64 30 64.7 3 34 207 150 212 UCG58142.1 MAG: sodium-dependent transporter [Phycisphaerales bacterium] diamond 192 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30003043 30003043 PRJNA1005695_P_NODE_39991_length_242_cov_0.923077_g39139_i0 PRJNA1005695 39991 242 0.923077 2.23384634 Akkermansia sp. N21116 3040764 Bacteria Bacteria 58.2 1.28e-7   NR WP_322190066.1 3040764 g39139 i0 42.7 0.929752066115702 75 43 93 0 229 5 101 175 WP_322190066.1 hypothetical protein [Akkermansia sp. N21116] diamond 225 58.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae Akkermansia Akkermansia sp. N21116
30160628 30160628 PRJNA1005695_P_NODE_37032_length_248_cov_0.891429_g36180_i0 PRJNA1005695 37032 248 0.891429 2.21074392 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0273   NR MEO1715621.1 2026780 g36180 i0 41.5 0.991935483870968 41 21 46 1 34 147 215 255 MEO1715621.1 hypothetical protein [Planctomycetota bacterium] diamond 246 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30761289 30761289 PRJNA1005695_P_NODE_40014_length_242_cov_0.923077_g39162_i0 PRJNA1005695 40014 242 0.923077 2.23384634 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 94 3.51e-20   NR MCU0749224.1 2562705 g39162 i0 62.8 0.966942148760331 78 29 96.7 0 7 240 656 733 MCU0749224.1 family 16 glycosylhydrolase [Akkermansiaceae bacterium] diamond 234 94 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
31171678 31171678 PRJNA1005695_P_NODE_40975_length_235_cov_2.290123_g40123_i0 PRJNA1005695 40975 235 2.290123 5.38178905 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 109 5.0700000000000006e-27   NR QTN31624.1 2562705 g40123 i0 59 2.98723404255319 78 30 97 1 233 6 105 182 QTN31624.1 ROK family protein [Akkermansiaceae bacterium] diamond 702 109 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
31583259 31583259 PRJNA1005695_P_NODE_8856_length_524_cov_4.547672_g8009_i0 PRJNA1005695 8856 524 4.547672 23.82980128 Mariniblastus fucicola 980251 Bacteria Bacteria 163 5.3899999999999997e-48   NR WP_075084412.1 980251 g8009 i0 57.1 0.801526717557252 140 57 80.2 2 421 2 4 140 WP_075084412.1 thiol peroxidase [Mariniblastus fucicola] diamond 420 163 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Mariniblastus Mariniblastus fucicola
32437547 32437547 PRJNA1005695_P_NODE_28919_length_278_cov_1.346341_g28067_i0 PRJNA1005695 28919 278 1.346341 3.74282798 Puniceicoccales bacterium 2478473 Bacteria Bacteria 117 7.23e-29   NR MDR2812906.1 2478473 g28067 i0 61.8 0.960431654676259 89 34 96 0 12 278 178 266 MDR2812906.1 M48 family metallopeptidase [Puniceicoccales bacterium] diamond 267 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales     Puniceicoccales bacterium
32532423 32532423 PRJNA1005695_P_NODE_35639_length_251_cov_0.876404_g34787_i0 PRJNA1005695 35639 251 0.876404 2.19977404 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 134 2.87e-37   NR MCC6883823.1 2026801 g34787 i0 76.5 0.968127490039841 81 19 96.8 0 4 246 20 100 MCC6883823.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 243 134 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32564109 32564109 PRJNA1005695_P_NODE_40099_length_242_cov_0.923077_g39247_i0 PRJNA1005695 40099 242 0.923077 2.23384634 Chlamydiota bacterium 2081524 Bacteria Bacteria 55.5 1.23e-6   NR MCX6988744.1 2081524 g39247 i0 41.7 1.04132231404959 84 40 93 2 5 229 767 850 MCX6988744.1 protein translocase subunit SecD [Chlamydiota bacterium] diamond 252 55.5 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
32776707 32776707 PRJNA1005695_P_NODE_36300_length_249_cov_2.965909_g35448_i0 PRJNA1005695 36300 249 2.965909 7.38511341 Bacteria 2 Bacteria Bacteria 57 3.95e-7   NR MBL9136906.1 2026801 g35448 i0 50 7.33734939759036 54 24 65.1 1 88 249 667 717 MBL9136906.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 1827 57.4 0.993031358885017 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales 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);;