contig_metadata
10 rows where bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23699939 | 23699939 | PRJNA770826_P_NODE_5519_length_360_cov_1.672026_g5348_i0 | PRJNA770826 | 5519 | 360 | 1.672026 | 6.0192936 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 191 | 6.61e-57 | NR | RYE83110.1 | 2250255 | g5348 | i0 | 79.7 | 0.983333333333333 | 118 | 24 | 98.3 | 0 | 5 | 358 | 97 | 214 | RYE83110.1 MAG: translation elongation factor EF-1 subunit alpha, partial [Methanosarcinales archaeon] | diamond | 354 | 191 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27663239 | 27663239 | PRJNA770826_P_NODE_4744_length_394_cov_1.205797_g4573_i0 | PRJNA770826 | 4744 | 394 | 1.205797 | 4.75084018 | root | 1 | Root_unresolved | Root_unresolved | 80.9 | 8.47e-15 | NR | MBO7518105.1 | 66852 | g4573 | i0 | 63.8 | 1.78934010152284 | 58 | 19 | 42.6 | 2 | 333 | 166 | 414 | 471 | MBO7518105.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 705 | 81.3 | 0.995079950799508 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28821473 | 28821473 | PRJNA770826_P_NODE_28768_length_167_cov_0.881356_g28597_i0 | PRJNA770826 | 28768 | 167 | 0.881356 | 1.47186452 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 67.4 | 2.67e-11 | NR | MEI7649455.1 | 2184052 | g28597 | i0 | 57.4 | 0.970059880239521 | 54 | 23 | 97 | 0 | 5 | 166 | 343 | 396 | MEI7649455.1 TIGR03768 family metallophosphoesterase [Methanomicrobiales archaeon] | diamond | 162 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 29326854 | 29326854 | PRJNA770826_P_NODE_43969_length_162_cov_0.858407_g43798_i0 | PRJNA770826 | 43969 | 162 | 0.858407 | 1.39061934 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 41.6 | 0.0314 | NR | HSA35153.1 | 1906667 | g43798 | i0 | 74.1 | 0.5 | 27 | 7 | 50 | 0 | 68 | 148 | 295 | 321 | HSA35153.1 AAA family ATPase [Methanomassiliicoccales archaeon] | diamond | 81 | 41.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 29390239 | 29390239 | PRJNA770826_P_NODE_24269_length_169_cov_0.866667_g24098_i0 | PRJNA770826 | 24269 | 169 | 0.866667 | 1.46466723 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 69.7 | 4.26e-12 | NR | MFL2974845.1 | 2670411 | g24098 | i0 | 56.6 | 8.16568047337278 | 53 | 23 | 94.1 | 0 | 159 | 1 | 628 | 680 | MFL2974845.1 methionine--tRNA ligase [Candidatus Thalassarchaeaceae archaeon] | diamond | 1380 | 69.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 30685054 | 30685054 | PRJNA770826_P_NODE_21753_length_173_cov_1.258065_g21582_i0 | PRJNA770826 | 21753 | 173 | 1.258065 | 2.17645245 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 50.4 | 1.01e-5 | NR | WP_155396839.1 | 2208 | g21582 | i0 | 53.1 | 0.84971098265896 | 49 | 22 | 85 | 1 | 21 | 167 | 23 | 70 | WP_155396839.1 hypothetical protein [Methanosarcina barkeri] | diamond | 147 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 30906548 | 30906548 | PRJNA770826_P_NODE_25514_length_168_cov_0.873950_g25343_i0 | PRJNA770826 | 25514 | 168 | 0.87395 | 1.468236 | Methanothrix soehngenii | 2223 | Archaea | Archaea | 57 | 1.23e-7 | NR | HNY34772.1 | 2223 | g25343 | i0 | 63 | 0.821428571428571 | 46 | 16 | 82.1 | 1 | 2 | 139 | 211 | 255 | HNY34772.1 hypothetical protein [Methanothrix soehngenii] | diamond | 138 | 57 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix soehngenii | |
| 31042669 | 31042669 | PRJNA770826_P_NODE_20935_length_177_cov_1.218750_g20764_i0 | PRJNA770826 | 20935 | 177 | 1.21875 | 2.1571875 | Methanococcoides | 2225 | Archaea | Archaea | 85.1 | 1.34e-17 | NR | WP_048204366.1 | 2226 | g20764 | i0 | 78.4 | 2.59322033898305 | 51 | 11 | 86.4 | 0 | 21 | 173 | 186 | 236 | WP_048204366.1 serine hydroxymethyltransferase [Methanococcoides methylutens] | diamond | 459 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanococcoides | Methanococcoides methylutens | |
| 31412141 | 31412141 | PRJNA770826_P_NODE_16836_length_197_cov_1.405405_g16665_i0 | PRJNA770826 | 16836 | 197 | 1.405405 | 2.76864785 | unclassified Archaeoglobus | 2643606 | Archaea | Archaea | 62.4 | 1.61e-9 | NR | WP_290596002.1 | 2643606 | g16665 | i0 | 43.8 | 0.974619289340102 | 64 | 34 | 97.5 | 1 | 197 | 6 | 167 | 228 | WP_290596002.1 MULTISPECIES: alpha/beta hydrolase [unclassified Archaeoglobus] | diamond | 192 | 62.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobus | |||
| 32244512 | 32244512 | PRJNA770826_P_NODE_2238_length_581_cov_2.770677_g2074_i0 | PRJNA770826 | 2238 | 581 | 2.770677 | 16.09763337 | Geoglobus | 190818 | Archaea | Archaea | 187 | 5.519999999999998e-55 | NR | WP_048095167.1 | 113653 | g2074 | i0 | 48.7 | 1.99311531841652 | 193 | 96 | 99.7 | 2 | 579 | 1 | 46 | 235 | WP_048095167.1 bis-aminopropyl spermidine synthase family protein [Geoglobus ahangari] | diamond | 1158 | 187 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Geoglobus | Geoglobus ahangari |
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);;