contig_metadata
10 rows where 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 | |
| 27265972 | 27265972 | PRJNA473824_P_NODE_59543_length_173_cov_4.919118_g58905_i0 | PRJNA473824 | 59543 | 173 | 4.919118 | 8.51007414 | Halopenitus sp. | 1979403 | Archaea | Archaea | 90.1 | 2.92e-19 | NR | MFB6235430.1 | 1979403 | g58905 | i0 | 72.3 | 1.1271676300578 | 65 | 10 | 98.8 | 1 | 171 | 1 | 111 | 175 | MFB6235430.1 type II secretion system F family protein [Halopenitus sp.] | diamond | 195 | 90.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. | |
| 29649748 | 29649748 | PRJNA473824_P_NODE_111810_length_173_cov_2.477941_g111172_i0 | PRJNA473824 | 111810 | 173 | 2.477941 | 4.28683793 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.028 | NR | WP_321507132.1 | 1005933 | g111172 | i0 | 57.6 | 0.988439306358382 | 33 | 14 | 57.2 | 0 | 106 | 8 | 1288 | 1320 | WP_321507132.1 PKD domain-containing protein [uncultured Methanoregula sp.] | diamond | 171 | 42.4 | 0.990566037735849 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 31656291 | 31656291 | PRJNA473824_P_NODE_26257_length_231_cov_5.438144_g25619_i0 | PRJNA473824 | 26257 | 231 | 5.438144 | 12.56211264 | Methanothrix sp. | 90426 | Archaea | Archaea | 45.8 | 0.00258 | NR | MCX6674574.1 | 90426 | g25619 | i0 | 62.5 | 0.415584415584416 | 32 | 12 | 41.6 | 0 | 6 | 101 | 644 | 675 | MCX6674574.1 discoidin domain-containing protein [Methanothrix sp.] | diamond | 96 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 32447682 | 32447682 | PRJNA473824_P_NODE_38199_length_196_cov_1.716981_g37561_i0 | PRJNA473824 | 38199 | 196 | 1.716981 | 3.36528276 | Methanothrix sp. | 90426 | Archaea | Archaea | 44.7 | 0.00325 | NR | MCK9441979.1 | 90426 | g37561 | i0 | 77.3 | 1.04081632653061 | 22 | 5 | 33.7 | 0 | 1 | 66 | 72 | 93 | MCK9441979.1 hypothetical protein [Methanothrix sp.] | diamond | 204 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 32542566 | 32542566 | PRJNA473824_P_NODE_113319_length_173_cov_2.397059_g112681_i0 | PRJNA473824 | 113319 | 173 | 2.397059 | 4.14691207 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 55.1 | 2.56e-7 | NR | WP_120068875.1 | 2321230 | g112681 | i0 | 77.1 | 1.04046242774566 | 35 | 8 | 60.7 | 0 | 2 | 106 | 107 | 141 | WP_120068875.1 hypothetical protein [Halococcus sp. IIIV-5B] | diamond | 180 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B |
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);;