contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 286907 | 286907 | PRJNA1144090_P_NODE_116221_length_241_cov_0.916667_g115686_i0 | PRJNA1144090 | 116221 | 241 | 0.916667 | 2.20916747 | Archaeoglobus sulfaticallidus | 1316941 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|484591393|gb|CP005290.1| | 387631 | g115686 | i0 | 96.97 | 0.136929460580913 | 33 | 0 | 13 | 1 | 142 | 173 | 218801 | 218833 | Archaeoglobus sulfaticallidus PM70-1, complete genome | blastn | 33 | 54.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobus | Archaeoglobus sulfaticallidus | ||
| 5390604 | 5390604 | PRJNA1144090_P_NODE_51545_length_355_cov_2.021277_g51010_i0 | PRJNA1144090 | 51545 | 355 | 2.021277 | 7.17553335 | Methanosarcina barkeri | 2208 | Archaea | Archaea | 54.7 | 0.009 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g51010 | i0 | 100 | 0.0816901408450704 | 29 | 0 | 8 | 0 | 86 | 114 | 3731152 | 3731180 | Methanosarcina barkeri CM1, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 6665558 | 6665558 | PRJNA1144090_P_NODE_74266_length_293_cov_1.936364_g73731_i0 | PRJNA1144090 | 74266 | 293 | 1.936364 | 5.67354652 | Halorientalis marina | 2931976 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|2225350885|gb|CP095487.1| | 2931976 | g73731 | i0 | 96.875 | 0.109215017064846 | 32 | 1 | 11 | 0 | 154 | 185 | 660418 | 660449 | Halorientalis marina strain GDY88 chromosome, complete genome | blastn | 32 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis marina | |
| 7939975 | 7939975 | PRJNA1144090_P_NODE_111567_length_244_cov_0.900585_g111032_i0 | PRJNA1144090 | 111567 | 244 | 0.900585 | 2.1974274 | Natribaculum breve | 1419050 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2224381021|gb|CP095390.1| | 1419050 | g111032 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 18 | 45 | 2199606 | 2199579 | Natribaculum breve strain TRM20010 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natribaculum | Natribaculum breve | |
| 11765819 | 11765819 | PRJNA1144090_P_NODE_28330_length_497_cov_1.275943_g27796_i0 | PRJNA1144090 | 28330 | 497 | 1.275943 | 6.34143671 | Methanosphaera stadtmanae | 2317 | Archaea | Archaea | 54.7 | 0.013 | NTclustered | gi|1721134173|emb|LR698975.1| | 2317 | g27796 | i0 | 100 | 0.0583501006036217 | 29 | 0 | 6 | 0 | 401 | 429 | 1447215 | 1447243 | Methanosphaera stadtmanae isolate MGYG-HGUT-02164 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera stadtmanae | |
| 21963656 | 21963656 | PRJNA1144090_P_NODE_109238_length_245_cov_0.895349_g108703_i0 | PRJNA1144090 | 109238 | 245 | 0.895349 | 2.19360505 | Natrononativus amylolyticus | 2963434 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2274417431|gb|CP101458.1| | 2963434 | g108703 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 44 | 71 | 2451136 | 2451163 | Natrononativus amylolyticus strain CGA73 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrononativus | Natrononativus amylolyticus |
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);;