contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7495670 | 7495670 | PRJNA533114_P_NODE_45626_length_347_cov_1.062044_g45374_i0 | PRJNA533114 | 45626 | 347 | 1.062044 | 3.68529268 | Candidatus Methanosuratincola sp. | 2495426 | Archaea | Archaea | 174 | 2.58e-51 | NR | MEM4658407.1 | 2495426 | g45374 | i0 | 67 | 9.93371757925072 | 115 | 38 | 99.4 | 0 | 347 | 3 | 3 | 117 | MEM4658407.1 adenylyl-sulfate kinase [Candidatus Methanosuratincola sp.] | diamond | 3447 | 174 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) | Candidatus Methanosuratincola sp. | ||
| 10046063 | 10046063 | PRJNA533114_P_NODE_37488_length_377_cov_1.444079_g37236_i0 | PRJNA533114 | 37488 | 377 | 1.444079 | 5.44417783 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 220 | 1.18e-65 | NR | MFB5612793.1 | 2026886 | g37236 | i0 | 88.8 | 0.994694960212202 | 125 | 14 | 99.5 | 0 | 377 | 3 | 438 | 562 | MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.] | diamond | 375 | 220 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 26776390 | 26776390 | PRJNA533114_P_NODE_281_length_2425_cov_3.537415_g266_i0 | PRJNA533114 | 281 | 2425 | 3.537415 | 85.78231375 | root | 1 | Root_unresolved | Root_unresolved | 77.8 | 1.99e-10 | NR | MDE1826414.1 | 2026795 | g266 | i0 | 26.2 | 2.58927835051546 | 386 | 208 | 45.6 | 15 | 1280 | 2386 | 56 | 381 | MDE1826414.1 fibronectin type III domain-containing protein [Nitrososphaerota archaeon] | diamond | 6279 | 78.2 | 0.994884910485933 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27566496 | 27566496 | PRJNA533114_P_NODE_53184_length_324_cov_1.533865_g52932_i0 | PRJNA533114 | 53184 | 324 | 1.533865 | 4.9697226 | Archaea | 2157 | Archaea | Archaea | 45.8 | 0.00142 | NR | MBM5805508.1 | 2250257 | g52932 | i0 | 55.6 | 3.86111111111111 | 45 | 20 | 41.7 | 0 | 57 | 191 | 1 | 45 | MBM5805508.1 50S ribosomal protein P1 [Candidatus Methanomethylicota archaeon] | diamond | 1251 | 45.8 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 28467441 | 28467441 | PRJNA533114_P_NODE_66006_length_294_cov_1.393665_g65754_i0 | PRJNA533114 | 66006 | 294 | 1.393665 | 4.0973751 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 65.1 | 8.27e-10 | NR | NIP61579.1 | 2202732 | g65754 | i0 | 36 | 1.89795918367347 | 86 | 55 | 87.8 | 0 | 35 | 292 | 1 | 86 | NIP61579.1 aldo/keto reductase [Nitrosopumilaceae archaeon] | diamond | 558 | 65.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 28530558 | 28530558 | PRJNA533114_P_NODE_36267_length_382_cov_5.588997_g36015_i0 | PRJNA533114 | 36267 | 382 | 5.588997 | 21.34996854 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 76.6 | 2.61e-13 | NR | MEX0764003.1 | 2202732 | g36015 | i0 | 45.2 | 0.816753926701571 | 104 | 51 | 80.9 | 2 | 17 | 325 | 633 | 731 | MEX0764003.1 LamG-like jellyroll fold domain-containing protein [Nitrosopumilaceae archaeon] | diamond | 312 | 76.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 28877691 | 28877691 | PRJNA533114_P_NODE_97648_length_250_cov_0.870056_g97396_i0 | PRJNA533114 | 97648 | 250 | 0.870056 | 2.17514 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 42.7 | 0.0406 | NR | MEM2129180.1 | 3045160 | g97396 | i0 | 28.4 | 0.888 | 74 | 48 | 82.8 | 1 | 225 | 19 | 376 | 449 | MEM2129180.1 hypothetical protein [Candidatus Bathyarchaeia archaeon] | diamond | 222 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29208643 | 29208643 | PRJNA533114_P_NODE_103149_length_247_cov_2.212644_g102897_i0 | PRJNA533114 | 103149 | 247 | 2.212644 | 5.46523068 | root | 1 | Root_unresolved | Root_unresolved | 77.4 | 1.28e-14 | NR | MCC6019250.1 | 2250257 | g102897 | i0 | 59.7 | 5.05263157894737 | 62 | 25 | 75.3 | 0 | 189 | 4 | 3 | 64 | MCC6019250.1 L-threonine 3-dehydrogenase [Candidatus Methanomethylicota archaeon] | diamond | 1248 | 77.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicota archaeon | ||||||
| 29256429 | 29256429 | PRJNA533114_P_NODE_74789_length_279_cov_1.577670_g74537_i0 | PRJNA533114 | 74789 | 279 | 1.57767 | 4.4016993 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 49.7 | 1.81e-4 | NR | HJS64354.1 | 2169593 | g74537 | i0 | 44.6 | 0.698924731182796 | 65 | 30 | 69.9 | 3 | 199 | 5 | 227 | 285 | HJS64354.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 195 | 49.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29587043 | 29587043 | PRJNA533114_P_NODE_108310_length_246_cov_0.861272_g108058_i0 | PRJNA533114 | 108310 | 246 | 0.861272 | 2.11872912 | Candidatus Bathycorpusculum | 3139623 | Archaea | Archaea | 42.7 | 0.0279 | NR | MCL2642081.1 | 2994959 | g108058 | i0 | 31.7 | 1.46341463414634 | 60 | 35 | 68.3 | 2 | 55 | 222 | 118 | 175 | MCL2642081.1 transposase [Candidatus Bathycorpusculum sp.] | diamond | 360 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeales | Candidatus Bathycorpusculaceae | Candidatus Bathycorpusculum | Candidatus Bathycorpusculum sp. | ||
| 29919845 | 29919845 | PRJNA533114_P_NODE_38431_length_373_cov_1.303333_g38179_i0 | PRJNA533114 | 38431 | 373 | 1.303333 | 4.86143209 | Pyrodictiaceae archaeon | 2528704 | Archaea | Archaea | 43.1 | 0.0416 | NR | MET1101952.1 | 2528704 | g38179 | i0 | 42.5 | 0.32171581769437 | 40 | 23 | 32.2 | 0 | 266 | 147 | 18 | 57 | MET1101952.1 universal stress protein [Pyrodictiaceae archaeon] | diamond | 120 | 43.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Pyrodictiaceae | Pyrodictiaceae archaeon | |||
| 29998043 | 29998043 | PRJNA533114_P_NODE_101071_length_248_cov_1.308571_g100819_i0 | PRJNA533114 | 101071 | 248 | 1.308571 | 3.24525608 | Archaea | 2157 | Archaea | Archaea | 80.1 | 2.53e-15 | NR | MCW4044179.1 | 2026714 | g100819 | i0 | 47.5 | 1.93548387096774 | 80 | 42 | 96.8 | 0 | 3 | 242 | 166 | 245 | MCW4044179.1 SLC13 family permease [Candidatus Bathyarchaeota archaeon] | diamond | 480 | 80.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31151484 | 31151484 | PRJNA533114_P_NODE_20935_length_495_cov_1.642180_g20686_i0 | PRJNA533114 | 20935 | 495 | 1.64218 | 8.128791 | Sulfodiicoccus acidiphilus | 1670455 | Archaea | Archaea | 45.4 | 0.0317 | NR | WP_126449921.1 | 1670455 | g20686 | i0 | 34.5 | 1.05454545454545 | 87 | 57 | 52.7 | 0 | 318 | 58 | 41 | 127 | WP_126449921.1 hypothetical protein [Sulfodiicoccus acidiphilus] | diamond | 522 | 45.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfodiicoccus | Sulfodiicoccus acidiphilus | ||
| 31404975 | 31404975 | PRJNA533114_P_NODE_13156_length_624_cov_1.600726_g12912_i0 | PRJNA533114 | 13156 | 624 | 1.600726 | 9.98853024 | Saccharolobus shibatae B12 | 523848 | Archaea | Archaea | 57.4 | 8.45e-6 | NR | AAA87625.1 | 523848 | g12912 | i0 | 41.2 | 0.408653846153846 | 85 | 50 | 40.9 | 0 | 145 | 399 | 27 | 111 | AAA87625.1 ORF [Saccharolobus shibatae B12] | diamond | 255 | 57.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus shibatae | ||
| 32100874 | 32100874 | PRJNA533114_P_NODE_84018_length_265_cov_1.364583_g83766_i0 | PRJNA533114 | 84018 | 265 | 1.364583 | 3.61614495 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 53.9 | 5.42e-6 | NR | MEJ2241842.1 | 2026714 | g83766 | i0 | 34.1 | 2.98867924528302 | 88 | 29 | 99.6 | 2 | 1 | 264 | 151 | 209 | MEJ2241842.1 multicopper oxidase domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 792 | 53.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32322623 | 32322623 | PRJNA533114_P_NODE_48959_length_336_cov_1.874525_g48707_i0 | PRJNA533114 | 48959 | 336 | 1.874525 | 6.298404 | Caldisphaera sp. | 2060322 | Archaea | Archaea | 63.9 | 2.93e-9 | NR | MFP3144362.1 | 2060322 | g48707 | i0 | 41.1 | 1.65178571428571 | 90 | 43 | 76.8 | 3 | 6 | 263 | 186 | 269 | MFP3144362.1 ABC transporter ATP-binding protein [Caldisphaera sp.] | diamond | 555 | 63.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Acidilobales | Caldisphaeraceae | Caldisphaera | Caldisphaera sp. |
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);;