contig_metadata
10 rows where bioproject = "PRJNA1126661" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4109811 | 4109811 | PRJNA1126661_P_NODE_75964_length_238_cov_3.387879_g75434_i0 | PRJNA1126661 | 75964 | 238 | 3.387879 | 8.06315202 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 390 | 3.99e-104 | NTclustered | gi|2176096791|gb|CP090373.1| | 2904243 | g75434 | i0 | 96.218 | 38.8865546218487 | 238 | 9 | 100 | 0 | 1 | 238 | 806 | 1043 | Halobaculum sp. CBA1158 plasmid pCBA1158-2, complete sequence | blastn | 9255 | 390 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 10486332 | 10486332 | PRJNA1126661_P_NODE_77009_length_234_cov_8.155280_g76479_i0 | PRJNA1126661 | 77009 | 234 | 8.15528 | 19.0833552 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 272 | 1.4799999999999999e-68 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g76479 | i0 | 87.866 | 2.05555555555556 | 239 | 20 | 99 | 6 | 4 | 234 | 2084402 | 2084165 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 481 | 272 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 20684036 | 20684036 | PRJNA1126661_P_NODE_52897_length_292_cov_4.913242_g52368_i0 | PRJNA1126661 | 52897 | 292 | 4.913242 | 14.34666664 | Haloarcula regularis | 3033392 | Archaea | Archaea | 302 | 2.43e-77 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g52368 | i0 | 94.819 | 22.5616438356164 | 193 | 10 | 66 | 0 | 100 | 292 | 22751 | 22943 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 6588 | 302 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 26848969 | 26848969 | PRJNA1126661_P_NODE_32121_length_316_cov_4.757202_g31592_i0 | PRJNA1126661 | 32121 | 316 | 4.757202 | 15.03275832 | Methanococcoides methylutens | 2226 | Archaea | Archaea | 140 | 6.15e-37 | NR | WP_052721412.1 | 2226 | g31592 | i0 | 49.7 | 2.59177215189873 | 143 | 34 | 99.7 | 1 | 1 | 315 | 179 | 321 | WP_052721412.1 VWA domain-containing protein [Methanococcoides methylutens] | diamond | 819 | 140 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanococcoides | Methanococcoides methylutens | |
| 27291628 | 27291628 | PRJNA1126661_P_NODE_35423_length_301_cov_5.934211_g34894_i0 | PRJNA1126661 | 35423 | 301 | 5.934211 | 17.86197511 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 147 | 7.51e-41 | NR | MEE0901010.1 | 66852 | g34894 | i0 | 96.1 | 0.767441860465116 | 77 | 3 | 76.7 | 0 | 301 | 71 | 247 | 323 | MEE0901010.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 231 | 147 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 28049433 | 28049433 | PRJNA1126661_P_NODE_30585_length_325_cov_14.599206_g30056_i0 | PRJNA1126661 | 30585 | 325 | 14.599206 | 47.4474195 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 94.7 | 5.63e-20 | NR | MCH7661053.1 | 2026739 | g30056 | i0 | 32.5 | 4.48615384615385 | 243 | 29 | 99.7 | 1 | 325 | 2 | 199 | 441 | MCH7661053.1 MMPL family transporter [Methanobacteriota archaeon] | diamond | 1458 | 94.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28396751 | 28396751 | PRJNA1126661_P_NODE_76766_length_235_cov_5.432099_g76236_i0 | PRJNA1126661 | 76766 | 235 | 5.432099 | 12.76543265 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 108 | 7.28e-27 | NR | MEK6975271.1 | 2806419 | g76236 | i0 | 68 | 2.89787234042553 | 75 | 24 | 95.7 | 0 | 234 | 10 | 98 | 172 | MEK6975271.1 Ku protein [Thermoplasmatota archaeon] | diamond | 681 | 108 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30355193 | 30355193 | PRJNA1126661_P_NODE_30952_length_325_cov_5.595238_g30423_i0 | PRJNA1126661 | 30952 | 325 | 5.595238 | 18.1845235 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 88.2 | 1.07e-17 | NR | HUR68234.1 | 2806419 | g30423 | i0 | 89.8 | 3.15692307692308 | 49 | 5 | 45.2 | 0 | 177 | 323 | 590 | 638 | HUR68234.1 NADP-dependent malic enzyme [Thermoplasmatota archaeon] | diamond | 1026 | 88.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32851378 | 32851378 | PRJNA1126661_P_NODE_18960_length_326_cov_4.106719_g18431_i0 | PRJNA1126661 | 18960 | 326 | 4.106719 | 13.38790394 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 99 | 1.63e-21 | NR | HWR97819.1 | 2032688 | g18431 | i0 | 87.8 | 0.450920245398773 | 49 | 6 | 45.1 | 0 | 178 | 324 | 143 | 191 | HWR97819.1 ammonia-forming cytochrome c nitrite reductase subunit c552 [Candidatus Methanoperedens sp.] | diamond | 147 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 32851395 | 32851395 | PRJNA1126661_P_NODE_73180_length_245_cov_4.197674_g72650_i0 | PRJNA1126661 | 73180 | 245 | 4.197674 | 10.2843013 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 81.6 | 3.58e-16 | NR | WP_266081598.1 | 2993314 | g72650 | i0 | 52.9 | 0.857142857142857 | 70 | 32 | 85.7 | 1 | 211 | 2 | 149 | 217 | WP_266081598.1 hypothetical protein [Haladaptatus caseinilyticus] | diamond | 210 | 81.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus |
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);;