contig_metadata
14 rows where bioproject = "PRJNA738523" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25424344 | 25424344 | PRJNA738523_P_NODE_16000_length_241_cov_0.916667_g15929_i0 | PRJNA738523 | 16000 | 241 | 0.916667 | 2.20916747 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 303 | 5.42e-78 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g15929 | i0 | 90.171 | 56.5228215767635 | 234 | 21 | 97 | 2 | 1 | 233 | 849066 | 849298 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 13622 | 303 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26672313 | 26672313 | PRJNA738523_P_NODE_4481_length_332_cov_0.891892_g4410_i0 | PRJNA738523 | 4481 | 332 | 0.891892 | 2.96108144 | archaeon | 1906665 | Archaea | Archaea | 143 | 2.61e-38 | NR | MDP2437844.1 | 1906665 | g4410 | i0 | 65 | 4.51807228915663 | 100 | 35 | 90.4 | 0 | 2 | 301 | 325 | 424 | MDP2437844.1 type II methionyl aminopeptidase [archaeon] | diamond | 1500 | 143 | 1 | Archaea | archaeon | ||||||||
| 26988985 | 26988985 | PRJNA738523_P_NODE_7262_length_281_cov_1.514423_g7191_i0 | PRJNA738523 | 7262 | 281 | 1.514423 | 4.25552863 | archaeon | 1906665 | Archaea | Archaea | 43.9 | 0.0212 | NR | RYH22573.1 | 1906665 | g7191 | i0 | 41 | 0.65124555160142406 | 61 | 34 | 65.1 | 1 | 243 | 61 | 138 | 196 | RYH22573.1 MAG: hypothetical protein EON65_19030, partial [archaeon] | diamond | 183 | 43.9 | 1 | Archaea | archaeon | ||||||||
| 27431946 | 27431946 | PRJNA738523_P_NODE_10943_length_250_cov_1.740113_g10872_i0 | PRJNA738523 | 10943 | 250 | 1.740113 | 4.3502825 | archaeon | 1906665 | Archaea | Archaea | 75.1 | 3.81e-15 | NR | RYG52457.1 | 1906665 | g10872 | i0 | 55.2 | 0.804 | 67 | 29 | 79.2 | 1 | 199 | 2 | 6 | 72 | RYG52457.1 MAG: hypothetical protein EON67_01195, partial [archaeon] | diamond | 201 | 75.1 | 1 | Archaea | archaeon | ||||||||
| 27747653 | 27747653 | PRJNA738523_P_NODE_13304_length_246_cov_0.890173_g13233_i0 | PRJNA738523 | 13304 | 246 | 0.890173 | 2.18982558 | archaeon | 1906665 | Archaea | Archaea | 115 | 7.2399999999999995e-28 | NR | RYG57585.1 | 1906665 | g13233 | i0 | 65 | 0.975609756097561 | 80 | 28 | 97.6 | 0 | 6 | 245 | 205 | 284 | RYG57585.1 MAG: hypothetical protein EON66_00045 [archaeon] | diamond | 240 | 115 | 1 | Archaea | archaeon | ||||||||
| 28631758 | 28631758 | PRJNA738523_P_NODE_7087_length_283_cov_1.371429_g7016_i0 | PRJNA738523 | 7087 | 283 | 1.371429 | 3.88114407 | archaeon | 1906665 | Archaea | Archaea | 115 | 9.13e-28 | NR | RYY34477.1 | 1906665 | g7016 | i0 | 62.4 | 0.985865724381625 | 93 | 35 | 98.6 | 0 | 5 | 283 | 340 | 432 | RYY34477.1 MAG: ATP-binding cassette domain-containing protein, partial [archaeon] | diamond | 279 | 115 | 1 | Archaea | archaeon | ||||||||
| 28820663 | 28820663 | PRJNA738523_P_NODE_6448_length_290_cov_1.064516_g6377_i0 | PRJNA738523 | 6448 | 290 | 1.064516 | 3.0870964 | archaeon | 1906665 | Archaea | Archaea | 49.3 | 2.98e-4 | NR | RYY33198.1 | 1906665 | g6377 | i0 | 35.7 | 0.868965517241379 | 84 | 51 | 86.9 | 3 | 290 | 39 | 162 | 242 | RYY33198.1 MAG: SET domain-containing protein-lysine N-methyltransferase, partial [archaeon] | diamond | 252 | 49.3 | 1 | Archaea | archaeon | ||||||||
| 29200030 | 29200030 | PRJNA738523_P_NODE_15449_length_242_cov_0.911243_g15378_i0 | PRJNA738523 | 15449 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 107 | 8.84e-25 | NR | MDP2436156.1 | 1906665 | g15378 | i0 | 65 | 0.991735537190083 | 80 | 28 | 99.2 | 0 | 3 | 242 | 565 | 644 | MDP2436156.1 hypothetical protein [archaeon] | diamond | 240 | 107 | 1 | Archaea | archaeon | ||||||||
| 29515393 | 29515393 | PRJNA738523_P_NODE_11070_length_250_cov_0.870056_g10999_i0 | PRJNA738523 | 11070 | 250 | 0.870056 | 2.17514 | archaeon | 1906665 | Archaea | Archaea | 70.9 | 2.38e-12 | NR | RYG51924.1 | 1906665 | g10999 | i0 | 68.8 | 0.576 | 48 | 15 | 57.6 | 0 | 250 | 107 | 196 | 243 | RYG51924.1 MAG: AAA family ATPase [archaeon] | diamond | 144 | 70.9 | 1 | Archaea | archaeon | ||||||||
| 29578520 | 29578520 | PRJNA738523_P_NODE_7270_length_281_cov_1.480769_g7199_i0 | PRJNA738523 | 7270 | 281 | 1.480769 | 4.16096089 | archaeon | 1906665 | Archaea | Archaea | 172 | 5.83e-53 | NR | MDP2438463.1 | 1906665 | g7199 | i0 | 84.9 | 0.99288256227758 | 93 | 14 | 99.3 | 0 | 280 | 2 | 6 | 98 | MDP2438463.1 MC/SLC25 family protein [archaeon] | diamond | 279 | 172 | 1 | Archaea | archaeon | ||||||||
| 29799652 | 29799652 | PRJNA738523_P_NODE_11811_length_249_cov_0.875000_g11740_i0 | PRJNA738523 | 11811 | 249 | 0.875 | 2.17875 | archaeon | 1906665 | Archaea | Archaea | 123 | 1.2799999999999999e-31 | NR | MDP2434610.1 | 1906665 | g11740 | i0 | 63.4 | 0.987951807228916 | 82 | 30 | 98.8 | 0 | 247 | 2 | 193 | 274 | MDP2434610.1 AGC family serine/threonine-protein kinase [archaeon] | diamond | 246 | 123 | 1 | Archaea | archaeon | ||||||||
| 31379791 | 31379791 | PRJNA738523_P_NODE_13856_length_245_cov_0.895349_g13785_i0 | PRJNA738523 | 13856 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 65.9 | 3.53e-11 | NR | RYG42029.1 | 1906665 | g13785 | i0 | 71.4 | 0.514285714285714 | 42 | 12 | 51.4 | 0 | 3 | 128 | 1 | 42 | RYG42029.1 MAG: hypothetical protein EON68_02370 [archaeon] | diamond | 126 | 65.9 | 1 | Archaea | archaeon | ||||||||
| 31990741 | 31990741 | PRJNA738523_P_NODE_8358_length_270_cov_2.091371_g8287_i0 | PRJNA738523 | 8358 | 270 | 2.091371 | 5.6467017 | root | 1 | Root_unresolved | Root_unresolved | 112 | 1.17e-26 | NR | AIF04411.1 | 1457931 | g8287 | i0 | 54.5 | 4.94444444444444 | 88 | 40 | 97.8 | 0 | 4 | 267 | 338 | 425 | AIF04411.1 aldehyde dehydrogenase (dmpC) [uncultured marine group II/III euryarchaeote KM3_174_A11] | diamond | 1335 | 113 | 0.991150442477876 | Archaea | Methanobacteriati | Methanobacteriota | uncultured marine group II/III euryarchaeote KM3_174_A11 | ||||||
| 32012365 | 32012365 | PRJNA738523_P_NODE_6438_length_290_cov_1.115207_g6367_i0 | PRJNA738523 | 6438 | 290 | 1.115207 | 3.2341003 | archaeon | 1906665 | Archaea | Archaea | 58.2 | 4.04e-8 | NR | RYG43734.1 | 1906665 | g6367 | i0 | 53 | 0.682758620689655 | 66 | 26 | 64.1 | 3 | 288 | 103 | 81 | 145 | RYG43734.1 MAG: hypothetical protein EON67_12585 [archaeon] | diamond | 198 | 58.2 | 1 | Archaea | archaeon |
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);;