contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26792146 | 26792146 | PRJNA493828_P_NODE_47441_length_202_cov_6.310078_g47022_i0 | PRJNA493828 | 47441 | 202 | 6.310078 | 12.74635756 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 114 | 1.74e-29 | NR | MCI0535408.1 | 2026801 | g47022 | i0 | 83.6 | 1.99009900990099 | 67 | 11 | 99.5 | 0 | 2 | 202 | 47 | 113 | MCI0535408.1 HEAT repeat domain-containing protein [Verrucomicrobiales bacterium] | diamond | 402 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28245243 | 28245243 | PRJNA493828_P_NODE_20906_length_284_cov_2.113744_g20487_i0 | PRJNA493828 | 20906 | 284 | 2.113744 | 6.00303296 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 107 | 1.02e-25 | NR | RYD71573.1 | 2026800 | g20487 | i0 | 77.4 | 0.654929577464789 | 62 | 14 | 65.5 | 0 | 284 | 99 | 277 | 338 | RYD71573.1 MAG: MiaB/RimO family radical SAM methylthiotransferase, partial [Verrucomicrobiaceae bacterium] | diamond | 186 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28419106 | 28419106 | PRJNA493828_P_NODE_44726_length_221_cov_5.560811_g44307_i0 | PRJNA493828 | 44726 | 221 | 5.560811 | 12.28939231 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 115 | 5.18e-28 | NR | RYD71824.1 | 2026800 | g44307 | i0 | 69.9 | 8.9185520361991 | 73 | 21 | 99.1 | 1 | 221 | 3 | 118 | 189 | RYD71824.1 MAG: hypothetical protein EOP84_24225, partial [Verrucomicrobiaceae bacterium] | diamond | 1971 | 116 | 0.991379310344828 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28908219 | 28908219 | PRJNA493828_P_NODE_25268_length_270_cov_1.203046_g24849_i0 | PRJNA493828 | 25268 | 270 | 1.203046 | 3.2482242 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 112 | 1.64e-26 | NR | HEY9247700.1 | 2706526 | g24849 | i0 | 63 | 0.9 | 81 | 30 | 90 | 0 | 19 | 261 | 513 | 593 | HEY9247700.1 hypothetical protein [Rariglobus sp.] | diamond | 243 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 29744797 | 29744797 | PRJNA493828_P_NODE_19210_length_290_cov_2.990783_g18791_i0 | PRJNA493828 | 19210 | 290 | 2.990783 | 8.6732707 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 114 | 2.86e-29 | NR | MES2572056.1 | 2026799 | g18791 | i0 | 55.2 | 4.01379310344828 | 96 | 41 | 97.2 | 1 | 282 | 1 | 60 | 155 | MES2572056.1 multicopper oxidase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 1164 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29823969 | 29823969 | PRJNA493828_P_NODE_16131_length_310_cov_2.329114_g15712_i0 | PRJNA493828 | 16131 | 310 | 2.329114 | 7.2202534 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 159 | 1.0699999999999999e-43 | NR | PYI72093.1 | 2026799 | g15712 | i0 | 79.3 | 3.56129032258065 | 92 | 15 | 85.2 | 1 | 310 | 47 | 438 | 529 | PYI72093.1 MAG: hypothetical protein DMF08_06960 [Verrucomicrobiota bacterium] | diamond | 1104 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30045165 | 30045165 | PRJNA493828_P_NODE_19831_length_288_cov_1.883721_g19412_i0 | PRJNA493828 | 19831 | 288 | 1.883721 | 5.42511648 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 72 | 1.81e-12 | NR | HET6407288.1 | 2811408 | g19412 | i0 | 94.3 | 0.364583333333333 | 35 | 2 | 36.5 | 0 | 184 | 288 | 1 | 35 | HET6407288.1 lipoyl synthase [Chthoniobacteraceae bacterium] | diamond | 105 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 30550722 | 30550722 | PRJNA493828_P_NODE_33913_length_248_cov_3.022857_g33494_i0 | PRJNA493828 | 33913 | 248 | 3.022857 | 7.49668536 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 119 | 3.76e-30 | NR | HRE83121.1 | 2006848 | g33494 | i0 | 95.2 | 0.762096774193548 | 63 | 3 | 76.2 | 0 | 247 | 59 | 301 | 363 | HRE83121.1 FecR domain-containing protein [Opitutaceae bacterium] | diamond | 189 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31024845 | 31024845 | PRJNA493828_P_NODE_45995_length_211_cov_4.376812_g45576_i0 | PRJNA493828 | 45995 | 211 | 4.376812 | 9.23507332 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 85.5 | 2.2e-17 | NR | MCC6355890.1 | 2499141 | g45576 | i0 | 65.7 | 0.95260663507109 | 67 | 23 | 95.3 | 0 | 11 | 211 | 2729 | 2795 | MCC6355890.1 SDR family NAD(P)-dependent oxidoreductase [Verrucomicrobiia bacterium] | diamond | 201 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31293123 | 31293123 | PRJNA493828_P_NODE_29615_length_257_cov_1.673913_g29196_i0 | PRJNA493828 | 29615 | 257 | 1.673913 | 4.30195641 | Chthoniobacter | 295577 | Bacteria | Bacteria | 86.7 | 4.3e-18 | NR | HEY3899370.1 | 2510640 | g29196 | i0 | 54.3 | 3.59533073929961 | 81 | 35 | 92.2 | 1 | 237 | 1 | 4 | 84 | HEY3899370.1 RluA family pseudouridine synthase [Chthoniobacter sp.] | diamond | 924 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 32068300 | 32068300 | PRJNA493828_P_NODE_27498_length_263_cov_1.615789_g27079_i0 | PRJNA493828 | 27498 | 263 | 1.615789 | 4.24952507 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 116 | 1.21e-30 | NR | HET6407168.1 | 2811408 | g27079 | i0 | 78.1 | 0.730038022813688 | 64 | 14 | 73 | 0 | 263 | 72 | 125 | 188 | HET6407168.1 PAS domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 192 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 32100017 | 32100017 | PRJNA493828_P_NODE_45238_length_217_cov_4.666667_g44819_i0 | PRJNA493828 | 45238 | 217 | 4.666667 | 10.12666739 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 94.7 | 1.27e-20 | NR | HET6409878.1 | 2811408 | g44819 | i0 | 64.3 | 0.967741935483871 | 70 | 25 | 96.8 | 0 | 212 | 3 | 235 | 304 | HET6409878.1 lamin tail domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 210 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 32637329 | 32637329 | PRJNA493828_P_NODE_20700_length_285_cov_1.448113_g20281_i0 | PRJNA493828 | 20700 | 285 | 1.448113 | 4.12712205 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 129 | 1.41e-34 | NR | MEQ1862498.1 | 2811408 | g20281 | i0 | 70.2 | 0.989473684210526 | 94 | 28 | 98.9 | 0 | 283 | 2 | 36 | 129 | MEQ1862498.1 hypothetical protein [Chthoniobacteraceae bacterium] | diamond | 282 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 32889319 | 32889319 | PRJNA493828_P_NODE_15860_length_310_cov_2.691983_g15441_i0 | PRJNA493828 | 15860 | 310 | 2.691983 | 8.3451473 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 102 | 4.49e-24 | NR | HET6406353.1 | 2811408 | g15441 | i0 | 90.7 | 0.52258064516129 | 54 | 5 | 52.3 | 0 | 147 | 308 | 37 | 90 | HET6406353.1 dienelactone hydrolase family protein [Chthoniobacteraceae bacterium] | diamond | 162 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae 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);;