contig_metadata
22 rows where bioproject = "PRJNA704949" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1975956 | 1975956 | PRJNA704949_P_NODE_685262_length_326_cov_1.202166_g669934_i0 | PRJNA704949 | 685262 | 326 | 1.202166 | 3.91906116 | Kiritimatiella glycovorans | 1307763 | Bacteria | Bacteria | 58.4 | 6.59e-4 | NTclustered | gi|827038732|gb|CP010904.1| | 1307763 | g669934 | i0 | 89.13 | 0.141104294478528 | 46 | 5 | 14 | 0 | 182 | 227 | 575168 | 575213 | Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome | blastn | 46 | 58.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellaceae | Kiritimatiella | Kiritimatiella glycovorans | |
| 9622682 | 9622682 | PRJNA704949_P_NODE_201408_length_584_cov_2.302804_g187246_i0 | PRJNA704949 | 201408 | 584 | 2.302804 | 13.44837536 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 174 | 2.76e-49 | NR | MBC8207032.1 | 2599938 | g187246 | i0 | 50 | 12.4931506849315 | 188 | 92 | 96.1 | 2 | 568 | 8 | 77 | 263 | MBC8207032.1 mechanosensitive ion channel family protein [Kiritimatiellota bacterium] | diamond | 7296 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium | |||||
| 18547737 | 18547737 | PRJNA704949_P_NODE_268895_length_515_cov_3.306867_g254242_i0 | PRJNA704949 | 268895 | 515 | 3.306867 | 17.03036505 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 136 | 1e-37 | NR | MBO7684667.1 | 2212473 | g254242 | i0 | 54.5 | 2.29514563106796 | 132 | 55 | 76.9 | 1 | 20 | 415 | 16 | 142 | MBO7684667.1 dUTP diphosphatase [Kiritimatiellia bacterium] | diamond | 1182 | 136 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26702972 | 26702972 | PRJNA704949_P_NODE_1435441_length_207_cov_1.031646_g1420103_i0 | PRJNA704949 | 1435441 | 207 | 1.031646 | 2.13550722 | Kiritimatiellaeota bacterium B1221 | 3033806 | Bacteria | Bacteria | 61.2 | 4.33e-9 | NR | MDF3129321.1 | 3033806 | g1420103 | i0 | 54 | 0.91304347826087 | 63 | 25 | 91.3 | 1 | 18 | 206 | 7 | 65 | MDF3129321.1 PEP-CTERM sorting domain-containing protein [Kiritimatiellaeota bacterium B1221] | diamond | 189 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellaeota bacterium B1221 | |||||
| 28030472 | 28030472 | PRJNA704949_P_NODE_1068185_length_250_cov_1.293532_g1052849_i0 | PRJNA704949 | 1068185 | 250 | 1.293532 | 3.23383 | Kiritimatiellaeota bacterium B1221 | 3033806 | Bacteria | Bacteria | 57.8 | 2.15e-7 | NR | MDF3128428.1 | 3033806 | g1052849 | i0 | 65.9 | 1.356 | 44 | 15 | 52.8 | 0 | 166 | 35 | 2325 | 2368 | MDF3128428.1 autotransporter-associated beta strand repeat-containing protein [Kiritimatiellaeota bacterium B1221] | diamond | 339 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellaeota bacterium B1221 | |||||
| 28220244 | 28220244 | PRJNA704949_P_NODE_885626_length_280_cov_2.086580_g870292_i0 | PRJNA704949 | 885626 | 280 | 2.08658 | 5.842424 | Kiritimatiella glycovorans | 1307763 | Bacteria | Bacteria | 45.4 | 0.00515 | NR | WP_052880872.1 | 1307763 | g870292 | i0 | 37.9 | 0.621428571428571 | 58 | 36 | 62.1 | 0 | 176 | 3 | 8 | 65 | WP_052880872.1 PulJ/GspJ family protein [Kiritimatiella glycovorans] | diamond | 174 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellaceae | Kiritimatiella | Kiritimatiella glycovorans | |
| 28535847 | 28535847 | PRJNA704949_P_NODE_1206527_length_231_cov_2.000000_g1191190_i0 | PRJNA704949 | 1206527 | 231 | 2 | 4.62 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 121 | 3.6899999999999996e-32 | NR | MDD2239908.1 | 2212473 | g1191190 | i0 | 80.9 | 2.66233766233766 | 68 | 13 | 88.3 | 0 | 230 | 27 | 128 | 195 | MDD2239908.1 glycosyltransferase family 2 protein [Kiritimatiellia bacterium] | diamond | 615 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28694158 | 28694158 | PRJNA704949_P_NODE_535167_length_372_cov_1.857585_g519872_i0 | PRJNA704949 | 535167 | 372 | 1.857585 | 6.9102162 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 58.5 | 4.85e-7 | NR | HMP73026.1 | 2212473 | g519872 | i0 | 42 | 1.91935483870968 | 119 | 62 | 92.7 | 4 | 24 | 368 | 1145 | 1260 | HMP73026.1 autotransporter-associated beta strand repeat-containing protein [Kiritimatiellia bacterium] | diamond | 714 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28756748 | 28756748 | PRJNA704949_P_NODE_1688607_length_186_cov_1.138686_g1673268_i0 | PRJNA704949 | 1688607 | 186 | 1.138686 | 2.11795596 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 47.8 | 3.01e-4 | NR | MBP7829183.1 | 2212473 | g1673268 | i0 | 44 | 0.806451612903226 | 50 | 28 | 80.6 | 0 | 153 | 4 | 29 | 78 | MBP7829183.1 selenide, water dikinase SelD [Kiritimatiellia bacterium] | diamond | 150 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28788327 | 28788327 | PRJNA704949_P_NODE_1991407_length_167_cov_1.322034_g1976068_i0 | PRJNA704949 | 1991407 | 167 | 1.322034 | 2.20779678 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 72.8 | 1.06e-13 | NR | MFO1529897.1 | 2212473 | g1976068 | i0 | 61.2 | 1.76047904191617 | 49 | 19 | 88 | 0 | 151 | 5 | 51 | 99 | MFO1529897.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 294 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28788420 | 28788420 | PRJNA704949_P_NODE_274467_length_511_cov_1.677489_g259793_i0 | PRJNA704949 | 274467 | 511 | 1.677489 | 8.57196879 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 126 | 2.5599999999999997e-31 | NR | HMP76775.1 | 2212473 | g259793 | i0 | 49.6 | 0.7573385518591 | 129 | 65 | 75.7 | 0 | 19 | 405 | 258 | 386 | HMP76775.1 glycosyltransferase [Kiritimatiellia bacterium] | diamond | 387 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29609096 | 29609096 | PRJNA704949_P_NODE_2120330_length_163_cov_1.640351_g2104991_i0 | PRJNA704949 | 2120330 | 163 | 1.640351 | 2.67377213 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 59.3 | 1.66e-8 | NR | MDD3605177.1 | 2212473 | g2104991 | i0 | 46.3 | 3.86503067484663 | 54 | 29 | 99.4 | 0 | 162 | 1 | 103 | 156 | MDD3605177.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 630 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29651377 | 29651377 | PRJNA704949_P_NODE_1197970_length_232_cov_2.087432_g1182633_i0 | PRJNA704949 | 1197970 | 232 | 2.087432 | 4.84284224 | Bacteria | 2 | Bacteria | Bacteria | 90.1 | 6.280000000000001e-19 | NR | MBQ9430464.1 | 2212473 | g1182633 | i0 | 60 | 7.24137931034483 | 70 | 28 | 90.5 | 0 | 23 | 232 | 85 | 154 | MBQ9430464.1 YifB family Mg chelatase-like AAA ATPase [Kiritimatiellia bacterium] | diamond | 1680 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30020188 | 30020188 | PRJNA704949_P_NODE_2179651_length_162_cov_0.920354_g2164312_i0 | PRJNA704949 | 2179651 | 162 | 0.920354 | 1.49097348 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 46.6 | 5.39e-4 | NR | MDD5520362.1 | 2212473 | g2164312 | i0 | 44.9 | 2.72222222222222 | 49 | 27 | 90.7 | 0 | 15 | 161 | 1493 | 1541 | MDD5520362.1 Calx-beta domain-containing protein [Kiritimatiellia bacterium] | diamond | 441 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31062849 | 31062849 | PRJNA704949_P_NODE_2009555_length_167_cov_0.881356_g1994216_i0 | PRJNA704949 | 2009555 | 167 | 0.881356 | 1.47186452 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 52 | 4.54e-6 | NR | MBR4170762.1 | 2212473 | g1994216 | i0 | 41.4 | 1.04191616766467 | 58 | 28 | 95.2 | 2 | 166 | 8 | 124 | 180 | MBR4170762.1 DUF1080 domain-containing protein [Kiritimatiellia bacterium] | diamond | 174 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31094076 | 31094076 | PRJNA704949_P_NODE_1615575_length_191_cov_2.098592_g1600236_i0 | PRJNA704949 | 1615575 | 191 | 2.098592 | 4.00831072 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 42.4 | 0.0151 | NR | MBQ3343631.1 | 2212473 | g1600236 | i0 | 38.9 | 0.848167539267016 | 54 | 31 | 81.7 | 1 | 163 | 8 | 51 | 104 | MBQ3343631.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 162 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31231242 | 31231242 | PRJNA704949_P_NODE_1594975_length_193_cov_1.368056_g1579636_i0 | PRJNA704949 | 1594975 | 193 | 1.368056 | 2.64034808 | PVC group | 1783257 | Bacteria | Bacteria | 101 | 3.8199999999999996e-23 | NR | MBQ3342643.1 | 2212473 | g1579636 | i0 | 78.1 | 2.98445595854922 | 64 | 14 | 99.5 | 0 | 1 | 192 | 397 | 460 | MBQ3342643.1 IS21 family transposase [Kiritimatiellia bacterium] | diamond | 576 | 102 | 0.990196078431373 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32043049 | 32043049 | PRJNA704949_P_NODE_1866278_length_173_cov_1.258065_g1850939_i0 | PRJNA704949 | 1866278 | 173 | 1.258065 | 2.17645245 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 54.3 | 5.93e-7 | NR | MBR3086725.1 | 2212473 | g1850939 | i0 | 47.5 | 4.09248554913295 | 59 | 29 | 98.8 | 1 | 173 | 3 | 12 | 70 | MBR3086725.1 aminoacyl-tRNA hydrolase [Kiritimatiellia bacterium] | diamond | 708 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32137882 | 32137882 | PRJNA704949_P_NODE_1560898_length_196_cov_1.054422_g1545559_i0 | PRJNA704949 | 1560898 | 196 | 1.054422 | 2.06666712 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 58.5 | 9.51e-9 | NR | MDP6490989.1 | 2212473 | g1545559 | i0 | 46.8 | 2.8469387755102 | 62 | 33 | 94.9 | 0 | 5 | 190 | 6 | 67 | MDP6490989.1 dual specificity protein phosphatase family protein [Kiritimatiellia bacterium] | diamond | 558 | 58.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32201141 | 32201141 | PRJNA704949_P_NODE_1474018_length_203_cov_1.636364_g1458680_i0 | PRJNA704949 | 1474018 | 203 | 1.636364 | 3.32181892 | Kiritimatiellota bacterium B12222 | 3040511 | Bacteria | Bacteria | 58.9 | 2.95e-8 | NR | WFB36881.1 | 3040511 | g1458680 | i0 | 48.5 | 1.00492610837438 | 68 | 30 | 94.6 | 2 | 4 | 195 | 194 | 260 | WFB36881.1 hypothetical protein P3T73_03780 [Kiritimatiellota bacterium B12222] | diamond | 204 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium B12222 | |||||
| 32265015 | 32265015 | PRJNA704949_P_NODE_584798_length_355_cov_2.003268_g569481_i0 | PRJNA704949 | 584798 | 355 | 2.003268 | 7.1116014 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 121 | 9.389999999999999e-30 | NR | HRT29951.1 | 2212473 | g569481 | i0 | 71.1 | 0.642253521126761 | 76 | 22 | 64.2 | 0 | 243 | 16 | 85 | 160 | HRT29951.1 terminase family protein [Kiritimatiellia bacterium] | diamond | 228 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32843510 | 32843510 | PRJNA704949_P_NODE_508460_length_382_cov_1.651652_g493193_i0 | PRJNA704949 | 508460 | 382 | 1.651652 | 6.30931064 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 120 | 4.28e-30 | NR | HMP90179.1 | 2212473 | g493193 | i0 | 44.4 | 4.26439790575916 | 135 | 65 | 98.2 | 2 | 1 | 375 | 36 | 170 | HMP90179.1 zinc ABC transporter substrate-binding protein [Kiritimatiellia bacterium] | diamond | 1629 | 120 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium |
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);;