contig_metadata
17 rows where bioproject = "PRJNA492363", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25567189 | 25567189 | PRJNA492363_S_NODE_9113_length_316_cov_3.168627_g8292_i0 | PRJNA492363 | 9113 | 316 | 3.168627 | 10.01286132 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 142 | 8.62e-37 | NR | MFO7524563.1 | 2651163 | g8292 | i0 | 90 | 3.07594936708861 | 80 | 8 | 75.9 | 0 | 287 | 48 | 614 | 693 | MFO7524563.1 copper-translocating P-type ATPase [Ignavibacteriaceae bacterium] | diamond | 972 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 25701719 | 25701719 | PRJNA492363_S_NODE_10658_length_296_cov_1.736170_g9837_i0 | PRJNA492363 | 10658 | 296 | 1.73617 | 5.1390632 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 200 | 9.279999999999999e-47 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g9837 | i0 | 93.333 | 145.706081081081 | 135 | 9 | 46 | 0 | 162 | 296 | 807405 | 807271 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 43129 | 200 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 25702435 | 25702435 | PRJNA492363_S_NODE_36970_length_238_cov_1.327684_g36149_i0 | PRJNA492363 | 36970 | 238 | 1.327684 | 3.15988792 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 115 | 5.95e-30 | NR | MCF8265334.1 | 2614255 | g36149 | i0 | 75.3 | 1.84033613445378 | 73 | 18 | 92 | 0 | 221 | 3 | 21 | 93 | MCF8265334.1 DUF3267 domain-containing protein [Melioribacteraceae bacterium] | diamond | 438 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 25703342 | 25703342 | PRJNA492363_S_NODE_91586_length_206_cov_0.882759_g90765_i0 | PRJNA492363 | 91586 | 206 | 0.882759 | 1.81848354 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 122 | 2.11e-30 | NR | MBD1207077.1 | 2053306 | g90765 | i0 | 90.6 | 0.932038834951456 | 64 | 6 | 93.2 | 0 | 15 | 206 | 278 | 341 | MBD1207077.1 glycosyltransferase [Ignavibacteria bacterium] | diamond | 192 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26033244 | 26033244 | PRJNA492363_S_NODE_10332_length_300_cov_2.117155_g9511_i0 | PRJNA492363 | 10332 | 300 | 2.117155 | 6.351465 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 361 | 4.08e-95 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g9511 | i0 | 88.333 | 4 | 300 | 35 | 100 | 0 | 1 | 300 | 574464 | 574165 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 1200 | 361 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26110638 | 26110638 | PRJNA492363_S_NODE_26285_length_243_cov_2.373626_g25464_i0 | PRJNA492363 | 26285 | 243 | 2.373626 | 5.76791118 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 62.8 | 3.11e-9 | NR | MBD1209478.1 | 2053306 | g25464 | i0 | 82.9 | 0.432098765432099 | 35 | 6 | 43.2 | 0 | 223 | 119 | 438 | 472 | MBD1209478.1 tRNA (N6-isopentenyl adenosine(37)-C2)-methylthiotransferase MiaB [Ignavibacteria bacterium] | diamond | 105 | 62.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26169348 | 26169348 | PRJNA492363_S_NODE_115325_length_190_cov_2.364341_g114504_i0 | PRJNA492363 | 115325 | 190 | 2.364341 | 4.4922479 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 294 | 2.46e-75 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g114504 | i0 | 96.111 | 3.78947368421053 | 180 | 7 | 95 | 0 | 11 | 190 | 574192 | 574013 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 720 | 294 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26520028 | 26520028 | PRJNA492363_S_NODE_95344_length_204_cov_0.895105_g94523_i0 | PRJNA492363 | 95344 | 204 | 0.895105 | 1.8260142 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 118 | 9.36e-30 | NR | MBD1207410.1 | 2053306 | g94523 | i0 | 82.4 | 1 | 68 | 12 | 100 | 0 | 1 | 204 | 98 | 165 | MBD1207410.1 hybrid sensor histidine kinase/response regulator [Ignavibacteria bacterium] | diamond | 204 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32918269 | 32918269 | PRJNA492363_S_NODE_98657_length_202_cov_1.815603_g97836_i0 | PRJNA492363 | 98657 | 202 | 1.815603 | 3.66751806 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 51.6 | 1.68e-5 | NR | MBD1210439.1 | 2053306 | g97836 | i0 | 59.5 | 0.54950495049505 | 37 | 15 | 55 | 0 | 74 | 184 | 507 | 543 | MBD1210439.1 fibronectin type III domain-containing protein [Ignavibacteria bacterium] | diamond | 111 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32935356 | 32935356 | PRJNA492363_S_NODE_88137_length_208_cov_0.870748_g87316_i0 | PRJNA492363 | 88137 | 208 | 0.870748 | 1.81115584 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 135 | 4.83e-36 | NR | MBD1210505.1 | 2053306 | g87316 | i0 | 98.6 | 0.995192307692308 | 69 | 1 | 99.5 | 0 | 2 | 208 | 18 | 86 | MBD1210505.1 MATE family efflux transporter [Ignavibacteria bacterium] | diamond | 207 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32975665 | 32975665 | PRJNA492363_S_NODE_100666_length_201_cov_1.828571_g99845_i0 | PRJNA492363 | 100666 | 201 | 1.828571 | 3.67542771 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.3 | 9.33e-22 | NR | HRU00061.1 | 2049428 | g99845 | i0 | 78.2 | 2.46268656716418 | 55 | 12 | 82.1 | 0 | 35 | 199 | 60 | 114 | HRU00061.1 RNA ligase family protein [Ignavibacteriales bacterium] | diamond | 495 | 96.7 | 0.995863495346432 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32975666 | 32975666 | PRJNA492363_S_NODE_100946_length_201_cov_0.914286_g100125_i0 | PRJNA492363 | 100946 | 201 | 0.914286 | 1.83771486 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 124 | 3.0000000000000003e-31 | NR | MBD1209759.1 | 2053306 | g100125 | i0 | 83.3 | 1.97014925373134 | 66 | 11 | 98.5 | 0 | 2 | 199 | 947 | 1012 | MBD1209759.1 SpoIIE family protein phosphatase [Ignavibacteria bacterium] | diamond | 396 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 33071630 | 33071630 | PRJNA492363_S_NODE_10069_length_303_cov_2.636364_g9248_i0 | PRJNA492363 | 10069 | 303 | 2.636364 | 7.98818292 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 189 | 4.63e-57 | NR | MEO8232325.1 | 2026749 | g9248 | i0 | 92 | 0.99009900990099 | 100 | 8 | 99 | 0 | 302 | 3 | 3 | 102 | MEO8232325.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 300 | 189 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 33071858 | 33071858 | PRJNA492363_S_NODE_89581_length_207_cov_1.315068_g88760_i0 | PRJNA492363 | 89581 | 207 | 1.315068 | 2.72219076 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 132 | 8.91e-34 | NR | MBD1209265.1 | 2053306 | g88760 | i0 | 92.6 | 0.985507246376812 | 68 | 5 | 98.6 | 0 | 3 | 206 | 445 | 512 | MBD1209265.1 GAF domain-containing protein [Ignavibacteria bacterium] | diamond | 204 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 33106029 | 33106029 | PRJNA492363_S_NODE_68590_length_224_cov_3.098160_g67769_i0 | PRJNA492363 | 68590 | 224 | 3.09816 | 6.9398784 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 98.2 | 3.2699999999999995e-23 | NR | HWQ81659.1 | 2053306 | g67769 | i0 | 58.6 | 1.88839285714286 | 70 | 29 | 93.8 | 0 | 215 | 6 | 43 | 112 | HWQ81659.1 DNA alkylation repair protein [Ignavibacteria bacterium] | diamond | 423 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 33111971 | 33111971 | PRJNA492363_S_NODE_91350_length_206_cov_1.324138_g90529_i0 | PRJNA492363 | 91350 | 206 | 1.324138 | 2.72772428 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 93.6 | 2.8e-20 | NR | OGU37173.1 | 1798424 | g90529 | i0 | 55.4 | 2.83980582524272 | 65 | 29 | 94.7 | 0 | 204 | 10 | 283 | 347 | OGU37173.1 MAG: hypothetical protein A2068_01630 [Ignavibacteria bacterium GWB2_35_6b] | diamond | 585 | 93.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWB2_35_6b | ||||
| 33140197 | 33140197 | PRJNA492363_S_NODE_97055_length_203_cov_0.901408_g96234_i0 | PRJNA492363 | 97055 | 203 | 0.901408 | 1.82985824 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 105 | 1.58e-26 | NR | MBD1207364.1 | 2053306 | g96234 | i0 | 91.5 | 0.87192118226601 | 59 | 5 | 87.2 | 0 | 178 | 2 | 1 | 59 | MBD1207364.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 177 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria 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);;