contig_metadata
20 rows where bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1622314 | 1622314 | PRJNA1240804_P_NODE_18882_length_319_cov_1.048148_g18516_i0 | PRJNA1240804 | 18882 | 319 | 1.048148 | 3.34359212 | Pyrobaculum ferrireducens | 1104324 | Archaea | Archaea | 555 | 1.8699999999999994e-153 | NTclustered | gi|998226786|ref|NR_134837.2| | 1104324 | g18516 | i0 | 99.032 | 96.4012539184953 | 310 | 2 | 97 | 1 | 11 | 319 | 1371 | 1062 | Pyrobaculum ferrireducens strain 1860 16S ribosomal RNA, complete sequence | blastn | 30752 | 555 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum ferrireducens | ||
| 8001569 | 8001569 | PRJNA1240804_P_NODE_41967_length_233_cov_2.467391_g41601_i0 | PRJNA1240804 | 41967 | 233 | 2.467391 | 5.74902103 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 405 | 1.39e-108 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g41601 | i0 | 100 | 26.3991416309013 | 219 | 0 | 94 | 0 | 1 | 219 | 1790464 | 1790246 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 6151 | 405 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 10552623 | 10552623 | PRJNA1240804_P_NODE_58149_length_207_cov_2.063291_g57783_i0 | PRJNA1240804 | 58149 | 207 | 2.063291 | 4.27101237 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 344 | 2.67e-90 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g57783 | i0 | 98.958 | 13.9710144927536 | 192 | 2 | 93 | 0 | 15 | 206 | 1792025 | 1792216 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 2892 | 344 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 13803318 | 13803318 | PRJNA1240804_P_NODE_120631_length_167_cov_0.881356_g120265_i0 | PRJNA1240804 | 120631 | 167 | 0.881356 | 1.47186452 | Archaea | 2157 | Archaea | Archaea | 187 | 3.68e-43 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g120265 | i0 | 88.816 | 12.9041916167665 | 152 | 17 | 91 | 0 | 5 | 156 | 41021 | 40870 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 2155 | 187 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 14378211 | 14378211 | PRJNA1240804_P_NODE_87932_length_181_cov_1.454545_g87566_i0 | PRJNA1240804 | 87932 | 181 | 1.454545 | 2.63272645 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 305 | 1.07e-78 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g87566 | i0 | 100 | 8.1491712707182309 | 165 | 0 | 91 | 0 | 15 | 179 | 1790848 | 1791012 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 1475 | 305 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 16352442 | 16352442 | PRJNA1240804_P_NODE_137933_length_164_cov_0.904348_g137567_i0 | PRJNA1240804 | 137933 | 164 | 0.904348 | 1.48313072 | Nitrososphaera | 497726 | Archaea | Archaea | 252 | 1.26e-62 | NTclustered | gi|300521484|gb|GU797787.1| | 497727 | g137567 | i0 | 95 | 41.609756097561 | 160 | 8 | 98 | 0 | 5 | 164 | 1693 | 1852 | Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence | blastn | 6824 | 252 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera gargensis | ||
| 17627923 | 17627923 | PRJNA1240804_P_NODE_37654_length_243_cov_1.860825_g37288_i0 | PRJNA1240804 | 37654 | 243 | 1.860825 | 4.52180475 | root | 1 | Root_unresolved | Root_unresolved | 420 | 5.21e-113 | NTclustered | gi|218751468|emb|FM897366.1| | 29281 | g37288 | i0 | 100 | 93.4156378600823 | 227 | 0 | 93 | 0 | 3 | 229 | 244 | 18 | Uncultured crenarchaeote partial 16S rRNA gene, clone JG35U2A-TR-Ar57 | blastn | 22700 | 420 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 18901961 | 18901961 | PRJNA1240804_P_NODE_92755_length_178_cov_1.294574_g92389_i0 | PRJNA1240804 | 92755 | 178 | 1.294574 | 2.30434172 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 292 | 8.15e-75 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g92389 | i0 | 98.78 | 17.4101123595506 | 164 | 2 | 92 | 0 | 15 | 178 | 1789689 | 1789852 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 3099 | 292 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 25276236 | 25276236 | PRJNA1240804_P_NODE_17020_length_332_cov_1.438163_g16655_i0 | PRJNA1240804 | 17020 | 332 | 1.438163 | 4.77470116 | root | 1 | Root_unresolved | Root_unresolved | 497 | 3.34e-136 | NTclustered | gi|373125855|gb|JN567036.1| | 29281 | g16655 | i0 | 99.273 | 84.8373493975904 | 275 | 2 | 83 | 0 | 47 | 321 | 737 | 463 | Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence | blastn | 28166 | 501 | 0.992015968063872 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 26788775 | 26788775 | PRJNA1240804_P_NODE_137761_length_164_cov_0.904348_g137395_i0 | PRJNA1240804 | 137761 | 164 | 0.904348 | 1.48313072 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 45.1 | 0.00196 | NR | MDE1830385.1 | 2026795 | g137395 | i0 | 53.7 | 0.75 | 41 | 18 | 75 | 1 | 127 | 5 | 446 | 485 | MDE1830385.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 123 | 45.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28102197 | 28102197 | PRJNA1240804_P_NODE_113365_length_168_cov_0.873950_g112999_i0 | PRJNA1240804 | 113365 | 168 | 0.87395 | 1.468236 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 2.11e-7 | NR | MEM0282349.1 | 2184738 | g112999 | i0 | 49 | 3.26785714285714 | 49 | 25 | 87.5 | 0 | 14 | 160 | 190 | 238 | MEM0282349.1 CaiB/BaiF CoA-transferase family protein [Desulfurococcaceae archaeon] | diamond | 549 | 56.2 | 0.99288256227758 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 29852380 | 29852380 | PRJNA1240804_P_NODE_103971_length_171_cov_1.098361_g103605_i0 | PRJNA1240804 | 103971 | 171 | 1.098361 | 1.87819731 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 44.7 | 0.00307 | NR | HEY6282824.1 | 2268197 | g103605 | i0 | 42.3 | 0.912280701754386 | 52 | 30 | 91.2 | 0 | 7 | 162 | 732 | 783 | HEY6282824.1 reverse transcriptase domain-containing protein [Nitrososphaerales archaeon] | diamond | 156 | 44.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 30295090 | 30295090 | PRJNA1240804_P_NODE_31992_length_259_cov_1.733333_g31626_i0 | PRJNA1240804 | 31992 | 259 | 1.733333 | 4.48933247 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 143 | 1.73e-39 | NR | MFI5423128.1 | 2268197 | g31626 | i0 | 84.6 | 0.903474903474903 | 78 | 12 | 90.3 | 0 | 14 | 247 | 25 | 102 | MFI5423128.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 234 | 143 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 30926839 | 30926839 | PRJNA1240804_P_NODE_84714_length_183_cov_1.544776_g84348_i0 | PRJNA1240804 | 84714 | 183 | 1.544776 | 2.82694008 | Sulfolobales archaeon | 2268200 | Archaea | Archaea | 91.3 | 2.88e-20 | NR | MEM0439402.1 | 2268200 | g84348 | i0 | 93.8 | 0.786885245901639 | 48 | 3 | 78.7 | 0 | 160 | 17 | 46 | 93 | MEM0439402.1 DNA methyltransferase [Sulfolobales archaeon] | diamond | 144 | 91.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon | ||||
| 31545563 | 31545563 | PRJNA1240804_P_NODE_42416_length_232_cov_3.196721_g42050_i0 | PRJNA1240804 | 42416 | 232 | 3.196721 | 7.41639272 | root | 1 | Root_unresolved | Root_unresolved | 119 | 2.07e-31 | NR | MCI0564163.1 | 1971748 | g42050 | i0 | 72.6 | 6.55603448275862 | 73 | 20 | 94.4 | 0 | 231 | 13 | 67 | 139 | MCI0564163.1 nucleoside 2-deoxyribosyltransferase [Nitrososphaera sp.] | diamond | 1521 | 119 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 31653527 | 31653527 | PRJNA1240804_P_NODE_114857_length_168_cov_0.873950_g114491_i0 | PRJNA1240804 | 114857 | 168 | 0.87395 | 1.468236 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 47 | 4.38e-4 | NR | MEM2930031.1 | 2056631 | g114491 | i0 | 64.5 | 0.553571428571429 | 31 | 11 | 55.4 | 0 | 108 | 16 | 150 | 180 | MEM2930031.1 cellulase family glycosylhydrolase [Thermoproteota archaeon] | diamond | 93 | 47 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32223256 | 32223256 | PRJNA1240804_P_NODE_147618_length_162_cov_0.920354_g147252_i0 | PRJNA1240804 | 147618 | 162 | 0.920354 | 1.49097348 | Nitrososphaeria archaeon | 2268198 | Archaea | Archaea | 92.4 | 6.560000000000001e-21 | NR | NDF30488.1 | 2268198 | g147252 | i0 | 90.4 | 0.962962962962963 | 52 | 5 | 96.3 | 0 | 157 | 2 | 21 | 72 | NDF30488.1 hypothetical protein [Nitrososphaeria archaeon] | diamond | 156 | 92.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaeria archaeon | |||||
| 32286803 | 32286803 | PRJNA1240804_P_NODE_152739_length_158_cov_2.119266_g152373_i0 | PRJNA1240804 | 152739 | 158 | 2.119266 | 3.34844028 | Sulfolobus sp. E5 | 2200884 | Archaea | Archaea | 89.7 | 2.56e-19 | NR | TRM73770.1 | 2200884 | g152373 | i0 | 100 | 0.892405063291139 | 47 | 0 | 89.2 | 0 | 143 | 3 | 376 | 422 | TRM73770.1 acetaldehyde dehydrogenase [Sulfolobus sp. E5] | diamond | 141 | 89.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus sp. E5 | ||
| 32349989 | 32349989 | PRJNA1240804_P_NODE_53399_length_214_cov_1.169697_g53033_i0 | PRJNA1240804 | 53399 | 214 | 1.169697 | 2.50315158 | Nitrososphaeria archaeon | 2268198 | Archaea | Archaea | 64.3 | 5.2e-10 | NR | NIM44033.1 | 2268198 | g53033 | i0 | 48.2 | 0.785046728971963 | 56 | 29 | 78.5 | 0 | 172 | 5 | 243 | 298 | NIM44033.1 hypothetical protein [Nitrososphaeria archaeon] | diamond | 168 | 64.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaeria archaeon | |||||
| 32381483 | 32381483 | PRJNA1240804_P_NODE_138779_length_164_cov_0.904348_g138413_i0 | PRJNA1240804 | 138779 | 164 | 0.904348 | 1.48313072 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 93.2 | 1.37e-20 | NR | WP_148686069.1 | 1826872 | g138413 | i0 | 97.8 | 2.46951219512195 | 45 | 1 | 82.3 | 0 | 137 | 3 | 69 | 113 | WP_148686069.1 metallophosphoesterase family protein [Candidatus Nitrosocosmicus hydrocola] | diamond | 405 | 93.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola |
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);;