contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10651021 | 10651021 | PRJNA473824_P_NODE_89329_length_173_cov_3.095588_g88691_i0 | PRJNA473824 | 89329 | 173 | 3.095588 | 5.35536724 | Halosolutus gelatinilyticus | 2931975 | Archaea | Archaea | 52.8 | 0.015 | NTclustered | gi|2225350841|gb|CP095491.1| | 2931975 | g88691 | i0 | 100 | 0.161849710982659 | 28 | 0 | 16 | 0 | 26 | 53 | 608769 | 608742 | Halosolutus gelatinilyticus strain SQT-29-1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halosolutus | Halosolutus gelatinilyticus | |
| 11924761 | 11924761 | PRJNA473824_P_NODE_110450_length_173_cov_2.536765_g109812_i0 | PRJNA473824 | 110450 | 173 | 2.536765 | 4.38860345 | Natronomonas halophila | 2747817 | Archaea | Archaea | 128 | 2.35e-25 | NTclustered | gi|1865516082|gb|CP058334.1| | 2747817 | g109812 | i0 | 97.333 | 0.872832369942196 | 75 | 2 | 87 | 0 | 2 | 76 | 1184121 | 1184047 | Natronomonas halophila strain C90 chromosome, complete genome | blastn | 151 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas halophila | |
| 15749658 | 15749658 | PRJNA473824_P_NODE_44273_length_184_cov_2.469388_g43635_i0 | PRJNA473824 | 44273 | 184 | 2.469388 | 4.54367392 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 178 | 2.48e-40 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g43635 | i0 | 84.409 | 1.01086956521739 | 186 | 23 | 99 | 5 | 2 | 184 | 3086411 | 3086229 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 186 | 178 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 19572436 | 19572436 | PRJNA473824_P_NODE_19676_length_266_cov_3.960699_g19038_i0 | PRJNA473824 | 19676 | 266 | 3.960699 | 10.53545934 | uncultured Methanoregula sp. | 1005933 | Archaea | Archaea | 198 | 2.95e-46 | NTclustered | gi|2621785414|emb|OY781872.1| | 1005933 | g19038 | i0 | 88.485 | 30.8834586466165 | 165 | 17 | 62 | 2 | 5 | 168 | 3104125 | 3103962 | MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 | blastn | 8215 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 23399404 | 23399404 | PRJNA473824_P_NODE_60759_length_173_cov_4.757353_g60121_i0 | PRJNA473824 | 60759 | 173 | 4.757353 | 8.23022069 | Halorientalis sp. IM1011 | 1932360 | Archaea | Archaea | 71.3 | 4.01e-8 | NTclustered | gi|1142895524|gb|CP019067.1| | 1932360 | g60121 | i0 | 97.561 | 1.16763005780347 | 41 | 1 | 24 | 0 | 1 | 41 | 1718003 | 1718043 | Halorientalis sp. IM1011 chromosome, complete genome | blastn | 202 | 71.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis sp. IM1011 |
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);;