contig_metadata
8 rows where bioproject = "PRJNA975724" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 945647 | 945647 | PRJNA975724_S_NODE_2181_length_647_cov_6.168990_g2011_i0 | PRJNA975724 | 2181 | 647 | 6.16899 | 39.9133653 | root | 1 | Root_unresolved | Root_unresolved | 226 | 7.2099999999999995e-68 | NR | MBX7076496.1 | 2099680 | g2011 | i0 | 60.3 | 6.12982998454405 | 199 | 79 | 92.3 | 0 | 2 | 598 | 292 | 490 | MBX7076496.1 F0F1 ATP synthase subunit alpha [Methanobacteriaceae archaeon] | diamond | 3966 | 226 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 6049113 | 6049113 | PRJNA975724_S_NODE_33085_length_338_cov_2.883019_g32904_i0 | PRJNA975724 | 33085 | 338 | 2.883019 | 9.74460422 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 144 | 2.68e-41 | NR | HJN55548.1 | 2163009 | g32904 | i0 | 71.7 | 1.64201183431953 | 92 | 26 | 81.7 | 0 | 338 | 63 | 94 | 185 | HJN55548.1 peptidylprolyl isomerase [Candidatus Poseidoniales archaeon] | diamond | 555 | 144 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 23898907 | 23898907 | PRJNA975724_S_NODE_52539_length_292_cov_2.109589_g52358_i0 | PRJNA975724 | 52539 | 292 | 2.109589 | 6.15999988 | Halogeometricum borinquense | 60847 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1810666233|gb|CP048739.1| | 60847 | g52358 | i0 | 96.97 | 0.113013698630137 | 33 | 1 | 11 | 0 | 58 | 90 | 3003417 | 3003385 | Halogeometricum borinquense strain wsp4 chromosome, complete genome | blastn | 33 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogeometricum | Halogeometricum borinquense | |
| 27278956 | 27278956 | PRJNA975724_S_NODE_19203_length_390_cov_2.835962_g19022_i0 | PRJNA975724 | 19203 | 390 | 2.835962 | 11.0602518 | Thermococci archaeon | 2250254 | Archaea | Archaea | 68.9 | 1.66e-11 | NR | NPA48192.1 | 2250254 | g19022 | i0 | 47.5 | 0.469230769230769 | 61 | 32 | 46.9 | 0 | 2 | 184 | 119 | 179 | NPA48192.1 nicotinamidase [Thermococci archaeon] | diamond | 183 | 68.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococci archaeon | |||||
| 28200644 | 28200644 | PRJNA975724_S_NODE_42226_length_314_cov_2.755187_g42045_i0 | PRJNA975724 | 42226 | 314 | 2.755187 | 8.65128718 | Archaea | 2157 | Archaea | Archaea | 55.1 | 3.85e-6 | NR | MCK5253134.1 | 1906666 | g42045 | i0 | 54.9 | 1.43312101910828 | 51 | 19 | 47.8 | 2 | 5 | 154 | 445 | 492 | MCK5253134.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Thermoplasmata archaeon] | diamond | 450 | 55.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28769111 | 28769111 | PRJNA975724_S_NODE_35147_length_332_cov_2.420849_g34966_i0 | PRJNA975724 | 35147 | 332 | 2.420849 | 8.03721868 | Archaea | 2157 | Archaea | Archaea | 69.7 | 2.73e-11 | NR | GIQ98002.1 | 2163009 | g34966 | i0 | 39.8 | 4.50903614457831 | 83 | 48 | 75 | 1 | 6 | 254 | 266 | 346 | GIQ98002.1 MAG: diacylglycerol kinase [Candidatus Poseidoniales archaeon] | diamond | 1497 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 32017412 | 32017412 | PRJNA975724_S_NODE_1458_length_724_cov_14.678955_g1306_i0 | PRJNA975724 | 1458 | 724 | 14.678955 | 106.2756342 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 72.8 | 1.47e-10 | NR | MEC7255192.1 | 2806419 | g1306 | i0 | 32.7 | 0.948895027624309 | 110 | 73 | 45.6 | 1 | 1 | 330 | 878 | 986 | MEC7255192.1 putative Ig domain-containing protein [Thermoplasmatota archaeon] | diamond | 687 | 72.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32175869 | 32175869 | PRJNA975724_S_NODE_28618_length_352_cov_4.989247_g28437_i0 | PRJNA975724 | 28618 | 352 | 4.989247 | 17.56214944 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 48.9 | 8.31e-4 | NR | MDO9537579.1 | 1906666 | g28437 | i0 | 53.2 | 0.400568181818182 | 47 | 22 | 40.1 | 0 | 352 | 212 | 376 | 422 | MDO9537579.1 hydroxymethylglutaryl-CoA reductase, degradative [Thermoplasmata archaeon] | diamond | 141 | 48.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon |
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);;