contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4751198 | 4751198 | PRJNA942359_P_NODE_10324_length_277_cov_2.823529_g10209_i0 | PRJNA942359 | 10324 | 277 | 2.823529 | 7.82117533 | Candidatus Nitrosarchaeum limnium | 1007084 | Archaea | Archaea | 98.2 | 1.86e-21 | NR | WP_048097151.1 | 1007084 | g10209 | i0 | 60.8 | 2.11191335740072 | 102 | 30 | 99.6 | 3 | 276 | 1 | 503 | 604 | WP_048097151.1 beta strand repeat-containing protein, partial [Candidatus Nitrosarchaeum limnium] | diamond | 585 | 98.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium | ||
| 5087170 | 5087170 | PRJNA942359_P_NODE_6284_length_336_cov_1.969582_g6169_i0 | PRJNA942359 | 6284 | 336 | 1.969582 | 6.61779552 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 224 | 6.82e-70 | NR | MBS3926316.1 | 2026886 | g6169 | i0 | 96.4 | 2 | 112 | 4 | 100 | 0 | 336 | 1 | 203 | 314 | MBS3926316.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 672 | 224 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 7301109 | 7301109 | PRJNA942359_P_NODE_19866_length_242_cov_0.923077_g19751_i0 | PRJNA942359 | 19866 | 242 | 0.923077 | 2.23384634 | Nitrosarchaeum | 1007082 | Archaea | Archaea | 128 | 3.4599999999999995e-35 | NR | WP_010195597.1 | 1007084 | g19751 | i0 | 79 | 1.99586776859504 | 81 | 16 | 99.2 | 1 | 240 | 1 | 8 | 88 | WP_010195597.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] | diamond | 483 | 128 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium | ||
| 14950989 | 14950989 | PRJNA942359_P_NODE_212_length_1467_cov_13.237446_g177_i0 | PRJNA942359 | 212 | 1467 | 13.237446 | 194.19333282 | Candidatus Nitrosarchaeum limnium | 1007084 | Archaea | Archaea | 669 | 9.959999999999999e-228 | NR | WP_048097151.1 | 1007084 | g177 | i0 | 72.3 | 2.03680981595092 | 499 | 123 | 99.8 | 5 | 1465 | 2 | 3 | 497 | WP_048097151.1 beta strand repeat-containing protein, partial [Candidatus Nitrosarchaeum limnium] | diamond | 2988 | 669 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium | ||
| 22599976 | 22599976 | PRJNA942359_P_NODE_16438_length_248_cov_0.891429_g16323_i0 | PRJNA942359 | 16438 | 248 | 0.891429 | 2.21074392 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 134 | 8.34e-35 | NR | HWR96842.1 | 2032688 | g16323 | i0 | 85.4 | 0.991935483870968 | 82 | 12 | 99.2 | 0 | 1 | 246 | 261 | 342 | HWR96842.1 DHA2 family efflux MFS transporter permease subunit [Candidatus Methanoperedens sp.] | diamond | 246 | 134 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 26676736 | 26676736 | PRJNA942359_P_NODE_4721_length_378_cov_1.340984_g4606_i0 | PRJNA942359 | 4721 | 378 | 1.340984 | 5.06891952 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 75.9 | 8.56e-14 | NR | MDH3833836.1 | 2024843 | g4606 | i0 | 51.5 | 1.07936507936508 | 68 | 33 | 54 | 0 | 376 | 173 | 169 | 236 | MDH3833836.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 408 | 75.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 27088596 | 27088596 | PRJNA942359_P_NODE_9282_length_288_cov_1.200000_g9167_i0 | PRJNA942359 | 9282 | 288 | 1.2 | 3.456 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 45.1 | 0.0101 | NR | MFH1592725.1 | 2026803 | g9167 | i0 | 40.4 | 0.541666666666667 | 52 | 27 | 54.2 | 1 | 15 | 170 | 476 | 523 | MFH1592725.1 S8 family serine peptidase [Candidatus Woesearchaeota archaeon] | diamond | 156 | 45.1 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 27625691 | 27625691 | PRJNA942359_P_NODE_4744_length_377_cov_1.940789_g4629_i0 | PRJNA942359 | 4744 | 377 | 1.940789 | 7.31677453 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 88.2 | 1.44e-17 | NR | WP_368059013.1 | 2024843 | g4629 | i0 | 44.6 | 1.03448275862069 | 130 | 58 | 98.7 | 3 | 373 | 2 | 194 | 315 | WP_368059013.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 390 | 88.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 27783574 | 27783574 | PRJNA942359_P_NODE_10004_length_280_cov_2.927536_g9889_i0 | PRJNA942359 | 10004 | 280 | 2.927536 | 8.1971008 | Candidatus Nitrosotenuis uzonensis | 1407055 | Archaea | Archaea | 133 | 4.51e-35 | NR | WP_205097554.1 | 1407055 | g9889 | i0 | 77.4 | 0.996428571428571 | 93 | 21 | 99.6 | 0 | 279 | 1 | 20 | 112 | WP_205097554.1 trypsin-like serine protease [Candidatus Nitrosotenuis uzonensis] | diamond | 279 | 133 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis uzonensis | |||||
| 27948131 | 27948131 | PRJNA942359_P_NODE_14325_length_251_cov_0.876404_g14210_i0 | PRJNA942359 | 14325 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 98.6 | 4.04e-22 | NR | WP_048038854.1 | 2209 | g14210 | i0 | 56.6 | 5.85657370517928 | 83 | 36 | 99.2 | 0 | 249 | 1 | 274 | 356 | WP_048038854.1 restriction endonuclease subunit S [Methanosarcina mazei] | diamond | 1470 | 99 | 0.995959595959596 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina mazei | |
| 28320125 | 28320125 | PRJNA942359_P_NODE_14446_length_251_cov_0.876404_g14331_i0 | PRJNA942359 | 14446 | 251 | 0.876404 | 2.19977404 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 142 | 6.51e-39 | NR | HWR98640.1 | 2032688 | g14331 | i0 | 81.7 | 0.9800796812749 | 82 | 15 | 98 | 0 | 1 | 246 | 120 | 201 | HWR98640.1 DHH family phosphoesterase [Candidatus Methanoperedens sp.] | diamond | 246 | 142 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 29204410 | 29204410 | PRJNA942359_P_NODE_10709_length_273_cov_3.480000_g10594_i0 | PRJNA942359 | 10709 | 273 | 3.48 | 9.5004 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 111 | 3.56e-28 | NR | MEX1150830.1 | 2202732 | g10594 | i0 | 64.8 | 0.967032967032967 | 88 | 31 | 96.7 | 0 | 10 | 273 | 49 | 136 | MEX1150830.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 264 | 111 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 29519914 | 29519914 | PRJNA942359_P_NODE_20790_length_203_cov_4.161538_g20675_i0 | PRJNA942359 | 20790 | 203 | 4.161538 | 8.44792214 | Candidatus Nitrosarchaeum limnium | 1007084 | Archaea | Archaea | 109 | 5.230000000000001e-29 | NR | WP_193353005.1 | 1007084 | g20675 | i0 | 83.6 | 1.98029556650246 | 67 | 11 | 99 | 0 | 2 | 202 | 33 | 99 | WP_193353005.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] | diamond | 402 | 109 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium | ||
| 30119915 | 30119915 | PRJNA942359_P_NODE_16012_length_248_cov_0.891429_g15897_i0 | PRJNA942359 | 16012 | 248 | 0.891429 | 2.21074392 | Desulfurococcales archaeon ex4484_58 | 2012521 | Archaea | Archaea | 42.4 | 0.0211 | NR | OYT37353.1 | 2012521 | g15897 | i0 | 32 | 0.604838709677419 | 50 | 31 | 58.1 | 2 | 146 | 3 | 21 | 69 | OYT37353.1 MAG: DNA-binding protein [Desulfurococcales archaeon ex4484_58] | diamond | 150 | 42.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcales archaeon ex4484_58 | ||||
| 30530673 | 30530673 | PRJNA942359_P_NODE_15773_length_249_cov_0.886364_g15658_i0 | PRJNA942359 | 15773 | 249 | 0.886364 | 2.20704636 | Methanobrevibacter gottschalkii | 190974 | Archaea | Archaea | 145 | 1.54e-40 | NR | WP_091698890.1 | 190974 | g15658 | i0 | 81.9 | 3 | 83 | 15 | 100 | 0 | 1 | 249 | 119 | 201 | WP_091698890.1 CPBP family intramembrane glutamic endopeptidase [Methanobrevibacter gottschalkii] | diamond | 747 | 145 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter gottschalkii | |
| 30973254 | 30973254 | PRJNA942359_P_NODE_14314_length_251_cov_0.876404_g14199_i0 | PRJNA942359 | 14314 | 251 | 0.876404 | 2.19977404 | Haloferax | 2251 | Archaea | Archaea | 52.8 | 1.23e-5 | NR | WP_151114281.1 | 2251 | g14199 | i0 | 36.3 | 1.60159362549801 | 80 | 35 | 95.6 | 2 | 243 | 4 | 726 | 789 | WP_151114281.1 MULTISPECIES: PD-(D/E)XK nuclease family protein [Haloferax] | diamond | 402 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | ||
| 31225768 | 31225768 | PRJNA942359_P_NODE_1515_length_629_cov_1.785971_g1405_i0 | PRJNA942359 | 1515 | 629 | 1.785971 | 11.23375759 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 280 | 2.08e-92 | NR | MEX1150829.1 | 2202732 | g1405 | i0 | 66.7 | 0.972972972972973 | 204 | 59 | 95.9 | 2 | 628 | 26 | 39 | 236 | MEX1150829.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 612 | 280 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 31921780 | 31921780 | PRJNA942359_P_NODE_4317_length_391_cov_1.962264_g4202_i0 | PRJNA942359 | 4317 | 391 | 1.962264 | 7.67245224 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 141 | 4.75e-39 | NR | MDH3833836.1 | 2024843 | g4202 | i0 | 54.7 | 0.982097186700767 | 128 | 57 | 97.4 | 1 | 386 | 6 | 3 | 130 | MDH3833836.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 384 | 141 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 32111674 | 32111674 | PRJNA942359_P_NODE_13778_length_252_cov_0.871508_g13663_i0 | PRJNA942359 | 13778 | 252 | 0.871508 | 2.19620016 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 108 | 2.11e-25 | NR | MDW0176719.1 | 2169593 | g13663 | i0 | 68 | 0.892857142857143 | 75 | 24 | 89.3 | 0 | 2 | 226 | 65 | 139 | MDW0176719.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] | diamond | 225 | 108 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32774966 | 32774966 | PRJNA942359_P_NODE_15660_length_249_cov_0.886364_g15545_i0 | PRJNA942359 | 15660 | 249 | 0.886364 | 2.20704636 | Methanothrix sp. | 90426 | Archaea | Archaea | 143 | 1.59e-38 | NR | MBP8623374.1 | 90426 | g15545 | i0 | 83.1 | 1 | 83 | 14 | 100 | 0 | 249 | 1 | 57 | 139 | MBP8623374.1 anthranilate synthase component I [Methanothrix sp.] | diamond | 249 | 143 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 32900890 | 32900890 | PRJNA942359_P_NODE_7460_length_314_cov_1.236515_g7345_i0 | PRJNA942359 | 7460 | 314 | 1.236515 | 3.8826571 | Candidatus Nitrosarchaeum limnium | 1007084 | Archaea | Archaea | 198 | 2.22e-62 | NR | WP_010195597.1 | 1007084 | g7345 | i0 | 91.3 | 1.98726114649682 | 104 | 9 | 99.4 | 0 | 2 | 313 | 75 | 178 | WP_010195597.1 hypothetical protein, partial [Candidatus Nitrosarchaeum limnium] | diamond | 624 | 198 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium |
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);;