contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14689090 | 14689090 | PRJNA682078_P_NODE_202572_length_261_cov_2.026596_g200795_i0 | PRJNA682078 | 202572 | 261 | 2.026596 | 5.28941556 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 1.22e-7 | NR | MCX9024633.1 | 2032688 | g200795 | i0 | 73.3 | 2.06896551724138 | 30 | 8 | 34.5 | 0 | 259 | 170 | 66 | 95 | MCX9024633.1 HNH endonuclease signature motif containing protein [Candidatus Methanoperedens sp.] | diamond | 540 | 55.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 26797230 | 26797230 | PRJNA682078_P_NODE_201761_length_262_cov_1.259259_g199984_i0 | PRJNA682078 | 201761 | 262 | 1.259259 | 3.29925858 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 64.3 | 1.17e-9 | NR | HOT07308.1 | 2595067 | g199984 | i0 | 87.9 | 0.744274809160305 | 33 | 4 | 37.8 | 0 | 164 | 262 | 1 | 33 | HOT07308.1 FkbM family methyltransferase [Methanotrichaceae archaeon] | diamond | 195 | 64.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 27492908 | 27492908 | PRJNA682078_P_NODE_207723_length_258_cov_2.281081_g205946_i0 | PRJNA682078 | 207723 | 258 | 2.281081 | 5.88518898 | Haloarchaeobius litoreus | 755306 | Archaea | Archaea | 48.5 | 3.43e-4 | NR | WP_256398896.1 | 755306 | g205946 | i0 | 50 | 0.534883720930233 | 46 | 21 | 51.2 | 1 | 161 | 30 | 10 | 55 | WP_256398896.1 hypothetical protein [Haloarchaeobius litoreus] | diamond | 138 | 48.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius litoreus | |
| 27714277 | 27714277 | PRJNA682078_P_NODE_121444_length_324_cov_0.808765_g119667_i0 | PRJNA682078 | 121444 | 324 | 0.808765 | 2.6203986 | Halobacteriales archaeon QS_5_7 | 1904752 | Archaea | Archaea | 43.5 | 0.0431 | NR | PSQ11283.1 | 1919180 | g119667 | i0 | 35.4 | 0.888888888888889 | 96 | 57 | 84.3 | 2 | 34 | 306 | 89 | 184 | PSQ11283.1 MAG: hypothetical protein BRC93_06035 [Halobacteriales archaeon QS_5_70_15] | diamond | 288 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QS_5_70_15 | |||
| 28092757 | 28092757 | PRJNA682078_P_NODE_293025_length_241_cov_0.863095_g291248_i0 | PRJNA682078 | 293025 | 241 | 0.863095 | 2.08005895 | Haloarcula | 2237 | Archaea | Archaea | 43.5 | 0.00443 | NR | WP_284009536.1 | 2237 | g291248 | i0 | 32.4 | 0.883817427385892 | 71 | 46 | 85.9 | 1 | 11 | 217 | 5 | 75 | WP_284009536.1 MULTISPECIES: hypothetical protein [Haloarcula] | diamond | 213 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | ||
| 28420397 | 28420397 | PRJNA682078_P_NODE_86926_length_374_cov_0.943522_g85151_i0 | PRJNA682078 | 86926 | 374 | 0.943522 | 3.52877228 | root | 1 | Root_unresolved | Root_unresolved | 142 | 1.35e-38 | NR | HET8689236.1 | 2213 | g85151 | i0 | 83.5 | 2.5427807486631 | 79 | 13 | 63.4 | 0 | 5 | 241 | 235 | 313 | HET8689236.1 hypothetical protein [Methanosarcina sp.] | diamond | 951 | 143 | 0.993006993006993 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28850309 | 28850309 | PRJNA682078_P_NODE_122468_length_322_cov_2.120482_g120691_i0 | PRJNA682078 | 122468 | 322 | 2.120482 | 6.8279520399999996 | Methanosarcina sp. | 2213 | Archaea | Archaea | 105 | 2.61e-26 | NR | HET8689243.1 | 2213 | g120691 | i0 | 64.9 | 0.68944099378882 | 74 | 26 | 68.9 | 0 | 3 | 224 | 91 | 164 | HET8689243.1 hypothetical protein [Methanosarcina sp.] | diamond | 222 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28945531 | 28945531 | PRJNA682078_P_NODE_210168_length_257_cov_1.576087_g208391_i0 | PRJNA682078 | 210168 | 257 | 1.576087 | 4.05054359 | Methanosarcina sp. | 2213 | Archaea | Archaea | 105 | 3.67e-27 | NR | HET8685164.1 | 2213 | g208391 | i0 | 57.6 | 0.992217898832685 | 85 | 36 | 99.2 | 0 | 255 | 1 | 9 | 93 | HET8685164.1 hypothetical protein [Methanosarcina sp.] | diamond | 255 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29797682 | 29797682 | PRJNA682078_P_NODE_281651_length_242_cov_0.911243_g279874_i0 | PRJNA682078 | 281651 | 242 | 0.911243 | 2.20520806 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 53.9 | 4.91e-7 | NR | HQJ88396.1 | 2485498 | g279874 | i0 | 61.4 | 1.42561983471074 | 57 | 18 | 65.7 | 1 | 82 | 240 | 1 | 57 | HQJ88396.1 hypothetical protein [Methanoregulaceae archaeon] | diamond | 345 | 53.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 29955757 | 29955757 | PRJNA682078_P_NODE_58551_length_449_cov_1.000000_g56778_i0 | PRJNA682078 | 58551 | 449 | 1 | 4.49 | Methanosarcina sp. | 2213 | Archaea | Archaea | 199 | 2.92e-58 | NR | HET8689240.1 | 2213 | g56778 | i0 | 74.4 | 1.73051224944321 | 129 | 33 | 86.2 | 0 | 446 | 60 | 315 | 443 | HET8689240.1 hypothetical protein [Methanosarcina sp.] | diamond | 777 | 199 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31030180 | 31030180 | PRJNA682078_P_NODE_195675_length_265_cov_2.130208_g193898_i0 | PRJNA682078 | 195675 | 265 | 2.130208 | 5.6450512 | Salinigranum rubrum | 755307 | Archaea | Archaea | 43.1 | 0.0238 | NR | WP_162562412.1 | 755307 | g193898 | i0 | 31.7 | 1.35849056603774 | 60 | 41 | 67.9 | 0 | 59 | 238 | 118 | 177 | WP_162562412.1 hypothetical protein [Salinigranum rubrum] | diamond | 360 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinigranum | Salinigranum rubrum | |
| 31946860 | 31946860 | PRJNA682078_P_NODE_253077_length_246_cov_2.421965_g251300_i0 | PRJNA682078 | 253077 | 246 | 2.421965 | 5.9580339 | Methanosarcina sp. | 2213 | Archaea | Archaea | 80.5 | 2.01e-15 | NR | HET8689294.1 | 2213 | g251300 | i0 | 68.2 | 0.536585365853659 | 44 | 14 | 53.7 | 0 | 246 | 115 | 561 | 604 | HET8689294.1 hypothetical protein [Methanosarcina sp.] | diamond | 132 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32737351 | 32737351 | PRJNA682078_P_NODE_111660_length_335_cov_3.167939_g109883_i0 | PRJNA682078 | 111660 | 335 | 3.167939 | 10.61259565 | Methanosarcina sp. | 2213 | Archaea | Archaea | 79 | 2.16e-14 | NR | HET8689298.1 | 2213 | g109883 | i0 | 38 | 1.78208955223881 | 108 | 63 | 95.8 | 2 | 328 | 8 | 114 | 218 | HET8689298.1 hypothetical protein [Methanosarcina sp.] | diamond | 597 | 79 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. |
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);;