contig_metadata
9 rows where bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7969438 | 7969438 | PRJNA1174234_P_NODE_3407_length_714_cov_2.148206_g3228_i0 | PRJNA1174234 | 3407 | 714 | 2.148206 | 15.33819084 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 62.1 | 1.19e-4 | NTclustered | gi|2108430933|gb|CP070629.1| | 1906666 | g3228 | i0 | 97.222 | 4.54901960784314 | 36 | 1 | 5 | 0 | 81 | 116 | 816497 | 816462 | MAG: Thermoplasmata archaeon isolate bin983 chromosome | blastn | 3248 | 62.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27861727 | 27861727 | PRJNA1174234_P_NODE_31065_length_248_cov_0.880000_g30869_i0 | PRJNA1174234 | 31065 | 248 | 0.88 | 2.1824 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 50.1 | 9.84e-5 | NR | MEI6842808.1 | 2184052 | g30869 | i0 | 42.9 | 1.51209677419355 | 56 | 30 | 65.3 | 1 | 245 | 84 | 78 | 133 | MEI6842808.1 protein kinase [Methanomicrobiales archaeon] | diamond | 375 | 50.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 27912391 | 27912391 | PRJNA1174234_P_NODE_17205_length_333_cov_0.888462_g17009_i0 | PRJNA1174234 | 17205 | 333 | 0.888462 | 2.95857846 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0162 | NR | RLG73092.1 | 2026739 | g17009 | i0 | 34.1 | 1.58558558558559 | 91 | 51 | 73.9 | 1 | 79 | 324 | 478 | 568 | RLG73092.1 MAG: hypothetical protein DRO11_00595 [Methanobacteriota archaeon] | diamond | 528 | 45.1 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28619824 | 28619824 | PRJNA1174234_P_NODE_34267_length_243_cov_0.905882_g34071_i0 | PRJNA1174234 | 34267 | 243 | 0.905882 | 2.20129326 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 83.2 | 1.67e-16 | NR | MBJ16883.1 | 2026739 | g34071 | i0 | 60.9 | 2.37037037037037 | 64 | 25 | 79 | 0 | 196 | 5 | 117 | 180 | MBJ16883.1 histidine--tRNA ligase [Methanobacteriota archaeon] | diamond | 576 | 83.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28670483 | 28670483 | PRJNA1174234_P_NODE_21027_length_301_cov_1.350877_g20831_i0 | PRJNA1174234 | 21027 | 301 | 1.350877 | 4.06613977 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 4.86e-9 | NR | HJH57925.1 | 2026739 | g20831 | i0 | 36.4 | 4.07641196013289 | 99 | 59 | 94.7 | 1 | 301 | 17 | 372 | 470 | HJH57925.1 5'-nucleotidase C-terminal domain-containing protein [Methanobacteriota archaeon] | diamond | 1227 | 63.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31291930 | 31291930 | PRJNA1174234_P_NODE_11215_length_412_cov_2.427729_g11019_i0 | PRJNA1174234 | 11215 | 412 | 2.427729 | 10.00224348 | root | 1 | Root_unresolved | Root_unresolved | 198 | 1.03e-58 | NR | MDA7464093.1 | 1915863 | g11019 | i0 | 63.8 | 2.78155339805825 | 130 | 45 | 94.7 | 1 | 20 | 409 | 309 | 436 | MDA7464093.1 DNA photolyase family protein [Candidatus Poseidonia alphae] | diamond | 1146 | 198 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 31355406 | 31355406 | PRJNA1174234_P_NODE_32116_length_246_cov_1.208092_g31920_i0 | PRJNA1174234 | 32116 | 246 | 1.208092 | 2.97190632 | Methanobacteriati | 3366610 | Archaea | Archaea | 44.7 | 0.00404 | NR | RZD50530.1 | 2026739 | g31920 | i0 | 47.5 | 1.54878048780488 | 40 | 21 | 48.8 | 0 | 121 | 2 | 115 | 154 | RZD50530.1 MAG: hypothetical protein CXT66_02840 [Methanobacteriota archaeon] | diamond | 381 | 44.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31589335 | 31589335 | PRJNA1174234_P_NODE_24376_length_279_cov_1.106796_g24180_i0 | PRJNA1174234 | 24376 | 279 | 1.106796 | 3.08796084 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 43.1 | 0.0386 | NR | MDD1753682.1 | 2595067 | g24180 | i0 | 41.3 | 0.67741935483871 | 63 | 30 | 67.7 | 2 | 59 | 247 | 120 | 175 | MDD1753682.1 thermosome subunit [Methanotrichaceae archaeon] | diamond | 189 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 32790106 | 32790106 | PRJNA1174234_P_NODE_31160_length_248_cov_0.880000_g30964_i0 | PRJNA1174234 | 31160 | 248 | 0.88 | 2.1824 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 57.8 | 1.99e-7 | NR | HNJ81026.1 | 2485498 | g30964 | i0 | 41.7 | 0.725806451612903 | 60 | 33 | 72.6 | 1 | 203 | 24 | 603 | 660 | HNJ81026.1 Ig-like domain-containing protein [Methanoregulaceae archaeon] | diamond | 180 | 57.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae 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);;