contig_metadata
8 rows where bioproject = "PRJNA1047749" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5277813 | 5277813 | PRJNA1047749_P_NODE_26085_length_299_cov_7.469027_g25818_i0 | PRJNA1047749 | 26085 | 299 | 7.469027 | 22.33239073 | Halosimplex rarum | 3396619 | Archaea | Archaea | 139 | 2.07e-28 | NTclustered | gi|2908454640|gb|CP180412.1| | 3396619 | g25818 | i0 | 84.028 | 2.67892976588629 | 144 | 23 | 48 | 0 | 13 | 156 | 1820921 | 1820778 | Halosimplex sp. TS25 chromosome, complete genome | blastn | 801 | 139 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex rarum | |
| 13763548 | 13763548 | PRJNA1047749_P_NODE_27031_length_297_cov_13.629464_g26764_i0 | PRJNA1047749 | 27031 | 297 | 13.629464 | 40.47950808 | root | 1 | Root_unresolved | Root_unresolved | 81.3 | 2.03e-15 | NR | MCE5214309.1 | 2164 | g26764 | i0 | 57.1 | 14.1414141414141 | 70 | 25 | 65.7 | 1 | 3 | 197 | 596 | 665 | MCE5214309.1 PAS domain S-box protein [Methanobacterium sp.] | diamond | 4200 | 82 | 0.991463414634146 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 15477764 | 15477764 | PRJNA1047749_P_NODE_24533_length_301_cov_3.188596_g24266_i0 | PRJNA1047749 | 24533 | 301 | 3.188596 | 9.59767396 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 69.7 | 2.54e-11 | NR | HUR69663.1 | 2806419 | g24266 | i0 | 75.6 | 1.92358803986711 | 45 | 11 | 44.9 | 0 | 286 | 152 | 868 | 912 | HUR69663.1 PAS domain S-box protein [Thermoplasmatota archaeon] | diamond | 579 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 20576121 | 20576121 | PRJNA1047749_P_NODE_27617_length_296_cov_2.901345_g27350_i0 | PRJNA1047749 | 27617 | 296 | 2.901345 | 8.5879812 | Haloglomus litoreum | 3034026 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2463606059|gb|CP119988.1| | 3034026 | g27350 | i0 | 100 | 0.101351351351351 | 30 | 0 | 10 | 0 | 245 | 274 | 1876041 | 1876012 | Haloglomus litoreum strain DT116 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Haloglomus | Haloglomus litoreum | |
| 23127619 | 23127619 | PRJNA1047749_P_NODE_45719_length_232_cov_2.622642_g45452_i0 | PRJNA1047749 | 45719 | 232 | 2.622642 | 6.08452944 | Methanobacterium aridiramus | 2584467 | Archaea | Archaea | 424 | 3.82e-114 | NTclustered | gi|2523005876|gb|CP040735.1| | 2584467 | g45452 | i0 | 99.569 | 133.836206896552 | 232 | 1 | 100 | 0 | 1 | 232 | 1375805 | 1375574 | Methanobacterium aridiramus strain CWC-01 chromosome, complete genome | blastn | 31050 | 424 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium aridiramus | |
| 24401067 | 24401067 | PRJNA1047749_P_NODE_27260_length_297_cov_3.531250_g26993_i0 | PRJNA1047749 | 27260 | 297 | 3.53125 | 10.4878125 | Halovalidus salilacus | 3075124 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2581323319|gb|CP134700.1| | 3075124 | g26993 | i0 | 100 | 0.191919191919192 | 29 | 0 | 10 | 0 | 240 | 268 | 3941006 | 3940978 | Halovalidus salilacus strain CCL63 chromosome, complete genome | blastn | 57 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halovalidus | Halovalidus salilacus | |
| 27911396 | 27911396 | PRJNA1047749_P_NODE_50825_length_203_cov_7.061538_g50558_i0 | PRJNA1047749 | 50825 | 203 | 7.061538 | 14.33492214 | root | 1 | Root_unresolved | Root_unresolved | 108 | 2.88e-27 | NR | MCD4843358.1 | 2250255 | g50558 | i0 | 81 | 4.66995073891626 | 63 | 12 | 93.1 | 0 | 189 | 1 | 41 | 103 | MCD4843358.1 type I restriction-modification system subunit M [Methanosarcinales archaeon] | diamond | 948 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30698733 | 30698733 | PRJNA1047749_P_NODE_47234_length_226_cov_9.235294_g46967_i0 | PRJNA1047749 | 47234 | 226 | 9.235294 | 20.87176444 | Methanoculleus taiwanensis | 1550565 | Archaea | Archaea | 56.6 | 3.86e-7 | NR | WP_128694369.1 | 1550565 | g46967 | i0 | 71.8 | 4.18141592920354 | 39 | 11 | 51.8 | 0 | 2 | 118 | 586 | 624 | WP_128694369.1 1,4-alpha-glucan branching protein GlgB [Methanoculleus taiwanensis] | diamond | 945 | 56.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus taiwanensis |
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);;