contig_metadata
4 rows where bioproject = "PRJNA1046144", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171874 | 171874 | PRJNA1046144_P_NODE_16881_length_393_cov_4.466049_g16586_i0 | PRJNA1046144 | 16881 | 393 | 4.466049 | 17.55157257 | uncultured Desulfobacter sp. | 240139 | Bacteria | Bacteria | 52.8 | 0.038 | NTclustered | gi|2621700914|emb|OY759748.1| | 240139 | g16586 | i0 | 100 | 0.0712468193384224 | 28 | 0 | 7 | 0 | 4 | 31 | 2018910 | 2018937 | MAG: uncultured Desulfobacter sp. isolate d0620cd2-44ed-4ad5-9930-dc425a2a51ce genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | uncultured Desulfobacter sp. | ||
| 172331 | 172331 | PRJNA1046144_P_NODE_41161_length_268_cov_2.170854_g40866_i0 | PRJNA1046144 | 41161 | 268 | 2.170854 | 5.81788872 | Candidatus Desulfofervidus auxilii | 1621989 | Bacteria | Bacteria | 172 | 1.81e-38 | NTclustered | gi|1001906061|gb|CP013015.1| | 1621989 | g40866 | i0 | 80.081 | 302.350746268657 | 246 | 38 | 91 | 6 | 3 | 245 | 267619 | 267856 | Candidatus Desulfofervidus auxilii strain HS1 genome | blastn | 81030 | 172 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Desulfofervidia | Candidatus Desulfofervidales | Candidatus Desulfofervidaceae | Candidatus Desulfofervidus | Candidatus Desulfofervidus auxilii | ||
| 21849355 | 21849355 | PRJNA1046144_P_NODE_48718_length_250_cov_2.298343_g48423_i0 | PRJNA1046144 | 48718 | 250 | 2.298343 | 5.7458575 | Desulfolutivibrio sulfoxidireducens | 2773299 | Bacteria | Bacteria | 63.9 | 1.05e-5 | NTclustered | gi|1863426051|gb|CP045506.1| | 2773299 | g48423 | i0 | 81.25 | 0.992 | 80 | 13 | 32 | 2 | 90 | 168 | 2276787 | 2276709 | Desulfolutivibrio sulfoxidireducens strain DSM 106783 chromosome, complete genome | blastn | 248 | 63.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfolutivibrio | Desulfolutivibrio sulfoxidireducens | ||
| 28077437 | 28077437 | PRJNA1046144_P_NODE_13385_length_438_cov_1.804878_g13090_i0 | PRJNA1046144 | 13385 | 438 | 1.804878 | 7.90536564 | Desulfobulbus sp. | 895 | Bacteria | Bacteria | 78.6 | 7.87e-14 | NR | MDD2467259.1 | 895 | g13090 | i0 | 75 | 1.12328767123288 | 52 | 13 | 35.6 | 0 | 436 | 281 | 359 | 410 | MDD2467259.1 Bcr/CflA family multidrug efflux MFS transporter [Desulfobulbus sp.] | diamond | 492 | 78.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus 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);;