contig_metadata
11 rows where bioproject = "PRJNA1010780" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26908090 | 26908090 | PRJNA1010780_S_NODE_53322_length_167_cov_2.424242_g52033_i0 | PRJNA1010780 | 53322 | 167 | 2.424242 | 4.04848414 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.4 | 0.0181 | NR | MDD5130574.1 | 2035772 | g52033 | i0 | 39.2 | 0.916167664670659 | 51 | 31 | 91.6 | 0 | 157 | 5 | 4 | 54 | MDD5130574.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 153 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27002820 | 27002820 | PRJNA1010780_S_NODE_58242_length_158_cov_1.650407_g56953_i0 | PRJNA1010780 | 58242 | 158 | 1.650407 | 2.60764306 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 75.9 | 2.41e-14 | NR | MCA9440246.1 | 2035772 | g56953 | i0 | 64.7 | 3.87341772151899 | 51 | 18 | 96.8 | 0 | 6 | 158 | 361 | 411 | MCA9440246.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 612 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28108342 | 28108342 | PRJNA1010780_S_NODE_37085_length_220_cov_1.686486_g35796_i0 | PRJNA1010780 | 37085 | 220 | 1.686486 | 3.7102692 | Omnitrophica WOR_2 bacterium SM23_29 | 1703776 | Bacteria | Bacteria | 44.3 | 0.0079 | NR | KPK42528.1 | 1703776 | g35796 | i0 | 42.6 | 0.927272727272727 | 68 | 35 | 91.4 | 3 | 9 | 209 | 815 | 879 | KPK42528.1 MAG: hypothetical protein AMJ78_02245 [Omnitrophica WOR_2 bacterium SM23_29] | diamond | 204 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium SM23_29 | |||||
| 28550718 | 28550718 | PRJNA1010780_S_NODE_2047_length_1779_cov_15.985665_g1816_i1 | PRJNA1010780 | 2047 | 1779 | 15.985665 | 284.38498035 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 445 | 1.2999999999999999e-134 | NR | MBI4372266.1 | 2035772 | g1816 | i1 | 46.7 | 2.53119730185497 | 508 | 262 | 85.2 | 7 | 1769 | 255 | 1522 | 2023 | MBI4372266.1 DUF89 family protein [Candidatus Omnitrophota bacterium] | diamond | 4503 | 445 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28890182 | 28890182 | PRJNA1010780_S_NODE_148_length_3728_cov_23.923369_g115_i0 | PRJNA1010780 | 148 | 3728 | 23.923369 | 891.86319632 | Bacteria | 2 | Bacteria | Bacteria | 644 | 1.25e-203 | NR | KPK41423.1 | 1703776 | g115 | i0 | 34.6 | 3.05713519313305 | 1267 | 735 | 97.3 | 30 | 1 | 3627 | 27 | 1257 | KPK41423.1 MAG: hypothetical protein AMJ78_05560 [Omnitrophica WOR_2 bacterium SM23_29] | diamond | 11397 | 645 | 0.998449612403101 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium SM23_29 | |||||
| 29497714 | 29497714 | PRJNA1010780_S_NODE_25990_length_305_cov_2.618519_g24701_i0 | PRJNA1010780 | 25990 | 305 | 2.618519 | 7.98648295 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 68.6 | 6.01e-11 | NR | MDD4980145.1 | 2035772 | g24701 | i0 | 35.6 | 1.02295081967213 | 104 | 61 | 99.3 | 3 | 1 | 303 | 75 | 175 | MDD4980145.1 glycoside hydrolase family 1 protein [Candidatus Omnitrophota bacterium] | diamond | 312 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30382599 | 30382599 | PRJNA1010780_S_NODE_46073_length_186_cov_1.178808_g44784_i0 | PRJNA1010780 | 46073 | 186 | 1.178808 | 2.19258288 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 87.4 | 9.61e-19 | NR | MBN1405721.1 | 2035772 | g44784 | i0 | 60.7 | 1.96774193548387 | 61 | 24 | 98.4 | 0 | 186 | 4 | 209 | 269 | MBN1405721.1 S-methyl-5-thioribose-1-phosphate isomerase [Candidatus Omnitrophota bacterium] | diamond | 366 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30792788 | 30792788 | PRJNA1010780_S_NODE_16354_length_497_cov_2.902597_g15109_i0 | PRJNA1010780 | 16354 | 497 | 2.902597 | 14.42590709 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 52.4 | 2.12e-4 | NR | MBN1869558.1 | 2035772 | g15109 | i0 | 31.3 | 0.869215291750503 | 144 | 78 | 79.7 | 6 | 426 | 31 | 651 | 785 | MBN1869558.1 glycosyltransferase [Candidatus Omnitrophota bacterium] | diamond | 432 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31733601 | 31733601 | PRJNA1010780_S_NODE_17917_length_452_cov_7.503597_g16642_i0 | PRJNA1010780 | 17917 | 452 | 7.503597 | 33.91625844 | root | 1 | Root_unresolved | Root_unresolved | 211 | 1.76e-67 | NR | MBI3313936.1 | 2035772 | g16642 | i0 | 73.9 | 4.58628318584071 | 138 | 34 | 91.6 | 1 | 450 | 37 | 12 | 147 | MBI3313936.1 nucleoside deaminase [Candidatus Omnitrophota bacterium] | diamond | 2073 | 213 | 0.990610328638498 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32405853 | 32405853 | PRJNA1010780_S_NODE_26639_length_298_cov_1.532319_g25350_i0 | PRJNA1010780 | 26639 | 298 | 1.532319 | 4.56631062 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 106 | 7.1e-25 | NR | MEW6233844.1 | 2035772 | g25350 | i0 | 51.4 | 2.01342281879195 | 105 | 44 | 98.7 | 2 | 296 | 3 | 51 | 155 | MEW6233844.1 lactonase family protein [Candidatus Omnitrophota bacterium] | diamond | 600 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32815783 | 32815783 | PRJNA1010780_S_NODE_18560_length_435_cov_3.285000_g17282_i0 | PRJNA1010780 | 18560 | 435 | 3.285 | 14.28975 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 55.5 | 6.17e-6 | NR | MBU4252014.1 | 2035772 | g17282 | i0 | 34 | 0.668965517241379 | 97 | 60 | 66.9 | 1 | 3 | 293 | 7 | 99 | MBU4252014.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 291 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;