contig_metadata
5 rows where bioproject = "PRJNA670521", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23591346 | 23591346 | PRJNA670521_P_NODE_91839_length_241_cov_0.916667_g91094_i0 | PRJNA670521 | 91839 | 241 | 0.916667 | 2.20916747 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 178 | 3.43e-40 | NTclustered | gi|2076447151|gb|CP075366.1| | 2682144 | g91094 | i0 | 80.247 | 261.614107883817 | 243 | 42 | 99 | 6 | 1 | 240 | 896022 | 895783 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM8 chromosome | blastn | 63049 | 178 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28124043 | 28124043 | PRJNA670521_P_NODE_90945_length_242_cov_0.911243_g90200_i0 | PRJNA670521 | 90945 | 242 | 0.911243 | 2.20520806 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 41.6 | 0.0464 | NR | MER3558380.1 | 2033014 | g90200 | i0 | 42.2 | 0.557851239669422 | 45 | 26 | 55.8 | 0 | 10 | 144 | 55 | 99 | MER3558380.1 hypothetical protein [Armatimonadota bacterium] | diamond | 135 | 41.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29733962 | 29733962 | PRJNA670521_P_NODE_28570_length_367_cov_1.309524_g27825_i0 | PRJNA670521 | 28570 | 367 | 1.309524 | 4.80595308 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 69.7 | 3.54e-11 | NR | HUT74329.1 | 2033014 | g27825 | i0 | 48.5 | 0.555858310626703 | 68 | 25 | 55.6 | 1 | 139 | 342 | 1 | 58 | HUT74329.1 ribose-phosphate pyrophosphokinase [Armatimonadota bacterium] | diamond | 204 | 69.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30776920 | 30776920 | PRJNA670521_P_NODE_82174_length_246_cov_0.890173_g81429_i0 | PRJNA670521 | 82174 | 246 | 0.890173 | 2.18982558 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 9.29e-38 | NR | MBC8104568.1 | 2033014 | g81429 | i0 | 76.5 | 1.97560975609756 | 81 | 19 | 98.8 | 0 | 245 | 3 | 5 | 85 | MBC8104568.1 hypothetical protein [Armatimonadota bacterium] | diamond | 486 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30808434 | 30808434 | PRJNA670521_P_NODE_92214_length_241_cov_0.916667_g91469_i0 | PRJNA670521 | 92214 | 241 | 0.916667 | 2.20916747 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 47 | 7.99e-4 | NR | MDX2064719.1 | 2682144 | g91469 | i0 | 39.1 | 0.796680497925311 | 64 | 35 | 78.4 | 2 | 193 | 5 | 21 | 81 | MDX2064719.1 PEP-CTERM sorting domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 192 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium |
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);;