contig_metadata
12 rows where bioproject = "PRJNA312107", tax_kingdom = "Pseudomonadati" and tax_phylum = "Elusimicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13131342 | 13131342 | PRJNA312107_P_NODE_20151_length_168_cov_0.873950_g19985_i0 | PRJNA312107 | 20151 | 168 | 0.87395 | 1.468236 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 198 | 1.7099999999999997e-46 | NTclustered | gi|2233025045|gb|CP096137.1| | 2030800 | g19985 | i0 | 91.608 | 0.851190476190476 | 143 | 12 | 85 | 0 | 26 | 168 | 3537426 | 3537568 | MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome | blastn | 143 | 198 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 15680294 | 15680294 | PRJNA312107_P_NODE_10813_length_220_cov_1.309942_g10647_i0 | PRJNA312107 | 10813 | 220 | 1.309942 | 2.8818724 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 276 | 1.06e-69 | NTclustered | gi|2233025045|gb|CP096137.1| | 2030800 | g10647 | i0 | 92.67 | 369.918181818182 | 191 | 14 | 87 | 0 | 30 | 220 | 3536925 | 3537115 | MAG: Elusimicrobia bacterium isolate JAD_PAG50586_1 chromosome, complete genome | blastn | 81382 | 276 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 26662423 | 26662423 | PRJNA312107_P_NODE_19781_length_168_cov_0.873950_g19615_i0 | PRJNA312107 | 19781 | 168 | 0.87395 | 1.468236 | Elusimicrobia bacterium RIFCSPLOWO2_ | 1797946 | Bacteria | Bacteria | 68.9 | 7.61e-12 | NR | OGR89178.1 | 1797946 | g19615 | i0 | 61.8 | 0.982142857142857 | 55 | 21 | 98.2 | 0 | 167 | 3 | 574 | 628 | OGR89178.1 MAG: hypothetical protein A2992_09975 [Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_59_12] | diamond | 165 | 68.9 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_59_12 | ||||||
| 27579712 | 27579712 | PRJNA312107_P_NODE_23784_length_164_cov_0.904348_g23618_i0 | PRJNA312107 | 23784 | 164 | 0.904348 | 1.48313072 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 91.7 | 7.45e-20 | NR | UPT72808.1 | 2030800 | g23618 | i0 | 92.6 | 10.8658536585366 | 54 | 4 | 98.8 | 0 | 1 | 162 | 434 | 487 | UPT72808.1 MAG: efflux RND transporter permease subunit [Elusimicrobiota bacterium] | diamond | 1782 | 91.7 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 27643113 | 27643113 | PRJNA312107_P_NODE_20244_length_168_cov_0.873950_g20078_i0 | PRJNA312107 | 20244 | 168 | 0.87395 | 1.468236 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 74.7 | 7.06e-14 | NR | MFA5860034.1 | 2030800 | g20078 | i0 | 63.6 | 0.982142857142857 | 55 | 20 | 98.2 | 0 | 3 | 167 | 773 | 827 | MFA5860034.1 fibronectin type III domain-containing protein [Elusimicrobiota bacterium] | diamond | 165 | 74.7 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 29032429 | 29032429 | PRJNA312107_P_NODE_21788_length_166_cov_0.888889_g21622_i0 | PRJNA312107 | 21788 | 166 | 0.888889 | 1.47555574 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 60.1 | 9.64e-9 | NR | MFA5779178.1 | 2030800 | g21622 | i0 | 65.9 | 5.02409638554217 | 44 | 15 | 79.5 | 0 | 12 | 143 | 105 | 148 | MFA5779178.1 glycine-rich domain-containing protein [Elusimicrobiota bacterium] | diamond | 834 | 60.1 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 29284594 | 29284594 | PRJNA312107_P_NODE_24649_length_163_cov_0.912281_g24483_i0 | PRJNA312107 | 24649 | 163 | 0.912281 | 1.48701803 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 53.1 | 2.72e-6 | NR | MBL8022726.1 | 2030800 | g24483 | i0 | 48.1 | 0.993865030674847 | 54 | 28 | 99.4 | 0 | 162 | 1 | 335 | 388 | MBL8022726.1 metallophosphoesterase [Elusimicrobiota bacterium] | diamond | 162 | 53.1 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 29568877 | 29568877 | PRJNA312107_P_NODE_21990_length_166_cov_0.888889_g21824_i0 | PRJNA312107 | 21990 | 166 | 0.888889 | 1.47555574 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 82 | 1.66e-16 | NR | MBI4217706.1 | 2030800 | g21824 | i0 | 72.7 | 2.98192771084337 | 55 | 15 | 99.4 | 0 | 1 | 165 | 366 | 420 | MBI4217706.1 hypothetical protein [Elusimicrobiota bacterium] | diamond | 495 | 82 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 29853189 | 29853189 | PRJNA312107_P_NODE_24491_length_163_cov_0.912281_g24325_i0 | PRJNA312107 | 24491 | 163 | 0.912281 | 1.48701803 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 57 | 8.75e-9 | NR | MEQ1919919.1 | 2030800 | g24325 | i0 | 86.7 | 0.552147239263804 | 30 | 4 | 55.2 | 0 | 92 | 3 | 3 | 32 | MEQ1919919.1 DUF2752 domain-containing protein [Elusimicrobiota bacterium] | diamond | 90 | 57 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 31179770 | 31179770 | PRJNA312107_P_NODE_20575_length_167_cov_0.881356_g20409_i0 | PRJNA312107 | 20575 | 167 | 0.881356 | 1.47186452 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 80.5 | 6.07e-16 | NR | HXT02172.1 | 2030800 | g20409 | i0 | 76 | 3.59281437125748 | 50 | 12 | 89.8 | 0 | 2 | 151 | 408 | 457 | HXT02172.1 8-oxoguanine deaminase [Elusimicrobiota bacterium] | diamond | 600 | 80.5 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota bacterium | ||||||
| 32319221 | 32319221 | PRJNA312107_P_NODE_22119_length_166_cov_0.888889_g21953_i0 | PRJNA312107 | 22119 | 166 | 0.888889 | 1.47555574 | Elusimicrobia bacterium RIFCSPLOWO2_ | 1797947 | Bacteria | Bacteria | 75.1 | 2.36e-15 | NR | OGR87225.1 | 1797947 | g21953 | i0 | 78.2 | 0.993975903614458 | 55 | 11 | 97.6 | 1 | 1 | 162 | 89 | 143 | OGR87225.1 MAG: hypothetical protein A3A86_05175 [Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11] | diamond | 165 | 75.1 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobia bacterium RIFCSPLOWO2_01_FULL_60_11 | ||||||
| 32666398 | 32666398 | PRJNA312107_P_NODE_23960_length_164_cov_0.904348_g23794_i0 | PRJNA312107 | 23960 | 164 | 0.904348 | 1.48313072 | Elusimicrobiota bacterium | 2030800 | Bacteria | Bacteria | 79.3 | 1.56e-15 | NR | MDE2426276.1 | 2030800 | g23794 | i0 | 70.6 | 0.932926829268293 | 51 | 15 | 93.3 | 0 | 153 | 1 | 8 | 58 | MDE2426276.1 hypothetical protein [Elusimicrobiota bacterium] | diamond | 153 | 79.3 | 1 | Bacteria | Pseudomonadati | Elusimicrobiota | Elusimicrobiota 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);;