contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA849822" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26810088 | 26810088 | PRJNA849822_P_NODE_23041_length_302_cov_0.995633_g22867_i0 | PRJNA849822 | 23041 | 302 | 0.995633 | 3.00681166 | Bacteria | 2 | Bacteria | Bacteria | 67.4 | 1.69e-10 | NR | OGQ89419.1 | 1797895 | g22867 | i0 | 37.3 | 2.02649006622517 | 102 | 52 | 98.3 | 3 | 302 | 6 | 1133 | 1225 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 612 | 67.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27031523 | 27031523 | PRJNA849822_P_NODE_9222_length_495_cov_1.464455_g9049_i0 | PRJNA849822 | 9222 | 495 | 1.464455 | 7.24905225 | Bacteria | 2 | Bacteria | Bacteria | 83.2 | 4.88e-15 | NR | OGQ89419.1 | 1797895 | g9049 | i0 | 35 | 3.46666666666667 | 143 | 85 | 86.1 | 5 | 426 | 1 | 1110 | 1245 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 1716 | 83.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27055048 | 27055048 | PRJNA849822_P_NODE_42742_length_242_cov_1.467456_g42568_i0 | PRJNA849822 | 42742 | 242 | 1.467456 | 3.55124352 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | 2013741 | Bacteria | Bacteria | 68.2 | 3.98e-11 | NR | PKN56436.1 | 2013741 | g42568 | i0 | 46.8 | 0.979338842975207 | 79 | 33 | 96.7 | 5 | 234 | 1 | 371 | 441 | PKN56436.1 MAG: hypothetical protein CVU56_16230, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] | diamond | 237 | 68.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 | ||||||
| 27125998 | 27125998 | PRJNA849822_P_NODE_31742_length_259_cov_2.032258_g31568_i0 | PRJNA849822 | 31742 | 259 | 2.032258 | 5.26354822 | Bacteria | 2 | Bacteria | Bacteria | 76.3 | 7.55e-14 | NR | OGQ89419.1 | 1797895 | g31568 | i0 | 47 | 1.92277992277992 | 83 | 38 | 93.8 | 4 | 5 | 247 | 1204 | 1282 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 498 | 76.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27339549 | 27339549 | PRJNA849822_P_NODE_25243_length_289_cov_1.296296_g25069_i0 | PRJNA849822 | 25243 | 289 | 1.296296 | 3.74629544 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 83.6 | 2.94e-16 | NR | WP_133621798.1 | 1548548 | g25069 | i0 | 45.5 | 2.04498269896194 | 99 | 51 | 99.7 | 2 | 289 | 2 | 272 | 370 | WP_133621798.1 hypothetical protein [Bradymonas sediminis] | diamond | 591 | 83.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 27505783 | 27505783 | PRJNA849822_P_NODE_2963_length_949_cov_1.711187_g2821_i0 | PRJNA849822 | 2963 | 949 | 1.711187 | 16.23916463 | Bacteria | 2 | Bacteria | Bacteria | 127 | 2.57e-28 | NR | OGQ89419.1 | 1797895 | g2821 | i0 | 33.9 | 1.49209694415174 | 236 | 128 | 69.5 | 6 | 661 | 2 | 1035 | 1258 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 1416 | 127 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27537212 | 27537212 | PRJNA849822_P_NODE_4743_length_726_cov_1.580398_g4579_i0 | PRJNA849822 | 4743 | 726 | 1.580398 | 11.473689480000001 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 0.00173 | NR | MDG2063691.1 | 2024889 | g4579 | i0 | 57.5 | 0.330578512396694 | 40 | 17 | 16.5 | 0 | 484 | 365 | 15 | 54 | MDG2063691.1 molecular chaperone Tir [SAR324 cluster bacterium] | diamond | 240 | 50.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 27727035 | 27727035 | PRJNA849822_P_NODE_14404_length_384_cov_1.652733_g14230_i0 | PRJNA849822 | 14404 | 384 | 1.652733 | 6.34649472 | Bacteria | 2 | Bacteria | Bacteria | 70.5 | 3.74e-11 | NR | OGQ89419.1 | 1797895 | g14230 | i0 | 35.1 | 1.78125 | 114 | 64 | 89.1 | 3 | 374 | 33 | 1129 | 1232 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 684 | 70.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27821512 | 27821512 | PRJNA849822_P_NODE_35164_length_251_cov_0.876404_g34990_i0 | PRJNA849822 | 35164 | 251 | 0.876404 | 2.19977404 | Bacteria | 2 | Bacteria | Bacteria | 80.5 | 2.17e-15 | NR | OGQ89419.1 | 1797895 | g34990 | i0 | 44.4 | 1.93625498007968 | 81 | 41 | 96.8 | 2 | 247 | 5 | 1144 | 1220 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 486 | 80.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 27876193 | 27876193 | PRJNA849822_P_NODE_9685_length_482_cov_1.339853_g9512_i0 | PRJNA849822 | 9685 | 482 | 1.339853 | 6.45809146 | Bradymonadaceae bacterium | 2740543 | Bacteria | Bacteria | 46.2 | 0.0231 | NR | MFU8804266.1 | 2740543 | g9512 | i0 | 24 | 0.946058091286307 | 121 | 64 | 74.1 | 3 | 471 | 115 | 32 | 126 | MFU8804266.1 DUF4397 domain-containing protein [Bradymonadaceae bacterium] | diamond | 456 | 46.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonadaceae bacterium | ||||
| 28200023 | 28200023 | PRJNA849822_P_NODE_28606_length_273_cov_1.295000_g28432_i0 | PRJNA849822 | 28606 | 273 | 1.295 | 3.53535 | Bacteria | 2 | Bacteria | Bacteria | 79 | 1e-14 | NR | OGQ89419.1 | 1797895 | g28432 | i0 | 41.4 | 1.91208791208791 | 87 | 48 | 95.6 | 2 | 272 | 12 | 1126 | 1209 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 522 | 79 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 28579214 | 28579214 | PRJNA849822_P_NODE_21407_length_313_cov_1.833333_g21233_i0 | PRJNA849822 | 21407 | 313 | 1.833333 | 5.73833229 | Bacteria | 2 | Bacteria | Bacteria | 79.3 | 1.22e-14 | NR | OGQ89419.1 | 1797895 | g21233 | i0 | 42.6 | 1.93610223642173 | 101 | 51 | 96.8 | 4 | 9 | 311 | 1159 | 1252 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 606 | 79.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 28831591 | 28831591 | PRJNA849822_P_NODE_25908_length_286_cov_1.150235_g25734_i0 | PRJNA849822 | 25908 | 286 | 1.150235 | 3.2896721 | Myxococcota | 2818505 | Bacteria | Bacteria | 65.1 | 8.74e-10 | NR | OGQ89419.1 | 1797895 | g25734 | i0 | 38.2 | 2.64335664335664 | 89 | 49 | 93.4 | 3 | 9 | 275 | 1152 | 1234 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 756 | 65.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 28863142 | 28863142 | PRJNA849822_P_NODE_16288_length_360_cov_1.087108_g16114_i0 | PRJNA849822 | 16288 | 360 | 1.087108 | 3.9135888 | Bacteria | 2 | Bacteria | Bacteria | 82 | 2.53e-15 | NR | OGQ89419.1 | 1797895 | g16114 | i0 | 45.2 | 1.55 | 93 | 49 | 77.5 | 2 | 310 | 32 | 1179 | 1269 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 558 | 82 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 29368494 | 29368494 | PRJNA849822_P_NODE_33809_length_253_cov_0.866667_g33635_i0 | PRJNA849822 | 33809 | 253 | 0.866667 | 2.19266751 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 2.06e-9 | NR | OGQ89419.1 | 1797895 | g33635 | i0 | 43.1 | 1.54150197628458 | 65 | 36 | 77.1 | 1 | 26 | 220 | 1160 | 1223 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 390 | 63.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 29842068 | 29842068 | PRJNA849822_P_NODE_33411_length_253_cov_0.866667_g33237_i0 | PRJNA849822 | 33411 | 253 | 0.866667 | 2.19266751 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 6.18e-5 | NR | OGQ89419.1 | 1797895 | g33237 | i0 | 42.9 | 1.6600790513834 | 70 | 33 | 80.6 | 2 | 252 | 49 | 1182 | 1246 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 420 | 50.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 29905411 | 29905411 | PRJNA849822_P_NODE_9671_length_482_cov_2.068460_g9498_i0 | PRJNA849822 | 9671 | 482 | 2.06846 | 9.9699772 | Bacteria | 2 | Bacteria | Bacteria | 82.4 | 7.7e-15 | NR | OGQ89419.1 | 1797895 | g9498 | i0 | 35.2 | 1.76763485477178 | 142 | 82 | 85.9 | 6 | 480 | 67 | 1144 | 1279 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 852 | 82.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 29968449 | 29968449 | PRJNA849822_P_NODE_37031_length_249_cov_0.886364_g36857_i0 | PRJNA849822 | 37031 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 1.98e-9 | NR | OGQ89419.1 | 1797895 | g36857 | i0 | 45.3 | 1.80722891566265 | 75 | 40 | 90.4 | 1 | 7 | 231 | 1182 | 1255 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 450 | 63.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 30560226 | 30560226 | PRJNA849822_P_NODE_31453_length_261_cov_0.914894_g31279_i0 | PRJNA849822 | 31453 | 261 | 0.914894 | 2.38787334 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 100 | 5.16e-23 | NR | WP_111336476.1 | 1548548 | g31279 | i0 | 63.2 | 0.781609195402299 | 68 | 25 | 78.2 | 0 | 261 | 58 | 211 | 278 | WP_111336476.1 acyl-CoA desaturase [Bradymonas sediminis] | diamond | 204 | 100 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis | |||
| 30568439 | 30568439 | PRJNA849822_P_NODE_19553_length_327_cov_1.657480_g19379_i0 | PRJNA849822 | 19553 | 327 | 1.65748 | 5.4199596 | Myxococcota | 2818505 | Bacteria | Bacteria | 81.3 | 3.24e-15 | NR | OGQ89419.1 | 1797895 | g19379 | i0 | 38.8 | 2.79816513761468 | 103 | 60 | 94.5 | 2 | 315 | 7 | 1171 | 1270 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 915 | 81.6 | 0.996323529411765 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 31232060 | 31232060 | PRJNA849822_P_NODE_30495_length_265_cov_1.213542_g30321_i0 | PRJNA849822 | 30495 | 265 | 1.213542 | 3.2158863 | Bacteria | 2 | Bacteria | Bacteria | 56.6 | 6.39e-7 | NR | OGQ89419.1 | 1797895 | g30321 | i0 | 39.5 | 1.94716981132075 | 86 | 47 | 97.4 | 3 | 260 | 3 | 1124 | 1204 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 516 | 56.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 32213004 | 32213004 | PRJNA849822_P_NODE_26498_length_283_cov_1.114286_g26324_i0 | PRJNA849822 | 26498 | 283 | 1.114286 | 3.15342938 | Bacteria | 2 | Bacteria | Bacteria | 72.8 | 1.72e-12 | NR | OGQ89419.1 | 1797895 | g26324 | i0 | 37.5 | 1.86572438162544 | 88 | 51 | 93.3 | 2 | 277 | 14 | 1140 | 1223 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 528 | 72.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 32521360 | 32521360 | PRJNA849822_P_NODE_4479_length_752_cov_2.374080_g4315_i0 | PRJNA849822 | 4479 | 752 | 2.37408 | 17.8530816 | Bradymonadales bacterium | 2099667 | Bacteria | Bacteria | 107 | 3.09e-22 | NR | MBS7380160.1 | 2099667 | g4315 | i0 | 46.6 | 0.530585106382979 | 133 | 61 | 51.5 | 5 | 1 | 387 | 300 | 426 | MBS7380160.1 DUF4215 domain-containing protein [Bradymonadales bacterium] | diamond | 399 | 107 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadales bacterium | |||||
| 32686816 | 32686816 | PRJNA849822_P_NODE_32280_length_257_cov_2.108696_g32106_i0 | PRJNA849822 | 32280 | 257 | 2.108696 | 5.41934872 | Bacteria | 2 | Bacteria | Bacteria | 68.9 | 2.71e-11 | NR | OGQ89419.1 | 1797895 | g32106 | i0 | 40.7 | 1.89105058365759 | 81 | 44 | 94.6 | 2 | 247 | 5 | 1158 | 1234 | OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 486 | 68.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 |
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);;