contig_metadata
5 rows where bioproject = "PRJNA509429" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8138284 | 8138284 | PRJNA509429_P_NODE_2167_length_947_cov_1.706140_g1743_i0 | PRJNA509429 | 2167 | 947 | 1.70614 | 16.1571458 | Thermococcus | 2263 | Archaea | Archaea | 620 | 3.58e-205 | NR | WP_167728776.1 | 163002 | g1743 | i0 | 98.4 | 4.97360084477297 | 314 | 5 | 99.5 | 0 | 943 | 2 | 1 | 314 | WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3] | diamond | 4710 | 620 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9N3 | ||
| 8138397 | 8138397 | PRJNA509429_P_NODE_51907_length_150_cov_1.008696_g51079_i0 | PRJNA509429 | 51907 | 150 | 1.008696 | 1.513044 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 267 | 4.009999999999999e-67 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g51079 | i0 | 98.667 | 180.72 | 150 | 2 | 100 | 0 | 1 | 150 | 130948 | 131097 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 27108 | 267 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 12589690 | 12589690 | PRJNA509429_P_NODE_13390_length_389_cov_2.415254_g12567_i0 | PRJNA509429 | 13390 | 389 | 2.415254 | 9.39533806 | Thermococcus | 2263 | Archaea | Archaea | 205 | 1.5e-59 | NR | MEO2152736.1 | 35749 | g12567 | i0 | 97.1 | 11.7917737789203 | 103 | 3 | 79.4 | 0 | 1 | 309 | 628 | 730 | MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.] | diamond | 4587 | 205 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. | ||
| 31531105 | 31531105 | PRJNA509429_P_NODE_8976_length_486_cov_1.436807_g8168_i0 | PRJNA509429 | 8976 | 486 | 1.436807 | 6.98288202 | Thermococcus henrietii | 2016361 | Archaea | Archaea | 314 | 1.5099999999999996e-96 | NR | WP_099209949.1 | 2016361 | g8168 | i0 | 96.9 | 6.92592592592593 | 160 | 5 | 98.8 | 0 | 482 | 3 | 1028 | 1187 | WP_099209949.1 DNA polymerase domain-containing protein [Thermococcus henrietii] | diamond | 3366 | 314 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus henrietii | ||
| 32179195 | 32179195 | PRJNA509429_P_NODE_14098_length_378_cov_2.032070_g13274_i0 | PRJNA509429 | 14098 | 378 | 2.03207 | 7.6812246 | Thermococcus | 2263 | Archaea | Archaea | 248 | 5.4e-76 | NR | MEO2151751.1 | 35749 | g13274 | i0 | 96 | 8.96031746031746 | 126 | 5 | 100 | 0 | 1 | 378 | 136 | 261 | MEO2151751.1 DNA polymerase domain-containing protein [Thermococcus sp.] | diamond | 3387 | 249 | 0.995983935742972 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus 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);;