contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1126198" and tax_kingdom = "Nanobdellati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27386551 | 27386551 | PRJNA1126198_P_NODE_406903_length_248_cov_0.891429_g406182_i0 | PRJNA1126198 | 406903 | 248 | 0.891429 | 2.21074392 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 40 | 0.0499 | NR | MCK5608646.1 | 2026773 | g406182 | i0 | 32 | 0.604838709677419 | 50 | 28 | 53.2 | 1 | 247 | 116 | 9 | 58 | MCK5608646.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 150 | 40 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon | ||||||
| 28838658 | 28838658 | PRJNA1126198_P_NODE_144888_length_316_cov_0.905350_g144169_i0 | PRJNA1126198 | 144888 | 316 | 0.90535 | 2.860906 | Candidatus Iainarchaeum archaeon | 3101447 | Archaea | Archaea | 73.2 | 1.84e-12 | NR | HRT03471.1 | 2026736 | g144169 | i0 | 47.8 | 0.854430379746835 | 90 | 46 | 84.5 | 1 | 267 | 1 | 510 | 599 | HRT03471.1 hypothetical protein [Candidatus Iainarchaeum archaeon] | diamond | 270 | 73.2 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Iainarchaeum | Candidatus Iainarchaeum archaeon | |||||
| 29880926 | 29880926 | PRJNA1126198_P_NODE_416491_length_247_cov_0.896552_g415770_i0 | PRJNA1126198 | 416491 | 247 | 0.896552 | 2.21448344 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 40.8 | 0.0269 | NR | MFQ5620966.1 | 2910166 | g415770 | i0 | 39.1 | 0.558704453441296 | 46 | 22 | 48.6 | 1 | 3 | 122 | 5 | 50 | MFQ5620966.1 hypothetical protein [Candidatus Nanoarchaeia archaeon] | diamond | 138 | 40.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 30164858 | 30164858 | PRJNA1126198_P_NODE_377672_length_251_cov_0.876404_g376951_i0 | PRJNA1126198 | 377672 | 251 | 0.876404 | 2.19977404 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 148 | 6.4e-40 | NR | MDD5649174.1 | 2910166 | g376951 | i0 | 81.7 | 0.9800796812749 | 82 | 15 | 98 | 0 | 250 | 5 | 482 | 563 | MDD5649174.1 helicase C-terminal domain-containing protein [Candidatus Nanoarchaeia archaeon] | diamond | 246 | 148 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 30670526 | 30670526 | PRJNA1126198_P_NODE_420453_length_246_cov_2.705202_g419732_i0 | PRJNA1126198 | 420453 | 246 | 2.705202 | 6.65479692 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 121 | 1.08e-31 | NR | MBI4015710.1 | 3121606 | g419732 | i0 | 76.7 | 0.890243902439024 | 73 | 17 | 89 | 0 | 220 | 2 | 67 | 139 | MBI4015710.1 uridine phosphorylase [Candidatus Aenigmatarchaeota archaeon] | diamond | 219 | 121 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31018197 | 31018197 | PRJNA1126198_P_NODE_388435_length_250_cov_0.875706_g387714_i0 | PRJNA1126198 | 388435 | 250 | 0.875706 | 2.189265 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 166 | 2.1699999999999998e-47 | NR | MEM3247439.1 | 2953041 | g387714 | i0 | 100 | 1.992 | 83 | 0 | 99.6 | 0 | 250 | 2 | 346 | 428 | MEM3247439.1 AAA family ATPase [Candidatus Micrarchaeaceae archaeon] | diamond | 498 | 166 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 31871866 | 31871866 | PRJNA1126198_P_NODE_392437_length_249_cov_1.732955_g391716_i0 | PRJNA1126198 | 392437 | 249 | 1.732955 | 4.31505795 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 68.6 | 3.13e-11 | NR | MBN2102220.1 | 3121606 | g391716 | i0 | 51.5 | 2.50602409638554 | 68 | 29 | 81.9 | 1 | 3 | 206 | 245 | 308 | MBN2102220.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 624 | 68.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32504953 | 32504953 | PRJNA1126198_P_NODE_427679_length_246_cov_0.895954_g426958_i0 | PRJNA1126198 | 427679 | 246 | 0.895954 | 2.20404684 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 105 | 2.45e-24 | NR | MDI3474137.1 | 2026803 | g426958 | i0 | 66.7 | 0.914634146341463 | 75 | 24 | 90.2 | 1 | 1 | 222 | 398 | 472 | MDI3474137.1 polymerase large subunit [Candidatus Woesearchaeota archaeon] | diamond | 225 | 105 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota 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);;