contig_metadata
16 rows where bioproject = "PRJNA1182301" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4145600 | 4145600 | PRJNA1182301_P_NODE_40684_length_261_cov_1.638298_g40559_i0 | PRJNA1182301 | 40684 | 261 | 1.638298 | 4.27595778 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 121 | 7.38e-30 | NR | NLC57851.1 | 2033014 | g40559 | i0 | 66.3 | 0.988505747126437 | 86 | 29 | 98.9 | 0 | 2 | 259 | 485 | 570 | NLC57851.1 hypothetical protein [Armatimonadota bacterium] | diamond | 258 | 121 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 13072563 | 13072563 | PRJNA1182301_P_NODE_53571_length_248_cov_0.880000_g53446_i0 | PRJNA1182301 | 53571 | 248 | 0.88 | 2.1824 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 111 | 5.279999999999999e-28 | NR | MCW3099777.1 | 2739509 | g53446 | i0 | 59.8 | 1.98387096774194 | 82 | 33 | 99.2 | 0 | 247 | 2 | 99 | 180 | MCW3099777.1 metal dependent phosphohydrolase [Chthonomonadaceae bacterium] | diamond | 492 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 15621241 | 15621241 | PRJNA1182301_P_NODE_30733_length_274_cov_1.532338_g30608_i0 | PRJNA1182301 | 30733 | 274 | 1.532338 | 4.19860612 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 80.9 | 1.96e-15 | NR | HHX42331.1 | 2033014 | g30608 | i0 | 47.5 | 1.08394160583942 | 99 | 41 | 96.4 | 3 | 7 | 270 | 90 | 188 | HHX42331.1 transposase [Armatimonadota bacterium] | diamond | 297 | 80.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28051340 | 28051340 | PRJNA1182301_P_NODE_42685_length_258_cov_2.432432_g42560_i0 | PRJNA1182301 | 42685 | 258 | 2.432432 | 6.27567456 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 100 | 1.8e-23 | NR | HTE18293.1 | 2033014 | g42560 | i0 | 70 | 1.67441860465116 | 70 | 20 | 81.4 | 1 | 3 | 212 | 183 | 251 | HTE18293.1 MBL fold metallo-hydrolase [Armatimonadota bacterium] | diamond | 432 | 100 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28588310 | 28588310 | PRJNA1182301_P_NODE_43847_length_257_cov_1.673913_g43722_i0 | PRJNA1182301 | 43847 | 257 | 1.673913 | 4.30195641 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.4 | 1.79e-5 | NR | HEY3281767.1 | 2033014 | g43722 | i0 | 35.6 | 0.852140077821012 | 73 | 46 | 84 | 1 | 222 | 7 | 96 | 168 | HEY3281767.1 carboxypeptidase regulatory-like domain-containing protein [Armatimonadota bacterium] | diamond | 219 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28777462 | 28777462 | PRJNA1182301_P_NODE_46587_length_253_cov_2.261111_g46462_i0 | PRJNA1182301 | 46587 | 253 | 2.261111 | 5.72061083 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 125 | 1.06e-33 | NR | MFN3650927.1 | 2033014 | g46462 | i0 | 69 | 0.99604743083004 | 84 | 26 | 99.6 | 0 | 252 | 1 | 26 | 109 | MFN3650927.1 Crp/Fnr family transcriptional regulator [Armatimonadota bacterium] | diamond | 252 | 125 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28796477 | 28796477 | PRJNA1182301_P_NODE_27687_length_278_cov_1.878049_g27562_i0 | PRJNA1182301 | 27687 | 278 | 1.878049 | 5.22097622 | Bacteria | 2 | Bacteria | Bacteria | 100 | 1.55e-23 | NR | NLI01070.1 | 2282151 | g27562 | i0 | 87.3 | 4.89928057553957 | 63 | 8 | 68 | 0 | 219 | 31 | 3 | 65 | NLI01070.1 DUF1559 domain-containing protein [Chthonomonadales bacterium] | diamond | 1362 | 101 | 0.99009900990099 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 28967142 | 28967142 | PRJNA1182301_P_NODE_22108_length_286_cov_1.417840_g21983_i0 | PRJNA1182301 | 22108 | 286 | 1.41784 | 4.0550224 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 125 | 1.23e-33 | NR | MBI3722288.1 | 1005039 | g21983 | i0 | 66 | 2.95804195804196 | 94 | 32 | 98.6 | 0 | 284 | 3 | 61 | 154 | MBI3722288.1 hypothetical protein [Fimbriimonas ginsengisoli] | diamond | 846 | 125 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 29219748 | 29219748 | PRJNA1182301_P_NODE_45589_length_254_cov_3.751381_g45464_i0 | PRJNA1182301 | 45589 | 254 | 3.751381 | 9.52850774 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 134 | 1.3e-35 | NR | MBC8135387.1 | 2033014 | g45464 | i0 | 84.5 | 0.992125984251969 | 84 | 13 | 99.2 | 0 | 253 | 2 | 126 | 209 | MBC8135387.1 HEAT repeat domain-containing protein [Armatimonadota bacterium] | diamond | 252 | 134 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29535329 | 29535329 | PRJNA1182301_P_NODE_46010_length_254_cov_1.701657_g45885_i0 | PRJNA1182301 | 46010 | 254 | 1.701657 | 4.32220878 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 110 | 4.63e-26 | NR | HLK60049.1 | 2739509 | g45885 | i0 | 64.3 | 3.96850393700787 | 84 | 30 | 99.2 | 0 | 1 | 252 | 33 | 116 | HLK60049.1 tetratricopeptide repeat protein [Chthonomonadaceae bacterium] | diamond | 1008 | 110 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30439124 | 30439124 | PRJNA1182301_P_NODE_57473_length_245_cov_0.895349_g57348_i0 | PRJNA1182301 | 57473 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 65.1 | 4.64e-10 | NR | MDQ3814043.1 | 2033014 | g57348 | i0 | 47 | 1.56734693877551 | 66 | 35 | 80.8 | 0 | 48 | 245 | 10 | 75 | MDQ3814043.1 GntR family transcriptional regulator [Armatimonadota bacterium] | diamond | 384 | 65.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31336072 | 31336072 | PRJNA1182301_P_NODE_61416_length_242_cov_1.591716_g61291_i0 | PRJNA1182301 | 61416 | 242 | 1.591716 | 3.85195272 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 130 | 7.04e-33 | NR | MBI3910514.1 | 2033014 | g61291 | i0 | 81.3 | 2.97520661157025 | 80 | 15 | 99.2 | 0 | 240 | 1 | 1376 | 1455 | MBI3910514.1 FtsX-like permease family protein [Armatimonadota bacterium] | diamond | 720 | 130 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31462927 | 31462927 | PRJNA1182301_P_NODE_59676_length_243_cov_2.264706_g59551_i0 | PRJNA1182301 | 59676 | 243 | 2.264706 | 5.50323558 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.5 | 1.73e-14 | NR | HEY3281305.1 | 2033014 | g59551 | i0 | 55.4 | 1.82716049382716 | 74 | 33 | 91.4 | 0 | 22 | 243 | 1 | 74 | HEY3281305.1 hypothetical protein [Armatimonadota bacterium] | diamond | 444 | 75.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31557815 | 31557815 | PRJNA1182301_P_NODE_26656_length_280_cov_1.096618_g26531_i0 | PRJNA1182301 | 26656 | 280 | 1.096618 | 3.0705304 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.4 | 0.0038 | NR | MBW3624845.1 | 2033014 | g26531 | i0 | 65.6 | 0.342857142857143 | 32 | 10 | 34.3 | 1 | 3 | 98 | 54 | 84 | MBW3624845.1 NHL repeat-containing protein [Armatimonadota bacterium] | diamond | 96 | 45.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32114673 | 32114673 | PRJNA1182301_P_NODE_58998_length_244_cov_0.900585_g58873_i0 | PRJNA1182301 | 58998 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 99 | 6.1000000000000005e-22 | NR | MDQ3814842.1 | 2033014 | g58873 | i0 | 66.2 | 2.37295081967213 | 65 | 22 | 79.9 | 0 | 50 | 244 | 122 | 186 | MDQ3814842.1 CRTAC1 family protein [Armatimonadota bacterium] | diamond | 579 | 99 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32853287 | 32853287 | PRJNA1182301_P_NODE_46220_length_254_cov_1.447514_g46095_i0 | PRJNA1182301 | 46220 | 254 | 1.447514 | 3.67668556 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 138 | 5.899999999999999e-36 | NR | MBI3910412.1 | 2033014 | g46095 | i0 | 75 | 0.992125984251969 | 84 | 21 | 99.2 | 0 | 3 | 254 | 316 | 399 | MBI3910412.1 GAF domain-containing protein [Armatimonadota bacterium] | diamond | 252 | 138 | 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);;