contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27405531 | 27405531 | PRJNA976345_P_NODE_96583_length_192_cov_2.031847_g94975_i0 | PRJNA976345 | 96583 | 192 | 2.031847 | 3.90114624 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 43.9 | 0.00708 | NR | HJJ77687.1 | 2058474 | g94975 | i0 | 46.3 | 0.640625 | 41 | 22 | 64.1 | 0 | 126 | 4 | 4 | 44 | HJJ77687.1 hypothetical protein [Methanocorpusculum sp.] | diamond | 123 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 28131659 | 28131659 | PRJNA976345_P_NODE_133245_length_174_cov_1.323741_g131637_i0 | PRJNA976345 | 133245 | 174 | 1.323741 | 2.30330934 | archaeon | 1906665 | Archaea | Archaea | 42 | 0.0267 | NR | NCN86483.1 | 1906665 | g131637 | i0 | 46.9 | 0.844827586206897 | 49 | 22 | 84.5 | 1 | 155 | 9 | 204 | 248 | NCN86483.1 radical SAM protein [archaeon] | diamond | 147 | 42 | 1 | Archaea | archaeon | ||||||||
| 28194465 | 28194465 | PRJNA976345_P_NODE_40526_length_270_cov_3.234043_g38918_i0 | PRJNA976345 | 40526 | 270 | 3.234043 | 8.7319161 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 60.5 | 2.89e-8 | NR | MCH2406285.1 | 2024843 | g38918 | i0 | 40 | 1.78888888888889 | 85 | 49 | 93.3 | 2 | 15 | 266 | 445 | 528 | MCH2406285.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 483 | 60.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28542167 | 28542167 | PRJNA976345_P_NODE_146927_length_167_cov_3.689394_g145319_i0 | PRJNA976345 | 146927 | 167 | 3.689394 | 6.16128798 | Methanocaldococcus sp. | 2152917 | Archaea | Archaea | 46.2 | 7.88e-4 | NR | WP_297317778.1 | 2152917 | g145319 | i0 | 44.9 | 0.880239520958084 | 49 | 27 | 88 | 0 | 6 | 152 | 50 | 98 | WP_297317778.1 GTPase [Methanocaldococcus sp.] | diamond | 147 | 46.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus sp. | |
| 29205166 | 29205166 | PRJNA976345_P_NODE_100889_length_189_cov_1.961039_g99281_i0 | PRJNA976345 | 100889 | 189 | 1.961039 | 3.70636371 | Archaeoglobaceae archaeon | 2511821 | Archaea | Archaea | 91.3 | 1.49e-19 | NR | MCS7121671.1 | 2511821 | g99281 | i0 | 70.5 | 8.96825396825397 | 61 | 18 | 96.8 | 0 | 183 | 1 | 430 | 490 | MCS7121671.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Archaeoglobaceae archaeon] | diamond | 1695 | 91.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobaceae archaeon | |||
| 29299727 | 29299727 | PRJNA976345_P_NODE_135269_length_173_cov_1.427536_g133661_i0 | PRJNA976345 | 135269 | 173 | 1.427536 | 2.46963728 | archaeon | 1906665 | Archaea | Archaea | 55.1 | 2.36e-8 | NR | RYY86752.1 | 1906665 | g133661 | i0 | 65.2 | 0.797687861271676 | 46 | 16 | 79.8 | 0 | 3 | 140 | 5 | 50 | RYY86752.1 MAG: hypothetical protein EON63_05265 [archaeon] | diamond | 138 | 55.1 | 1 | Archaea | archaeon | ||||||||
| 29678298 | 29678298 | PRJNA976345_P_NODE_146630_length_168_cov_1.187970_g145022_i0 | PRJNA976345 | 146630 | 168 | 1.18797 | 1.9957896 | archaeon | 1906665 | Archaea | Archaea | 60.8 | 4.39e-9 | NR | RYG53897.1 | 1906665 | g145022 | i0 | 62.5 | 0.857142857142857 | 48 | 18 | 85.7 | 0 | 23 | 166 | 1 | 48 | RYG53897.1 MAG: hypothetical protein EON66_07885 [archaeon] | diamond | 144 | 60.8 | 1 | Archaea | archaeon | ||||||||
| 29962902 | 29962902 | PRJNA976345_P_NODE_128111_length_176_cov_2.340426_g126503_i0 | PRJNA976345 | 128111 | 176 | 2.340426 | 4.11914976 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 45.4 | 0.00169 | NR | HKU83278.1 | 2109671 | g126503 | i0 | 44.1 | 1.00568181818182 | 59 | 28 | 92 | 2 | 167 | 6 | 194 | 252 | HKU83278.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.] | diamond | 177 | 45.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 30562883 | 30562883 | PRJNA976345_P_NODE_87713_length_199_cov_1.725610_g86105_i0 | PRJNA976345 | 87713 | 199 | 1.72561 | 3.4339639 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 40.8 | 0.0255 | NR | WP_196817592.1 | 1353260 | g86105 | i0 | 42.2 | 0.678391959798995 | 45 | 26 | 67.8 | 0 | 187 | 53 | 3 | 47 | WP_196817592.1 hypothetical protein [Candidatus Nitrosocosmicus oleophilus] | diamond | 135 | 40.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 30562888 | 30562888 | PRJNA976345_P_NODE_95193_length_193_cov_2.126582_g93585_i0 | PRJNA976345 | 95193 | 193 | 2.126582 | 4.10430326 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 40 | 0.0439 | NR | MBI1658427.1 | 2026795 | g93585 | i0 | 50 | 0.49740932642487 | 32 | 16 | 49.7 | 0 | 116 | 21 | 44 | 75 | MBI1658427.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 96 | 40 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 30847517 | 30847517 | PRJNA976345_P_NODE_102994_length_188_cov_1.267974_g101386_i0 | PRJNA976345 | 102994 | 188 | 1.267974 | 2.38379112 | Candidatus Marsarchaeota archaeon | 2823144 | Archaea | Archaea | 43.1 | 0.0132 | NR | MCL5427951.1 | 2823144 | g101386 | i0 | 39.3 | 2.48936170212766 | 56 | 33 | 89.4 | 1 | 14 | 181 | 442 | 496 | MCL5427951.1 TCP-1/cpn60 chaperonin family protein [Candidatus Marsarchaeota archaeon] | diamond | 468 | 43.1 | 1 | Archaea | Thermoproteati | Candidatus Marsarchaeota | Candidatus Marsarchaeota archaeon | ||||||
| 31574805 | 31574805 | PRJNA976345_P_NODE_34456_length_290_cov_1.839216_g32849_i0 | PRJNA976345 | 34456 | 290 | 1.839216 | 5.3337264 | Promethearchaeota archaeon | 2053489 | Archaea | Archaea | 47.4 | 0.00141 | NR | MBD3352878.1 | 2053489 | g32849 | i0 | 50 | 1.46896551724138 | 52 | 26 | 53.8 | 0 | 289 | 134 | 261 | 312 | MBD3352878.1 GTP-binding protein [Promethearchaeota archaeon] | diamond | 426 | 47.4 | 1 | Archaea | Promethearchaeati | Promethearchaeota | Promethearchaeota archaeon | ||||||
| 32175938 | 32175938 | PRJNA976345_P_NODE_46598_length_255_cov_1.500000_g44990_i0 | PRJNA976345 | 46598 | 255 | 1.5 | 3.825 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 42.7 | 0.00534 | NR | RLE37447.1 | 2026803 | g44990 | i0 | 37 | 0.635294117647059 | 54 | 34 | 63.5 | 0 | 164 | 3 | 6 | 59 | RLE37447.1 MAG: hypothetical protein DRJ17_06615 [Candidatus Woesearchaeota archaeon] | diamond | 162 | 42.7 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32492347 | 32492347 | PRJNA976345_P_NODE_64199_length_223_cov_6.218085_g62591_i0 | PRJNA976345 | 64199 | 223 | 6.218085 | 13.86632955 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 65.1 | 3.83e-10 | NR | MDW3615052.1 | 2169593 | g62591 | i0 | 42.6 | 1.80269058295964 | 68 | 39 | 91.5 | 0 | 1 | 204 | 60 | 127 | MDW3615052.1 ribonuclease H family protein [Nitrososphaeraceae archaeon] | diamond | 402 | 65.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32681095 | 32681095 | PRJNA976345_P_NODE_112320_length_182_cov_1.619048_g110712_i0 | PRJNA976345 | 112320 | 182 | 1.619048 | 2.94666736 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 45.8 | 0.0013 | NR | WP_288267568.1 | 253161 | g110712 | i0 | 50 | 0.659340659340659 | 40 | 20 | 65.9 | 0 | 31 | 150 | 257 | 296 | WP_288267568.1 RHS repeat-associated core domain-containing protein [uncultured Methanobrevibacter sp.] | diamond | 120 | 45.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 32807293 | 32807293 | PRJNA976345_P_NODE_131220_length_175_cov_1.328571_g129612_i0 | PRJNA976345 | 131220 | 175 | 1.328571 | 2.32499925 | Candidatus Pacearchaeota archaeon | 2026773 | Archaea | Archaea | 77.4 | 9.09e-15 | NR | MCK5611892.1 | 2026773 | g129612 | i0 | 62.1 | 0.994285714285714 | 58 | 22 | 99.4 | 0 | 175 | 2 | 701 | 758 | MCK5611892.1 hypothetical protein [Candidatus Pacearchaeota archaeon] | diamond | 174 | 77.4 | 1 | Archaea | Candidatus Pacearchaeota | Nanobdellati | Candidatus Pacearchaeota archaeon |
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);;