contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1111082" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15517862 | 15517862 | PRJNA1111082_P_NODE_12673_length_242_cov_0.923077_g12628_i0 | PRJNA1111082 | 12673 | 242 | 0.923077 | 2.23384634 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 128 | 6.249999999999998e-35 | NR | WP_054519682.1 | 1604004 | g12628 | i0 | 77.2 | 0.979338842975207 | 79 | 18 | 97.9 | 0 | 3 | 239 | 93 | 171 | WP_054519682.1 phosphoglycolate phosphatase [Halanaeroarchaeum sulfurireducens] | diamond | 237 | 128 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 26783129 | 26783129 | PRJNA1111082_P_NODE_8481_length_279_cov_1.126214_g8436_i0 | PRJNA1111082 | 8481 | 279 | 1.126214 | 3.14213706 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 43.5 | 0.0247 | NR | HUV84463.1 | 2250255 | g8436 | i0 | 41 | 0.419354838709677 | 39 | 23 | 41.9 | 0 | 260 | 144 | 15 | 53 | HUV84463.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 117 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 27469951 | 27469951 | PRJNA1111082_P_NODE_5543_length_336_cov_2.608365_g5498_i0 | PRJNA1111082 | 5543 | 336 | 2.608365 | 8.7641064 | Halostagnicola | 353799 | Archaea | Archaea | 45.8 | 0.00863 | NR | MCU4924456.1 | 2979987 | g5498 | i0 | 52.9 | 1.79464285714286 | 102 | 41 | 84.8 | 3 | 302 | 18 | 1 | 102 | MCU4924456.1 PQQ-dependent sugar dehydrogenase [Halobacteria archaeon AArc-dxtr1] | diamond | 603 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteria archaeon AArc-dxtr1 | ||||
| 27731479 | 27731479 | PRJNA1111082_P_NODE_11764_length_246_cov_0.901734_g11719_i0 | PRJNA1111082 | 11764 | 246 | 0.901734 | 2.21826564 | Halanaeroarchaeum sp. HSR-CO | 2866382 | Archaea | Archaea | 115 | 9.35e-28 | NR | WP_259518077.1 | 2866382 | g11719 | i0 | 66.7 | 0.98780487804878 | 81 | 27 | 98.8 | 0 | 244 | 2 | 304 | 384 | WP_259518077.1 hypothetical protein [Halanaeroarchaeum sp. HSR-CO] | diamond | 243 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. HSR-CO | |
| 28141865 | 28141865 | PRJNA1111082_P_NODE_11525_length_247_cov_1.195402_g11480_i0 | PRJNA1111082 | 11525 | 247 | 1.195402 | 2.95264294 | Methanosarcina sp. | 2213 | Archaea | Archaea | 117 | 1.17e-28 | NR | HET8685973.1 | 2213 | g11480 | i0 | 71.4 | 0.850202429149798 | 70 | 20 | 85 | 0 | 246 | 37 | 514 | 583 | HET8685973.1 hypothetical protein [Methanosarcina sp.] | diamond | 210 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 29679681 | 29679681 | PRJNA1111082_P_NODE_12710_length_242_cov_0.875740_g12665_i0 | PRJNA1111082 | 12710 | 242 | 0.87574 | 2.1192908 | root | 1 | Root_unresolved | Root_unresolved | 118 | 6.01e-29 | NR | HET8689288.1 | 2213 | g12665 | i0 | 65.8 | 4.89669421487603 | 79 | 27 | 97.9 | 0 | 238 | 2 | 5 | 83 | HET8689288.1 hypothetical protein [Methanosarcina sp.] | diamond | 1185 | 118 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30469964 | 30469964 | PRJNA1111082_P_NODE_8453_length_279_cov_1.893204_g8408_i0 | PRJNA1111082 | 8453 | 279 | 1.893204 | 5.28203916 | root | 1 | Root_unresolved | Root_unresolved | 87.8 | 3.85e-19 | NR | HET8686576.1 | 2213 | g8408 | i0 | 64.7 | 1.45161290322581 | 68 | 24 | 73.1 | 0 | 204 | 1 | 2 | 69 | HET8686576.1 ERF family protein [Methanosarcina sp.] | diamond | 405 | 88.2 | 0.99546485260771 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32312717 | 32312717 | PRJNA1111082_P_NODE_9019_length_270_cov_5.050761_g8974_i0 | PRJNA1111082 | 9019 | 270 | 5.050761 | 13.6370547 | Methanosarcina sp. | 2213 | Archaea | Archaea | 49.7 | 1.39e-4 | NR | HET8689075.1 | 2213 | g8974 | i0 | 44.9 | 0.544444444444444 | 49 | 27 | 54.4 | 0 | 14 | 160 | 188 | 236 | HET8689075.1 hypothetical protein [Methanosarcina sp.] | diamond | 147 | 49.7 | 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);;