contig_metadata
9 rows where bioproject = "PRJNA799842" and tax_phylum = "Nanobdellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13548972 | 13548972 | PRJNA799842_P_NODE_65051_length_353_cov_3.207143_g63478_i0 | PRJNA799842 | 65051 | 353 | 3.207143 | 11.32121479 | Nanobdellati | 1783276 | Archaea | Archaea | 204 | 1.04e-61 | NR | MBU0667468.1 | 2026764 | g63478 | i0 | 85.5 | 15.9093484419263 | 117 | 17 | 99.4 | 0 | 351 | 1 | 297 | 413 | MBU0667468.1 phosphopyruvate hydratase [Nanoarchaeota archaeon] | diamond | 5616 | 204 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28759277 | 28759277 | PRJNA799842_P_NODE_156727_length_247_cov_0.885057_g155154_i0 | PRJNA799842 | 156727 | 247 | 0.885057 | 2.18609079 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 86.3 | 1.92e-17 | NR | MFC1768721.1 | 2026764 | g155154 | i0 | 58 | 0.983805668016194 | 81 | 34 | 98.4 | 0 | 2 | 244 | 696 | 776 | MFC1768721.1 type I restriction endonuclease subunit R [Nanoarchaeota archaeon] | diamond | 243 | 86.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29336721 | 29336721 | PRJNA799842_P_NODE_146729_length_249_cov_0.875000_g145156_i0 | PRJNA799842 | 146729 | 249 | 0.875 | 2.17875 | Archaea | 2157 | Archaea | Archaea | 119 | 2.73e-29 | NR | MEK6825429.1 | 2026764 | g145156 | i0 | 71.1 | 5 | 83 | 24 | 100 | 0 | 1 | 249 | 250 | 332 | MEK6825429.1 phenylalanine--tRNA ligase subunit beta [Nanoarchaeota archaeon] | diamond | 1245 | 119 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30622584 | 30622584 | PRJNA799842_P_NODE_177813_length_243_cov_0.905882_g176240_i0 | PRJNA799842 | 177813 | 243 | 0.905882 | 2.20129326 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 147 | 4.85e-42 | NR | MBU0756589.1 | 2026764 | g176240 | i0 | 92.5 | 1.97530864197531 | 80 | 6 | 98.8 | 0 | 242 | 3 | 130 | 209 | MBU0756589.1 AAA family ATPase [Nanoarchaeota archaeon] | diamond | 480 | 147 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31002004 | 31002004 | PRJNA799842_P_NODE_55414_length_381_cov_2.311688_g53841_i0 | PRJNA799842 | 55414 | 381 | 2.311688 | 8.80753128 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 45.4 | 0.0192 | NR | MDD3175763.1 | 2910166 | g53841 | i0 | 24.7 | 1.82677165354331 | 97 | 72 | 76.4 | 1 | 379 | 89 | 108 | 203 | MDD3175763.1 hypothetical protein [Candidatus Nanoarchaeia archaeon] | diamond | 696 | 45.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 31136977 | 31136977 | PRJNA799842_P_NODE_179195_length_243_cov_0.905882_g177622_i0 | PRJNA799842 | 179195 | 243 | 0.905882 | 2.20129326 | Archaea | 2157 | Archaea | Archaea | 114 | 5.67e-28 | NR | HTY74500.1 | 2910166 | g177622 | i0 | 71.3 | 1.97530864197531 | 80 | 23 | 98.8 | 0 | 242 | 3 | 36 | 115 | HTY74500.1 glutamate-5-semialdehyde dehydrogenase [Candidatus Nanoarchaeia archaeon] | diamond | 480 | 115 | 0.991304347826087 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 31222866 | 31222866 | PRJNA799842_P_NODE_166275_length_245_cov_0.895349_g164702_i0 | PRJNA799842 | 166275 | 245 | 0.895349 | 2.19360505 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 75.1 | 1.79e-14 | NR | MEK6916334.1 | 2026764 | g164702 | i0 | 74.4 | 0.52653061224489806 | 43 | 11 | 52.7 | 0 | 238 | 110 | 153 | 195 | MEK6916334.1 methyltransferase [Nanoarchaeota archaeon] | diamond | 129 | 75.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31769710 | 31769710 | PRJNA799842_P_NODE_163037_length_246_cov_0.890173_g161464_i0 | PRJNA799842 | 163037 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 108 | 4.26e-27 | NR | MEK6882973.1 | 2026764 | g161464 | i0 | 71.8 | 2.75609756097561 | 71 | 20 | 86.6 | 0 | 246 | 34 | 33 | 103 | MEK6882973.1 site-specific DNA-methyltransferase [Nanoarchaeota archaeon] | diamond | 678 | 109 | 0.990825688073395 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32614865 | 32614865 | PRJNA799842_P_NODE_81940_length_319_cov_0.939024_g80367_i0 | PRJNA799842 | 81940 | 319 | 0.939024 | 2.99548656 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 164 | 1.38e-44 | NR | HTY74894.1 | 2910166 | g80367 | i0 | 77.8 | 1.01567398119122 | 108 | 22 | 99.7 | 1 | 318 | 1 | 397 | 504 | HTY74894.1 anaerobic ribonucleoside-triphosphate reductase [Candidatus Nanoarchaeia archaeon] | diamond | 324 | 164 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia 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);;