contig_metadata
7 rows where bioproject = "PRJNA1240804", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Methylomirabilota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5452486 | 5452486 | PRJNA1240804_P_NODE_79285_length_187_cov_1.333333_g78919_i0 | PRJNA1240804 | 79285 | 187 | 1.333333 | 2.49333271 | uncultured Methylomirabilota bacterium | 991135 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2874253892|emb|OY970067.1| | 991135 | g78919 | i0 | 92.308 | 0.20855614973262 | 39 | 2 | 20 | 1 | 79 | 116 | 2900642 | 2900680 | MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 | blastn | 39 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | uncultured Methylomirabilota bacterium | ||||||
| 6726007 | 6726007 | PRJNA1240804_P_NODE_39946_length_238_cov_1.026455_g39580_i0 | PRJNA1240804 | 39946 | 238 | 1.026455 | 2.4429629 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 78.6 | 7.98e-15 | NR | HEV8441405.1 | 2072417 | g39580 | i0 | 77.8 | 3.42857142857143 | 54 | 12 | 68.1 | 0 | 223 | 62 | 408 | 461 | HEV8441405.1 class II fumarate hydratase [Candidatus Methylomirabilota bacterium] | diamond | 816 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27041946 | 27041946 | PRJNA1240804_P_NODE_72502_length_192_cov_0.986014_g72136_i0 | PRJNA1240804 | 72502 | 192 | 0.986014 | 1.89314688 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 42.7 | 0.0191 | NR | HZS34569.1 | 2072417 | g72136 | i0 | 43.9 | 0.890625 | 57 | 31 | 87.5 | 1 | 186 | 19 | 275 | 331 | HZS34569.1 prolipoprotein diacylglyceryl transferase [Candidatus Methylomirabilota bacterium] | diamond | 171 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28305123 | 28305123 | PRJNA1240804_P_NODE_107506_length_169_cov_0.866667_g107140_i0 | PRJNA1240804 | 107506 | 169 | 0.866667 | 1.46466723 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 48.9 | 9.25e-5 | NR | HWN97073.1 | 2072417 | g107140 | i0 | 37.5 | 1.95266272189349 | 56 | 35 | 99.4 | 0 | 2 | 169 | 478 | 533 | HWN97073.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 330 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30010506 | 30010506 | PRJNA1240804_P_NODE_66971_length_197_cov_0.959459_g66605_i0 | PRJNA1240804 | 66971 | 197 | 0.959459 | 1.89013423 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 63.5 | 9.05e-10 | NR | NJD69336.1 | 2072417 | g66605 | i0 | 82.1 | 0.593908629441624 | 39 | 7 | 59.4 | 0 | 8 | 124 | 8 | 46 | NJD69336.1 TonB-dependent receptor [Candidatus Methylomirabilota bacterium] | diamond | 117 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30818361 | 30818361 | PRJNA1240804_P_NODE_121234_length_167_cov_0.881356_g120868_i0 | PRJNA1240804 | 121234 | 167 | 0.881356 | 1.47186452 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.9 | 9.98e-22 | NR | HTZ31349.1 | 2072417 | g120868 | i0 | 85.7 | 6.16167664670659 | 49 | 7 | 88 | 0 | 162 | 16 | 214 | 262 | HTZ31349.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 1029 | 96.3 | 0.995846313603323 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31355753 | 31355753 | PRJNA1240804_P_NODE_137116_length_164_cov_0.904348_g136750_i0 | PRJNA1240804 | 137116 | 164 | 0.904348 | 1.48313072 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.2 | 1.29e-5 | NR | HEX2441991.1 | 2072417 | g136750 | i0 | 60.5 | 3.16463414634146 | 43 | 17 | 78.7 | 0 | 160 | 32 | 129 | 171 | HEX2441991.1 cytochrome c/FTR1 family iron permease [Candidatus Methylomirabilota bacterium] | diamond | 519 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota 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);;