contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2137353 | 2137353 | PRJNA886442_P_NODE_1902_length_501_cov_2.773364_g1738_i0 | PRJNA886442 | 1902 | 501 | 2.773364 | 13.89455364 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 206 | 6.440000000000001e-64 | NR | MDZ4801135.1 | 2212468 | g1738 | i0 | 86.9 | 1.2814371257485 | 107 | 14 | 64.1 | 0 | 181 | 501 | 5 | 111 | MDZ4801135.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Bryobacteraceae bacterium] | diamond | 642 | 206 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 21263891 | 21263891 | PRJNA886442_P_NODE_3057_length_408_cov_1.241791_g2893_i0 | PRJNA886442 | 3057 | 408 | 1.241791 | 5.06650728 | FCB group | 1783270 | Bacteria | Bacteria | 153 | 4.99e-40 | NR | MDQ3040800.1 | 1978231 | g2893 | i0 | 88.8 | 41.4852941176471 | 89 | 10 | 65.4 | 0 | 2 | 268 | 820 | 908 | MDQ3040800.1 heavy metal translocating P-type ATPase [Acidobacteriota bacterium] | diamond | 16926 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 24192967 | 24192967 | PRJNA886442_P_NODE_13879_length_245_cov_0.906977_g13715_i0 | PRJNA886442 | 13879 | 245 | 0.906977 | 2.22209365 | Granulicella | 940557 | Bacteria | Bacteria | 125 | 8.73e-33 | NR | WP_263378038.1 | 474951 | g13715 | i0 | 79 | 1.98367346938776 | 81 | 17 | 99.2 | 0 | 2 | 244 | 142 | 222 | WP_263378038.1 ABC transporter ATP-binding protein [Granulicella paludicola] | diamond | 486 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella paludicola | ||
| 26802199 | 26802199 | PRJNA886442_P_NODE_7781_length_286_cov_1.093897_g7617_i0 | PRJNA886442 | 7781 | 286 | 1.093897 | 3.12854542 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 159 | 9.54e-43 | NR | HWI20223.1 | 2910147 | g7617 | i0 | 78.5 | 0.975524475524476 | 93 | 20 | 97.6 | 0 | 3 | 281 | 929 | 1021 | HWI20223.1 TonB-dependent receptor [Vicinamibacterales bacterium] | diamond | 279 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27118432 | 27118432 | PRJNA886442_P_NODE_14102_length_244_cov_0.912281_g13938_i0 | PRJNA886442 | 14102 | 244 | 0.912281 | 2.22596564 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 145 | 4.33e-39 | NR | HEY0161240.1 | 1934404 | g13938 | i0 | 92.6 | 0.995901639344262 | 81 | 6 | 99.6 | 0 | 1 | 243 | 33 | 113 | HEY0161240.1 polysaccharide biosynthesis C-terminal domain-containing protein [Edaphobacter sp.] | diamond | 243 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 27497934 | 27497934 | PRJNA886442_P_NODE_13383_length_246_cov_0.901734_g13219_i0 | PRJNA886442 | 13383 | 246 | 0.901734 | 2.21826564 | Terriglobus sp. | 1889013 | Bacteria | Bacteria | 131 | 4.429999999999999e-35 | NR | HEY9137136.1 | 1889013 | g13219 | i0 | 98.5 | 0.817073170731707 | 67 | 1 | 81.7 | 0 | 44 | 244 | 1 | 67 | HEY9137136.1 ABC transporter ATP-binding protein [Terriglobus sp.] | diamond | 201 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus sp. | ||
| 27624330 | 27624330 | PRJNA886442_P_NODE_7104_length_296_cov_1.748879_g6940_i0 | PRJNA886442 | 7104 | 296 | 1.748879 | 5.17668184 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 65.9 | 2.33e-11 | NR | HEV8318110.1 | 2910147 | g6940 | i0 | 51.6 | 1.83445945945946 | 62 | 25 | 59.8 | 2 | 294 | 118 | 23 | 82 | HEV8318110.1 RNA-binding protein [Vicinamibacterales bacterium] | diamond | 543 | 65.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28894851 | 28894851 | PRJNA886442_P_NODE_12208_length_249_cov_0.886364_g12044_i0 | PRJNA886442 | 12208 | 249 | 0.886364 | 2.20704636 | Edaphobacter | 388463 | Bacteria | Bacteria | 77.4 | 1.14e-14 | NR | WP_260706009.1 | 1933044 | g12044 | i0 | 61 | 2.91566265060241 | 77 | 23 | 92.8 | 1 | 239 | 9 | 28 | 97 | WP_260706009.1 UDP-3-O-(3-hydroxymyristoyl)glucosamine N-acyltransferase [Edaphobacter flagellatus] | diamond | 726 | 77.8 | 0.994858611825193 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 29108202 | 29108202 | PRJNA886442_P_NODE_13048_length_247_cov_0.896552_g12884_i0 | PRJNA886442 | 13048 | 247 | 0.896552 | 2.21448344 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.5 | 0.0183 | NR | HXF26870.1 | 2212468 | g12884 | i0 | 81.8 | 0.534412955465587 | 22 | 4 | 26.7 | 0 | 68 | 3 | 1 | 22 | HXF26870.1 TIGR00282 family metallophosphoesterase [Bryobacteraceae bacterium] | diamond | 132 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30560752 | 30560752 | PRJNA886442_P_NODE_12413_length_248_cov_0.891429_g12249_i0 | PRJNA886442 | 12413 | 248 | 0.891429 | 2.21074392 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 86.7 | 9.19e-18 | NR | MFB3777564.1 | 2212468 | g12249 | i0 | 48.8 | 0.991935483870968 | 82 | 42 | 99.2 | 0 | 3 | 248 | 235 | 316 | MFB3777564.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 246 | 86.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30940284 | 30940284 | PRJNA886442_P_NODE_11494_length_250_cov_0.881356_g11330_i0 | PRJNA886442 | 11494 | 250 | 0.881356 | 2.20339 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 122 | 1.61e-30 | NR | HEX3893089.1 | 1964191 | g11330 | i0 | 68.7 | 1.968 | 83 | 23 | 99.6 | 1 | 1 | 249 | 193 | 272 | HEX3893089.1 alpha-L-fucosidase [Terracidiphilus sp.] | diamond | 492 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 31445932 | 31445932 | PRJNA886442_P_NODE_12336_length_248_cov_0.891429_g12172_i0 | PRJNA886442 | 12336 | 248 | 0.891429 | 2.21074392 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 48.5 | 3.57e-4 | NR | HMD87200.1 | 2081523 | g12172 | i0 | 35.4 | 1.98387096774194 | 82 | 53 | 99.2 | 0 | 248 | 3 | 36 | 117 | HMD87200.1 TolC family protein [Terriglobia bacterium] | diamond | 492 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 31698985 | 31698985 | PRJNA886442_P_NODE_10317_length_253_cov_0.866667_g10153_i0 | PRJNA886442 | 10317 | 253 | 0.866667 | 2.19266751 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.042 | NR | MBI1941179.1 | 1978231 | g10153 | i0 | 46.7 | 0.533596837944664 | 45 | 24 | 53.4 | 0 | 117 | 251 | 258 | 302 | MBI1941179.1 DUF5107 domain-containing protein [Acidobacteriota bacterium] | diamond | 135 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;