RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Chlamydiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlamydiota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1160211 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
6687006 6687006 PRJNA1160211_S_NODE_120966_length_419_cov_14.020231_g119737_i0 PRJNA1160211 120966 419 14.020231 58.74476789 Chlamydiia 204429 Bacteria Bacteria 184 2.9599999999999998e-53   NR OJU80258.1 1895742 g119737 i0 82.7 7.91885441527446 110 19 78.8 0 89 418 45 154 OJU80258.1 MAG: transcription termination factor Rho [Chlamydia sp. 32-24] diamond 3318 185 0.994594594594595 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia sp. 32-24
26628841 26628841 PRJNA1160211_S_NODE_62721_length_540_cov_5.961456_g61529_i0 PRJNA1160211 62721 540 5.961456 32.1918624 Chlamydia ibidis 1405396 Bacteria Bacteria 57 2.55e-6   NR EPP35755.1 1405396 g61529 i0 86 0.594444444444444 107 15 59.4 0 409 89 1 107 EPP35755.1 hypothetical protein CP10139811_1363 [Chlamydia ibidis] diamond 321 57 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
27293272 27293272 PRJNA1160211_S_NODE_298823_length_207_cov_8.179104_g297590_i0 PRJNA1160211 298823 207 8.179104 16.93074528 Chlamydia psittaci 83554 Bacteria Bacteria 66.2 1.61e-12   NR EPJ33662.1 1112244 g297590 i0 94.6 0.536231884057971 37 2 53.6 0 207 97 30 66 EPJ33662.1 putative membrane protein, partial [Chlamydia psittaci 06-1683] diamond 111 66.2 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
27545979 27545979 PRJNA1160211_S_NODE_28764_length_658_cov_5.603419_g27673_i0 PRJNA1160211 28764 658 5.603419 36.87049702 Chlamydia ibidis 1405396 Bacteria Bacteria 65.9 3.19e-9   NR EPP35755.1 1405396 g27673 i0 86.6 0.51063829787234 112 15 51.1 0 527 192 1 112 EPP35755.1 hypothetical protein CP10139811_1363 [Chlamydia ibidis] diamond 336 65.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
27830091 27830091 PRJNA1160211_S_NODE_242624_length_268_cov_2.138462_g241391_i0 PRJNA1160211 242624 268 2.138462 5.73107816 Chlamydia psittaci 1 83554 Bacteria Bacteria 70.5 9.57e-14   NR EPP37695.1 1238236 g241391 i0 58.5 0.727611940298508 65 25 70.5 1 57 245 13 77 EPP37695.1 hypothetical protein CP10743SC13_1219, partial [Chlamydia psittaci 10_743_SC13] diamond 195 70.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
28208819 28208819 PRJNA1160211_S_NODE_164246_length_355_cov_2.858156_g163013_i0 PRJNA1160211 164246 355 2.858156 10.1464538 Parachlamydiaceae bacterium 2052176 Bacteria Bacteria 205 1.27e-62   NR MFN4174658.1 2052176 g163013 i0 90 0.929577464788732 110 11 93 0 1 330 72 181 MFN4174658.1 hypothetical protein [Parachlamydiaceae bacterium] diamond 330 205 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae   Parachlamydiaceae bacterium
28208834 28208834 PRJNA1160211_S_NODE_280186_length_242_cov_2.733728_g278953_i0 PRJNA1160211 280186 242 2.733728 6.61562176 Chlamydia ibidis 1405396 Bacteria Bacteria 80.1 1.06e-17   NR EPP34943.1 1405396 g278953 i0 84.4 0.557851239669422 45 6 54.5 1 190 59 13 57 EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis] diamond 135 80.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
28733578 28733578 PRJNA1160211_S_NODE_237127_length_273_cov_1.760000_g235894_i0 PRJNA1160211 237127 273 1.76 4.8048 Candidatus Criblamydia 340070 Bacteria Bacteria 135 9.3e-36   NR WP_041017153.1 340071 g235894 i0 70 2.96703296703297 90 27 98.9 0 2 271 220 309 WP_041017153.1 tyrosine--tRNA ligase [Criblamydia sequanensis] diamond 810 135 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Candidatus Criblamydiaceae Candidatus Criblamydia Candidatus Criblamydia sequanensis
28777237 28777237 PRJNA1160211_S_NODE_181147_length_333_cov_1.815385_g179914_i0 PRJNA1160211 181147 333 1.815385 6.04523205 Chlamydia ibidis 1405396 Bacteria Bacteria 72.4 3.6e-14   NR EPP34943.1 1405396 g179914 i0 94.3 0.315315315315315 35 2 31.5 0 261 157 30 64 EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis] diamond 105 72.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
28891174 28891174 PRJNA1160211_S_NODE_236768_length_273_cov_3.600000_g235535_i0 PRJNA1160211 236768 273 3.6 9.828 Chlamydia 810 Bacteria Bacteria 55.5 4.45e-8   NR EPJ33784.1 1112244 g235535 i0 87.8 0.956043956043956 41 5 45.1 0 63 185 1 41 EPJ33784.1 hypothetical protein CP061683_1943, partial [Chlamydia psittaci 06-1683] diamond 261 55.8 0.99462365591397806 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29250778 29250778 PRJNA1160211_S_NODE_216369_length_293_cov_2.013636_g215136_i0 PRJNA1160211 216369 293 2.013636 5.89995348 Chlamydia psittaci 84-8471/1 1112230 Bacteria Bacteria 130 2.51e-36   NR EPP30166.1 1112230 g215136 i0 100 0.993174061433447 97 0 99.3 0 3 293 52 148 EPP30166.1 hypothetical protein CP8484711_2613, partial [Chlamydia psittaci 84-8471/1] diamond 291 130 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29345735 29345735 PRJNA1160211_S_NODE_172349_length_344_cov_4.051661_g171116_i0 PRJNA1160211 172349 344 4.051661 13.93771384 Chlamydia psittaci 84-8471/1 1112230 Bacteria Bacteria 59.7 2.21e-9   NR EPP37096.1 1112230 g171116 i0 61.2 0.427325581395349 49 19 42.7 0 204 58 2 50 EPP37096.1 hypothetical protein CP8484711_2938, partial [Chlamydia psittaci 84-8471/1] diamond 147 59.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29377253 29377253 PRJNA1160211_S_NODE_193029_length_319_cov_1.430894_g191796_i0 PRJNA1160211 193029 319 1.430894 4.56455186 Chlamydia psittaci 83554 Bacteria Bacteria 50.4 1.19e-5   NR EPJ32501.1 1112244 g191796 i0 53.6 1.09090909090909 56 12 52.7 2 6 173 9 50 EPJ32501.1 hypothetical protein CP061683_2628, partial [Chlamydia psittaci 06-1683] diamond 348 50.4 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29535133 29535133 PRJNA1160211_S_NODE_246790_length_264_cov_5.492147_g245557_i0 PRJNA1160211 246790 264 5.492147 14.49926808 Chlamydia psittaci 83554 Bacteria Bacteria 119 1.19e-32   NR EPJ33321.1 1112244 g245557 i0 100 0.681818181818182 60 0 68.2 0 1 180 53 112 EPJ33321.1 putative membrane protein [Chlamydia psittaci 06-1683] diamond 180 119 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29597936 29597936 PRJNA1160211_S_NODE_250810_length_261_cov_2.159574_g249577_i0 PRJNA1160211 250810 261 2.159574 5.63648814 Chlamydia psittaci 1 83554 Bacteria Bacteria 68.6 4.38e-13   NR EPP37534.1 1238236 g249577 i0 69.1 0.632183908045977 55 17 63.2 0 84 248 18 72 EPP37534.1 hypothetical protein CP10743SC13_1947, partial [Chlamydia psittaci 10_743_SC13] diamond 165 68.6 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29724293 29724293 PRJNA1160211_S_NODE_297230_length_214_cov_4.085106_g295997_i0 PRJNA1160211 297230 214 4.085106 8.74212684 Chlamydia psittaci 83554 Bacteria Bacteria 62 4.33e-11   NR EPJ32522.1 1112244 g295997 i0 87.1 0.434579439252336 31 4 43.5 0 214 122 7 37 EPJ32522.1 hypothetical protein CP061683_2406, partial [Chlamydia psittaci 06-1683] diamond 93 62 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
29945751 29945751 PRJNA1160211_S_NODE_282851_length_241_cov_1.267857_g281618_i0 PRJNA1160211 282851 241 1.267857 3.05553537 Chlamydia psittaci 84-8471/1 1112230 Bacteria Bacteria 75.1 4.82e-16   NR EPP38980.1 1112230 g281618 i0 80.4 0.572614107883817 46 9 57.3 0 220 83 1 46 EPP38980.1 hypothetical protein CP8484711_2377, partial [Chlamydia psittaci 84-8471/1] diamond 138 75.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
30925332 30925332 PRJNA1160211_S_NODE_292934_length_227_cov_3.889610_g291701_i0 PRJNA1160211 292934 227 3.88961 8.8294147 Chlamydia psittaci 1 83554 Bacteria Bacteria 42.7 0.00193   NR EPP35833.1 1238236 g291701 i0 55.6 0.475770925110132 36 9 47.6 1 174 67 1 29 EPP35833.1 hypothetical protein CP10743SC13_1051, partial [Chlamydia psittaci 10_743_SC13] diamond 108 42.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
30944510 30944510 PRJNA1160211_S_NODE_134294_length_398_cov_4.763077_g133062_i0 PRJNA1160211 134294 398 4.763077 18.95704646 Chlamydia 810 Bacteria Bacteria 48.5 2.99e-4   NR EPJ33321.1 1112244 g133062 i0 96.2 0.391959798994975 26 1 19.6 0 320 397 6 31 EPJ33321.1 putative membrane protein [Chlamydia psittaci 06-1683] diamond 156 48.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
31019956 31019956 PRJNA1160211_S_NODE_296035_length_218_cov_7.165517_g294802_i0 PRJNA1160211 296035 218 7.165517 15.62082706 Chlamydia ibidis 1405396 Bacteria Bacteria 49.7 4.08e-6   NR EPP35752.1 1405396 g294802 i0 84.6 0.357798165137615 26 4 35.8 0 87 10 1 26 EPP35752.1 hypothetical protein CP10139811_1360, partial [Chlamydia ibidis] diamond 78 49.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia ibidis
31272762 31272762 PRJNA1160211_S_NODE_4955_length_949_cov_11.660959_g4389_i0 PRJNA1160211 4955 949 11.660959 110.66250091 Candidatus Protochlamydia phocaeensis 1414722 Bacteria Bacteria 60.5 5.08e-6   NR WP_068470521.1 1414722 g4389 i0 54 0.322444678609062 50 23 15.8 0 14 163 321 370 WP_068470521.1 tetratricopeptide repeat protein [Candidatus Protochlamydia phocaeensis] diamond 306 60.5 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia phocaeensis
31387054 31387054 PRJNA1160211_S_NODE_165696_length_353_cov_2.821429_g164463_i0 PRJNA1160211 165696 353 2.821429 9.95964437 Chlamydia 810 Bacteria Bacteria 54.3 3.5e-7   NR EPJ31100.1 1112244 g164463 i0 65 0.679886685552408 40 11 34 1 353 234 8 44 EPJ31100.1 hypothetical protein CP061683_2291 [Chlamydia psittaci 06-1683] diamond 240 54.3 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
32095156 32095156 PRJNA1160211_S_NODE_279998_length_242_cov_3.934911_g278765_i0 PRJNA1160211 279998 242 3.934911 9.52248462 Chlamydia psittaci 83554 Bacteria Bacteria 53.9 1.05e-7   NR EPJ31051.1 1112244 g278765 i0 91.3 0.285123966942149 23 2 28.5 0 2 70 20 42 EPJ31051.1 hypothetical protein CP061683_2336 [Chlamydia psittaci 06-1683] diamond 69 53.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
32411688 32411688 PRJNA1160211_S_NODE_147439_length_378_cov_5.940984_g146206_i0 PRJNA1160211 147439 378 5.940984 22.45691952 Chlamydia psittaci 1 83554 Bacteria Bacteria 45.1 0.00251   NR EPP35796.1 1238236 g146206 i0 92.6 0.214285714285714 27 2 21.4 0 290 370 6 32 EPP35796.1 putative membrane protein, partial [Chlamydia psittaci 10_743_SC13] diamond 81 45.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
32632474 32632474 PRJNA1160211_S_NODE_153180_length_370_cov_4.131313_g151947_i0 PRJNA1160211 153180 370 4.131313 15.2858581 Chlamydiota bacterium 2081524 Bacteria Bacteria 151 4.45e-40   NR NGX38743.1 2081524 g151947 i0 74.2 3.91621621621622 97 25 78.6 0 80 370 1 97 NGX38743.1 UvrABC system protein C [Chlamydiota bacterium] diamond 1449 151 1 Bacteria PVC group Pseudomonadati Chlamydiota         Chlamydiota bacterium
32758698 32758698 PRJNA1160211_S_NODE_270380_length_247_cov_3.362069_g269147_i0 PRJNA1160211 270380 247 3.362069 8.30431043 Chlamydia psittaci 83554 Bacteria Bacteria 62.8 3.58e-11   NR EPP28211.1 1112246 g269147 i0 66.7 0.510121457489879 42 14 51 0 37 162 1 42 EPP28211.1 hypothetical protein CP082626L3_1479, partial [Chlamydia psittaci 08-2626_L3] diamond 126 62.8 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci
32884492 32884492 PRJNA1160211_S_NODE_165700_length_353_cov_2.796429_g164467_i0 PRJNA1160211 165700 353 2.796429 9.87139437 Chlamydia psittaci 1 83554 Bacteria Bacteria 79.3 3.15e-17   NR EPP37696.1 1238236 g164467 i0 97.1 0.288951841359773 34 1 28.9 0 193 294 1 34 EPP37696.1 hypothetical protein CP10743SC13_1220, partial [Chlamydia psittaci 10_743_SC13] diamond 102 79.3 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia psittaci

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);;