contig_metadata
12 rows where bioproject = "PRJNA488043" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724475 | 1724475 | PRJNA488043_P_NODE_11282_length_300_cov_6.996310_g9041_i0 | PRJNA488043 | 11282 | 300 | 6.99631 | 20.98893 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 521 | 1.7699999999999996e-143 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g9041 | i0 | 98 | 27.9 | 300 | 6 | 100 | 0 | 1 | 300 | 121161 | 121460 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 8370 | 521 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 11928501 | 11928501 | PRJNA488043_P_NODE_16790_length_205_cov_1.670455_g14548_i0 | PRJNA488043 | 16790 | 205 | 1.670455 | 3.42443275 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 351 | 1.58e-92 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g14548 | i0 | 98.02 | 26.3170731707317 | 202 | 4 | 99 | 0 | 4 | 205 | 740101 | 739900 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 5395 | 351 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 14478581 | 14478581 | PRJNA488043_P_NODE_932_length_1950_cov_4.498178_g148_i2 | PRJNA488043 | 932 | 1950 | 4.498178 | 87.714471 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 2900 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i2 | 93.327 | 18.9164102564103 | 1963 | 112 | 100 | 8 | 1 | 1950 | 1535573 | 1533617 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 36887 | 2900 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 22126267 | 22126267 | PRJNA488043_P_NODE_14018_length_243_cov_1.457944_g11776_i0 | PRJNA488043 | 14018 | 243 | 1.457944 | 3.54280392 | Candidatus Nitrosotenuis cloacae | 1603555 | Archaea | Archaea | 150 | 7.55e-32 | NTclustered | gi|808354332|gb|CP011097.2| | 1603555 | g11776 | i0 | 91.667 | 0.893004115226337 | 108 | 9 | 44 | 0 | 135 | 242 | 704266 | 704159 | Candidatus Nitrosotenuis cloacae strain SAT1, complete genome | blastn | 217 | 150 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis cloacae | |||||
| 24675950 | 24675950 | PRJNA488043_P_NODE_460_length_5141_cov_4.026995_g148_i0 | PRJNA488043 | 460 | 5141 | 4.026995 | 207.02781295 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 3476 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i0 | 92.402 | 9.03948648122933 | 2435 | 148 | 92 | 11 | 2727 | 5141 | 1533156 | 1535573 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 46472 | 3476 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 24676006 | 24676006 | PRJNA488043_P_NODE_900_length_1997_cov_4.404472_g148_i1 | PRJNA488043 | 900 | 1997 | 4.404472 | 87.95730584 | Candidatus Nitrosotenuis aquarius | 1846278 | Archaea | Archaea | 2880 | 0 | NTclustered | gi|1279207014|gb|CP024808.1| | 1846278 | g148 | i1 | 92.587 | 18.528292438658 | 2010 | 120 | 100 | 9 | 1 | 1997 | 1533580 | 1535573 | Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome | blastn | 37001 | 2880 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Nitrosotenuis | Candidatus Nitrosotenuis aquarius | |||||
| 27170970 | 27170970 | PRJNA488043_P_NODE_20482_length_167_cov_1.963768_g18240_i0 | PRJNA488043 | 20482 | 167 | 1.963768 | 3.27949256 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 70.5 | 2.17e-12 | NR | RLI37484.1 | 2026714 | g18240 | i0 | 66 | 1.86826347305389 | 53 | 18 | 95.2 | 0 | 161 | 3 | 170 | 222 | RLI37484.1 MAG: hypothetical protein DRO66_03775 [Candidatus Bathyarchaeota archaeon] | diamond | 312 | 70.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27250395 | 27250395 | PRJNA488043_P_NODE_15243_length_224_cov_2.312821_g13001_i0 | PRJNA488043 | 15243 | 224 | 2.312821 | 5.18071904 | root | 1 | Root_unresolved | Root_unresolved | 71.6 | 6.62e-14 | NR | MDX1532587.1 | 2202732 | g13001 | i0 | 51.4 | 1.94196428571429 | 72 | 35 | 96.4 | 0 | 224 | 9 | 23 | 94 | MDX1532587.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 435 | 71.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 30076222 | 30076222 | PRJNA488043_P_NODE_2112_length_1066_cov_3.185149_g621_i2 | PRJNA488043 | 2112 | 1066 | 3.185149 | 33.95368834 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.83e-5 | NR | MEM2002118.1 | 3058293 | g621 | i2 | 42.2 | 0.180112570356473 | 64 | 35 | 18 | 2 | 882 | 691 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 30613335 | 30613335 | PRJNA488043_P_NODE_20613_length_166_cov_1.518248_g18371_i0 | PRJNA488043 | 20613 | 166 | 1.518248 | 2.52029168 | Nitrosarchaeum koreense | 1088740 | Archaea | Archaea | 52 | 7.25e-6 | NR | WP_007550483.1 | 1088740 | g18371 | i0 | 56.4 | 2.02409638554217 | 55 | 20 | 94 | 3 | 8 | 163 | 516 | 569 | WP_007550483.1 hypothetical protein [Nitrosarchaeum koreense] | diamond | 336 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum koreense | ||
| 31024251 | 31024251 | PRJNA488043_P_NODE_2055_length_1087_cov_3.140832_g621_i1 | PRJNA488043 | 2055 | 1087 | 3.140832 | 34.14084384 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.94e-5 | NR | MEM2002118.1 | 3058293 | g621 | i1 | 42.2 | 0.176632934682613 | 64 | 35 | 17.7 | 2 | 903 | 712 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 31719839 | 31719839 | PRJNA488043_P_NODE_2157_length_1053_cov_3.283203_g621_i3 | PRJNA488043 | 2157 | 1053 | 3.283203 | 34.57212759 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 52.4 | 4.77e-5 | NR | MEM2002118.1 | 3058293 | g621 | i3 | 42.2 | 0.182336182336182 | 64 | 35 | 18.2 | 2 | 864 | 673 | 1 | 62 | MEM2002118.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 192 | 52.4 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae 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);;