RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Berkelbacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Berkelbacteria · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 24 ✖

analysis 1

  • diamond · 24 ✖

tax_kingdom 0

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
13788526 13788526 PRJNA1148190_P_NODE_424531_length_281_cov_1.836538_g413358_i0 PRJNA1148190 424531 281 1.836538 5.16067178 Bacteria 2 Bacteria Bacteria 142 9.27e-38   NR KKP87930.1 1618333 g413358 i0 100 3.7900355871886098 71 0 75.8 0 281 69 441 511 KKP87930.1 MAG: Site-specific recombinase [Berkelbacteria bacterium GW2011_GWA2_35_9] diamond 1065 142 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA2_35_9
23242805 23242805 PRJNA1148190_P_NODE_10639_length_3111_cov_3.074391_g5479_i0 PRJNA1148190 10639 3111 3.074391 95.64430401 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 525 8.18e-174   NR MBM2820921.1 2053521 g5479 i0 66.2 0.351012536162006 364 123 35.1 0 2020 3111 1 364 MBM2820921.1 recombinase [Candidatus Berkelbacteria bacterium] diamond 1092 525 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
26976906 26976906 PRJNA1148190_P_NODE_86162_length_584_cov_1.544031_g75029_i0 PRJNA1148190 86162 584 1.544031 9.01714104 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 281 2.38e-90   NR MBM2820921.1 2053521 g75029 i0 59.8 0.996575342465753 194 78 99.7 0 3 584 140 333 MBM2820921.1 recombinase [Candidatus Berkelbacteria bacterium] diamond 582 281 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27007903 27007903 PRJNA1148190_P_NODE_49282_length_858_cov_3.136306_g38509_i0 PRJNA1148190 49282 858 3.136306 26.90950548 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 209 1.45e-62   NR MEI8060801.1 2053521 g38509 i0 48 0.867132867132867 248 129 86.7 0 110 853 6 253 MEI8060801.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 744 209 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27134694 27134694 PRJNA1148190_P_NODE_91102_length_564_cov_2.820774_g79962_i0 PRJNA1148190 91102 564 2.820774 15.90916536 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 81.3 4.16e-14   NR MCR4307510.1 2053521 g79962 i0 39.4 0.675531914893617 127 62 66.5 3 376 2 364 477 MCR4307510.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 381 81.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27153873 27153873 PRJNA1148190_P_NODE_123422_length_475_cov_1.323383_g112259_i0 PRJNA1148190 123422 475 1.323383 6.28606925 Bacteria 2 Bacteria Bacteria 75.1 1.84e-12   NR PIS07911.1 1974514 g112259 i0 51.6 2.32421052631579 91 42 57.5 1 287 15 22 110 PIS07911.1 MAG: hypothetical protein COT78_00995 [Candidatus Berkelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_13] diamond 1104 75.1 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_43_13
27671111 27671111 PRJNA1148190_P_NODE_138444_length_447_cov_1.491979_g127279_i0 PRJNA1148190 138444 447 1.491979 6.66914613 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 48.9 0.00229   NR MCR4308362.1 2053521 g127279 i0 30.4 0.771812080536913 115 70 77.2 2 347 3 448 552 MCR4308362.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 345 48.9 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27735121 27735121 PRJNA1148190_P_NODE_55604_length_784_cov_1.857947_g44693_i0 PRJNA1148190 55604 784 1.857947 14.56630448 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 81.3 2.88e-13   NR MCR4308362.1 2053521 g44693 i0 33.3 0.73469387755102 192 105 71.9 7 130 693 1207 1379 MCR4308362.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 576 81.3 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
27943988 27943988 PRJNA1148190_P_NODE_185365_length_389_cov_1.291139_g174196_i0 PRJNA1148190 185365 389 1.291139 5.02253071 Pseudomonadati 3379134 Bacteria Bacteria 124 1.63e-33   NR QQG50367.1 2053521 g174196 i0 55.7 9.40874035989717 106 46 81.7 1 1 318 22 126 QQG50367.1 MAG: dCMP deaminase family protein [Candidatus Berkelbacteria bacterium] diamond 3660 125 0.992 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
28208217 28208217 PRJNA1148190_P_NODE_53186_length_810_cov_2.010855_g42324_i0 PRJNA1148190 53186 810 2.010855 16.2879255 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 71.2 4.27e-11   NR MEI8061327.1 2053521 g42324 i0 31 1 142 94 52.6 2 205 630 1 138 MEI8061327.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 810 71.2 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
28303508 28303508 PRJNA1148190_P_NODE_775086_length_241_cov_1.505952_g763913_i0 PRJNA1148190 775086 241 1.505952 3.62934432 Candidatus Berkelbacteria bacterium Licking1 2053521 Bacteria Bacteria 52.4 1.33e-5   NR TSC92613.1 2017148 g763913 i0 34.3 1.8298755186722 70 45 87.1 1 7 216 227 295 TSC92613.1 MAG: hypothetical protein CEN91_391 [Candidatus Berkelbacteria bacterium Licking1014_85] diamond 441 52.4 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium Licking1014_85
28638788 28638788 PRJNA1148190_P_NODE_291967_length_323_cov_1.540000_g280794_i0 PRJNA1148190 291967 323 1.54 4.9742 Bacteria 2 Bacteria Bacteria 99.4 9.67e-22   NR MCR4307133.1 2053521 g280794 i0 48.6 1.98761609907121 107 53 99.4 1 1 321 331 435 MCR4307133.1 terminase family protein [Candidatus Berkelbacteria bacterium] diamond 642 99.4 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
28840112 28840112 PRJNA1148190_P_NODE_739968_length_243_cov_0.905882_g728795_i0 PRJNA1148190 739968 243 0.905882 2.20129326 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 60.5 2.55e-9   NR MCR4308157.1 2053521 g728795 i0 65.2 0.567901234567901 46 16 56.8 0 44 181 32 77 MCR4308157.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 138 60.5 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
29187592 29187592 PRJNA1148190_P_NODE_654309_length_247_cov_2.304598_g643136_i0 PRJNA1148190 654309 247 2.304598 5.69235706 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 154 4.65e-43   NR MBM2820921.1 2053521 g643136 i0 86.3 1.93117408906883 80 11 97.2 0 3 242 93 172 MBM2820921.1 recombinase [Candidatus Berkelbacteria bacterium] diamond 477 154 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
29249759 29249759 PRJNA1148190_P_NODE_298869_length_320_cov_1.582996_g287696_i0 PRJNA1148190 298869 320 1.582996 5.0655872 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 171 2.5e-47   NR MCR4308171.1 2053521 g287696 i0 76.4 7.9125 106 25 99.4 0 320 3 349 454 MCR4308171.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 2532 171 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
29344436 29344436 PRJNA1148190_P_NODE_137229_length_449_cov_1.566489_g126064_i0 PRJNA1148190 137229 449 1.566489 7.03353561 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 103 4.7499999999999997e-23   NR MEI6040097.1 2053521 g126064 i0 50 0.628062360801782 94 47 62.8 0 1 282 307 400 MEI6040097.1 tyrosine--tRNA ligase [Candidatus Berkelbacteria bacterium] diamond 282 103 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
29881893 29881893 PRJNA1148190_P_NODE_44571_length_929_cov_2.991822_g33962_i0 PRJNA1148190 44571 929 2.991822 27.79402638 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 181 1.48e-50   NR MBI4032246.1 2053521 g33962 i0 65.7 0.871905274488697 134 46 43.3 0 15 416 66 199 MBI4032246.1 M23 family metallopeptidase [Candidatus Berkelbacteria bacterium] diamond 810 181 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
30375930 30375930 PRJNA1148190_P_NODE_37052_length_1080_cov_1.954320_g26831_i0 PRJNA1148190 37052 1080 1.95432 21.106656 Pseudomonadati 3379134 Bacteria Bacteria 329 1.41e-108   NR OGD61162.1 1797468 g26831 i0 57.5 1.55555555555556 280 116 77.2 3 134 967 1 279 OGD61162.1 MAG: hypothetical protein A2807_01585 [Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_01_FULL_50_36] diamond 1680 330 0.996969696969697 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_01_FULL_50_36
30640455 30640455 PRJNA1148190_P_NODE_97913_length_541_cov_1.382479_g86759_i0 PRJNA1148190 97913 541 1.382479 7.47921139 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 65.9 8.04e-10   NR MEI8061327.1 2053521 g86759 i0 34.8 0.765249537892791 138 85 75.4 3 540 133 36 170 MEI8061327.1 hypothetical protein [Candidatus Berkelbacteria bacterium] diamond 414 65.9 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium
31113836 31113836 PRJNA1148190_P_NODE_556955_length_255_cov_3.291209_g545782_i0 PRJNA1148190 556955 255 3.291209 8.39258295 Berkelbacteria bacterium GW2 2053521 Bacteria Bacteria 165 1.24e-46   NR KKP87930.1 1618333 g545782 i0 98.8 0.988235294117647 84 1 98.8 0 254 3 107 190 KKP87930.1 MAG: Site-specific recombinase [Berkelbacteria bacterium GW2011_GWA2_35_9] diamond 252 165 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA2_35_9
31355317 31355317 PRJNA1148190_P_NODE_715136_length_244_cov_1.578947_g703963_i0 PRJNA1148190 715136 244 1.578947 3.85263068 Bacteria 2 Bacteria Bacteria 113 4.11e-30   NR OGD61251.1 1797468 g703963 i0 63.8 1.9672131147541 80 29 98.4 0 5 244 31 110 OGD61251.1 MAG: hypothetical protein A2807_01700 [Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_01_FULL_50_36] diamond 480 114 0.991228070175439 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_01_FULL_50_36
31398045 31398045 PRJNA1148190_P_NODE_16616_length_2156_cov_3.662506_g9457_i0 PRJNA1148190 16616 2156 3.662506 78.96362936 Candidatus Berkelbacteria bacterium CG1_ 2053521 Bacteria Bacteria 200 3.81e-53   NR OIN89532.1 1805036 g9457 i0 43.7 0.397959183673469 286 159 39.5 2 2 853 141 426 OIN89532.1 MAG: hypothetical protein AUJ40_01740 [Candidatus Berkelbacteria bacterium CG1_02_42_45] diamond 858 200 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria bacterium CG1_02_42_45
31418304 31418304 PRJNA1148190_P_NODE_269016_length_334_cov_1.053640_g257845_i0 PRJNA1148190 269016 334 1.05364 3.5191576 Bacteria 2 Bacteria Bacteria 214 4.77e-65   NR KKP87930.1 1618333 g257845 i0 99.1 2.95508982035928 111 1 99.7 0 333 1 344 454 KKP87930.1 MAG: Site-specific recombinase [Berkelbacteria bacterium GW2011_GWA2_35_9] diamond 987 215 0.995348837209302 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Berkelbacteria bacterium GW2011_GWA2_35_9
31557111 31557111 PRJNA1148190_P_NODE_620876_length_249_cov_1.193182_g609703_i0 PRJNA1148190 620876 249 1.193182 2.97102318 Candidatus Berkelbacteria bacterium 2053521 Bacteria Bacteria 56.6 4.6e-7   NR MCR4308196.1 2053521 g609703 i0 38 0.951807228915663 79 45 91.6 2 15 242 80 157 MCR4308196.1 amidoligase family protein [Candidatus Berkelbacteria bacterium] diamond 237 56.6 1 Bacteria Bacteria candidate phyla   Candidatus Berkelbacteria         Candidatus Berkelbacteria 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);;