contig_metadata
8 rows where bioproject = "PRJNA807685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2498290 | 2498290 | PRJNA807685_P_NODE_27462_length_249_cov_1.943396_g26389_i0 | PRJNA807685 | 27462 | 249 | 1.943396 | 4.83905604 | Haloferax | 2251 | Archaea | Archaea | 165 | 2.77e-36 | NTclustered | gi|1810670185|gb|CP048738.1| | 2246 | g26389 | i0 | 78.884 | 10.714859437751 | 251 | 47 | 99 | 6 | 2 | 249 | 3086364 | 3086611 | Haloferax volcanii strain wsp1 chromosome, complete genome | blastn | 2668 | 165 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 4634901 | 4634901 | PRJNA807685_P_NODE_23644_length_277_cov_2.008333_g22571_i0 | PRJNA807685 | 23644 | 277 | 2.008333 | 5.56308241 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 65.8 | 3.27e-6 | NTclustered | gi|2176093559|gb|CP090371.1| | 2904243 | g22571 | i0 | 91.489 | 0.169675090252708 | 47 | 4 | 17 | 0 | 120 | 166 | 1890922 | 1890876 | Halobaculum sp. CBA1158 chromosome, complete genome | blastn | 47 | 65.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 9734438 | 9734438 | PRJNA807685_P_NODE_16548_length_363_cov_1.153374_g15478_i0 | PRJNA807685 | 16548 | 363 | 1.153374 | 4.18674762 | Haloarcula litorea | 3032579 | Archaea | Archaea | 320 | 8.55e-83 | NTclustered | gi|2463595526|gb|CP119779.1| | 3032579 | g15478 | i0 | 82.967 | 51.3388429752066 | 364 | 52 | 99 | 9 | 1 | 359 | 269393 | 269035 | Haloarcula litorea strain GDY20 chromosome, complete genome | blastn | 18636 | 320 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula litorea | |
| 13560199 | 13560199 | PRJNA807685_P_NODE_37291_length_203_cov_0.909639_g36218_i0 | PRJNA807685 | 37291 | 203 | 0.909639 | 1.84656717 | Natrarchaeobaculum sulfurireducens | 2044521 | Archaea | Archaea | 87.9 | 4.85e-13 | NTclustered | gi|1464915720|gb|CP027033.1| | 2044521 | g36218 | i0 | 87.838 | 0.729064039408867 | 74 | 9 | 36 | 0 | 21 | 94 | 2360195 | 2360122 | Natrarchaeobaculum sulfurireducens strain AArc-Mg chromosome, complete genome | blastn | 148 | 87.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobaculum | Natrarchaeobaculum sulfurireducens | |
| 27718006 | 27718006 | PRJNA807685_P_NODE_63264_length_155_cov_0.957627_g62191_i0 | PRJNA807685 | 63264 | 155 | 0.957627 | 1.48432185 | archaeon GW2 | 1579370 | Archaea | Archaea | 60.8 | 4.52e-9 | NR | AJF59590.1 | 1579370 | g62191 | i0 | 74.3 | 0.67741935483871 | 35 | 9 | 67.7 | 0 | 107 | 3 | 247 | 281 | AJF59590.1 MAG: DNA ligase 1 [archaeon GW2011_AR10] | diamond | 105 | 60.8 | 1 | Archaea | archaeon GW2011_AR10 | ||||||||
| 28096453 | 28096453 | PRJNA807685_P_NODE_14045_length_410_cov_2.774799_g12979_i0 | PRJNA807685 | 14045 | 410 | 2.774799 | 11.3766759 | Euryarchaeota archaeon ADurb.Bin | 2026739 | Archaea | Archaea | 47.8 | 0.00382 | NR | OQC51050.1 | 1852875 | g12979 | i0 | 35.8 | 0.38780487804878 | 53 | 34 | 38.8 | 0 | 126 | 284 | 350 | 402 | OQC51050.1 MAG: CRISPR-associated protein (cas_TM1802) [Euryarchaeota archaeon ADurb.Bin023] | diamond | 159 | 47.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon ADurb.Bin023 | ||||||
| 29674849 | 29674849 | PRJNA807685_P_NODE_59070_length_159_cov_2.532787_g57997_i0 | PRJNA807685 | 59070 | 159 | 2.532787 | 4.02713133 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 45.8 | 9.97e-4 | NR | MDW0252250.1 | 2169593 | g57997 | i0 | 43.5 | 0.867924528301887 | 46 | 26 | 86.8 | 0 | 22 | 159 | 271 | 316 | MDW0252250.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] | diamond | 138 | 45.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31318088 | 31318088 | PRJNA807685_P_NODE_44595_length_183_cov_1.664384_g43522_i0 | PRJNA807685 | 44595 | 183 | 1.664384 | 3.04582272 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 42 | 0.0316 | NR | WP_319373145.1 | 176306 | g43522 | i0 | 41.7 | 0.786885245901639 | 48 | 26 | 78.7 | 1 | 154 | 11 | 8 | 53 | WP_319373145.1 HEAT repeat domain-containing protein [uncultured Methanobacterium sp.] | diamond | 144 | 42 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. |
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);;