contig_metadata
9 rows where bioproject = "PRJNA716463" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5021103 | 5021103 | PRJNA716463_P_NODE_21604_length_310_cov_3.430380_g21187_i0 | PRJNA716463 | 21604 | 310 | 3.43038 | 10.634178 | root | 1 | Root_unresolved | Root_unresolved | 278 | 4.39e-70 | NTclustered | gi|27227784|emb|AJ535122.1| | 29281 | g21187 | i0 | 100 | 90.6903225806452 | 150 | 0 | 97 | 0 | 1 | 150 | 842 | 693 | Uncultured crenarchaeote partial 16S rRNA gene, clone Gitt-GR-74 | blastn | 28114 | 278 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 11396414 | 11396414 | PRJNA716463_P_NODE_29729_length_310_cov_2.489451_g29312_i0 | PRJNA716463 | 29729 | 310 | 2.489451 | 7.7172981 | root | 1 | Root_unresolved | Root_unresolved | 568 | 2.3299999999999995e-157 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g29312 | i0 | 99.677 | 99.8193548387097 | 310 | 1 | 100 | 0 | 1 | 310 | 39787 | 40096 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 30944 | 573 | 0.991273996509599 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 17286718 | 17286718 | PRJNA716463_P_NODE_88634_length_261_cov_3.031915_g88217_i0 | PRJNA716463 | 88634 | 261 | 3.031915 | 7.91329815 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 444 | 3.36e-120 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g88217 | i0 | 97.318 | 102.486590038314 | 261 | 7 | 100 | 0 | 1 | 261 | 42215 | 42475 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 26749 | 444 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 18559298 | 18559298 | PRJNA716463_P_NODE_121215_length_226_cov_3.588235_g120797_i0 | PRJNA716463 | 121215 | 226 | 3.588235 | 8.1094111 | uncultured marine thaumarchaeote AD1000_100_C06 | 1455887 | Archaea | Archaea | 418 | 1.7199999999999998e-112 | NTclustered | gi|663500052|gb|KF900324.1| | 1455887 | g120797 | i0 | 100 | 1 | 226 | 0 | 100 | 0 | 1 | 226 | 35173 | 35398 | Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence | blastn | 226 | 418 | 1 | Archaea | Thermoproteati | Nitrososphaerota | uncultured marine thaumarchaeote AD1000_100_C06 | ||||||
| 21110993 | 21110993 | PRJNA716463_P_NODE_71177_length_275_cov_2.693069_g70760_i0 | PRJNA716463 | 71177 | 275 | 2.693069 | 7.40593975 | Nitrososphaeria archaeon | 2268198 | Archaea | Archaea | 178 | 3.419999999999999e-54 | NR | NDB47524.1 | 2268198 | g70760 | i0 | 94.5 | 0.992727272727273 | 91 | 5 | 99.3 | 0 | 273 | 1 | 71 | 161 | NDB47524.1 ABC transporter ATP-binding protein [Nitrososphaeria archaeon] | diamond | 273 | 178 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaeria archaeon | |||||
| 27810313 | 27810313 | PRJNA716463_P_NODE_105104_length_247_cov_1.758621_g104687_i0 | PRJNA716463 | 105104 | 247 | 1.758621 | 4.34379387 | Thermofilaceae archaeon | 2268203 | Archaea | Archaea | 184 | 9.02e-58 | NR | MEM2592530.1 | 2268203 | g104687 | i0 | 98.8 | 0.995951417004049 | 82 | 1 | 99.6 | 0 | 246 | 1 | 39 | 120 | MEM2592530.1 DUF2750 domain-containing protein [Thermofilaceae archaeon] | diamond | 246 | 184 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilaceae archaeon | |||
| 28504751 | 28504751 | PRJNA716463_P_NODE_41247_length_298_cov_2.631111_g40830_i0 | PRJNA716463 | 41247 | 298 | 2.631111 | 7.84071078 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 76.3 | 1.1e-13 | NR | HKG87688.1 | 2169593 | g40830 | i0 | 68 | 2.50671140939597 | 50 | 16 | 50.3 | 0 | 293 | 144 | 357 | 406 | HKG87688.1 PQQ-dependent sugar dehydrogenase [Nitrososphaeraceae archaeon] | diamond | 747 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28788774 | 28788774 | PRJNA716463_P_NODE_85107_length_264_cov_3.099476_g84690_i0 | PRJNA716463 | 85107 | 264 | 3.099476 | 8.1826166400000009 | Nitrosopumilales archaeon | 2026768 | Archaea | Archaea | 169 | 5.58e-49 | NR | RPJ31745.1 | 2026768 | g84690 | i0 | 100 | 0.988636363636364 | 87 | 0 | 98.9 | 0 | 263 | 3 | 216 | 302 | RPJ31745.1 MAG: adenosylhomocysteinase [Nitrosopumilales archaeon] | diamond | 261 | 169 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 31379333 | 31379333 | PRJNA716463_P_NODE_97656_length_253_cov_2.844444_g97239_i0 | PRJNA716463 | 97656 | 253 | 2.844444 | 7.19644332 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 165 | 2.05e-45 | NR | HEY9491973.1 | 2169593 | g97239 | i0 | 97.6 | 2.98814229249012 | 84 | 2 | 99.6 | 0 | 1 | 252 | 19 | 102 | HEY9491973.1 GMC family oxidoreductase [Nitrososphaeraceae archaeon] | diamond | 756 | 165 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;