contig_metadata
10 rows where bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6282751 | 6282751 | PRJNA690124_P_NODE_55725_length_242_cov_0.923077_g55359_i0 | PRJNA690124 | 55725 | 242 | 0.923077 | 2.23384634 | Nitrososphaera | 497726 | Archaea | Archaea | 143 | 1.2599999999999998e-29 | NTclustered | gi|647810480|gb|CP007536.1| | 926571 | g55359 | i0 | 92.079 | 2.87190082644628 | 101 | 8 | 42 | 0 | 142 | 242 | 889406 | 889506 | Nitrososphaera viennensis EN76, complete genome | blastn | 695 | 143 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera viennensis | ||
| 14698492 | 14698492 | PRJNA690124_P_NODE_46792_length_250_cov_0.881356_g46426_i0 | PRJNA690124 | 46792 | 250 | 0.881356 | 2.20339 | Candidatus Nitrosotenuis chungbukensis | 1353246 | Archaea | Archaea | 156 | 1.68e-33 | NTclustered | gi|2551106379|gb|CP130341.1| | 1353246 | g46426 | i0 | 78.75 | 1.492 | 240 | 45 | 94 | 5 | 15 | 250 | 1182105 | 1181868 | Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome | blastn | 373 | 156 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis chungbukensis | |||||
| 18521671 | 18521671 | PRJNA690124_P_NODE_49995_length_247_cov_0.896552_g49629_i0 | PRJNA690124 | 49995 | 247 | 0.896552 | 2.21448344 | Candidatus Nitrosotenuis sp. DW1 | 2259672 | Archaea | Archaea | 340 | 4.25e-89 | NTclustered | gi|1869227213|gb|CP030846.1| | 2259672 | g49629 | i0 | 91.498 | 2 | 247 | 21 | 100 | 0 | 1 | 247 | 21097 | 21343 | Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome | blastn | 494 | 340 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis sp. DW1 | |||||
| 26797537 | 26797537 | PRJNA690124_P_NODE_47881_length_249_cov_0.886364_g47515_i0 | PRJNA690124 | 47881 | 249 | 0.886364 | 2.20704636 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 169 | 7.05e-50 | NR | HEU5461551.1 | 2169593 | g47515 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 2 | 247 | 164 | 245 | HEU5461551.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 246 | 169 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 27809117 | 27809117 | PRJNA690124_P_NODE_48704_length_248_cov_0.891429_g48338_i0 | PRJNA690124 | 48704 | 248 | 0.891429 | 2.21074392 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 152 | 5.56e-45 | NR | HJY09668.1 | 2169593 | g48338 | i0 | 93.9 | 2.9758064516129 | 82 | 5 | 99.2 | 0 | 247 | 2 | 72 | 153 | HJY09668.1 carboxylating nicotinate-nucleotide diphosphorylase [Nitrososphaeraceae archaeon] | diamond | 738 | 152 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28736055 | 28736055 | PRJNA690124_P_NODE_44527_length_252_cov_0.871508_g44161_i0 | PRJNA690124 | 44527 | 252 | 0.871508 | 2.19620016 | Nitrososphaera | 497726 | Archaea | Archaea | 148 | 1.27e-39 | NR | WP_226987211.1 | 1459637 | g44161 | i0 | 78.3 | 6.91666666666667 | 83 | 18 | 98.8 | 0 | 3 | 251 | 219 | 301 | WP_226987211.1 beta-CASP ribonuclease aCPSF1 [Candidatus Nitrososphaera evergladensis] | diamond | 1743 | 149 | 0.993288590604027 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Candidatus Nitrososphaera evergladensis | ||
| 29367573 | 29367573 | PRJNA690124_P_NODE_54969_length_243_cov_0.917647_g54603_i0 | PRJNA690124 | 54969 | 243 | 0.917647 | 2.22988221 | root | 1 | Root_unresolved | Root_unresolved | 113 | 8.189999999999999e-31 | NR | HET7642346.1 | 2169593 | g54603 | i0 | 68.5 | 1.7037037037037 | 73 | 22 | 90.1 | 1 | 221 | 3 | 1 | 72 | HET7642346.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] | diamond | 414 | 114 | 0.991228070175439 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31030482 | 31030482 | PRJNA690124_P_NODE_44575_length_252_cov_0.871508_g44209_i0 | PRJNA690124 | 44575 | 252 | 0.871508 | 2.19620016 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 161 | 2.28e-49 | NR | HEU5462210.1 | 2169593 | g44209 | i0 | 100 | 0.988095238095238 | 83 | 0 | 98.8 | 0 | 251 | 3 | 26 | 108 | HEU5462210.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 249 | 161 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31124631 | 31124631 | PRJNA690124_P_NODE_43215_length_253_cov_0.866667_g42849_i0 | PRJNA690124 | 43215 | 253 | 0.866667 | 2.19266751 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 43.9 | 0.00389 | NR | MEM2237482.1 | 2972665 | g42849 | i0 | 51.4 | 0.41501976284585 | 35 | 15 | 41.5 | 1 | 33 | 137 | 58 | 90 | MEM2237482.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 105 | 43.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 31378081 | 31378081 | PRJNA690124_P_NODE_56036_length_242_cov_0.923077_g55670_i0 | PRJNA690124 | 56036 | 242 | 0.923077 | 2.23384634 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 175 | 7.1e-52 | NR | MCJ7636817.1 | 2169593 | g55670 | i0 | 98.8 | 2.97520661157025 | 80 | 1 | 99.2 | 0 | 241 | 2 | 74 | 153 | MCJ7636817.1 zinc-binding dehydrogenase [Nitrososphaeraceae archaeon] | diamond | 720 | 175 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;