contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA888821" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3413396 | 3413396 | PRJNA888821_P_NODE_18123_length_310_cov_4.308017_g18041_i0 | PRJNA888821 | 18123 | 310 | 4.308017 | 13.3548527 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 150 | 9.98e-32 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g18041 | i0 | 85.034 | 1.34516129032258 | 147 | 22 | 47 | 0 | 163 | 309 | 359110 | 359256 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 417 | 150 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 3793976 | 3793976 | PRJNA888821_P_NODE_50523_length_204_cov_8.137405_g50440_i0 | PRJNA888821 | 50523 | 204 | 8.137405 | 16.6003062 | Chthonomonas | 1077265 | Bacteria | Bacteria | 134 | 6.1800000000000006e-27 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g50440 | i0 | 80.11 | 195.700980392157 | 181 | 34 | 88 | 2 | 26 | 204 | 2808 | 2628 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 39923 | 134 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 13616710 | 13616710 | PRJNA888821_P_NODE_43951_length_225_cov_7.118421_g43868_i0 | PRJNA888821 | 43951 | 225 | 7.118421 | 16.01644725 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 222 | 1.44e-53 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g43868 | i0 | 84.444 | 288.164444444444 | 225 | 35 | 100 | 0 | 1 | 225 | 592646 | 592870 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 64837 | 222 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis | ||
| 17441007 | 17441007 | PRJNA888821_P_NODE_31214_length_264_cov_15.287958_g31131_i0 | PRJNA888821 | 31214 | 264 | 15.287958 | 40.36020912 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 106 | 1.83e-18 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g31131 | i0 | 81.818 | 1.18939393939394 | 132 | 19 | 50 | 5 | 1 | 131 | 2072157 | 2072030 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 314 | 106 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17441102 | 17441102 | PRJNA888821_P_NODE_36294_length_247_cov_11.770115_g36211_i0 | PRJNA888821 | 36294 | 247 | 11.770115 | 29.07218405 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 226 | 1.2399999999999997e-54 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g36211 | i0 | 83.471 | 0.979757085020243 | 242 | 40 | 98 | 0 | 3 | 244 | 2529226 | 2529467 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 242 | 226 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 17819292 | 17819292 | PRJNA888821_P_NODE_22634_length_307_cov_10.025641_g22552_i0 | PRJNA888821 | 22634 | 307 | 10.025641 | 30.77871787 | PVC group | 1783257 | Bacteria | Bacteria | 71.3 | 7.91e-8 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g22552 | i0 | 97.561 | 2.14983713355049 | 41 | 1 | 14 | 0 | 165 | 205 | 2209799 | 2209839 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 660 | 71.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 17819464 | 17819464 | PRJNA888821_P_NODE_38854_length_242_cov_0.911243_g38771_i0 | PRJNA888821 | 38854 | 242 | 0.911243 | 2.20520806 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 375 | 1.14e-99 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g38771 | i0 | 94.65 | 261.669421487603 | 243 | 11 | 100 | 2 | 1 | 242 | 29027 | 28786 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 63324 | 375 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli |
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);;