contig_metadata
20 rows where bioproject = "PRJNA946307" and tax_phylum = "Nitrososphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4756526 | 4756526 | PRJNA946307_P_NODE_92924_length_187_cov_2.579710_g92050_i0 | PRJNA946307 | 92924 | 187 | 2.57971 | 4.8240577 | Candidatus Nitrosopolaris sp. | 3069383 | Archaea | Archaea | 94.7 | 6.28e-21 | NR | HYV57425.1 | 3069383 | g92050 | i0 | 72.1 | 3.67379679144385 | 61 | 17 | 97.9 | 0 | 184 | 2 | 73 | 133 | HYV57425.1 acyltransferase [Candidatus Nitrosopolaris sp.] | diamond | 687 | 94.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosopolaris | Candidatus Nitrosopolaris sp. | ||
| 6030373 | 6030373 | PRJNA946307_P_NODE_36645_length_218_cov_4.360947_g35771_i0 | PRJNA946307 | 36645 | 218 | 4.360947 | 9.50686446 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 361 | 2.82e-95 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g35771 | i0 | 99.005 | 73.7614678899083 | 201 | 2 | 92 | 0 | 4 | 204 | 1789563 | 1789363 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 16080 | 361 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 12407073 | 12407073 | PRJNA946307_P_NODE_80030_length_194_cov_1.834483_g79156_i0 | PRJNA946307 | 80030 | 194 | 1.834483 | 3.55889702 | Candidatus Nitrosocosmicus hydrocola | 1826872 | Archaea | Archaea | 353 | 4.1e-93 | NTclustered | gi|1100598057|gb|CP017922.1| | 1826872 | g79156 | i0 | 99.485 | 15.8865979381443 | 194 | 1 | 100 | 0 | 1 | 194 | 1789632 | 1789825 | Candidatus Nitrosocosmicus hydrocola strain G61, complete genome | blastn | 3082 | 353 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus hydrocola | ||
| 14955732 | 14955732 | PRJNA946307_P_NODE_74332_length_198_cov_2.664430_g73458_i0 | PRJNA946307 | 74332 | 198 | 2.66443 | 5.2755714 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 329 | 7.08e-86 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g73458 | i0 | 98.913 | 8.86363636363636 | 184 | 2 | 93 | 0 | 15 | 198 | 849242 | 849425 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 1755 | 329 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 15288106 | 15288106 | PRJNA946307_P_NODE_1572_length_1124_cov_5.409302_g1234_i0 | PRJNA946307 | 1572 | 1124 | 5.409302 | 60.80055448 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 1827 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g1234 | i0 | 96.724 | 87.2330960854093 | 1099 | 33 | 98 | 3 | 13 | 1110 | 849298 | 848202 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 98050 | 1834 | 0.99618320610687 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 25151705 | 25151705 | PRJNA946307_P_NODE_102780_length_183_cov_1.447761_g101906_i0 | PRJNA946307 | 102780 | 183 | 1.447761 | 2.64940263 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 254 | 3.98e-63 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g101906 | i0 | 93.567 | 87.120218579235 | 171 | 10 | 93 | 1 | 1 | 170 | 848074 | 847904 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 15943 | 254 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 26835688 | 26835688 | PRJNA946307_P_NODE_172521_length_153_cov_4.423077_g171647_i0 | PRJNA946307 | 172521 | 153 | 4.423077 | 6.76730781 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 65.5 | 1.02e-10 | NR | MBS3922737.1 | 2026886 | g171647 | i0 | 65.2 | 1.80392156862745 | 46 | 16 | 90.2 | 0 | 139 | 2 | 404 | 449 | MBS3922737.1 beta-lactamase family protein [Nitrosarchaeum sp.] | diamond | 276 | 65.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 26993597 | 26993597 | PRJNA946307_P_NODE_94882_length_186_cov_3.065693_g94008_i0 | PRJNA946307 | 94882 | 186 | 3.065693 | 5.70218898 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 43.5 | 0.00727 | NR | MCI0561479.1 | 1971748 | g94008 | i0 | 40 | 1.45161290322581 | 45 | 27 | 72.6 | 0 | 137 | 3 | 80 | 124 | MCI0561479.1 toprim domain-containing protein [Nitrososphaera sp.] | diamond | 270 | 43.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 27404790 | 27404790 | PRJNA946307_P_NODE_103443_length_182_cov_4.383459_g102569_i0 | PRJNA946307 | 103443 | 182 | 4.383459 | 7.97789538 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 104 | 1.2099999999999999e-24 | NR | MBA3977413.1 | 2024843 | g102569 | i0 | 81.8 | 0.906593406593407 | 55 | 10 | 90.7 | 0 | 18 | 182 | 1 | 55 | MBA3977413.1 threonine synthase [Nitrosopumilus sp.] | diamond | 165 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 28004877 | 28004877 | PRJNA946307_P_NODE_71645_length_199_cov_2.780000_g70771_i0 | PRJNA946307 | 71645 | 199 | 2.78 | 5.5322 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 77.8 | 8.45e-15 | NR | MFI5405223.1 | 2268197 | g70771 | i0 | 51.4 | 1.05527638190955 | 70 | 25 | 92 | 1 | 15 | 197 | 231 | 300 | MFI5405223.1 twitch domain-containing radical SAM protein [Nitrososphaerales archaeon] | diamond | 210 | 77.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 28193890 | 28193890 | PRJNA946307_P_NODE_91266_length_188_cov_1.841727_g90392_i0 | PRJNA946307 | 91266 | 188 | 1.841727 | 3.46244676 | Marine Group I thaumarchaeote | 2511932 | Archaea | Archaea | 48.1 | 2.2e-4 | NR | NWK05358.1 | 2511932 | g90392 | i0 | 38.7 | 0.98936170212766 | 62 | 33 | 91 | 2 | 3 | 173 | 64 | 125 | NWK05358.1 MBL fold metallo-hydrolase [Marine Group I thaumarchaeote] | diamond | 186 | 48.1 | 1 | Archaea | Marine Group I | Thermoproteati | Nitrososphaerota | Marine Group I thaumarchaeote | |||||
| 29456682 | 29456682 | PRJNA946307_P_NODE_26210_length_252_cov_1.635468_g25336_i0 | PRJNA946307 | 26210 | 252 | 1.635468 | 4.12137936 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 79.3 | 1.84e-15 | NR | HVD07366.1 | 2169593 | g25336 | i0 | 54.9 | 1.08333333333333 | 91 | 32 | 97.6 | 3 | 252 | 7 | 55 | 145 | HVD07366.1 retropepsin-like aspartic protease [Nitrososphaeraceae archaeon] | diamond | 273 | 79.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30499396 | 30499396 | PRJNA946307_P_NODE_17493_length_307_cov_5.011628_g16622_i0 | PRJNA946307 | 17493 | 307 | 5.011628 | 15.38569796 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 73.2 | 6.48e-13 | NR | NOJ26544.1 | 1971748 | g16622 | i0 | 63.6 | 1.07491856677524 | 55 | 19 | 53.7 | 1 | 142 | 306 | 4 | 57 | NOJ26544.1 hypothetical protein [Nitrososphaera sp.] | diamond | 330 | 73.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30594043 | 30594043 | PRJNA946307_P_NODE_30453_length_236_cov_1.909091_g29579_i0 | PRJNA946307 | 30453 | 236 | 1.909091 | 4.50545476 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 49.7 | 5.18e-5 | NR | MDE1866457.1 | 2026795 | g29579 | i0 | 36.4 | 1.91949152542373 | 77 | 45 | 92.8 | 2 | 3 | 221 | 7 | 83 | MDE1866457.1 J domain-containing protein [Nitrososphaerota archaeon] | diamond | 453 | 49.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 31415844 | 31415844 | PRJNA946307_P_NODE_127596_length_172_cov_1.455285_g126722_i0 | PRJNA946307 | 127596 | 172 | 1.455285 | 2.5030902 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 50.8 | 1.64e-5 | NR | HEY5631421.1 | 2169593 | g126722 | i0 | 41.2 | 0.88953488372093 | 51 | 30 | 89 | 0 | 159 | 7 | 141 | 191 | HEY5631421.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 153 | 50.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31921906 | 31921906 | PRJNA946307_P_NODE_115517_length_177_cov_1.968750_g114643_i0 | PRJNA946307 | 115517 | 177 | 1.96875 | 3.4846875 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 73.9 | 1.49e-13 | NR | MEK0324366.1 | 2024843 | g114643 | i0 | 65.4 | 0.88135593220339 | 52 | 18 | 88.1 | 0 | 173 | 18 | 455 | 506 | MEK0324366.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 156 | 73.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31953514 | 31953514 | PRJNA946307_P_NODE_174697_length_150_cov_5.534653_g173823_i0 | PRJNA946307 | 174697 | 150 | 5.534653 | 8.3019795 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 85.5 | 4.11e-18 | NR | HEU0046132.1 | 1971748 | g173823 | i0 | 75.6 | 1.8 | 45 | 11 | 90 | 0 | 150 | 16 | 82 | 126 | HEU0046132.1 hypothetical protein [Nitrososphaera sp.] | diamond | 270 | 85.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32023633 | 32023633 | PRJNA946307_P_NODE_59238_length_208_cov_10.509434_g58364_i0 | PRJNA946307 | 59238 | 208 | 10.509434 | 21.85962272 | root | 1 | Root_unresolved | Root_unresolved | 47 | 6.4899999999999e-4 | NR | HEU0049262.1 | 1971748 | g58364 | i0 | 70 | 3.50480769230769 | 30 | 9 | 43.3 | 0 | 101 | 12 | 162 | 191 | HEU0049262.1 DDE-type integrase/transposase/recombinase [Nitrososphaera sp.] | diamond | 729 | 47.4 | 0.991561181434599 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32080062 | 32080062 | PRJNA946307_P_NODE_120478_length_175_cov_1.539683_g119604_i0 | PRJNA946307 | 120478 | 175 | 1.539683 | 2.69444525 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 47.4 | 8.2e-5 | NR | MDD9809427.1 | 2026795 | g119604 | i0 | 75 | 1.86857142857143 | 28 | 7 | 48 | 0 | 175 | 92 | 56 | 83 | MDD9809427.1 tetratricopeptide repeat protein [Nitrososphaerota archaeon] | diamond | 327 | 47.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 32901083 | 32901083 | PRJNA946307_P_NODE_49560_length_210_cov_3.484472_g48686_i0 | PRJNA946307 | 49560 | 210 | 3.484472 | 7.3173912 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 57 | 2.17e-7 | NR | MFI5407230.1 | 2268197 | g48686 | i0 | 92.9 | 0.8 | 28 | 2 | 40 | 0 | 111 | 194 | 254 | 281 | MFI5407230.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Nitrososphaerales archaeon] | diamond | 168 | 57 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales 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);;