contig_metadata
13 rows where analysis = "blastn" and 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 | ||||
| 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 | ||||
| 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 |
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);;