contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26594684 | 26594684 | PRJNA1120060_P_NODE_399901_length_389_cov_1.917722_g382485_i0 | PRJNA1120060 | 399901 | 389 | 1.917722 | 7.45993858 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 48.1 | 6.18e-4 | NR | MCX6121772.1 | 2049428 | g382485 | i0 | 41.9 | 0.331619537275064 | 43 | 25 | 33.2 | 0 | 301 | 173 | 36 | 78 | MCX6121772.1 ribonuclease HI family protein [Ignavibacteriales bacterium] | diamond | 129 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 27258875 | 27258875 | PRJNA1120060_P_NODE_2648323_length_250_cov_0.870056_g2630243_i0 | PRJNA1120060 | 2648323 | 250 | 0.870056 | 2.17514 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 75.9 | 6.07e-14 | NR | MDP3444116.1 | 2053306 | g2630243 | i0 | 47 | 0.996 | 83 | 42 | 97.2 | 1 | 245 | 3 | 20 | 102 | MDP3444116.1 IPT/TIG domain-containing protein [Ignavibacteria bacterium] | diamond | 249 | 75.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27290106 | 27290106 | PRJNA1120060_P_NODE_2147043_length_267_cov_1.484536_g2128997_i0 | PRJNA1120060 | 2147043 | 267 | 1.484536 | 3.96371112 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 55.5 | 3.16e-7 | NR | HEY3251302.1 | 2053306 | g2128997 | i0 | 54 | 1.1685393258427 | 50 | 23 | 56.2 | 0 | 168 | 19 | 6 | 55 | HEY3251302.1 ribonuclease HI family protein [Ignavibacteria bacterium] | diamond | 312 | 55.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27543316 | 27543316 | PRJNA1120060_P_NODE_2836444_length_245_cov_1.686047_g2818358_i0 | PRJNA1120060 | 2836444 | 245 | 1.686047 | 4.13081515 | Ignavibacteria bacterium GWA2_55_25 | 1798422 | Bacteria | Bacteria | 50.8 | 1.73e-5 | NR | OGU18515.1 | 1798422 | g2818358 | i0 | 41.4 | 1.37142857142857 | 58 | 34 | 71 | 0 | 243 | 70 | 24 | 81 | OGU18515.1 MAG: hypothetical protein A2059_01000 [Ignavibacteria bacterium GWA2_55_25] | diamond | 336 | 50.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWA2_55_25 | ||||
| 27921330 | 27921330 | PRJNA1120060_P_NODE_1746325_length_283_cov_1.757143_g1728317_i0 | PRJNA1120060 | 1746325 | 283 | 1.757143 | 4.97271469 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 43.5 | 0.0321 | NR | HEY3250293.1 | 2053306 | g1728317 | i0 | 31.5 | 0.943462897526502 | 89 | 55 | 93.3 | 3 | 10 | 273 | 61 | 144 | HEY3250293.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 267 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28016637 | 28016637 | PRJNA1120060_P_NODE_2280085_length_262_cov_1.375661_g2262030_i0 | PRJNA1120060 | 2280085 | 262 | 1.375661 | 3.60423182 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 43.1 | 0.0362 | NR | MBM2817197.1 | 2053306 | g2262030 | i0 | 52.8 | 0.412213740458015 | 36 | 17 | 41.2 | 0 | 226 | 119 | 158 | 193 | MBM2817197.1 gliding motility-related protein [Ignavibacteria bacterium] | diamond | 108 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28553317 | 28553317 | PRJNA1120060_P_NODE_2169367_length_266_cov_1.922280_g2151318_i0 | PRJNA1120060 | 2169367 | 266 | 1.92228 | 5.1132648 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 126 | 6.43e-32 | NR | MDH3251311.1 | 2053306 | g2151318 | i0 | 67 | 2.97744360902256 | 88 | 29 | 99.2 | 0 | 1 | 264 | 158 | 245 | MDH3251311.1 phosphoglycerate dehydrogenase [Ignavibacteria bacterium] | diamond | 792 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28900764 | 28900764 | PRJNA1120060_P_NODE_2824888_length_245_cov_2.959302_g2806802_i0 | PRJNA1120060 | 2824888 | 245 | 2.959302 | 7.2502899 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 43.1 | 0.0281 | NR | MBK7103742.1 | 2026749 | g2806802 | i0 | 33.9 | 0.685714285714286 | 56 | 37 | 68.6 | 0 | 225 | 58 | 244 | 299 | MBK7103742.1 GH92 family glycosyl hydrolase [Ignavibacteriota bacterium] | diamond | 168 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28931628 | 28931628 | PRJNA1120060_P_NODE_1436428_length_296_cov_3.470852_g1418444_i0 | PRJNA1120060 | 1436428 | 296 | 3.470852 | 10.27372192 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 42 | 0.0431 | NR | MBE2216761.1 | 2053306 | g1418444 | i0 | 37.1 | 0.709459459459459 | 70 | 39 | 68.9 | 2 | 1 | 204 | 33 | 99 | MBE2216761.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 210 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28932631 | 28932631 | PRJNA1120060_P_NODE_2930428_length_243_cov_0.917647_g2912335_i0 | PRJNA1120060 | 2930428 | 243 | 0.917647 | 2.22988221 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 51.2 | 9.34e-6 | NR | MCX6121772.1 | 2049428 | g2912335 | i0 | 40 | 0.864197530864197 | 70 | 35 | 86.4 | 2 | 242 | 33 | 36 | 98 | MCX6121772.1 ribonuclease HI family protein [Ignavibacteriales bacterium] | diamond | 210 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 29216202 | 29216202 | PRJNA1120060_P_NODE_1850229_length_279_cov_1.126214_g1832214_i0 | PRJNA1120060 | 1850229 | 279 | 1.126214 | 3.14213706 | Ignavibacteriales bacterium UTCHB3 | 1961106 | Bacteria | Bacteria | 42.7 | 0.0103 | NR | OQY72807.1 | 1961106 | g1832214 | i0 | 53.5 | 0.462365591397849 | 43 | 17 | 46.2 | 1 | 120 | 248 | 13 | 52 | OQY72807.1 MAG: hypothetical protein B6D45_08775, partial [Ignavibacteriales bacterium UTCHB3] | diamond | 129 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium UTCHB3 | |||
| 29427454 | 29427454 | PRJNA1120060_P_NODE_350609_length_402_cov_4.155015_g333329_i0 | PRJNA1120060 | 350609 | 402 | 4.155015 | 16.7031603 | Ignavibacterium | 795750 | Bacteria | Bacteria | 53.5 | 6.28e-6 | NR | MBI3004544.1 | 2049428 | g333329 | i0 | 39.1 | 1.83582089552239 | 64 | 39 | 47.8 | 0 | 198 | 389 | 18 | 81 | MBI3004544.1 ribonuclease HI family protein [Ignavibacteriales bacterium] | diamond | 738 | 53.9 | 0.992578849721707 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 29531648 | 29531648 | PRJNA1120060_P_NODE_1662970_length_286_cov_3.849765_g1644969_i0 | PRJNA1120060 | 1662970 | 286 | 3.849765 | 11.0103279 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 43.1 | 0.0419 | NR | MDQ7817722.1 | 2614255 | g1644969 | i0 | 37.3 | 0.786713286713287 | 75 | 40 | 78.7 | 2 | 8 | 232 | 130 | 197 | MDQ7817722.1 1,4-dihydroxy-2-naphthoate polyprenyltransferase [Melioribacteraceae bacterium] | diamond | 225 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 29721717 | 29721717 | PRJNA1120060_P_NODE_3049030_length_238_cov_4.096970_g3030929_i0 | PRJNA1120060 | 3049030 | 238 | 4.09697 | 9.7507886 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 52.4 | 1.42e-5 | NR | MEO8398350.1 | 2651163 | g3030929 | i0 | 88 | 3.61764705882353 | 25 | 3 | 31.5 | 0 | 2 | 76 | 260 | 284 | MEO8398350.1 sucrose synthase [Ignavibacteriaceae bacterium] | diamond | 861 | 52.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 31047916 | 31047916 | PRJNA1120060_P_NODE_1135115_length_311_cov_2.596639_g1117180_i0 | PRJNA1120060 | 1135115 | 311 | 2.596639 | 8.07554729 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 51.6 | 1.51e-5 | NR | HEY3251302.1 | 2053306 | g1117180 | i0 | 44.1 | 0.569131832797428 | 59 | 33 | 56.9 | 0 | 309 | 133 | 9 | 67 | HEY3251302.1 ribonuclease HI family protein [Ignavibacteria bacterium] | diamond | 177 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31070457 | 31070457 | PRJNA1120060_P_NODE_2439535_length_256_cov_1.677596_g2421466_i0 | PRJNA1120060 | 2439535 | 256 | 1.677596 | 4.29464576 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0427 | NR | OGU32446.1 | 1798421 | g2421466 | i0 | 45.1 | 1.1953125 | 51 | 27 | 58.6 | 1 | 56 | 205 | 65 | 115 | OGU32446.1 MAG: hypothetical protein A2X67_14450 [Ignavibacteria bacterium GWA2_55_11] | diamond | 306 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWA2_55_11 | ||||
| 31427698 | 31427698 | PRJNA1120060_P_NODE_2277776_length_262_cov_1.544974_g2259721_i0 | PRJNA1120060 | 2277776 | 262 | 1.544974 | 4.04783188 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 45.1 | 0.00727 | NR | MEJ5261481.1 | 2651167 | g2259721 | i0 | 32.6 | 0.984732824427481 | 86 | 56 | 98.5 | 1 | 5 | 262 | 532 | 615 | MEJ5261481.1 SPOR domain-containing protein [Ignavibacterium sp.] | diamond | 258 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 31711814 | 31711814 | PRJNA1120060_P_NODE_1381517_length_298_cov_5.880000_g1363537_i0 | PRJNA1120060 | 1381517 | 298 | 5.88 | 17.5224 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 43.5 | 0.0155 | NR | HOJ38659.1 | 2049428 | g1363537 | i0 | 37.9 | 0.583892617449664 | 58 | 35 | 57.4 | 1 | 292 | 122 | 43 | 100 | HOJ38659.1 Holliday junction resolvase RuvX [Ignavibacteriales bacterium] | diamond | 174 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 31712810 | 31712810 | PRJNA1120060_P_NODE_2810717_length_246_cov_0.890173_g2792631_i0 | PRJNA1120060 | 2810717 | 246 | 0.890173 | 2.18982558 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 44.7 | 0.00768 | NR | NLT51755.1 | 2053306 | g2792631 | i0 | 41.7 | 0.585365853658537 | 48 | 26 | 56.1 | 1 | 40 | 177 | 208 | 255 | NLT51755.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 144 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32219704 | 32219704 | PRJNA1120060_P_NODE_670638_length_337_cov_5.492424_g652842_i0 | PRJNA1120060 | 670638 | 337 | 5.492424 | 18.50946888 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 48.1 | 0.00121 | NR | MCK5456146.1 | 2614255 | g652842 | i0 | 30.1 | 0.649851632047478 | 73 | 48 | 65 | 1 | 320 | 102 | 194 | 263 | MCK5456146.1 IS1595 family transposase [Melioribacteraceae bacterium] | diamond | 219 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 32376424 | 32376424 | PRJNA1120060_P_NODE_1521099_length_292_cov_3.146119_g1503110_i0 | PRJNA1120060 | 1521099 | 292 | 3.146119 | 9.18666748 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 45.4 | 0.00782 | NR | MBK6915448.1 | 2049428 | g1503110 | i0 | 42.9 | 0.431506849315068 | 42 | 23 | 42.1 | 1 | 219 | 97 | 523 | 564 | MBK6915448.1 T9SS type A sorting domain-containing protein [Ignavibacteriales bacterium] | diamond | 126 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32377508 | 32377508 | PRJNA1120060_P_NODE_3129139_length_234_cov_6.173913_g3111035_i0 | PRJNA1120060 | 3129139 | 234 | 6.173913 | 14.44695642 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 41.2 | 0.0399 | NR | MEO8666417.1 | 2053306 | g3111035 | i0 | 41.9 | 0.551282051282051 | 43 | 25 | 55.1 | 0 | 30 | 158 | 6 | 48 | MEO8666417.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 129 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32566173 | 32566173 | PRJNA1120060_P_NODE_1102199_length_311_cov_3.029412_g1084264_i0 | PRJNA1120060 | 1102199 | 311 | 3.029412 | 9.42147132 | Ignavibacteria bacterium GWA2_55_25 | 1798422 | Bacteria | Bacteria | 51.6 | 1.84e-5 | NR | OGU18515.1 | 1798422 | g1084264 | i0 | 51 | 0.472668810289389 | 49 | 24 | 47.3 | 0 | 310 | 164 | 10 | 58 | OGU18515.1 MAG: hypothetical protein A2059_01000 [Ignavibacteria bacterium GWA2_55_25] | diamond | 147 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWA2_55_25 |
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);;