contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12068750 | 12068750 | PRJNA611476_P_NODE_35010_length_354_cov_1.580071_g34219_i0 | PRJNA611476 | 35010 | 354 | 1.580071 | 5.59345134 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 84 | 3.32e-18 | NR | MCC6729695.1 | 2282151 | g34219 | i0 | 50.5 | 1.60169491525424 | 95 | 46 | 80.5 | 1 | 60 | 344 | 14 | 107 | MCC6729695.1 Dabb family protein [Chthonomonadales bacterium] | diamond | 567 | 84 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 23542316 | 23542316 | PRJNA611476_P_NODE_70199_length_266_cov_1.357513_g69408_i0 | PRJNA611476 | 70199 | 266 | 1.357513 | 3.6109845800000002 | root | 1 | Root_unresolved | Root_unresolved | 149 | 4.26e-40 | NR | WP_016481560.1 | 454171 | g69408 | i0 | 79.5 | 16.8496240601504 | 88 | 18 | 99.2 | 0 | 2 | 265 | 449 | 536 | WP_016481560.1 glucose-6-phosphate isomerase [Chthonomonas calidirosea] | diamond | 4482 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 27174847 | 27174847 | PRJNA611476_P_NODE_71762_length_263_cov_1.215789_g70971_i0 | PRJNA611476 | 71762 | 263 | 1.215789 | 3.19752507 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 73.9 | 4.93e-13 | NR | MDQ7850862.1 | 2033014 | g70971 | i0 | 61.8 | 0.627376425855513 | 55 | 21 | 62.7 | 0 | 178 | 14 | 1 | 55 | MDQ7850862.1 hypothetical protein [Armatimonadota bacterium] | diamond | 165 | 73.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27269811 | 27269811 | PRJNA611476_P_NODE_71843_length_263_cov_1.215789_g71052_i0 | PRJNA611476 | 71843 | 263 | 1.215789 | 3.19752507 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 87 | 1.25e-17 | NR | MCL5283481.1 | 2033014 | g71052 | i0 | 55.4 | 0.741444866920152 | 65 | 29 | 74.1 | 0 | 68 | 262 | 675 | 739 | MCL5283481.1 cellulase family glycosylhydrolase [Armatimonadota bacterium] | diamond | 195 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27378009 | 27378009 | PRJNA611476_P_NODE_116843_length_241_cov_0.916667_g116052_i0 | PRJNA611476 | 116843 | 241 | 0.916667 | 2.20916747 | Bacillati | 1783272 | Bacteria | Bacteria | 84.3 | 3.43e-17 | NR | MBM3459046.1 | 2033014 | g116052 | i0 | 61.6 | 4.50622406639004 | 73 | 28 | 90.9 | 0 | 1 | 219 | 252 | 324 | MBM3459046.1 tryptophan--tRNA ligase [Armatimonadota bacterium] | diamond | 1086 | 84.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27396485 | 27396485 | PRJNA611476_P_NODE_86743_length_249_cov_0.875000_g85952_i0 | PRJNA611476 | 86743 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 42.7 | 0.0391 | NR | MBI5831086.1 | 2033014 | g85952 | i0 | 46.7 | 0.542168674698795 | 45 | 24 | 54.2 | 0 | 248 | 114 | 353 | 397 | MBI5831086.1 2-isopropylmalate synthase [Armatimonadota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28785324 | 28785324 | PRJNA611476_P_NODE_21727_length_429_cov_1.839888_g20936_i0 | PRJNA611476 | 21727 | 429 | 1.839888 | 7.89311952 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 97.1 | 1.42e-20 | NR | HSV72461.1 | 2282151 | g20936 | i0 | 43.1 | 2.87412587412587 | 137 | 61 | 93 | 4 | 8 | 406 | 195 | 318 | HSV72461.1 hypothetical protein [Chthonomonadales bacterium] | diamond | 1233 | 97.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 29227802 | 29227802 | PRJNA611476_P_NODE_51449_length_304_cov_1.333333_g50658_i0 | PRJNA611476 | 51449 | 304 | 1.333333 | 4.05333232 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 129 | 2.1999999999999994e-32 | NR | WP_025227446.1 | 1005039 | g50658 | i0 | 59.6 | 0.976973684210526 | 99 | 40 | 97.7 | 0 | 299 | 3 | 297 | 395 | WP_025227446.1 hypothetical protein [Fimbriimonas ginsengisoli] | diamond | 297 | 129 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 29227807 | 29227807 | PRJNA611476_P_NODE_55069_length_295_cov_1.040541_g54278_i0 | PRJNA611476 | 55069 | 295 | 1.040541 | 3.06959595 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 76.6 | 8.74e-14 | NR | MCD6350765.1 | 2033014 | g54278 | i0 | 41.5 | 0.955932203389831 | 94 | 52 | 93.6 | 2 | 277 | 2 | 740 | 832 | MCD6350765.1 discoidin domain-containing protein [Armatimonadota bacterium] | diamond | 282 | 76.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29764166 | 29764166 | PRJNA611476_P_NODE_9991_length_617_cov_0.952206_g9207_i0 | PRJNA611476 | 9991 | 617 | 0.952206 | 5.87511102 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 99.4 | 3.2e-20 | NR | HZT42531.1 | 2739509 | g9207 | i0 | 48.7 | 0.568881685575365 | 117 | 46 | 56.4 | 5 | 362 | 15 | 401 | 504 | HZT42531.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 351 | 99.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30174885 | 30174885 | PRJNA611476_P_NODE_108672_length_243_cov_0.905882_g107881_i0 | PRJNA611476 | 108672 | 243 | 0.905882 | 2.20129326 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 53.9 | 4.31e-6 | NR | MDR3688683.1 | 1936159 | g107881 | i0 | 44.4 | 0.777777777777778 | 63 | 35 | 77.8 | 0 | 242 | 54 | 880 | 942 | MDR3688683.1 DUF4062 domain-containing protein [Fimbriimonas sp.] | diamond | 189 | 53.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30901783 | 30901783 | PRJNA611476_P_NODE_87914_length_249_cov_0.875000_g87123_i0 | PRJNA611476 | 87914 | 249 | 0.875 | 2.17875 | Chthonomonas sp. | 2282153 | Bacteria | Bacteria | 91.3 | 1.32e-21 | NR | MBL8047619.1 | 2282153 | g87123 | i0 | 66.7 | 0.795180722891566 | 66 | 22 | 79.5 | 0 | 247 | 50 | 48 | 113 | MBL8047619.1 hypothetical protein [Chthonomonas sp.] | diamond | 198 | 91.3 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas sp. | ||
| 31692066 | 31692066 | PRJNA611476_P_NODE_53877_length_298_cov_1.026667_g53086_i0 | PRJNA611476 | 53877 | 298 | 1.026667 | 3.05946766 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 89.4 | 2.88e-18 | NR | HZT42531.1 | 2739509 | g53086 | i0 | 42.9 | 0.986577181208054 | 98 | 51 | 98.7 | 2 | 3 | 296 | 164 | 256 | HZT42531.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 294 | 89.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31723598 | 31723598 | PRJNA611476_P_NODE_105597_length_244_cov_0.900585_g104806_i0 | PRJNA611476 | 105597 | 244 | 0.900585 | 2.1974274 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 64.7 | 6.32e-10 | NR | HZT43825.1 | 2739509 | g104806 | i0 | 44 | 1.74590163934426 | 75 | 38 | 87.3 | 3 | 234 | 22 | 41 | 115 | HZT43825.1 GDSL-type esterase/lipase family protein [Chthonomonadaceae bacterium] | diamond | 426 | 64.7 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31755263 | 31755263 | PRJNA611476_P_NODE_118517_length_240_cov_2.119760_g117726_i0 | PRJNA611476 | 118517 | 240 | 2.11976 | 5.087424 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.6 | 8.53e-15 | NR | HEY3267294.1 | 2033014 | g117726 | i0 | 48 | 1.85 | 75 | 39 | 93.8 | 0 | 15 | 239 | 102 | 176 | HEY3267294.1 DUF5127 domain-containing protein [Armatimonadota bacterium] | diamond | 444 | 78.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32293570 | 32293570 | PRJNA611476_P_NODE_36559_length_348_cov_1.956364_g35768_i0 | PRJNA611476 | 36559 | 348 | 1.956364 | 6.80814672 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 76.3 | 2.01e-13 | NR | MCW3096097.1 | 2739509 | g35768 | i0 | 63 | 0.991379310344828 | 54 | 20 | 46.6 | 0 | 157 | 318 | 27 | 80 | MCW3096097.1 hypothetical protein [Chthonomonadaceae bacterium] | diamond | 345 | 76.3 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 32293612 | 32293612 | PRJNA611476_P_NODE_81539_length_250_cov_1.734463_g80748_i0 | PRJNA611476 | 81539 | 250 | 1.734463 | 4.3361575 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 43.1 | 0.0282 | NR | HEY3283252.1 | 2033014 | g80748 | i0 | 38.3 | 0.72 | 60 | 33 | 72 | 1 | 3 | 182 | 165 | 220 | HEY3283252.1 S41 family peptidase [Armatimonadota bacterium] | diamond | 180 | 43.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;