contig_metadata
14 rows where bioproject = "PRJNA1120060", tax_phylum = "Promethearchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1513451 | 1513451 | PRJNA1120060_P_NODE_1501642_length_293_cov_2.927273_g1483654_i0 | PRJNA1120060 | 1501642 | 293 | 2.927273 | 8.57690989 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|2107931243|gb|CP070805.1| | 2053489 | g1483654 | i0 | 100 | 0.0955631399317406 | 28 | 0 | 10 | 0 | 231 | 258 | 2085605 | 2085632 | MAG: Promethearchaeota archaeon isolate bin132 chromosome | blastn | 28 | 52.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 26626184 | 26626184 | PRJNA1120060_P_NODE_3024961_length_239_cov_5.463855_g3006861_i0 | PRJNA1120060 | 3024961 | 239 | 5.463855 | 13.05861345 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0137 | NR | MBN2151993.1 | 2053489 | g3006861 | i0 | 34.2 | 0.916317991631799 | 73 | 40 | 91.6 | 2 | 235 | 17 | 166 | 230 | MBN2151993.1 B12-binding domain-containing radical SAM protein [Promethearchaeota archaeon] | diamond | 219 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 27638575 | 27638575 | PRJNA1120060_P_NODE_3587144_length_200_cov_4.125984_g3569017_i0 | PRJNA1120060 | 3587144 | 200 | 4.125984 | 8.251968 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 62.4 | 2.48e-9 | NR | MFO7795213.1 | 3067280 | g3569017 | i0 | 72.1 | 0.645 | 43 | 12 | 64.5 | 0 | 3 | 131 | 893 | 935 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 129 | 62.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 28017111 | 28017111 | PRJNA1120060_P_NODE_2978485_length_242_cov_0.917160_g2960391_i0 | PRJNA1120060 | 2978485 | 242 | 0.91716 | 2.2195272 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 42.4 | 0.0481 | NR | TXT55076.1 | 2053489 | g2960391 | i0 | 36.8 | 0.706611570247934 | 57 | 33 | 70.7 | 1 | 27 | 197 | 161 | 214 | TXT55076.1 MAG: hypothetical protein BAJALOKI2v1_690013 [Promethearchaeota archaeon] | diamond | 171 | 42.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 29594355 | 29594355 | PRJNA1120060_P_NODE_1603910_length_289_cov_1.425926_g1585917_i0 | PRJNA1120060 | 1603910 | 289 | 1.425926 | 4.12092614 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 43.1 | 0.0408 | NR | HME52843.1 | 3067280 | g1585917 | i0 | 47.4 | 0.394463667820069 | 38 | 20 | 39.4 | 0 | 137 | 250 | 157 | 194 | HME52843.1 DNA methyltransferase [Promethearchaeia archaeon] | diamond | 114 | 43.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 29932999 | 29932999 | PRJNA1120060_P_NODE_2146471_length_267_cov_1.536082_g2128425_i0 | PRJNA1120060 | 2146471 | 267 | 1.536082 | 4.10133894 | Archaea | 2157 | Archaea | Archaea | 43.9 | 0.0181 | NR | NVM43513.1 | 2053489 | g2128425 | i0 | 36.2 | 1.30337078651685 | 58 | 37 | 65.2 | 0 | 92 | 265 | 78 | 135 | NVM43513.1 helix-turn-helix domain-containing protein [Promethearchaeota archaeon] | diamond | 348 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30510510 | 30510510 | PRJNA1120060_P_NODE_1236893_length_309_cov_5.122881_g1218952_i0 | PRJNA1120060 | 1236893 | 309 | 5.122881 | 15.82970229 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0298 | NR | MCK5587475.1 | 2053489 | g1218952 | i0 | 43.2 | 0.427184466019417 | 44 | 25 | 42.7 | 0 | 48 | 179 | 289 | 332 | MCK5587475.1 formylmethanofuran dehydrogenase subunit B [Promethearchaeota archaeon] | diamond | 132 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 30668668 | 30668668 | PRJNA1120060_P_NODE_1519653_length_292_cov_3.452055_g1501664_i0 | PRJNA1120060 | 1519653 | 292 | 3.452055 | 10.0800006 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 140 | 2.26e-36 | NR | MFO7795213.1 | 3067280 | g1501664 | i0 | 70.4 | 1.00684931506849 | 98 | 27 | 98.6 | 1 | 290 | 3 | 158 | 255 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 294 | 140 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 30890157 | 30890157 | PRJNA1120060_P_NODE_1802614_length_281_cov_0.889423_g1784602_i0 | PRJNA1120060 | 1802614 | 281 | 0.889423 | 2.49927863 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.1 | 0.0424 | NR | TES99012.1 | 2053489 | g1784602 | i0 | 40.4 | 0.608540925266904 | 57 | 34 | 60.9 | 0 | 62 | 232 | 382 | 438 | TES99012.1 MAG: hypothetical protein E3J90_05275 [Promethearchaeota archaeon] | diamond | 171 | 43.1 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31269420 | 31269420 | PRJNA1120060_P_NODE_1942235_length_275_cov_1.732673_g1924211_i0 | PRJNA1120060 | 1942235 | 275 | 1.732673 | 4.76485075 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 41.2 | 0.0363 | NR | TFF85692.1 | 2053489 | g1924211 | i0 | 46.2 | 0.425454545454545 | 39 | 20 | 42.5 | 1 | 133 | 249 | 38 | 75 | TFF85692.1 MAG: hypothetical protein EU551_03495 [Promethearchaeota archaeon] | diamond | 117 | 41.2 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 31364800 | 31364800 | PRJNA1120060_P_NODE_2519716_length_253_cov_2.088889_g2501644_i0 | PRJNA1120060 | 2519716 | 253 | 2.088889 | 5.28488917 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 87.8 | 5.74e-18 | NR | MFO7795213.1 | 3067280 | g2501644 | i0 | 76.9 | 0.616600790513834 | 52 | 12 | 61.7 | 0 | 96 | 251 | 478 | 529 | MFO7795213.1 reverse transcriptase family protein [Promethearchaeia archaeon] | diamond | 156 | 87.8 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia archaeon | |||||
| 31618486 | 31618486 | PRJNA1120060_P_NODE_700956_length_333_cov_3.300000_g683129_i0 | PRJNA1120060 | 700956 | 333 | 3.3 | 10.989 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 43.9 | 0.0402 | NR | TFG03779.1 | 2053489 | g683129 | i0 | 34.9 | 0.774774774774775 | 86 | 50 | 73 | 3 | 18 | 260 | 349 | 433 | TFG03779.1 MAG: phosphate ABC transporter permease subunit PstC [Promethearchaeota archaeon] | diamond | 258 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32029492 | 32029492 | PRJNA1120060_P_NODE_3206958_length_231_cov_2.772152_g3188851_i0 | PRJNA1120060 | 3206958 | 231 | 2.772152 | 6.40367112 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 42.4 | 0.0428 | NR | TFG00604.1 | 2053489 | g3188851 | i0 | 38.1 | 0.545454545454545 | 42 | 26 | 54.5 | 0 | 192 | 67 | 144 | 185 | TFG00604.1 MAG: hypothetical protein EU542_07925, partial [Promethearchaeota archaeon] | diamond | 126 | 42.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32091523 | 32091523 | PRJNA1120060_P_NODE_1449118_length_296_cov_1.000000_g1431134_i0 | PRJNA1120060 | 1449118 | 296 | 1 | 2.96 | Promethearchaeia archaeon | 3067280 | Archaea | Archaea | 43.9 | 0.0265 | NR | MFO8018910.1 | 3067280 | g1431134 | i0 | 28.8 | 0.810810810810811 | 80 | 57 | 81.1 | 0 | 26 | 265 | 168 | 247 | MFO8018910.1 CoA-binding protein [Promethearchaeia archaeon] | diamond | 240 | 43.9 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeia | Promethearchaeia 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);;