contig_metadata
19 rows where bioproject = "PRJNA1010780", tax_phylum = "Nitrososphaerota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26844993 | 26844993 | PRJNA1010780_S_NODE_42941_length_196_cov_1.378882_g41652_i0 | PRJNA1010780 | 42941 | 196 | 1.378882 | 2.70260872 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 111 | 2.46e-27 | NR | MDA7940732.1 | 2024843 | g41652 | i0 | 75.4 | 0.933673469387755 | 61 | 15 | 93.4 | 0 | 9 | 191 | 333 | 393 | MDA7940732.1 multicopper oxidase domain-containing protein [Nitrosopumilus sp.] | diamond | 183 | 111 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 27002710 | 27002710 | PRJNA1010780_S_NODE_1682_length_1920_cov_6.874801_g1489_i0 | PRJNA1010780 | 1682 | 1920 | 6.874801 | 131.9961792 | Candidatus Nitrosocaldaceae archaeon | 2838776 | Archaea | Archaea | 76.3 | 2.8e-10 | NR | GIU70957.1 | 2838776 | g1489 | i0 | 24.8 | 0.8625 | 552 | 325 | 76.4 | 23 | 1906 | 440 | 1 | 525 | GIU70957.1 MAG: hypothetical protein KatS3mg003_0436 [Candidatus Nitrosocaldaceae archaeon] | diamond | 1656 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Candidatus Nitrosocaldales | Candidatus Nitrosocaldaceae | Candidatus Nitrosocaldaceae archaeon | |||
| 27311777 | 27311777 | PRJNA1010780_S_NODE_59163_length_156_cov_2.586777_g57874_i0 | PRJNA1010780 | 59163 | 156 | 2.586777 | 4.03537212 | Candidatus Pacearchaeota | 1801617 | Archaea | Archaea | 64.3 | 1.88e-10 | NR | WP_268541211.1 | 1603555 | g57874 | i0 | 64.7 | 4.90384615384615 | 51 | 18 | 98.1 | 0 | 155 | 3 | 73 | 123 | WP_268541211.1 spherulation-specific family 4 protein, partial [Candidatus Nitrosotenuis cloacae] | diamond | 765 | 64.7 | 0.993817619783617 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 27540225 | 27540225 | PRJNA1010780_S_NODE_25284_length_313_cov_4.086331_g23995_i0 | PRJNA1010780 | 25284 | 313 | 4.086331 | 12.79021603 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 153 | 3.2999999999999994e-46 | NR | HXF90788.1 | 2507556 | g23995 | i0 | 83.1 | 0.853035143769968 | 89 | 15 | 85.3 | 0 | 13 | 279 | 1 | 89 | HXF90788.1 HU family DNA-binding protein [Candidatus Nitrosotenuis sp.] | diamond | 267 | 153 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 27950666 | 27950666 | PRJNA1010780_S_NODE_29065_length_273_cov_1.987395_g27776_i0 | PRJNA1010780 | 29065 | 273 | 1.987395 | 5.42558835 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 45.1 | 0.00785 | NR | HXV46585.1 | 1971748 | g27776 | i0 | 36.6 | 0.78021978021978 | 71 | 41 | 73.6 | 1 | 269 | 69 | 154 | 224 | HXV46585.1 phosphate ABC transporter permease PstA [Nitrososphaera sp.] | diamond | 213 | 45.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 28140375 | 28140375 | PRJNA1010780_S_NODE_50345_length_174_cov_2.043165_g49056_i0 | PRJNA1010780 | 50345 | 174 | 2.043165 | 3.5551071 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 70.1 | 3.25e-12 | NR | MBA3283922.1 | 2024843 | g49056 | i0 | 56.1 | 0.982758620689655 | 57 | 25 | 98.3 | 0 | 2 | 172 | 160 | 216 | MBA3283922.1 reverse transcriptase family protein [Nitrosopumilus sp.] | diamond | 171 | 70.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28645352 | 28645352 | PRJNA1010780_S_NODE_25647_length_309_cov_2.624088_g24358_i0 | PRJNA1010780 | 25647 | 309 | 2.624088 | 8.10843192 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 80.9 | 3.48e-15 | NR | MBA3284442.1 | 2024843 | g24358 | i0 | 36.9 | 1 | 103 | 65 | 100 | 0 | 1 | 309 | 623 | 725 | MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 309 | 80.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28929407 | 28929407 | PRJNA1010780_S_NODE_18588_length_435_cov_1.922500_g17310_i0 | PRJNA1010780 | 18588 | 435 | 1.9225 | 8.362875 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 94.4 | 3e-19 | NR | MBA3284442.1 | 2024843 | g17310 | i0 | 44.1 | 0.703448275862069 | 102 | 57 | 70.3 | 0 | 129 | 434 | 443 | 544 | MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 306 | 94.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29087454 | 29087454 | PRJNA1010780_S_NODE_39508_length_209_cov_1.701149_g38219_i0 | PRJNA1010780 | 39508 | 209 | 1.701149 | 3.55540141 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 55.5 | 7.75e-7 | NR | MBA3283922.1 | 2024843 | g38219 | i0 | 35.3 | 1.89473684210526 | 68 | 44 | 97.6 | 0 | 209 | 6 | 351 | 418 | MBA3283922.1 reverse transcriptase family protein [Nitrosopumilus sp.] | diamond | 396 | 55.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29213887 | 29213887 | PRJNA1010780_S_NODE_58349_length_158_cov_1.439024_g57060_i0 | PRJNA1010780 | 58349 | 158 | 1.439024 | 2.2736579200000002 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 41.6 | 0.0277 | NR | MDF2428265.1 | 2024843 | g57060 | i0 | 54.3 | 0.664556962025316 | 35 | 13 | 66.5 | 1 | 140 | 36 | 81 | 112 | MDF2428265.1 tetratricopeptide repeat protein [Nitrosopumilus sp.] | diamond | 105 | 41.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29245260 | 29245260 | PRJNA1010780_S_NODE_55729_length_163_cov_1.140625_g54440_i0 | PRJNA1010780 | 55729 | 163 | 1.140625 | 1.85921875 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 43.1 | 0.00939 | NR | MBT6646619.1 | 2026795 | g54440 | i0 | 34 | 2.55828220858896 | 50 | 32 | 90.2 | 1 | 5 | 151 | 109 | 158 | MBT6646619.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 417 | 43.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29371475 | 29371475 | PRJNA1010780_S_NODE_13029_length_617_cov_7.134021_g11902_i0 | PRJNA1010780 | 13029 | 617 | 7.134021 | 44.01690957 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 141 | 3.9399999999999997e-38 | NR | MCJ7638082.1 | 2169593 | g11902 | i0 | 40.2 | 0.991896272285251 | 204 | 95 | 86.1 | 5 | 617 | 87 | 11 | 214 | MCJ7638082.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrososphaeraceae archaeon] | diamond | 612 | 141 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29813374 | 29813374 | PRJNA1010780_S_NODE_29871_length_266_cov_2.095238_g28582_i0 | PRJNA1010780 | 29871 | 266 | 2.095238 | 5.57333308 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 86.3 | 2.33e-17 | NR | MEO9320001.1 | 1971748 | g28582 | i0 | 51.1 | 0.992481203007519 | 88 | 43 | 99.2 | 0 | 2 | 265 | 133 | 220 | MEO9320001.1 spherulation-specific family 4 protein [Nitrososphaera sp.] | diamond | 264 | 86.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30003138 | 30003138 | PRJNA1010780_S_NODE_25311_length_313_cov_2.492806_g24022_i0 | PRJNA1010780 | 25311 | 313 | 2.492806 | 7.80248278 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 52.8 | 2.33e-5 | NR | PHY03692.1 | 2026795 | g24022 | i0 | 33 | 0.843450479233227 | 88 | 54 | 79.6 | 1 | 250 | 2 | 37 | 124 | PHY03692.1 MAG: hypothetical protein CK526_06640 [Nitrososphaerota archaeon] | diamond | 264 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30097631 | 30097631 | PRJNA1010780_S_NODE_11912_length_667_cov_2.909810_g10843_i0 | PRJNA1010780 | 11912 | 667 | 2.90981 | 19.4084327 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 108 | 5.68e-23 | NR | MBA3284442.1 | 2024843 | g10843 | i0 | 37.4 | 1.03448275862069 | 230 | 123 | 96.3 | 7 | 25 | 666 | 1047 | 1271 | MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 690 | 108 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 30540117 | 30540117 | PRJNA1010780_S_NODE_37493_length_218_cov_1.726776_g36204_i0 | PRJNA1010780 | 37493 | 218 | 1.726776 | 3.76437168 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 73.9 | 2.71e-13 | NR | HKU49008.1 | 1971748 | g36204 | i0 | 62 | 0.977064220183486 | 71 | 25 | 97.7 | 2 | 213 | 1 | 560 | 628 | HKU49008.1 HYR domain-containing protein [Nitrososphaera sp.] | diamond | 213 | 73.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 31077368 | 31077368 | PRJNA1010780_S_NODE_15_length_6295_cov_99.504792_g6_i0 | PRJNA1010780 | 15 | 6295 | 99.504792 | 6263.8266564 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 1089 | 0 | NR | MBA3284442.1 | 2024843 | g6 | i0 | 45.8 | 0.650516282764098 | 1365 | 713 | 64.5 | 13 | 2055 | 6113 | 73 | 1422 | MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 4095 | 1089 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31520113 | 31520113 | PRJNA1010780_S_NODE_36776_length_221_cov_2.537634_g35487_i0 | PRJNA1010780 | 36776 | 221 | 2.537634 | 5.60817114 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 62 | 2.57e-9 | NR | MBA3284025.1 | 2024843 | g35487 | i0 | 42.9 | 0.950226244343891 | 70 | 38 | 92.3 | 1 | 5 | 208 | 133 | 202 | MBA3284025.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 210 | 62 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 32437635 | 32437635 | PRJNA1010780_S_NODE_18679_length_433_cov_1.919598_g17401_i0 | PRJNA1010780 | 18679 | 433 | 1.919598 | 8.31185934 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 66.6 | 1.43e-9 | NR | MBA3284442.1 | 2024843 | g17401 | i0 | 33.5 | 1.07390300230947 | 155 | 81 | 99.8 | 6 | 432 | 1 | 1265 | 1408 | MBA3284442.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 465 | 66.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus 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);;