contig_metadata
15 rows where bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26617862 | 26617862 | PRJNA533114_P_NODE_39781_length_367_cov_2.697279_g39529_i0 | PRJNA533114 | 39781 | 367 | 2.697279 | 9.89901393 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.9 | 4.94e-22 | NR | MBI5216594.1 | 2026749 | g39529 | i0 | 73.2 | 9.67847411444142 | 56 | 15 | 45.8 | 0 | 245 | 78 | 47 | 102 | MBI5216594.1 peptide-methionine (S)-S-oxide reductase MsrA [Ignavibacteriota bacterium] | diamond | 3552 | 96.7 | 0.991726990692865 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 26950908 | 26950908 | PRJNA533114_P_NODE_14442_length_595_cov_3.940613_g14197_i0 | PRJNA533114 | 14442 | 595 | 3.940613 | 23.44664735 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 47 | 0.0286 | NR | HEY3249713.1 | 2053306 | g14197 | i0 | 29 | 0.695798319327731 | 138 | 79 | 69.1 | 5 | 37 | 447 | 412 | 531 | HEY3249713.1 M14 family zinc carboxypeptidase [Ignavibacteria bacterium] | diamond | 414 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27709887 | 27709887 | PRJNA533114_P_NODE_114864_length_243_cov_0.905882_g114612_i0 | PRJNA533114 | 114864 | 243 | 0.905882 | 2.20129326 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 42.7 | 0.0364 | NR | MBK6504545.1 | 2053306 | g114612 | i0 | 37.5 | 0.691358024691358 | 56 | 35 | 69.1 | 0 | 73 | 240 | 60 | 115 | MBK6504545.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29193692 | 29193692 | PRJNA533114_P_NODE_56769_length_315_cov_1.747934_g56517_i0 | PRJNA533114 | 56769 | 315 | 1.747934 | 5.5059921 | Ignavibacteria bacterium GWC2_36_12 | 1798427 | Bacteria | Bacteria | 94.7 | 2.11e-20 | NR | OGU50219.1 | 1798427 | g56517 | i0 | 41.3 | 2.57142857142857 | 104 | 61 | 99 | 0 | 314 | 3 | 180 | 283 | OGU50219.1 MAG: MFS transporter [Ignavibacteria bacterium GWC2_36_12] | diamond | 810 | 94.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWC2_36_12 | ||||
| 29572283 | 29572283 | PRJNA533114_P_NODE_83930_length_265_cov_1.572917_g83678_i0 | PRJNA533114 | 83930 | 265 | 1.572917 | 4.16823005 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 71.6 | 1.79e-12 | NR | MCX6164492.1 | 2026749 | g83678 | i0 | 48.9 | 1.0188679245283 | 90 | 44 | 99.6 | 2 | 264 | 1 | 114 | 203 | MCX6164492.1 serine hydrolase [Ignavibacteriota bacterium] | diamond | 270 | 71.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 30140481 | 30140481 | PRJNA533114_P_NODE_59572_length_308_cov_2.408511_g59320_i0 | PRJNA533114 | 59572 | 308 | 2.408511 | 7.41821388 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 55.8 | 1.03e-6 | NR | MBM4179762.1 | 2053306 | g59320 | i0 | 34.7 | 0.954545454545455 | 98 | 64 | 95.5 | 0 | 2 | 295 | 67 | 164 | MBM4179762.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 294 | 55.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30282661 | 30282661 | PRJNA533114_P_NODE_84892_length_264_cov_0.994764_g84640_i0 | PRJNA533114 | 84892 | 264 | 0.994764 | 2.62617696 | Bacteria | 2 | Bacteria | Bacteria | 105 | 1.66e-24 | NR | MBK7979391.1 | 2026749 | g84640 | i0 | 53.5 | 4.875 | 86 | 40 | 97.7 | 0 | 264 | 7 | 239 | 324 | MBK7979391.1 aldehyde dehydrogenase family protein [Ignavibacteriota bacterium] | diamond | 1287 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31436517 | 31436517 | PRJNA533114_P_NODE_80576_length_270_cov_1.852792_g80324_i0 | PRJNA533114 | 80576 | 270 | 1.852792 | 5.0025384 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 50.4 | 9.99e-5 | NR | MCU7495665.1 | 2053306 | g80324 | i0 | 37.2 | 0.955555555555556 | 86 | 45 | 92.2 | 3 | 259 | 11 | 719 | 798 | MCU7495665.1 choice-of-anchor A family protein [Ignavibacteria bacterium] | diamond | 258 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31531587 | 31531587 | PRJNA533114_P_NODE_54076_length_322_cov_1.236948_g53824_i0 | PRJNA533114 | 54076 | 322 | 1.236948 | 3.98297256 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 75.9 | 4.69e-14 | NR | MCB0711714.1 | 2026749 | g53824 | i0 | 51.2 | 0.763975155279503 | 82 | 38 | 75.5 | 2 | 255 | 13 | 15 | 95 | MCB0711714.1 50S ribosomal protein L1 [Ignavibacteriota bacterium] | diamond | 246 | 75.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31563384 | 31563384 | PRJNA533114_P_NODE_99356_length_249_cov_0.875000_g99104_i0 | PRJNA533114 | 99356 | 249 | 0.875 | 2.17875 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 49.3 | 2e-4 | NR | MBV6511003.1 | 2651163 | g99104 | i0 | 36.3 | 0.963855421686747 | 80 | 45 | 90.4 | 4 | 247 | 23 | 1075 | 1153 | MBV6511003.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 240 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32037512 | 32037512 | PRJNA533114_P_NODE_104618_length_247_cov_0.885057_g104366_i0 | PRJNA533114 | 104618 | 247 | 0.885057 | 2.18609079 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 73.9 | 3.41e-13 | NR | MCX6161419.1 | 2026749 | g104366 | i0 | 51.9 | 1.91902834008097 | 79 | 37 | 96 | 1 | 240 | 4 | 126 | 203 | MCX6161419.1 serine hydrolase [Ignavibacteriota bacterium] | diamond | 474 | 73.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 32369229 | 32369229 | PRJNA533114_P_NODE_4739_length_1001_cov_2.242457_g4579_i0 | PRJNA533114 | 4739 | 1001 | 2.242457 | 22.44699457 | Bacteria | 2 | Bacteria | Bacteria | 110 | 1.1199999999999999e-23 | NR | MCX7875137.1 | 2614255 | g4579 | i0 | 29.3 | 1.59440559440559 | 259 | 140 | 75.2 | 4 | 249 | 1001 | 15 | 238 | MCX7875137.1 fatty acid desaturase [Melioribacteraceae bacterium] | diamond | 1596 | 111 | 0.990990990990991 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 32764243 | 32764243 | PRJNA533114_P_NODE_41320_length_362_cov_0.851211_g41068_i0 | PRJNA533114 | 41320 | 362 | 0.851211 | 3.08138382 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 48.9 | 7.54e-4 | NR | HKI79936.1 | 2651163 | g41068 | i0 | 47.2 | 0.439226519337017 | 53 | 25 | 41.4 | 2 | 38 | 187 | 203 | 255 | HKI79936.1 DUF547 domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 159 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 32764256 | 32764256 | PRJNA533114_P_NODE_47020_length_342_cov_1.717472_g46768_i0 | PRJNA533114 | 47020 | 342 | 1.717472 | 5.87375424 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 96.3 | 8.52e-21 | NR | MBI5645832.1 | 2026749 | g46768 | i0 | 75.8 | 1.84210526315789 | 66 | 16 | 57.9 | 0 | 203 | 6 | 3 | 68 | MBI5645832.1 acetyl-CoA C-acetyltransferase [Ignavibacteriota bacterium] | diamond | 630 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 32795519 | 32795519 | PRJNA533114_P_NODE_28340_length_429_cov_0.766854_g28088_i0 | PRJNA533114 | 28340 | 429 | 0.766854 | 3.28980366 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 70.9 | 2.51e-12 | NR | HQJ45779.1 | 2651163 | g28088 | i0 | 40.2 | 3.69230769230769 | 117 | 64 | 77.6 | 4 | 428 | 96 | 5 | 121 | HQJ45779.1 EVE domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 1584 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;