contig_metadata
23 rows where tax_clade = "OMG group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3393598 | 3393598 | PRJNA857143_S_NODE_112223_length_300_cov_1.374449_g111130_i0 | PRJNA857143 | 112223 | 300 | 1.374449 | 4.123347 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 84.2 | 9.9e-12 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g111130 | i0 | 82.243 | 0.713333333333333 | 107 | 10 | 34 | 7 | 26 | 126 | 375644 | 375541 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 214 | 84.2 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 7049976 | 7049976 | PRJNA690592_S_NODE_189306_length_250_cov_0.870056_g188292_i0 | PRJNA690592 | 189306 | 250 | 0.870056 | 2.17514 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g188292 | i0 | 100 | 0.116 | 29 | 0 | 12 | 0 | 144 | 172 | 3942629 | 3942657 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 8336926 | 8336926 | PRJNA702290_P_NODE_1267_length_190_cov_14.874172_g1259_i0 | PRJNA702290 | 1267 | 190 | 14.874172 | 28.2609268 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 89.8 | 1.24e-13 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g1259 | i0 | 94.737 | 21.5157894736842 | 57 | 3 | 30 | 0 | 4 | 60 | 2845025 | 2845081 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 4088 | 89.8 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 10011314 | 10011314 | PRJNA414225_P_NODE_74808_length_164_cov_0.886957_g74721_i0 | PRJNA414225 | 74808 | 164 | 0.886957 | 1.45460948 | Gammaproteobacteria | 1236 | Bacteria | Bacteria | 110 | 9.919999999999999e-28 | NR | KRP35056.1 | 1655628 | g74721 | i0 | 90.7 | 9.87804878048781 | 54 | 5 | 98.8 | 0 | 2 | 163 | 175 | 228 | KRP35056.1 MAG: transposase [OM182 bacterium BACL3 MAG-120531-bin86] | diamond | 1620 | 110 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120531-bin86 | ||||
| 14054792 | 14054792 | PRJEB29441_P_NODE_34832_length_177_cov_1.390625_g34391_i0 | PRJEB29441 | 34832 | 177 | 1.390625 | 2.46140625 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 228 | 2.3099999999999997e-55 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g34391 | i0 | 91.071 | 256.610169491525 | 168 | 15 | 95 | 0 | 1 | 168 | 4450248 | 4450081 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 45420 | 228 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 15596135 | 15596135 | PRJNA1148190_P_NODE_274173_length_331_cov_1.701550_g263002_i0 | PRJNA1148190 | 274173 | 331 | 1.70155 | 5.6321305 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 230 | 1.3399999999999998e-55 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g263002 | i0 | 80.592 | 84.1268882175227 | 304 | 53 | 91 | 5 | 18 | 318 | 2745882 | 2746182 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 27846 | 230 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 17242868 | 17242868 | PRJNA683669_P_NODE_20854_length_283_cov_1.466667_g20622_i0 | PRJNA683669 | 20854 | 283 | 1.466667 | 4.15066761 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g20622 | i0 | 96.875 | 0.113074204946996 | 32 | 1 | 11 | 0 | 219 | 250 | 2281908 | 2281877 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 32 | 54.7 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 18303550 | 18303550 | PRJNA492280_P_NODE_19735_length_164_cov_3.377953_g19628_i0 | PRJNA492280 | 19735 | 164 | 3.377953 | 5.53984292 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 139 | 1.02e-28 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g19628 | i0 | 79.762 | 82.4085365853659 | 168 | 26 | 98 | 4 | 4 | 163 | 4450961 | 4450794 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 13515 | 139 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 19253727 | 19253727 | PRJEB64798_P_NODE_220356_length_162_cov_2.141593_g218590_i0 | PRJEB64798 | 220356 | 162 | 2.141593 | 3.46938066 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 58.4 | 2.9e-4 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g218590 | i0 | 100 | 0.191358024691358 | 31 | 0 | 19 | 0 | 126 | 156 | 1323930 | 1323900 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 31 | 58.4 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 19559021 | 19559021 | PRJNA437204_P_NODE_68116_length_268_cov_1.169231_g67817_i0 | PRJNA437204 | 68116 | 268 | 1.169231 | 3.13353908 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g67817 | i0 | 100 | 0.104477611940299 | 28 | 0 | 10 | 0 | 91 | 118 | 97597 | 97570 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 19621830 | 19621830 | PRJNA526367_P_NODE_23676_length_324_cov_2.123636_g23467_i0 | PRJNA526367 | 23676 | 324 | 2.123636 | 6.88058064 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 87.9 | 8.34e-13 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g23467 | i0 | 89.706 | 0.404320987654321 | 68 | 7 | 21 | 0 | 16 | 83 | 1488444 | 1488377 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 131 | 87.9 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 20959278 | 20959278 | PRJNA565584_P_NODE_51417_length_415_cov_1.190058_g50266_i0 | PRJNA565584 | 51417 | 415 | 1.190058 | 4.9387407 | Bowmanella | 366580 | Bacteria | Bacteria | 250 | 4.34e-81 | NR | KRO79565.1 | 1655580 | g50266 | i0 | 83.9 | 9.90361445783133 | 137 | 22 | 99 | 0 | 3 | 413 | 17 | 153 | KRO79565.1 MAG: S-(hydroxymethyl)glutathione dehydrogenase, partial [OM182 bacterium BACL3 MAG-120920-bin41] | diamond | 4110 | 252 | 0.992063492063492 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120920-bin41 | ||||
| 23554399 | 23554399 | PRJNA630162_P_NODE_152939_length_164_cov_0.904348_g151416_i0 | PRJNA630162 | 152939 | 164 | 0.904348 | 1.48313072 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 117 | 4.79e-22 | NTclustered | gi|2921923768|gb|CP182805.1| | 2510334 | g151416 | i0 | 83.871 | 42.5548780487805 | 124 | 19 | 76 | 1 | 33 | 156 | 4450814 | 4450936 | MAG: OM182 bacterium isolate amkv21 chromosome, complete genome | blastn | 6979 | 117 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 24523329 | 24523329 | PRJNA1148190_P_NODE_563360_length_254_cov_1.701657_g552187_i0 | PRJNA1148190 | 563360 | 254 | 1.701657 | 4.32220878 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 73.1 | 1.77e-8 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g552187 | i0 | 87.879 | 1.44094488188976 | 66 | 3 | 25 | 5 | 138 | 201 | 240609 | 240671 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 366 | 73.1 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 25043171 | 25043171 | PRJNA814235_P_NODE_182480_length_151_cov_5.956140_g181085_i0 | PRJNA814235 | 182480 | 151 | 5.95614 | 8.9937714 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 58.4 | 2.65e-4 | NTclustered | gi|2836059185|gb|CP121333.1| | 2510334 | g181085 | i0 | 89.13 | 0.304635761589404 | 46 | 5 | 30 | 0 | 8 | 53 | 2823077 | 2823122 | MAG: OM182 bacterium isolate NCC532_bact_4768 chromosome, complete genome | blastn | 46 | 58.4 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 26775680 | 26775680 | PRJNA379145_P_NODE_36481_length_336_cov_1.808581_g34333_i0 | PRJNA379145 | 36481 | 336 | 1.808581 | 6.07683216 | Bacteria | 2 | Bacteria | Bacteria | 96.7 | 3.51e-21 | NR | KRP32164.1 | 1655629 | g34333 | i0 | 81.4 | 2.10714285714286 | 59 | 11 | 52.7 | 0 | 335 | 159 | 272 | 330 | KRP32164.1 MAG: acetyl-CoA acetyltransferase, partial [OM182 bacterium BACL3 MAG-121001-bin29] | diamond | 708 | 96.7 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-121001-bin29 | ||||
| 27327304 | 27327304 | PRJNA315399_P_NODE_150963_length_189_cov_2.171053_g150515_i0 | PRJNA315399 | 150963 | 189 | 2.171053 | 4.10329017 | OM182 bacterium BACL3 MAG-12 | 2510334 | Bacteria | Bacteria | 42 | 0.0323 | NR | KRO73214.1 | 1655577 | g150515 | i0 | 70.8 | 0.380952380952381 | 24 | 7 | 38.1 | 0 | 85 | 14 | 167 | 190 | KRO73214.1 MAG: hypothetical protein ABR69_03850 [OM182 bacterium BACL3 MAG-120507-bin80] | diamond | 72 | 42 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120507-bin80 | ||||
| 27478477 | 27478477 | PRJNA1102048_P_NODE_9263_length_287_cov_1.266355_g9159_i0 | PRJNA1102048 | 9263 | 287 | 1.266355 | 3.63443885 | OM182 bacterium BACL3 MAG-12 | 2510334 | Bacteria | Bacteria | 149 | 3.459999999999999e-43 | NR | KRO80840.1 | 1655593 | g9159 | i0 | 96.1 | 0.804878048780488 | 77 | 3 | 80.5 | 0 | 56 | 286 | 1 | 77 | KRO80840.1 MAG: RNA polymerase subunit sigma [OM182 bacterium BACL3 MAG-120619-bin3] | diamond | 231 | 149 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120619-bin3 | ||||
| 29593534 | 29593534 | PRJNA1102048_P_NODE_17070_length_242_cov_0.911243_g16966_i0 | PRJNA1102048 | 17070 | 242 | 0.911243 | 2.20520806 | OM182 bacterium | 2510334 | Bacteria | Bacteria | 164 | 2.38e-48 | NR | MDO7640183.1 | 2510334 | g16966 | i0 | 95 | 4.95867768595041 | 80 | 4 | 99.2 | 0 | 1 | 240 | 10 | 89 | MDO7640183.1 PQQ-binding-like beta-propeller repeat protein [OM182 bacterium] | diamond | 1200 | 164 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium | ||||
| 29615889 | 29615889 | PRJEB30004_P_NODE_550590_length_178_cov_1.453237_g534963_i0 | PRJEB30004 | 550590 | 178 | 1.453237 | 2.58676186 | Bacteria | 2 | Bacteria | Bacteria | 45.8 | 0.00124 | NR | PDH32587.1 | 1986256 | g534963 | i0 | 41.7 | 2.00561797752809 | 60 | 32 | 96.1 | 1 | 1 | 171 | 98 | 157 | PDH32587.1 MAG: hypothetical protein CNF02_11770 [OM182 bacterium MED-G28] | diamond | 357 | 45.8 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium MED-G28 | ||||
| 29837631 | 29837631 | PRJNA1067370_P_NODE_48691_length_299_cov_1.761062_g48143_i0 | PRJNA1067370 | 48691 | 299 | 1.761062 | 5.26557538 | Bacteria | 2 | Bacteria | Bacteria | 71.2 | 4.87e-12 | NR | KRO76580.1 | 1655580 | g48143 | i0 | 44.4 | 3.29096989966555 | 81 | 41 | 77.3 | 3 | 235 | 5 | 32 | 112 | KRO76580.1 MAG: hypothetical protein ABR72_06385, partial [OM182 bacterium BACL3 MAG-120920-bin41] | diamond | 984 | 71.2 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120920-bin41 | ||||
| 30409302 | 30409302 | PRJNA560932_P_NODE_50213_length_256_cov_1.262295_g49857_i0 | PRJNA560932 | 50213 | 256 | 1.262295 | 3.2314752 | Bacteria | 2 | Bacteria | Bacteria | 89.7 | 3.81e-20 | NR | KRO70162.1 | 1655577 | g49857 | i0 | 48.8 | 13.39453125 | 82 | 42 | 96.1 | 0 | 254 | 9 | 106 | 187 | KRO70162.1 MAG: hypothetical protein ABR69_03915, partial [OM182 bacterium BACL3 MAG-120507-bin80] | diamond | 3429 | 90.5 | 0.991160220994475 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120507-bin80 | ||||
| 30754078 | 30754078 | PRJNA1087264_P_NODE_8194_length_220_cov_1.309942_g8112_i0 | PRJNA1087264 | 8194 | 220 | 1.309942 | 2.8818724 | Bacteria | 2 | Bacteria | Bacteria | 92.8 | 6.4500000000000005e-21 | NR | KRO80699.1 | 1655593 | g8112 | i0 | 55.6 | 3.92727272727273 | 72 | 32 | 98.2 | 0 | 218 | 3 | 54 | 125 | KRO80699.1 MAG: hypothetical protein ABR85_08005 [OM182 bacterium BACL3 MAG-120619-bin3] | diamond | 864 | 92.8 | 1 | Bacteria | OMG group | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | OM182 bacterium BACL3 MAG-120619-bin3 |
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);;