contig_metadata
16 rows where bioproject = "PRJNA1020854", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1435641 | 1435641 | PRJNA1020854_S_NODE_21522_length_234_cov_2522.087805_g18758_i0 | PRJNA1020854 | 21522 | 234 | 2522.087805 | 5901.6854637 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 114 | 8.249999999999998e-30 | NR | GIV12342.1 | 2682145 | g18758 | i0 | 98.3 | 0.756410256410256 | 59 | 1 | 75.6 | 0 | 179 | 3 | 18 | 76 | GIV12342.1 MAG: hypothetical protein KatS3mg021_0624 [Fimbriimonadales bacterium] | diamond | 177 | 114 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 2711060 | 2711060 | PRJNA1020854_S_NODE_14883_length_304_cov_5.385455_g12119_i0 | PRJNA1020854 | 14883 | 304 | 5.385455 | 16.3717832 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 167 | 8.87e-49 | NR | GIV11757.1 | 2682145 | g12119 | i0 | 98.8 | 0.848684210526316 | 86 | 1 | 84.9 | 0 | 45 | 302 | 195 | 280 | GIV11757.1 MAG: hypothetical protein KatS3mg021_0039 [Fimbriimonadales bacterium] | diamond | 258 | 167 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 3553774 | 3553774 | PRJNA1020854_S_NODE_23883_length_219_cov_4.363158_g21119_i0 | PRJNA1020854 | 23883 | 219 | 4.363158 | 9.55531602 | Armatimonadetes bacterium JP3_11 | 2012635 | Bacteria | Bacteria | 96.7 | 2.29e-21 | NR | OYT74718.1 | 2012635 | g21119 | i0 | 69.9 | 1 | 73 | 21 | 98.6 | 1 | 218 | 3 | 388 | 460 | OYT74718.1 MAG: hypothetical protein CFK49_07000 [Armatimonadetes bacterium JP3_11] | diamond | 219 | 96.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium JP3_11 | ||||||
| 3987911 | 3987911 | PRJNA1020854_S_NODE_6724_length_625_cov_1733.033557_g4174_i0 | PRJNA1020854 | 6724 | 625 | 1733.033557 | 10831.45973125 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 313 | 2.58e-80 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g4174 | i0 | 83.68 | 137.328 | 337 | 50 | 53 | 5 | 229 | 562 | 2615333 | 2615667 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 85830 | 313 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 16737630 | 16737630 | PRJNA1020854_S_NODE_13834_length_321_cov_6.335616_g11070_i0 | PRJNA1020854 | 13834 | 321 | 6.335616 | 20.33732736 | Armatimonadetes bacterium DC | 1661583 | Bacteria | Bacteria | 191 | 1.81e-59 | NR | CUU34319.1 | 1661583 | g11070 | i0 | 80.2 | 2.85046728971963 | 106 | 20 | 98.1 | 1 | 1 | 315 | 26 | 131 | CUU34319.1 RHS repeat-associated core domain-containing protein [Armatimonadetes bacterium DC] | diamond | 915 | 191 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium DC | ||||||
| 16737787 | 16737787 | PRJNA1020854_S_NODE_20734_length_241_cov_3.108491_g17970_i0 | PRJNA1020854 | 20734 | 241 | 3.108491 | 7.49146331 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 78.7 | 3.58e-10 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g17970 | i0 | 81.915 | 0.975103734439834 | 94 | 15 | 39 | 2 | 149 | 241 | 333819 | 333727 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 235 | 78.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 18013131 | 18013131 | PRJNA1020854_S_NODE_6875_length_608_cov_918.170984_g4307_i0 | PRJNA1020854 | 6875 | 608 | 918.170984 | 5582.47958272 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 344 | 1.04e-115 | NR | MCL6532605.1 | 2033014 | g4307 | i0 | 92.9 | 0.898026315789474 | 182 | 13 | 89.8 | 0 | 15 | 560 | 82 | 263 | MCL6532605.1 PEP-CTERM sorting domain-containing protein [Armatimonadota bacterium] | diamond | 546 | 344 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 20561750 | 20561750 | PRJNA1020854_S_NODE_10477_length_399_cov_5.354054_g7736_i0 | PRJNA1020854 | 10477 | 399 | 5.354054 | 21.36267546 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 272 | 2.6999999999999993e-68 | NTclustered | gi|2314715370|dbj|AP024673.1| | 2682145 | g7736 | i0 | 79.31 | 1.01754385964912 | 406 | 71 | 100 | 10 | 1 | 399 | 1434263 | 1433864 | MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome | blastn | 406 | 272 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 27919266 | 27919266 | PRJNA1020854_S_NODE_34565_length_172_cov_4.013986_g31801_i0 | PRJNA1020854 | 34565 | 172 | 4.013986 | 6.90405592 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 46.2 | 1.14e-4 | NR | MCX7688361.1 | 2682145 | g31801 | i0 | 75.9 | 0.505813953488372 | 29 | 7 | 50.6 | 0 | 157 | 71 | 31 | 59 | MCX7688361.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 87 | 46.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 28392943 | 28392943 | PRJNA1020854_S_NODE_34986_length_171_cov_2.950704_g32222_i0 | PRJNA1020854 | 34986 | 171 | 2.950704 | 5.04570384 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 116 | 2.17e-30 | NR | MCL6534018.1 | 2033014 | g32222 | i0 | 94.7 | 1 | 57 | 3 | 100 | 0 | 1 | 171 | 24 | 80 | MCL6534018.1 DUF1559 domain-containing protein [Armatimonadota bacterium] | diamond | 171 | 116 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29024800 | 29024800 | PRJNA1020854_S_NODE_21448_length_235_cov_3.635922_g18684_i0 | PRJNA1020854 | 21448 | 235 | 3.635922 | 8.5444167 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 144 | 7.08e-42 | NR | MCL6532453.1 | 2033014 | g18684 | i0 | 100 | 0.868085106382979 | 68 | 0 | 86.8 | 0 | 2 | 205 | 110 | 177 | MCL6532453.1 rRNA maturation RNase YbeY [Armatimonadota bacterium] | diamond | 204 | 144 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29371805 | 29371805 | PRJNA1020854_S_NODE_33389_length_176_cov_3.986395_g30625_i0 | PRJNA1020854 | 33389 | 176 | 3.986395 | 7.0160552 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 69.3 | 9.48e-13 | NR | HLK58200.1 | 2739509 | g30625 | i0 | 68 | 5.16477272727273 | 50 | 16 | 85.2 | 0 | 25 | 174 | 7 | 56 | HLK58200.1 ATP-dependent protease subunit HslV [Chthonomonadaceae bacterium] | diamond | 909 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 29529699 | 29529699 | PRJNA1020854_S_NODE_7670_length_538_cov_4.161100_g5039_i0 | PRJNA1020854 | 7670 | 538 | 4.1611 | 22.386718 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 145 | 2.8299999999999993e-40 | NR | MEJ5294877.1 | 2682145 | g5039 | i0 | 97.6 | 0.468401486988848 | 84 | 2 | 46.8 | 0 | 263 | 514 | 1 | 84 | MEJ5294877.1 Ig-like domain-containing protein [Fimbriimonadales bacterium] | diamond | 252 | 145 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29592366 | 29592366 | PRJNA1020854_S_NODE_19990_length_247_cov_2.706422_g17226_i0 | PRJNA1020854 | 19990 | 247 | 2.706422 | 6.68486234 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 149 | 1.26e-43 | NR | MCL6532453.1 | 2033014 | g17226 | i0 | 98.6 | 0.898785425101215 | 74 | 1 | 89.9 | 0 | 26 | 247 | 30 | 103 | MCL6532453.1 rRNA maturation RNase YbeY [Armatimonadota bacterium] | diamond | 222 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30698355 | 30698355 | PRJNA1020854_S_NODE_6354_length_676_cov_5.780526_g3858_i0 | PRJNA1020854 | 6354 | 676 | 5.780526 | 39.07635576 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 157 | 4.4499999999999985e-43 | NR | MCL6532002.1 | 2033014 | g3858 | i0 | 95.2 | 0.727810650887574 | 83 | 4 | 36.8 | 0 | 29 | 277 | 223 | 305 | MCL6532002.1 quinate 5-dehydrogenase [Armatimonadota bacterium] | diamond | 492 | 157 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31804817 | 31804817 | PRJNA1020854_S_NODE_41017_length_155_cov_2.968254_g38253_i0 | PRJNA1020854 | 41017 | 155 | 2.968254 | 4.6007937 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 89.4 | 2.78e-19 | NR | MCW3097388.1 | 2739509 | g38253 | i0 | 82 | 0.967741935483871 | 50 | 9 | 96.8 | 0 | 3 | 152 | 190 | 239 | MCW3097388.1 putative lipoprotein [Chthonomonadaceae bacterium] | diamond | 150 | 89.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae 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);;