contig_metadata
6 rows where bioproject = "PRJNA493632", tax_phylum = "Candidatus Parvarchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27519115 | 27519115 | PRJNA493632_P_NODE_81043_length_495_cov_2.277251_g77667_i0 | PRJNA493632 | 81043 | 495 | 2.277251 | 11.27239245 | Candidatus Parvarchaeum sp. | 2883576 | Archaea | Archaea | 89.7 | 1.42e-19 | NR | MEM0143611.1 | 2883576 | g77667 | i0 | 47 | 0.606060606060606 | 100 | 51 | 60.6 | 1 | 308 | 9 | 2 | 99 | MEM0143611.1 hypothetical protein [Candidatus Parvarchaeum sp.] | diamond | 300 | 89.7 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeum | Candidatus Parvarchaeum sp. | |||||
| 27897611 | 27897611 | PRJNA493632_P_NODE_137565_length_399_cov_8.076687_g134145_i0 | PRJNA493632 | 137565 | 399 | 8.076687 | 32.22598113 | Candidatus Parvarchaeum sp. | 2883576 | Archaea | Archaea | 151 | 2.19e-44 | NR | MEM0143619.1 | 2883576 | g134145 | i0 | 74.8 | 0.864661654135338 | 115 | 29 | 86.5 | 0 | 391 | 47 | 7 | 121 | MEM0143619.1 hypothetical protein [Candidatus Parvarchaeum sp.] | diamond | 345 | 151 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeum | Candidatus Parvarchaeum sp. | |||||
| 27992721 | 27992721 | PRJNA493632_P_NODE_461725_length_259_cov_3.268817_g458286_i0 | PRJNA493632 | 461725 | 259 | 3.268817 | 8.46623603 | Candidatus Parvarchaeum sp. | 2883576 | Archaea | Archaea | 89.7 | 5.53e-21 | NR | MEM0143618.1 | 2883576 | g458286 | i0 | 64.7 | 0.787644787644788 | 68 | 21 | 75.3 | 1 | 3 | 197 | 6 | 73 | MEM0143618.1 hypothetical protein [Candidatus Parvarchaeum sp.] | diamond | 204 | 89.7 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeum | Candidatus Parvarchaeum sp. | |||||
| 28339829 | 28339829 | PRJNA493632_P_NODE_255166_length_312_cov_0.891213_g251730_i0 | PRJNA493632 | 255166 | 312 | 0.891213 | 2.78058456 | Candidatus Parvarchaeum sp. | 2883576 | Archaea | Archaea | 146 | 3.199999999999999e-41 | NR | MEM0143612.1 | 2883576 | g251730 | i0 | 67.3 | 0.971153846153846 | 101 | 33 | 97.1 | 0 | 310 | 8 | 141 | 241 | MEM0143612.1 hypothetical protein [Candidatus Parvarchaeum sp.] | diamond | 303 | 146 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeum | Candidatus Parvarchaeum sp. | |||||
| 30187101 | 30187101 | PRJNA493632_P_NODE_400112_length_272_cov_1.547739_g396673_i0 | PRJNA493632 | 400112 | 272 | 1.547739 | 4.20985008 | Candidatus Parvarchaeum | 662758 | Archaea | Archaea | 180 | 9.989999999999997e-55 | NR | MCL5976460.1 | 2077140 | g396673 | i0 | 100 | 2.97794117647059 | 90 | 0 | 99.3 | 0 | 272 | 3 | 9 | 98 | MCL5976460.1 hypothetical protein [Candidatus Parvarchaeota archaeon] | diamond | 810 | 180 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeota archaeon | ||||||
| 30613618 | 30613618 | PRJNA493632_P_NODE_515513_length_251_cov_0.865169_g512074_i0 | PRJNA493632 | 515513 | 251 | 0.865169 | 2.17157419 | Candidatus Parvarchaeum tengchongense | 3036169 | Archaea | Archaea | 172 | 7e-48 | NR | MCW1295697.1 | 3036169 | g512074 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 251 | 3 | 390 | 472 | MCW1295697.1 hypothetical protein [Candidatus Parvarchaeum tengchongense] | diamond | 249 | 172 | 1 | Archaea | Nanobdellati | Candidatus Parvarchaeota | Candidatus Parvarchaeum | Candidatus Parvarchaeum tengchongense |
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);;