contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA488043" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1098051 | 1098051 | PRJNA488043_P_NODE_9281_length_364_cov_1.973134_g7052_i0 | PRJNA488043 | 9281 | 364 | 1.973134 | 7.18220776 | root | 1 | Root_unresolved | Root_unresolved | 76.8 | 2.05e-9 | NTclustered | gi|268322253|emb|FM868132.1| | 115547 | g7052 | i0 | 92.593 | 14.5824175824176 | 54 | 3 | 15 | 1 | 262 | 315 | 347 | 399 | Uncultured archaeon partial 16S rRNA gene, clone HA7-ARCH-C77 | blastn | 5308 | 76.8 | 1 | Archaea | uncultured archaeon | ||||||||
| 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 | |||||
| 8102935 | 8102935 | PRJNA488043_P_NODE_17407_length_198_cov_2.136095_g15165_i0 | PRJNA488043 | 17407 | 198 | 2.136095 | 4.2294681 | Methanosarcina thermophila | 2210 | Archaea | Archaea | 54.7 | 0.005 | NTclustered | gi|805329805|gb|CP009501.1| | 523844 | g15165 | i0 | 94.444 | 0.747474747474748 | 36 | 0 | 17 | 2 | 165 | 198 | 2419746 | 2419781 | Methanosarcina thermophila TM-1, complete genome | blastn | 148 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina thermophila | |
| 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 |
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);;