contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA498309" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15782708 | 15782708 | PRJNA498309_P_NODE_109833_length_173_cov_1.698529_g107684_i0 | PRJNA498309 | 109833 | 173 | 1.698529 | 2.93845517 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 95.1 | 2.95e-22 | NR | HOY60684.1 | 2026799 | g107684 | i0 | 81.8 | 4.76878612716763 | 55 | 10 | 95.4 | 0 | 2 | 166 | 52 | 106 | HOY60684.1 TIGR00730 family Rossman fold protein [Verrucomicrobiota bacterium] | diamond | 825 | 95.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26792286 | 26792286 | PRJNA498309_P_NODE_39261_length_442_cov_8.743210_g37166_i0 | PRJNA498309 | 39261 | 442 | 8.74321 | 38.6449882 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 126 | 4.48e-31 | NR | HYF37212.1 | 1965333 | g37166 | i0 | 58 | 0.760180995475113 | 112 | 44 | 75.3 | 3 | 387 | 55 | 362 | 471 | HYF37212.1 terminase family protein [Prosthecobacter sp.] | diamond | 336 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 26792288 | 26792288 | PRJNA498309_P_NODE_4761_length_1530_cov_9.099799_g3735_i0 | PRJNA498309 | 4761 | 1530 | 9.099799 | 139.2269247 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 311 | 5.7900000000000005e-97 | NR | HEY4285092.1 | 2201154 | g3735 | i0 | 74.5 | 0.384313725490196 | 196 | 50 | 38.4 | 0 | 3 | 590 | 250 | 445 | HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium] | diamond | 588 | 311 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 26997433 | 26997433 | PRJNA498309_P_NODE_19602_length_657_cov_6.604839_g17807_i0 | PRJNA498309 | 19602 | 657 | 6.604839 | 43.39379223 | Brevifollis | 1383070 | Bacteria | Bacteria | 234 | 2.83e-75 | NR | WP_146850614.1 | 748831 | g17807 | i0 | 71.8 | 1.44292237442922 | 163 | 45 | 74.4 | 1 | 529 | 41 | 1 | 162 | WP_146850614.1 hypothetical protein [Brevifollis gellanilyticus] | diamond | 948 | 234 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Brevifollis | Brevifollis gellanilyticus | |
| 27077036 | 27077036 | PRJNA498309_P_NODE_27682_length_544_cov_3.952663_g25717_i0 | PRJNA498309 | 27682 | 544 | 3.952663 | 21.50248672 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 235 | 4.359999999999999e-74 | NR | PYM04037.1 | 2026799 | g25717 | i0 | 94.4 | 1.35661764705882 | 126 | 7 | 69.5 | 0 | 383 | 6 | 1 | 126 | PYM04037.1 MAG: hypothetical protein DMF13_02355 [Verrucomicrobiota bacterium] | diamond | 738 | 235 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27171659 | 27171659 | PRJNA498309_P_NODE_8442_length_1059_cov_3.559687_g7113_i0 | PRJNA498309 | 8442 | 1059 | 3.559687 | 37.69708533 | Horticoccus sp. 23ND18S-11 | 3391832 | Bacteria | Bacteria | 458 | 6.609999999999998e-157 | NR | WP_414660626.1 | 3391832 | g7113 | i0 | 83.2 | 0.773371104815864 | 273 | 46 | 77.3 | 0 | 239 | 1057 | 1 | 273 | WP_414660626.1 MFS transporter [Horticoccus sp. 23ND18S-11] | diamond | 819 | 458 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus sp. 23ND18S-11 | |
| 27693022 | 27693022 | PRJNA498309_P_NODE_43964_length_411_cov_6.716578_g41839_i0 | PRJNA498309 | 43964 | 411 | 6.716578 | 27.60513558 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 1.67e-21 | NR | MBV9130075.1 | 2026799 | g41839 | i0 | 49 | 3.52554744525547 | 100 | 51 | 73 | 0 | 371 | 72 | 52 | 151 | MBV9130075.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 1449 | 95.5 | 0.995811518324607 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27709271 | 27709271 | PRJNA498309_P_NODE_102624_length_188_cov_1.529801_g100475_i0 | PRJNA498309 | 102624 | 188 | 1.529801 | 2.87602588 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 82.4 | 3.69e-17 | NR | MBS0628556.1 | 2026799 | g100475 | i0 | 69.1 | 2.60106382978723 | 55 | 17 | 87.8 | 0 | 167 | 3 | 197 | 251 | MBS0628556.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 489 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27929872 | 27929872 | PRJNA498309_P_NODE_45125_length_404_cov_5.874659_g42993_i0 | PRJNA498309 | 45125 | 404 | 5.874659 | 23.73362236 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 79.3 | 3.63e-14 | NR | MET0262465.1 | 2706526 | g42993 | i0 | 42.2 | 0.861386138613861 | 116 | 59 | 83.2 | 3 | 27 | 362 | 737 | 848 | MET0262465.1 glycosyltransferase [Rariglobus sp.] | diamond | 348 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 27993151 | 27993151 | PRJNA498309_S_NODE_26645_length_344_cov_340.990291_g24477_i0 | PRJNA498309 | 26645 | 344 | 340.990291 | 1173.00660104 | Luteolibacter algae | 454151 | Bacteria | Bacteria | 165 | 2.41e-47 | NR | WP_386818584.1 | 454151 | g24477 | i0 | 80.4 | 1.62209302325581 | 92 | 18 | 80.2 | 0 | 300 | 25 | 80 | 171 | WP_386818584.1 glycosyltransferase family 4 protein [Luteolibacter algae] | diamond | 558 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter algae | |
| 28435145 | 28435145 | PRJNA498309_P_NODE_98406_length_198_cov_1.645963_g96257_i0 | PRJNA498309 | 98406 | 198 | 1.645963 | 3.25900674 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 52.4 | 7.86e-6 | NR | HEV3149135.1 | 2201154 | g96257 | i0 | 49 | 2.28787878787879 | 49 | 25 | 74.2 | 0 | 191 | 45 | 275 | 323 | HEV3149135.1 ABC transporter permease [Chthoniobacterales bacterium] | diamond | 453 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 28529938 | 28529938 | PRJNA498309_S_NODE_13687_length_631_cov_12.588926_g11764_i0 | PRJNA498309 | 13687 | 631 | 12.588926 | 79.43612306 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 313 | 5.999999999999999e-103 | NR | HEX7860182.1 | 2499141 | g11764 | i0 | 90.1 | 1.62599049128368 | 171 | 17 | 81.3 | 0 | 98 | 610 | 1 | 171 | HEX7860182.1 putative DNA modification/repair radical SAM protein [Verrucomicrobiia bacterium] | diamond | 1026 | 313 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29192987 | 29192987 | PRJNA498309_P_NODE_5729_length_1354_cov_9.129841_g3735_i1 | PRJNA498309 | 5729 | 1354 | 9.129841 | 123.61804714 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 311 | 9.06e-98 | NR | HEY4285092.1 | 2201154 | g3735 | i1 | 74.5 | 0.434268833087149 | 196 | 50 | 43.4 | 0 | 3 | 590 | 250 | 445 | HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium] | diamond | 588 | 311 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29413763 | 29413763 | PRJNA498309_P_NODE_95549_length_205_cov_1.785714_g93400_i0 | PRJNA498309 | 95549 | 205 | 1.785714 | 3.6607137 | Luteolibacter yonseiensis | 1144680 | Bacteria | Bacteria | 72.4 | 2.37e-13 | NR | WP_200350434.1 | 1144680 | g93400 | i0 | 55 | 1.71219512195122 | 60 | 26 | 86.3 | 1 | 26 | 202 | 13 | 72 | WP_200350434.1 hypothetical protein [Luteolibacter yonseiensis] | diamond | 351 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter yonseiensis | |
| 29445190 | 29445190 | PRJNA498309_P_NODE_21210_length_629_cov_5.839527_g19363_i0 | PRJNA498309 | 21210 | 629 | 5.839527 | 36.730624829999996 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 261 | 3.51e-78 | NR | MEI6034466.1 | 2499141 | g19363 | i0 | 66.5 | 1.96502384737679 | 203 | 66 | 95.9 | 1 | 24 | 626 | 2 | 204 | MEI6034466.1 Hsp70 family protein [Verrucomicrobiia bacterium] | diamond | 1236 | 261 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29729355 | 29729355 | PRJNA498309_S_NODE_5330_length_1259_cov_11.385621_g3946_i0 | PRJNA498309 | 5330 | 1259 | 11.385621 | 143.34496839 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 305 | 8.259999999999999e-96 | NR | HEY4285092.1 | 2201154 | g3946 | i0 | 76.6 | 0.438443208895949 | 184 | 43 | 43.8 | 0 | 26 | 577 | 262 | 445 | HEY4285092.1 DNA methyltransferase [Chthoniobacterales bacterium] | diamond | 552 | 305 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 30234960 | 30234960 | PRJNA498309_P_NODE_113292_length_166_cov_2.395349_g111143_i0 | PRJNA498309 | 113292 | 166 | 2.395349 | 3.97627934 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 72.4 | 2.53e-13 | NR | MCX7713875.1 | 2201154 | g111143 | i0 | 100 | 0.578313253012048 | 32 | 0 | 57.8 | 0 | 97 | 2 | 231 | 262 | MCX7713875.1 endonuclease/exonuclease/phosphatase family protein [Chthoniobacterales bacterium] | diamond | 96 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 30740481 | 30740481 | PRJNA498309_P_NODE_21074_length_631_cov_8.378788_g19229_i0 | PRJNA498309 | 21074 | 631 | 8.378788 | 52.87015228 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 313 | 5.999999999999999e-103 | NR | HEX7860182.1 | 2499141 | g19229 | i0 | 90.1 | 1.62599049128368 | 171 | 17 | 81.3 | 0 | 98 | 610 | 1 | 171 | HEX7860182.1 putative DNA modification/repair radical SAM protein [Verrucomicrobiia bacterium] | diamond | 1026 | 313 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31277658 | 31277658 | PRJNA498309_P_NODE_78835_length_254_cov_2.783410_g76686_i0 | PRJNA498309 | 78835 | 254 | 2.78341 | 7.0698614 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 42.7 | 0.0432 | NR | HUA59632.1 | 2499141 | g76686 | i0 | 33.8 | 0.767716535433071 | 65 | 39 | 73.2 | 2 | 19 | 204 | 321 | 384 | HUA59632.1 serine/threonine-protein kinase [Verrucomicrobiia bacterium] | diamond | 195 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31324776 | 31324776 | PRJNA498309_P_NODE_38775_length_446_cov_1.640587_g36696_i0 | PRJNA498309 | 38775 | 446 | 1.640587 | 7.31701802 | Terrimicrobium | 1649503 | Bacteria | Bacteria | 212 | 3.54e-65 | NR | HEY5770585.1 | 1965319 | g36696 | i0 | 74.1 | 1.8632286995515699 | 139 | 36 | 93.5 | 0 | 22 | 438 | 1 | 139 | HEY5770585.1 DUF4126 domain-containing protein [Terrimicrobium sp.] | diamond | 831 | 214 | 0.990654205607477 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. |
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);;