contig_metadata
27 rows where bioproject = "PRJNA473799", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4923844 | 4923844 | PRJNA473799_P_NODE_27624_length_263_cov_1.621053_g27350_i0 | PRJNA473799 | 27624 | 263 | 1.621053 | 4.26336939 | Neochlamydia | 112987 | Bacteria | Bacteria | 259 | 1.32e-64 | NTclustered | gi|194594624|gb|EU662269.1| | 112235 | g27350 | i0 | 87.611 | 129.125475285171 | 226 | 24 | 86 | 4 | 1 | 225 | 2201 | 1979 | Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence | blastn | 33960 | 259 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Neochlamydia | Neochlamydia hartmannellae | |
| 6823340 | 6823340 | PRJNA473799_P_NODE_34026_length_252_cov_1.117318_g33752_i0 | PRJNA473799 | 34026 | 252 | 1.117318 | 2.81564136 | Estrella lausannensis | 483423 | Bacteria | Bacteria | 178 | 3.61e-40 | NTclustered | gi|343183590|gb|JN201889.1| | 483423 | g33752 | i0 | 86.875 | 103.111111111111 | 160 | 19 | 63 | 2 | 14 | 172 | 2281 | 2439 | Estrella lausannensis 23S ribosomal RNA gene, complete sequence | blastn | 25984 | 178 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Candidatus Criblamydiaceae | Estrella | Estrella lausannensis | |
| 7473821 | 7473821 | PRJNA473799_P_NODE_45446_length_245_cov_1.488372_g45172_i0 | PRJNA473799 | 45446 | 245 | 1.488372 | 3.6465114 | Parachlamydia | 83551 | Bacteria | Bacteria | 375 | 1.16e-99 | NTclustered | gi|470491594|ref|NR_077046.1| | 83552 | g45172 | i0 | 94.309 | 134.673469387755 | 246 | 13 | 100 | 1 | 1 | 245 | 784 | 1029 | Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence | blastn | 32995 | 375 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia acanthamoebae | |
| 24047594 | 24047594 | PRJNA473799_P_NODE_23919_length_270_cov_1.974619_g23645_i0 | PRJNA473799 | 23919 | 270 | 1.974619 | 5.3314713 | Parachlamydiaceae | 92713 | Bacteria | Bacteria | 370 | 6.02e-98 | NTclustered | gi|470491594|ref|NR_077046.1| | 83552 | g23645 | i0 | 92.045 | 169.474074074074 | 264 | 20 | 98 | 1 | 1 | 264 | 919 | 1181 | Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence | blastn | 45758 | 372 | 0.99462365591397806 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia acanthamoebae | |
| 26981224 | 26981224 | PRJNA473799_P_NODE_27402_length_264_cov_1.052356_g27128_i0 | PRJNA473799 | 27402 | 264 | 1.052356 | 2.77821984 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 89.7 | 1.66e-21 | NR | EPJ15176.1 | 1112252 | g27128 | i0 | 73.8 | 1.52272727272727 | 61 | 16 | 69.3 | 0 | 51 | 233 | 4 | 64 | EPJ15176.1 nef attachable domain protein [Chlamydia psittaci 01DC11] | diamond | 402 | 90.5 | 0.991160220994475 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 26981227 | 26981227 | PRJNA473799_P_NODE_30942_length_257_cov_1.581522_g30668_i0 | PRJNA473799 | 30942 | 257 | 1.581522 | 4.06451154 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 55.8 | 1.86e-8 | NR | EPL02241.1 | 1112270 | g30668 | i0 | 78.8 | 0.385214007782101 | 33 | 7 | 38.5 | 0 | 139 | 237 | 1 | 33 | EPL02241.1 hypothetical protein CP09DC79_1187, partial [Chlamydia psittaci 09DC79] | diamond | 99 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 27218535 | 27218535 | PRJNA473799_P_NODE_49682_length_243_cov_0.947059_g49408_i0 | PRJNA473799 | 49682 | 243 | 0.947059 | 2.30135337 | Chlamydia | 810 | Bacteria | Bacteria | 44.7 | 8.16e-4 | NR | EPP32998.1 | 1112249 | g49408 | i0 | 50 | 2.24691358024691 | 46 | 17 | 56.8 | 1 | 91 | 228 | 9 | 48 | EPP32998.1 nef attachable domain protein, partial [Chlamydia psittaci C6/98] | diamond | 546 | 45.1 | 0.991130820399113 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 27360858 | 27360858 | PRJNA473799_P_NODE_9263_length_349_cov_0.978261_g8989_i0 | PRJNA473799 | 9263 | 349 | 0.978261 | 3.41413089 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 40.8 | 0.0376 | NR | EPJ27361.1 | 1112269 | g8989 | i0 | 76.9 | 0.223495702005731 | 26 | 6 | 22.3 | 0 | 3 | 80 | 6 | 31 | EPJ27361.1 nef attachable domain protein [Chlamydia psittaci 09DC78] | diamond | 78 | 40.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 27455603 | 27455603 | PRJNA473799_P_NODE_10903_length_319_cov_1.353659_g10629_i0 | PRJNA473799 | 10903 | 319 | 1.353659 | 4.31817221 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 64.3 | 1.87e-11 | NR | EPJ22990.1 | 1112267 | g10629 | i0 | 83.3 | 0.338557993730408 | 36 | 6 | 33.9 | 0 | 110 | 217 | 2 | 37 | EPJ22990.1 hypothetical protein CP08DC60_1241 [Chlamydia psittaci 08DC60] | diamond | 108 | 64.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 27834210 | 27834210 | PRJNA473799_P_NODE_38984_length_249_cov_0.875000_g38710_i0 | PRJNA473799 | 38984 | 249 | 0.875 | 2.17875 | Chlamydia psittaci C6/98 | 1112249 | Bacteria | Bacteria | 70.9 | 2.82e-14 | NR | EPP32891.1 | 1112249 | g38710 | i0 | 76.7 | 0.518072289156627 | 43 | 10 | 51.8 | 0 | 131 | 3 | 1 | 43 | EPP32891.1 nef attachable domain protein [Chlamydia psittaci C6/98] | diamond | 129 | 70.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 28749976 | 28749976 | PRJNA473799_P_NODE_35087_length_251_cov_0.865169_g34813_i0 | PRJNA473799 | 35087 | 251 | 0.865169 | 2.17157419 | Chlamydiota bacterium | 2081524 | Bacteria | Bacteria | 86.7 | 5.73e-18 | NR | MEC7838608.1 | 2081524 | g34813 | i0 | 48.8 | 1.87649402390438 | 82 | 42 | 98 | 0 | 249 | 4 | 37 | 118 | MEC7838608.1 NUDIX domain-containing protein [Chlamydiota bacterium] | diamond | 471 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 29097369 | 29097369 | PRJNA473799_P_NODE_27708_length_263_cov_1.431579_g27434_i0 | PRJNA473799 | 27708 | 263 | 1.431579 | 3.76505277 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 60.8 | 2.58e-10 | NR | EPJ26271.1 | 1112262 | g27434 | i0 | 66.7 | 0.479087452471483 | 42 | 14 | 47.9 | 0 | 208 | 83 | 3 | 44 | EPJ26271.1 nef attachable domain protein, partial [Chlamydia psittaci 03DC29] | diamond | 126 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29192104 | 29192104 | PRJNA473799_P_NODE_35209_length_251_cov_0.865169_g34935_i0 | PRJNA473799 | 35209 | 251 | 0.865169 | 2.17157419 | Chlamydia psittaci C1/97 | 1112248 | Bacteria | Bacteria | 62.8 | 4.12e-11 | NR | EPP30779.1 | 1112248 | g34935 | i0 | 70.5 | 1.50597609561753 | 44 | 13 | 52.6 | 0 | 159 | 28 | 4 | 47 | EPP30779.1 nef attachable domain protein, partial [Chlamydia psittaci C1/97] | diamond | 378 | 62.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29223750 | 29223750 | PRJNA473799_P_NODE_48449_length_244_cov_0.900585_g48175_i0 | PRJNA473799 | 48449 | 244 | 0.900585 | 2.1974274 | Chlamydia psittaci C6/98 | 1112249 | Bacteria | Bacteria | 43.9 | 0.00118 | NR | EPP32891.1 | 1112249 | g48175 | i0 | 47.7 | 0.540983606557377 | 44 | 23 | 54.1 | 0 | 184 | 53 | 8 | 51 | EPP32891.1 nef attachable domain protein [Chlamydia psittaci C6/98] | diamond | 132 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29412886 | 29412886 | PRJNA473799_P_NODE_43209_length_247_cov_0.620690_g42935_i0 | PRJNA473799 | 43209 | 247 | 0.62069 | 1.5331043 | Chlamydia psittaci C6/98 | 1112249 | Bacteria | Bacteria | 67.8 | 6.06e-13 | NR | EPP32773.1 | 1112249 | g42935 | i0 | 60.3 | 0.765182186234818 | 63 | 10 | 58.3 | 1 | 160 | 17 | 1 | 63 | EPP32773.1 putative lipoprotein, partial [Chlamydia psittaci C6/98] | diamond | 189 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29444354 | 29444354 | PRJNA473799_P_NODE_41670_length_247_cov_1.609195_g41396_i0 | PRJNA473799 | 41670 | 247 | 1.609195 | 3.97471165 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 40.8 | 0.0197 | NR | EPJ17938.1 | 1112257 | g41396 | i0 | 50 | 0.437246963562753 | 36 | 18 | 43.7 | 0 | 113 | 220 | 6 | 41 | EPJ17938.1 hypothetical protein CP02DC21_1499 [Chlamydia psittaci 02DC21] | diamond | 108 | 40.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 29633619 | 29633619 | PRJNA473799_P_NODE_27550_length_263_cov_1.989474_g27276_i0 | PRJNA473799 | 27550 | 263 | 1.989474 | 5.23231662 | Chlamydia trachomatis | 813 | Bacteria | Bacteria | 76.6 | 3.6e-16 | NR | WP_216594844.1 | 813 | g27276 | i0 | 43 | 0.901140684410646 | 79 | 45 | 90.1 | 0 | 25 | 261 | 1 | 79 | WP_216594844.1 hypothetical protein, partial [Chlamydia trachomatis] | diamond | 237 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia trachomatis | |
| 29886792 | 29886792 | PRJNA473799_P_NODE_27931_length_263_cov_1.084211_g27657_i0 | PRJNA473799 | 27931 | 263 | 1.084211 | 2.85147493 | Chlamydia psittaci C1/97 | 1112248 | Bacteria | Bacteria | 77.4 | 9.66e-17 | NR | EPP30549.1 | 1112248 | g27657 | i0 | 67.3 | 0.593155893536122 | 52 | 17 | 59.3 | 0 | 178 | 23 | 5 | 56 | EPP30549.1 hypothetical protein CPC197_1956 [Chlamydia psittaci C1/97] | diamond | 156 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 30565949 | 30565949 | PRJNA473799_P_NODE_18693_length_281_cov_1.466346_g18419_i0 | PRJNA473799 | 18693 | 281 | 1.466346 | 4.12043226 | Chlamydia | 810 | Bacteria | Bacteria | 47.4 | 1.01e-4 | NR | EPP30345.1 | 1112248 | g18419 | i0 | 41 | 1.12099644128114 | 61 | 36 | 65.1 | 0 | 47 | 229 | 2 | 62 | EPP30345.1 nef attachable domain protein, partial [Chlamydia psittaci C1/97] | diamond | 315 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 30613201 | 30613201 | PRJNA473799_P_NODE_48013_length_244_cov_0.900585_g47739_i0 | PRJNA473799 | 48013 | 244 | 0.900585 | 2.1974274 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 43.1 | 0.00353 | NR | EPL02381.1 | 1112253 | g47739 | i0 | 65.6 | 0.39344262295082 | 32 | 11 | 39.3 | 0 | 87 | 182 | 41 | 72 | EPL02381.1 hypothetical protein CP02DC14_1897 [Chlamydia psittaci 02DC14] | diamond | 96 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 30866012 | 30866012 | PRJNA473799_P_NODE_34634_length_251_cov_1.157303_g34360_i0 | PRJNA473799 | 34634 | 251 | 1.157303 | 2.90483053 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 42.7 | 0.00358 | NR | EPJ15232.1 | 1112256 | g34360 | i0 | 76 | 0.597609561752988 | 25 | 6 | 29.9 | 0 | 108 | 34 | 28 | 52 | EPJ15232.1 putative nef attachable protein, partial [Chlamydia psittaci 02DC18] | diamond | 150 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 30960982 | 30960982 | PRJNA473799_P_NODE_15394_length_288_cov_2.190698_g15120_i0 | PRJNA473799 | 15394 | 288 | 2.190698 | 6.30921024 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 53.9 | 2.13e-7 | NR | EPJ27355.1 | 1112269 | g15120 | i0 | 54 | 0.520833333333333 | 50 | 23 | 52.1 | 0 | 21 | 170 | 2 | 51 | EPJ27355.1 nef attachable domain protein [Chlamydia psittaci 09DC78] | diamond | 150 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31024131 | 31024131 | PRJNA473799_P_NODE_56395_length_231_cov_3.006329_g56121_i0 | PRJNA473799 | 56395 | 231 | 3.006329 | 6.94461999 | Chlamydia psittaci C6/98 | 1112249 | Bacteria | Bacteria | 56.2 | 1.77e-8 | NR | EPP32773.1 | 1112249 | g56121 | i0 | 54.4 | 0.74025974025974 | 57 | 23 | 74 | 1 | 220 | 50 | 1 | 54 | EPP32773.1 putative lipoprotein, partial [Chlamydia psittaci C6/98] | diamond | 171 | 56.2 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31403572 | 31403572 | PRJNA473799_P_NODE_40176_length_248_cov_0.931429_g39902_i0 | PRJNA473799 | 40176 | 248 | 0.931429 | 2.30994392 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 71.6 | 1.87e-14 | NR | EPL02186.1 | 1112270 | g39902 | i0 | 64.3 | 0.508064516129032 | 42 | 15 | 50.8 | 0 | 245 | 120 | 23 | 64 | EPL02186.1 nef attachable domain protein, partial [Chlamydia psittaci 09DC79] | diamond | 126 | 71.6 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31940974 | 31940974 | PRJNA473799_P_NODE_54197_length_241_cov_0.916667_g53923_i0 | PRJNA473799 | 54197 | 241 | 0.916667 | 2.20916747 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 82 | 1.35e-18 | NR | EPJ15176.1 | 1112252 | g53923 | i0 | 75.9 | 1.38174273858921 | 58 | 14 | 72.2 | 0 | 24 | 197 | 4 | 61 | EPJ15176.1 nef attachable domain protein [Chlamydia psittaci 01DC11] | diamond | 333 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 31972791 | 31972791 | PRJNA473799_P_NODE_8438_length_369_cov_2.385135_g8164_i0 | PRJNA473799 | 8438 | 369 | 2.385135 | 8.80114815 | Chlamydia psittaci | 83554 | Bacteria | Bacteria | 50.8 | 8.09e-6 | NR | EPJ15232.1 | 1112256 | g8164 | i0 | 62.5 | 0.390243902439024 | 48 | 18 | 39 | 0 | 217 | 360 | 1 | 48 | EPJ15232.1 putative nef attachable protein, partial [Chlamydia psittaci 02DC18] | diamond | 144 | 50.8 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci | |
| 32305670 | 32305670 | PRJNA473799_P_NODE_14199_length_292_cov_1.054795_g13925_i0 | PRJNA473799 | 14199 | 292 | 1.054795 | 3.0800014 | Chlamydia | 810 | Bacteria | Bacteria | 48.1 | 4.97e-5 | NR | EPP30515.1 | 1112248 | g13925 | i0 | 91.7 | 0.493150684931507 | 24 | 2 | 24.7 | 0 | 150 | 221 | 1 | 24 | EPP30515.1 hypothetical protein CPC197_2045, partial [Chlamydia psittaci C1/97] | diamond | 144 | 48.1 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiaceae | Chlamydia | Chlamydia psittaci |
Advanced export
JSON shape: default, array, newline-delimited
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);;