contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA773247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4577411 | 4577411 | PRJNA773247_P_NODE_8524_length_552_cov_28.895616_g8441_i0 | PRJNA773247 | 8524 | 552 | 28.895616 | 159.50380032 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 89.8 | 4.14e-13 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g8441 | i0 | 96.364 | 0.521739130434783 | 55 | 1 | 10 | 1 | 156 | 210 | 1616886 | 1616833 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 288 | 89.8 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 5852366 | 5852366 | PRJNA773247_P_NODE_2085_length_1385_cov_4.661585_g2041_i0 | PRJNA773247 | 2085 | 1385 | 4.661585 | 64.56295225 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 1129 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g2041 | i0 | 82.353 | 94.142238267148 | 1309 | 222 | 94 | 8 | 75 | 1379 | 4573824 | 4575127 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 130387 | 1129 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 5852718 | 5852718 | PRJNA773247_P_NODE_8005_length_576_cov_16.817097_g7922_i0 | PRJNA773247 | 8005 | 576 | 16.817097 | 96.86647872 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 366 | 1.7899999999999994e-96 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g7922 | i0 | 78.881 | 60.4270833333333 | 554 | 107 | 95 | 9 | 11 | 559 | 553970 | 554518 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 34806 | 366 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 9677386 | 9677386 | PRJNA773247_P_NODE_26628_length_270_cov_2.538071_g26544_i0 | PRJNA773247 | 26628 | 270 | 2.538071 | 6.8527917 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 167 | 8.47e-37 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g26544 | i0 | 78.417 | 1.02962962962963 | 278 | 44 | 100 | 12 | 1 | 270 | 637136 | 637405 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 278 | 167 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 9677551 | 9677551 | PRJNA773247_P_NODE_508_length_2505_cov_11.299342_g497_i0 | PRJNA773247 | 508 | 2505 | 11.299342 | 283.0485171 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 1088 | 0 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g497 | i0 | 78.331 | 1.03193612774451 | 1726 | 345 | 68 | 24 | 734 | 2448 | 4958162 | 4959869 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 2585 | 1088 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 13502541 | 13502541 | PRJNA773247_P_NODE_20811_length_313_cov_3.058333_g20727_i0 | PRJNA773247 | 20811 | 313 | 3.058333 | 9.57258229 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 202 | 2.7499999999999996e-47 | NTclustered | gi|2778022393|emb|OZ123194.1| | 1936159 | g20727 | i0 | 81.967 | 44.3194888178914 | 244 | 38 | 77 | 5 | 1 | 241 | 343428 | 343188 | MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 | blastn | 13872 | 202 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 15235490 | 15235490 | PRJNA773247_P_NODE_20032_length_320_cov_4.060729_g19948_i0 | PRJNA773247 | 20032 | 320 | 4.060729 | 12.9943328 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 141 | 6.23e-29 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g19948 | i0 | 90.654 | 15.078125 | 107 | 8 | 38 | 2 | 206 | 311 | 724235 | 724130 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 4825 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 16051620 | 16051620 | PRJNA773247_P_NODE_4313_length_886_cov_6.004920_g4240_i0 | PRJNA773247 | 4313 | 886 | 6.00492 | 53.2035912 | Armatimonadetes bacterium Uphvl-Ar2 | 2004468 | Bacteria | Bacteria | 213 | 3.87e-50 | NTclustered | gi|1199101103|gb|CP021424.1| | 2004468 | g4240 | i0 | 76.601 | 2.65011286681716 | 406 | 83 | 45 | 11 | 284 | 683 | 994227 | 994626 | Armatimonadetes bacterium Uphvl-Ar2 genome | blastn | 2348 | 213 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium Uphvl-Ar2 | ||||||
| 22426123 | 22426123 | PRJNA773247_P_NODE_19678_length_324_cov_2.430279_g19594_i0 | PRJNA773247 | 19678 | 324 | 2.430279 | 7.87410396 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 130 | 1.37e-25 | NTclustered | gi|2076452338|gb|CP075364.1| | 2682144 | g19594 | i0 | 93.182 | 11.2098765432099 | 88 | 6 | 31 | 0 | 115 | 202 | 386815 | 386902 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome | blastn | 3632 | 130 | 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);;