contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3609113 | 3609113 | PRJNA274362_S_NODE_27043_length_182_cov_1.172932_g26923_i0 | PRJNA274362 | 27043 | 182 | 1.172932 | 2.13473624 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 230 | 6.659999999999998e-56 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g26923 | i0 | 89.56 | 126.263736263736 | 182 | 17 | 100 | 2 | 1 | 182 | 27641 | 27462 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 22980 | 230 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 11849449 | 11849449 | PRJNA274362_S_NODE_36390_length_163_cov_1.368421_g36270_i0 | PRJNA274362 | 36390 | 163 | 1.368421 | 2.23052623 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 252 | 1.25e-62 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g36270 | i0 | 95.031 | 18.5460122699387 | 161 | 6 | 99 | 2 | 1 | 161 | 1877852 | 1878010 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 3023 | 252 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 14399495 | 14399495 | PRJNA274362_S_NODE_20152_length_205_cov_2.352564_g20032_i0 | PRJNA274362 | 20152 | 205 | 2.352564 | 4.8227562 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 241 | 3.56e-59 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g20032 | i0 | 88.177 | 258.180487804878 | 203 | 22 | 99 | 2 | 1 | 203 | 1687590 | 1687790 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 52927 | 241 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 15673120 | 15673120 | PRJNA274362_S_NODE_16833_length_221_cov_1.308140_g16713_i0 | PRJNA274362 | 16833 | 221 | 1.30814 | 2.8909894 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 268 | 1.79e-67 | NTclustered | gi|1199101103|gb|CP021424.1| | 2004468 | g16713 | i0 | 88.688 | 127.325791855204 | 221 | 24 | 100 | 1 | 1 | 221 | 2201298 | 2201517 | Armatimonadetes bacterium Uphvl-Ar2 genome | blastn | 28139 | 268 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 22735335 | 22735335 | PRJNA274362_S_NODE_12258_length_253_cov_1.397059_g12138_i0 | PRJNA274362 | 12258 | 253 | 1.397059 | 3.53455927 | Armatimonadota | 67819 | Bacteria | Bacteria | 303 | 5.74e-78 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g12138 | i0 | 88.538 | 12.4901185770751 | 253 | 25 | 99 | 4 | 1 | 251 | 28894 | 29144 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 3160 | 303 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 22735443 | 22735443 | PRJNA274362_S_NODE_4258_length_403_cov_1.435028_g4138_i0 | PRJNA274362 | 4258 | 403 | 1.435028 | 5.78316284 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 540 | 6.7699999999999996e-149 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g4138 | i0 | 91.228 | 196.114143920596 | 399 | 32 | 99 | 3 | 4 | 401 | 28914 | 28518 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 79034 | 540 | 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);;