contig_metadata
12 rows where bioproject = "PRJNA1073005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14215661 | 14215661 | PRJNA1073005_P_NODE_7012_length_323_cov_0.924000_g6893_i0 | PRJNA1073005 | 7012 | 323 | 0.924 | 2.98452 | archaeon | 1906665 | Archaea | Archaea | 105 | 1.11e-24 | NR | RYH13701.1 | 1906665 | g6893 | i0 | 57 | 0.993808049535604 | 107 | 46 | 99.4 | 0 | 3 | 323 | 207 | 313 | RYH13701.1 MAG: 50S ribosomal protein L4 [archaeon] | diamond | 321 | 105 | 1 | Archaea | archaeon | ||||||||
| 20588059 | 20588059 | PRJNA1073005_P_NODE_9777_length_245_cov_0.895349_g9658_i0 | PRJNA1073005 | 9777 | 245 | 0.895349 | 2.19360505 | archaeon | 1906665 | Archaea | Archaea | 88.2 | 1.58e-18 | NR | RYH13652.1 | 1906665 | g9658 | i0 | 56.6 | 0.930612244897959 | 76 | 30 | 89.4 | 1 | 4 | 222 | 21 | 96 | RYH13652.1 MAG: ADP-ribosylglycohydrolase family protein [archaeon] | diamond | 228 | 88.2 | 1 | Archaea | archaeon | ||||||||
| 25242256 | 25242256 | PRJNA1073005_P_NODE_6460_length_349_cov_1.115942_g6341_i0 | PRJNA1073005 | 6460 | 349 | 1.115942 | 3.89463758 | archaeon | 1906665 | Archaea | Archaea | 204 | 7.75e-63 | NR | RYH04926.1 | 1906665 | g6341 | i0 | 87.1 | 0.997134670487106 | 116 | 15 | 99.7 | 0 | 2 | 349 | 46 | 161 | RYH04926.1 MAG: 50S ribosomal protein L10, partial [archaeon] | diamond | 348 | 204 | 1 | Archaea | archaeon | ||||||||
| 27193702 | 27193702 | PRJNA1073005_P_NODE_5782_length_381_cov_2.305195_g5663_i0 | PRJNA1073005 | 5782 | 381 | 2.305195 | 8.78279295 | archaeon | 1906665 | Archaea | Archaea | 160 | 3.64e-47 | NR | RYH12636.1 | 1906665 | g5663 | i0 | 61.6 | 0.984251968503937 | 125 | 47 | 98.4 | 1 | 381 | 7 | 4 | 127 | RYH12636.1 MAG: glutathione transferase GstA [archaeon] | diamond | 375 | 160 | 1 | Archaea | archaeon | ||||||||
| 27604656 | 27604656 | PRJNA1073005_P_NODE_7224_length_314_cov_2.435685_g7105_i0 | PRJNA1073005 | 7224 | 314 | 2.435685 | 7.6480509 | archaeon | 1906665 | Archaea | Archaea | 142 | 2.7299999999999998e-40 | NR | RYH12636.1 | 1906665 | g7105 | i0 | 65.4 | 0.993630573248408 | 104 | 36 | 99.4 | 0 | 312 | 1 | 10 | 113 | RYH12636.1 MAG: glutathione transferase GstA [archaeon] | diamond | 312 | 142 | 1 | Archaea | archaeon | ||||||||
| 28015103 | 28015103 | PRJNA1073005_P_NODE_6225_length_360_cov_1.209059_g6106_i0 | PRJNA1073005 | 6225 | 360 | 1.209059 | 4.3526124 | archaeon | 1906665 | Archaea | Archaea | 112 | 7.67e-30 | NR | RYG67183.1 | 1906665 | g6106 | i0 | 76 | 0.625 | 75 | 18 | 62.5 | 0 | 1 | 225 | 3 | 77 | RYG67183.1 MAG: hypothetical protein EON64_08020 [archaeon] | diamond | 225 | 112 | 1 | Archaea | archaeon | ||||||||
| 28551871 | 28551871 | PRJNA1073005_P_NODE_9527_length_247_cov_0.885057_g9408_i0 | PRJNA1073005 | 9527 | 247 | 0.885057 | 2.18609079 | archaeon | 1906665 | Archaea | Archaea | 47 | 0.00117 | NR | MDP2437063.1 | 1906665 | g9408 | i0 | 50 | 3.06072874493927 | 32 | 16 | 38.9 | 0 | 101 | 6 | 2 | 33 | MDP2437063.1 hypothetical protein [archaeon] | diamond | 756 | 47 | 1 | Archaea | archaeon | ||||||||
| 29025643 | 29025643 | PRJNA1073005_P_NODE_7788_length_290_cov_1.175115_g7669_i0 | PRJNA1073005 | 7788 | 290 | 1.175115 | 3.4078335 | archaeon | 1906665 | Archaea | Archaea | 43.5 | 0.032 | NR | RYH26676.1 | 1906665 | g7669 | i0 | 28.1 | 0.993103448275862 | 96 | 69 | 99.3 | 0 | 2 | 289 | 51 | 146 | RYH26676.1 MAG: hypothetical protein EON65_14315, partial [archaeon] | diamond | 288 | 43.5 | 1 | Archaea | archaeon | ||||||||
| 31015246 | 31015246 | PRJNA1073005_P_NODE_9415_length_248_cov_0.880000_g9296_i0 | PRJNA1073005 | 9415 | 248 | 0.88 | 2.1824 | archaeon | 1906665 | Archaea | Archaea | 127 | 1.42e-34 | NR | RYH14964.1 | 1906665 | g9296 | i0 | 76.5 | 3.91935483870968 | 81 | 19 | 98 | 0 | 2 | 244 | 54 | 134 | RYH14964.1 MAG: glutathione S-transferase family protein [archaeon] | diamond | 972 | 127 | 1 | Archaea | archaeon | ||||||||
| 31552996 | 31552996 | PRJNA1073005_P_NODE_7996_length_283_cov_1.366667_g7877_i0 | PRJNA1073005 | 7996 | 283 | 1.366667 | 3.86766761 | archaeon | 1906665 | Archaea | Archaea | 68.9 | 3.52e-11 | NR | RYG68730.1 | 1906665 | g7877 | i0 | 39.8 | 0.985865724381625 | 93 | 50 | 96.5 | 3 | 275 | 3 | 83 | 171 | RYG68730.1 MAG: glycosyltransferase family 61 protein [archaeon] | diamond | 279 | 68.9 | 1 | Archaea | archaeon | ||||||||
| 31774052 | 31774052 | PRJNA1073005_P_NODE_10237_length_242_cov_0.911243_g10118_i0 | PRJNA1073005 | 10237 | 242 | 0.911243 | 2.20520806 | archaeon | 1906665 | Archaea | Archaea | 95.5 | 5.72e-23 | NR | RYG96273.1 | 1906665 | g10118 | i0 | 82.8 | 0.71900826446281 | 58 | 10 | 71.9 | 0 | 174 | 1 | 1 | 58 | RYG96273.1 MAG: hypothetical protein EON65_54665 [archaeon] | diamond | 174 | 95.5 | 1 | Archaea | archaeon | ||||||||
| 32817015 | 32817015 | PRJNA1073005_P_NODE_8520_length_265_cov_1.203125_g8401_i0 | PRJNA1073005 | 8520 | 265 | 1.203125 | 3.18828125 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 43.9 | 0.00623 | NR | HVC77501.1 | 2953041 | g8401 | i0 | 39.7 | 1.4377358490566 | 63 | 36 | 69.1 | 1 | 43 | 225 | 4 | 66 | HVC77501.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] | diamond | 381 | 43.9 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae 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);;