contig_metadata
11 rows where bioproject = "PRJNA797475" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10145466 | 10145466 | PRJNA797475_P_NODE_25228_length_247_cov_0.885057_g25129_i0 | PRJNA797475 | 25228 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 140 | 1.71e-39 | NR | RYG62826.1 | 1906665 | g25129 | i0 | 80.5 | 0.995951417004049 | 82 | 16 | 99.6 | 0 | 247 | 2 | 9 | 90 | RYG62826.1 MAG: dihydrolipoyl dehydrogenase, partial [archaeon] | diamond | 246 | 140 | 1 | Archaea | archaeon | ||||||||
| 28096182 | 28096182 | PRJNA797475_P_NODE_26905_length_245_cov_0.895349_g26806_i0 | PRJNA797475 | 26905 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 58.5 | 4.33e-9 | NR | RYH14058.1 | 1906665 | g26806 | i0 | 66.7 | 0.587755102040816 | 48 | 16 | 58.8 | 0 | 244 | 101 | 25 | 72 | RYH14058.1 MAG: hypothetical protein EON65_34240 [archaeon] | diamond | 144 | 58.5 | 1 | Archaea | archaeon | ||||||||
| 28601475 | 28601475 | PRJNA797475_P_NODE_30607_length_240_cov_2.329341_g30508_i0 | PRJNA797475 | 30607 | 240 | 2.329341 | 5.5904184 | archaeon | 1906665 | Archaea | Archaea | 99.4 | 4.42e-22 | NR | RYG65919.1 | 1906665 | g30508 | i0 | 60 | 1 | 80 | 32 | 100 | 0 | 1 | 240 | 479 | 558 | RYG65919.1 MAG: hypothetical protein EON64_10915 [archaeon] | diamond | 240 | 99.4 | 1 | Archaea | archaeon | ||||||||
| 28948935 | 28948935 | PRJNA797475_P_NODE_6108_length_409_cov_0.916667_g6010_i0 | PRJNA797475 | 6108 | 409 | 0.916667 | 3.74916803 | archaeon | 1906665 | Archaea | Archaea | 68.6 | 2.41e-10 | NR | MDP2435053.1 | 1906665 | g6010 | i0 | 31.1 | 0.968215158924205 | 132 | 69 | 96.8 | 1 | 400 | 5 | 253 | 362 | MDP2435053.1 hypothetical protein [archaeon] | diamond | 396 | 68.6 | 1 | Archaea | archaeon | ||||||||
| 29043580 | 29043580 | PRJNA797475_P_NODE_15028_length_283_cov_1.828571_g14929_i0 | PRJNA797475 | 15028 | 283 | 1.828571 | 5.17485593 | archaeon | 1906665 | Archaea | Archaea | 154 | 6.209999999999999e-46 | NR | RYG68742.1 | 1906665 | g14929 | i0 | 85.7 | 0.890459363957597 | 84 | 12 | 89 | 0 | 30 | 281 | 1 | 84 | RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon] | diamond | 252 | 154 | 1 | Archaea | archaeon | ||||||||
| 29642987 | 29642987 | PRJNA797475_P_NODE_22030_length_250_cov_2.367232_g21931_i0 | PRJNA797475 | 22030 | 250 | 2.367232 | 5.91808 | archaeon | 1906665 | Archaea | Archaea | 142 | 7.319999999999998e-42 | NR | RYG59363.1 | 1906665 | g21931 | i0 | 84.3 | 0.996 | 83 | 13 | 99.6 | 0 | 1 | 249 | 2 | 84 | RYG59363.1 MAG: hypothetical protein EON64_20310, partial [archaeon] | diamond | 249 | 142 | 1 | Archaea | archaeon | ||||||||
| 30370308 | 30370308 | PRJNA797475_P_NODE_5912_length_415_cov_1.350877_g5814_i0 | PRJNA797475 | 5912 | 415 | 1.350877 | 5.60613955 | archaeon | 1906665 | Archaea | Archaea | 83.2 | 1.53e-17 | NR | MCQ2819076.1 | 1906665 | g5814 | i0 | 38.2 | 0.737349397590361 | 102 | 61 | 73.7 | 1 | 105 | 410 | 9 | 108 | MCQ2819076.1 GTP-binding protein [archaeon] | diamond | 306 | 83.2 | 1 | Archaea | archaeon | ||||||||
| 30559183 | 30559183 | PRJNA797475_P_NODE_14013_length_289_cov_1.217593_g13914_i0 | PRJNA797475 | 14013 | 289 | 1.217593 | 3.51884377 | archaeon | 1906665 | Archaea | Archaea | 46.6 | 4.31e-4 | NR | RYG95795.1 | 1906665 | g13914 | i0 | 51.4 | 0.726643598615917 | 35 | 17 | 36.3 | 0 | 88 | 192 | 2 | 36 | RYG95795.1 MAG: DUF599 family protein, partial [archaeon] | diamond | 210 | 46.6 | 1 | Archaea | archaeon | ||||||||
| 30875367 | 30875367 | PRJNA797475_P_NODE_21174_length_251_cov_1.730337_g21075_i0 | PRJNA797475 | 21174 | 251 | 1.730337 | 4.34314587 | Halococcus | 2249 | Archaea | Archaea | 82.4 | 8.61e-17 | NR | WP_152415497.1 | 2249 | g21075 | i0 | 45.8 | 1.93625498007968 | 83 | 40 | 99.2 | 1 | 2 | 250 | 160 | 237 | WP_152415497.1 MULTISPECIES: carbon-nitrogen hydrolase family protein [Halococcus] | diamond | 486 | 82.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | ||
| 32551934 | 32551934 | PRJNA797475_P_NODE_29179_length_242_cov_0.911243_g29080_i0 | PRJNA797475 | 29179 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 52.8 | 1.04e-5 | NR | MDP2435106.1 | 1906665 | g29080 | i0 | 37.8 | 2.56611570247934 | 74 | 46 | 91.7 | 0 | 226 | 5 | 218 | 291 | MDP2435106.1 hypothetical protein [archaeon] | diamond | 621 | 52.8 | 1 | Archaea | archaeon | ||||||||
| 32740776 | 32740776 | PRJNA797475_P_NODE_23580_length_249_cov_0.875000_g23481_i0 | PRJNA797475 | 23580 | 249 | 0.875 | 2.17875 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 55.1 | 1.4e-6 | NR | TMI20456.1 | 2026714 | g23481 | i0 | 42.3 | 2.89156626506024 | 78 | 39 | 88 | 3 | 15 | 233 | 161 | 237 | TMI20456.1 MAG: hypothetical protein E6H36_12920 [Candidatus Bathyarchaeota archaeon] | diamond | 720 | 55.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota 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);;