contig_metadata
18 rows where bioproject = "PRJNA615351", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26890948 | 26890948 | PRJNA615351_P_NODE_86241_length_387_cov_0.997159_g72172_i0 | PRJNA615351 | 86241 | 387 | 0.997159 | 3.85900533 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 45.4 | 0.0203 | NR | TLX98150.1 | 2026795 | g72172 | i0 | 37.5 | 0.62015503875969 | 80 | 45 | 58.1 | 2 | 144 | 368 | 42 | 121 | TLX98150.1 MAG: hypothetical protein E6K96_01215 [Nitrososphaerota archaeon] | diamond | 240 | 45.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27111900 | 27111900 | PRJNA615351_P_NODE_187242_length_150_cov_1.391304_g173142_i0 | PRJNA615351 | 187242 | 150 | 1.391304 | 2.086956 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 39.7 | 0.0346 | NR | HEY1247982.1 | 1971748 | g173142 | i0 | 47.1 | 0.68 | 34 | 18 | 68 | 0 | 149 | 48 | 51 | 84 | HEY1247982.1 hypothetical protein [Nitrososphaera sp.] | diamond | 102 | 39.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27238348 | 27238348 | PRJNA615351_P_NODE_136363_length_213_cov_1.348315_g122263_i0 | PRJNA615351 | 136363 | 213 | 1.348315 | 2.87191095 | Conexivisphaera calida | 1874277 | Archaea | Archaea | 104 | 4.25e-24 | NR | WP_269473739.1 | 1874277 | g122263 | i0 | 64.2 | 1.88732394366197 | 67 | 24 | 94.4 | 0 | 203 | 3 | 120 | 186 | WP_269473739.1 methionine--tRNA ligase [Conexivisphaera calida] | diamond | 402 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Conexivisphaeria | Conexivisphaerales | Conexivisphaeraceae | Conexivisphaera | Conexivisphaera calida | ||
| 27428208 | 27428208 | PRJNA615351_P_NODE_10763_length_1976_cov_2.885626_g7729_i0 | PRJNA615351 | 10763 | 1976 | 2.885626 | 57.01996976 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 51.2 | 0.0129 | NR | MFI5423005.1 | 2268197 | g7729 | i0 | 26.7 | 0.182186234817814 | 120 | 76 | 17 | 3 | 625 | 960 | 33 | 148 | MFI5423005.1 erythromycin esterase family protein [Nitrososphaerales archaeon] | diamond | 360 | 51.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 27554219 | 27554219 | PRJNA615351_P_NODE_89064_length_370_cov_3.716418_g74987_i0 | PRJNA615351 | 89064 | 370 | 3.716418 | 13.7507466 | Candidatus Geocrenenecus arthurdayi | 2978060 | Archaea | Archaea | 44.3 | 0.043 | NR | MCL7391525.1 | 2978060 | g74987 | i0 | 33.8 | 1.94594594594595 | 80 | 46 | 60 | 2 | 78 | 299 | 98 | 176 | MCL7391525.1 M6 family metalloprotease domain-containing protein [Candidatus Geocrenenecus arthurdayi] | diamond | 720 | 44.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Wolframiiraptoraceae | Candidatus Geocrenenecus | Candidatus Geocrenenecus arthurdayi | ||||
| 28501736 | 28501736 | PRJNA615351_P_NODE_62247_length_573_cov_3.301115_g48822_i0 | PRJNA615351 | 62247 | 573 | 3.301115 | 18.91538895 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 45.4 | 0.0204 | NR | TLX97763.1 | 2026795 | g48822 | i0 | 38.4 | 0.764397905759162 | 73 | 41 | 38.2 | 2 | 374 | 156 | 63 | 131 | TLX97763.1 MAG: ribonuclease HI family protein [Nitrososphaerota archaeon] | diamond | 438 | 45.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28533323 | 28533323 | PRJNA615351_P_NODE_178167_length_157_cov_2.426230_g164067_i0 | PRJNA615351 | 178167 | 157 | 2.42623 | 3.8091811 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 77.4 | 2.62e-17 | NR | MPZ05115.1 | 2169593 | g164067 | i0 | 71.4 | 5.04458598726115 | 42 | 12 | 80.3 | 0 | 155 | 30 | 11 | 52 | MPZ05115.1 30S ribosomal protein S27ae [Nitrososphaeraceae archaeon] | diamond | 792 | 77.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28704052 | 28704052 | PRJNA615351_P_NODE_140727_length_205_cov_1.511765_g126627_i0 | PRJNA615351 | 140727 | 205 | 1.511765 | 3.09911825 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 8.95e-6 | NR | MCS6788073.1 | 2528703 | g126627 | i0 | 50 | 3.39512195121951 | 56 | 24 | 80.5 | 2 | 23 | 187 | 11 | 63 | MCS6788073.1 CBS domain-containing protein [Aigarchaeota archaeon] | diamond | 696 | 49.7 | 0.991951710261569 | Archaea | Thermoproteati | Nitrososphaerota | Aigarchaeota archaeon | ||||||
| 28911782 | 28911782 | PRJNA615351_P_NODE_29208_length_1156_cov_3.027654_g21319_i0 | PRJNA615351 | 29208 | 1156 | 3.027654 | 34.999680240000004 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 52 | 0.00505 | NR | MDE1764929.1 | 2026795 | g21319 | i0 | 31.4 | 0.625432525951557 | 118 | 66 | 27.5 | 4 | 362 | 45 | 1417 | 1531 | MDE1764929.1 fibronectin type III domain-containing protein [Nitrososphaerota archaeon] | diamond | 723 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29007082 | 29007082 | PRJNA615351_P_NODE_154008_length_184_cov_2.120805_g139908_i0 | PRJNA615351 | 154008 | 184 | 2.120805 | 3.9022812 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 74.3 | 5.64e-14 | NR | WP_268541211.1 | 1603555 | g139908 | i0 | 55.9 | 0.96195652173913 | 59 | 26 | 96.2 | 0 | 1 | 177 | 59 | 117 | WP_268541211.1 spherulation-specific family 4 protein, partial [Candidatus Nitrosotenuis cloacae] | diamond | 177 | 74.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 29700913 | 29700913 | PRJNA615351_P_NODE_103910_length_302_cov_1.460674_g89811_i0 | PRJNA615351 | 103910 | 302 | 1.460674 | 4.41123548 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 115 | 2.47e-28 | NR | MBI1829802.1 | 2026795 | g89811 | i0 | 55 | 1.97682119205298 | 100 | 45 | 99.3 | 0 | 302 | 3 | 213 | 312 | MBI1829802.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 597 | 115 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30143358 | 30143358 | PRJNA615351_P_NODE_97812_length_327_cov_2.643836_g83715_i0 | PRJNA615351 | 97812 | 327 | 2.643836 | 8.64534372 | Candidatus Nitrosotenuis sp. | 2507556 | Archaea | Archaea | 41.2 | 0.0488 | NR | MEM3143984.1 | 2507556 | g83715 | i0 | 46.2 | 0.357798165137615 | 39 | 21 | 35.8 | 0 | 1 | 117 | 9 | 47 | MEM3143984.1 tetratricopeptide repeat protein [Candidatus Nitrosotenuis sp.] | diamond | 117 | 41.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. | |||||
| 30428297 | 30428297 | PRJNA615351_P_NODE_119773_length_251_cov_1.481481_g105673_i0 | PRJNA615351 | 119773 | 251 | 1.481481 | 3.71851731 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 45.1 | 0.00634 | NR | MBI5698125.1 | 2026795 | g105673 | i0 | 52.3 | 0.525896414342629 | 44 | 15 | 45.4 | 2 | 240 | 127 | 568 | 611 | MBI5698125.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 132 | 45.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30743916 | 30743916 | PRJNA615351_P_NODE_16594_length_1615_cov_11.762658_g11035_i2 | PRJNA615351 | 16594 | 1615 | 11.762658 | 189.9669267 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 394 | 3.09e-128 | NR | MEM3063254.1 | 2026795 | g11035 | i2 | 43.8 | 0.938080495356037 | 505 | 255 | 92.7 | 11 | 1520 | 24 | 10 | 491 | MEM3063254.1 sugar phosphate nucleotidyltransferase [Nitrososphaerota archaeon] | diamond | 1515 | 394 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30807198 | 30807198 | PRJNA615351_P_NODE_45974_length_791_cov_2.388889_g34532_i0 | PRJNA615351 | 45974 | 791 | 2.388889 | 18.89611199 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 125 | 1.75e-28 | NR | NHV06389.1 | 2026795 | g34532 | i0 | 34.1 | 0.989886219974716 | 261 | 147 | 98.6 | 9 | 788 | 9 | 137 | 373 | NHV06389.1 family 78 glycoside hydrolase catalytic domain [Nitrososphaerota archaeon] | diamond | 783 | 125 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30870284 | 30870284 | PRJNA615351_P_NODE_26814_length_1225_cov_6.339496_g19514_i0 | PRJNA615351 | 26814 | 1225 | 6.339496 | 77.658826 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 70.1 | 4.79e-11 | NR | MBS3922488.1 | 2026886 | g19514 | i0 | 34.5 | 0.205714285714286 | 84 | 55 | 20.6 | 0 | 1075 | 824 | 1 | 84 | MBS3922488.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 252 | 70.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 31249413 | 31249413 | PRJNA615351_P_NODE_16595_length_1615_cov_11.708861_g11035_i3 | PRJNA615351 | 16595 | 1615 | 11.708861 | 189.09810515 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 394 | 3.09e-128 | NR | MEM3063254.1 | 2026795 | g11035 | i3 | 43.8 | 0.938080495356037 | 505 | 255 | 92.7 | 11 | 96 | 1592 | 10 | 491 | MEM3063254.1 sugar phosphate nucleotidyltransferase [Nitrososphaerota archaeon] | diamond | 1515 | 394 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31768445 | 31768445 | PRJNA615351_P_NODE_27877_length_1193_cov_15.214162_g20309_i0 | PRJNA615351 | 27877 | 1193 | 15.214162 | 181.50495266 | root | 1 | Root_unresolved | Root_unresolved | 102 | 4.68e-22 | NR | WP_268542523.1 | 1603555 | g20309 | i0 | 41.3 | 2.08717518860017 | 109 | 64 | 27.4 | 0 | 916 | 590 | 8 | 116 | WP_268542523.1 peptide-methionine (S)-S-oxide reductase MsrA [Candidatus Nitrosotenuis cloacae] | diamond | 2490 | 103 | 0.990291262135922 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae |
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);;