contig_metadata
4 rows where bioproject = "PRJEB20058" and tax_phylum = "Atribacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25653879 | 25653879 | PRJEB20058_P_NODE_221586_length_241_cov_7.822222_g218761_i0 | PRJEB20058 | 221586 | 241 | 7.822222 | 18.85155502 | Atribacter laminatus | 2847778 | Bacteria | Bacteria | 219 | 2.02e-52 | NTclustered | gi|1940086973|gb|CP065383.1| | 2847778 | g218761 | i0 | 84.862 | 0.904564315352697 | 218 | 31 | 90 | 2 | 25 | 241 | 2445336 | 2445552 | Atribacter laminatus strain RT761 chromosome, complete genome | blastn | 218 | 219 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Atribacterales | Atribacteraceae | Atribacter | Atribacter laminatus | ||
| 25922620 | 25922620 | PRJEB20058_P_NODE_136092_length_335_cov_3.864964_g133272_i0 | PRJEB20058 | 136092 | 335 | 3.864964 | 12.9476294 | Atribacter laminatus | 2847778 | Bacteria | Bacteria | 307 | 6.11e-79 | NTclustered | gi|1940086973|gb|CP065383.1| | 2847778 | g133272 | i0 | 86.395 | 6.06865671641791 | 294 | 24 | 87 | 9 | 7 | 298 | 2421831 | 2422110 | Atribacter laminatus strain RT761 chromosome, complete genome | blastn | 2033 | 307 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Atribacterales | Atribacteraceae | Atribacter | Atribacter laminatus | ||
| 25928780 | 25928780 | PRJEB20058_P_NODE_54460_length_569_cov_24.990157_g51716_i0 | PRJEB20058 | 54460 | 569 | 24.990157 | 142.19399333 | uncultured Atribacterota bacterium | 263865 | Bacteria | Bacteria | 252 | 5.16e-62 | NTclustered | gi|306490911|gb|GU180083.1| | 263865 | g51716 | i0 | 84.47 | 305.862917398946 | 264 | 31 | 46 | 9 | 43 | 301 | 12485 | 12227 | Uncultured candidate division JS1 bacterium clone fosmid vNS2B_16C12 genomic sequence | blastn | 174036 | 252 | 1 | Bacteria | Pseudomonadati | Atribacterota | uncultured Atribacterota bacterium | ||||||
| 26329819 | 26329819 | PRJEB20058_P_NODE_117119_length_370_cov_2.433657_g114304_i0 | PRJEB20058 | 117119 | 370 | 2.433657 | 9.0045309 | Atribacter laminatus | 2847778 | Bacteria | Bacteria | 499 | 1.04e-136 | NTclustered | gi|1940086973|gb|CP065383.1| | 2847778 | g114304 | i0 | 92.529 | 0.940540540540541 | 348 | 26 | 94 | 0 | 18 | 365 | 336682 | 336335 | Atribacter laminatus strain RT761 chromosome, complete genome | blastn | 348 | 499 | 1 | Bacteria | Pseudomonadati | Atribacterota | Atribacteria | Atribacterales | Atribacteraceae | Atribacter | Atribacter laminatus |
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);;