contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_phylum = "Lentisphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8829819 | 8829819 | PRJNA688655_P_NODE_13787_length_244_cov_0.900585_g13722_i0 | PRJNA688655 | 13787 | 244 | 0.900585 | 2.1974274 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 162 | 9.22e-45 | NR | NLE67480.1 | 1932692 | g13722 | i0 | 98.8 | 0.995901639344262 | 81 | 1 | 99.6 | 0 | 2 | 244 | 154 | 234 | NLE67480.1 NAD-dependent DNA ligase LigA [Lentisphaerota bacterium] | diamond | 243 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 18519229 | 18519229 | PRJNA688655_P_NODE_16735_length_241_cov_0.916667_g16670_i0 | PRJNA688655 | 16735 | 241 | 0.916667 | 2.20916747 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 143 | 1.32e-37 | NR | NLN01562.1 | 1932692 | g16670 | i0 | 86.3 | 0.995850622406639 | 80 | 11 | 99.6 | 0 | 241 | 2 | 153 | 232 | NLN01562.1 DUF4981 domain-containing protein [Lentisphaerota bacterium] | diamond | 240 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 19794048 | 19794048 | PRJNA688655_P_NODE_14036_length_244_cov_0.900585_g13971_i0 | PRJNA688655 | 14036 | 244 | 0.900585 | 2.1974274 | Oligosphaeraceae bacterium | 2699751 | Bacteria | Bacteria | 137 | 7.63e-36 | NR | NLF94069.1 | 2699751 | g13971 | i0 | 92.3 | 0.959016393442623 | 78 | 6 | 95.9 | 0 | 2 | 235 | 49 | 126 | NLF94069.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Oligosphaeraceae bacterium] | diamond | 234 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Oligosphaeria | Oligosphaerales | Oligosphaeraceae | Oligosphaeraceae bacterium | ||
| 24128818 | 24128818 | PRJNA688655_P_NODE_11539_length_247_cov_0.885057_g11474_i0 | PRJNA688655 | 11539 | 247 | 0.885057 | 2.18609079 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 122 | 1.4e-30 | NR | NLB68951.1 | 1932692 | g11474 | i0 | 64.2 | 0.983805668016194 | 81 | 29 | 98.4 | 0 | 247 | 5 | 198 | 278 | NLB68951.1 DUF2341 domain-containing protein [Lentisphaerota bacterium] | diamond | 243 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27176880 | 27176880 | PRJNA688655_P_NODE_11622_length_247_cov_0.885057_g11557_i0 | PRJNA688655 | 11622 | 247 | 0.885057 | 2.18609079 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 130 | 7.54e-33 | NR | NLE41826.1 | 1932692 | g11557 | i0 | 88.2 | 0.923076923076923 | 76 | 9 | 92.3 | 0 | 2 | 229 | 813 | 888 | NLE41826.1 aminopeptidase N C-terminal domain-containing protein [Lentisphaerota bacterium] | diamond | 228 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 27208483 | 27208483 | PRJNA688655_P_NODE_9142_length_250_cov_0.870056_g9077_i0 | PRJNA688655 | 9142 | 250 | 0.870056 | 2.17514 | Lentisphaerae bacterium ADurb.BinA184 | 1852901 | Bacteria | Bacteria | 117 | 4.84e-29 | NR | OPZ28337.1 | 1852901 | g9077 | i0 | 62.2 | 1.956 | 82 | 31 | 98.4 | 0 | 3 | 248 | 218 | 299 | OPZ28337.1 MAG: hypothetical protein BWZ02_01341 [Lentisphaerae bacterium ADurb.BinA184] | diamond | 489 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium ADurb.BinA184 | |||||
| 27914933 | 27914933 | PRJNA688655_P_NODE_5105_length_293_cov_1.400000_g5040_i0 | PRJNA688655 | 5105 | 293 | 1.4 | 4.102 | Bacteria | 2 | Bacteria | Bacteria | 98.6 | 1.66e-21 | NR | NLK84052.1 | 1932692 | g5040 | i0 | 73.7 | 1.16723549488055 | 57 | 15 | 58.4 | 0 | 174 | 4 | 4 | 60 | NLK84052.1 isoleucine--tRNA ligase [Lentisphaerota bacterium] | diamond | 342 | 99 | 0.995959595959596 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 28041442 | 28041442 | PRJNA688655_P_NODE_12565_length_245_cov_0.895349_g12500_i0 | PRJNA688655 | 12565 | 245 | 0.895349 | 2.19360505 | PVC group | 1783257 | Bacteria | Bacteria | 69.3 | 1.64e-11 | NR | OPZ28807.1 | 1852901 | g12500 | i0 | 50.8 | 1.50612244897959 | 59 | 29 | 72.2 | 0 | 183 | 7 | 70 | 128 | OPZ28807.1 MAG: Chondroitinase-AC precursor [Lentisphaerae bacterium ADurb.BinA184] | diamond | 369 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium ADurb.BinA184 | |||||
| 28515023 | 28515023 | PRJNA688655_P_NODE_9747_length_249_cov_0.875000_g9682_i0 | PRJNA688655 | 9747 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.5 | 4.44e-12 | NR | MFH0880241.1 | 1932692 | g9682 | i0 | 54.8 | 1.34939759036145 | 62 | 26 | 72.3 | 1 | 66 | 245 | 16 | 77 | MFH0880241.1 S1/P1 nuclease [Lentisphaerota bacterium] | diamond | 336 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 28787403 | 28787403 | PRJNA688655_P_NODE_9107_length_250_cov_0.870056_g9042_i0 | PRJNA688655 | 9107 | 250 | 0.870056 | 2.17514 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 84.7 | 6.89e-17 | NR | NLE66288.1 | 1932692 | g9042 | i0 | 100 | 0.504 | 42 | 0 | 50.4 | 0 | 126 | 1 | 1 | 42 | NLE66288.1 ATP-dependent helicase HrpB [Lentisphaerota bacterium] | diamond | 126 | 84.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 28818829 | 28818829 | PRJNA688655_P_NODE_13228_length_245_cov_0.895349_g13163_i0 | PRJNA688655 | 13228 | 245 | 0.895349 | 2.19360505 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 166 | 9.68e-51 | NR | HCG26961.1 | 2053569 | g13163 | i0 | 96.3 | 1.98367346938776 | 81 | 3 | 99.2 | 0 | 243 | 1 | 42 | 122 | HCG26961.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 486 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 28882220 | 28882220 | PRJNA688655_P_NODE_9768_length_249_cov_0.875000_g9703_i0 | PRJNA688655 | 9768 | 249 | 0.875 | 2.17875 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 74.3 | 2.97e-13 | NR | MBO7148029.1 | 2053569 | g9703 | i0 | 44.6 | 1 | 83 | 46 | 100 | 0 | 249 | 1 | 27 | 109 | MBO7148029.1 DUF4838 domain-containing protein [Lentisphaeria bacterium] | diamond | 249 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29513605 | 29513605 | PRJNA688655_P_NODE_4810_length_299_cov_1.022124_g4745_i0 | PRJNA688655 | 4810 | 299 | 1.022124 | 3.05615076 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 112 | 2.03e-26 | NR | MFA6931584.1 | 2053569 | g4745 | i0 | 100 | 0.531772575250836 | 53 | 0 | 53.2 | 0 | 297 | 139 | 462 | 514 | MFA6931584.1 IS21 family transposase [Lentisphaeria bacterium] | diamond | 159 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29619636 | 29619636 | PRJNA688655_P_NODE_10710_length_248_cov_0.880000_g10645_i0 | PRJNA688655 | 10710 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 133 | 1.03e-36 | NR | NMA39345.1 | 1932692 | g10645 | i0 | 78 | 5.95161290322581 | 82 | 18 | 99.2 | 0 | 248 | 3 | 64 | 145 | NMA39345.1 ABC transporter ATP-binding protein [Lentisphaerota bacterium] | diamond | 1476 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30272105 | 30272105 | PRJNA688655_P_NODE_11612_length_247_cov_0.885057_g11547_i0 | PRJNA688655 | 11612 | 247 | 0.885057 | 2.18609079 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 150 | 1.65e-40 | NR | NLB69842.1 | 1932692 | g11547 | i0 | 84 | 0.983805668016194 | 81 | 13 | 98.4 | 0 | 3 | 245 | 397 | 477 | NLB69842.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 243 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30587628 | 30587628 | PRJNA688655_P_NODE_14113_length_244_cov_0.900585_g14048_i0 | PRJNA688655 | 14113 | 244 | 0.900585 | 2.1974274 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 177 | 2.3e-51 | NR | NLE41602.1 | 1932692 | g14048 | i0 | 98.8 | 0.995901639344262 | 81 | 1 | 99.6 | 0 | 1 | 243 | 235 | 315 | NLE41602.1 sulfatase-like hydrolase/transferase [Lentisphaerota bacterium] | diamond | 243 | 177 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 30840573 | 30840573 | PRJNA688655_P_NODE_12214_length_246_cov_0.890173_g12149_i0 | PRJNA688655 | 12214 | 246 | 0.890173 | 2.18982558 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 126 | 1.0999999999999999e-33 | NR | MBR7127936.1 | 2053569 | g12149 | i0 | 69.1 | 0.98780487804878 | 81 | 25 | 98.8 | 0 | 245 | 3 | 140 | 220 | MBR7127936.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 243 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 30915441 | 30915441 | PRJNA688655_P_NODE_16614_length_241_cov_0.916667_g16549_i0 | PRJNA688655 | 16614 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 120 | 1.21e-29 | NR | NLN01268.1 | 1932692 | g16549 | i0 | 72.5 | 1.99170124481328 | 80 | 21 | 99.6 | 1 | 2 | 241 | 267 | 345 | NLN01268.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 480 | 121 | 0.991735537190083 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 31030377 | 31030377 | PRJNA688655_P_NODE_13395_length_244_cov_0.900585_g13330_i0 | PRJNA688655 | 13395 | 244 | 0.900585 | 2.1974274 | Lentisphaerae bacterium ADurb.BinA184 | 1852901 | Bacteria | Bacteria | 139 | 5.95e-37 | NR | OPZ25473.1 | 1852901 | g13330 | i0 | 79 | 0.995901639344262 | 81 | 17 | 99.6 | 0 | 2 | 244 | 128 | 208 | OPZ25473.1 MAG: Arylsulfatase [Lentisphaerae bacterium ADurb.BinA184] | diamond | 243 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium ADurb.BinA184 | |||||
| 31093317 | 31093317 | PRJNA688655_P_NODE_16235_length_241_cov_0.916667_g16170_i0 | PRJNA688655 | 16235 | 241 | 0.916667 | 2.20916747 | Lentisphaerae bacterium GWF2_44_16 | 1798571 | Bacteria | Bacteria | 74.3 | 2.69e-13 | NR | OGV49206.1 | 1798571 | g16170 | i0 | 43.8 | 0.995850622406639 | 80 | 45 | 99.6 | 0 | 2 | 241 | 163 | 242 | OGV49206.1 MAG: hypothetical protein A2017_05965 [Lentisphaerae bacterium GWF2_44_16] | diamond | 240 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium GWF2_44_16 | |||||
| 31409528 | 31409528 | PRJNA688655_P_NODE_13396_length_244_cov_0.900585_g13331_i0 | PRJNA688655 | 13396 | 244 | 0.900585 | 2.1974274 | Lentisphaerae bacterium RIFOXYA12_64_32 | 1798577 | Bacteria | Bacteria | 105 | 2.27e-25 | NR | OGV71508.1 | 1798577 | g13331 | i0 | 70.4 | 4.9672131147541 | 81 | 22 | 99.6 | 1 | 243 | 1 | 72 | 150 | OGV71508.1 MAG: hypothetical protein A3K18_22560 [Lentisphaerae bacterium RIFOXYA12_64_32] | diamond | 1212 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium RIFOXYA12_64_32 | |||||
| 31441037 | 31441037 | PRJNA688655_P_NODE_13836_length_244_cov_0.900585_g13771_i0 | PRJNA688655 | 13836 | 244 | 0.900585 | 2.1974274 | Lentisphaerae bacterium ADurb.Bin242 | 1852900 | Bacteria | Bacteria | 158 | 2.0999999999999998e-47 | NR | OQA83369.1 | 1852900 | g13771 | i0 | 90.1 | 0.995901639344262 | 81 | 8 | 99.6 | 0 | 1 | 243 | 59 | 139 | OQA83369.1 MAG: hypothetical protein BWY31_02908 [Lentisphaerae bacterium ADurb.Bin242] | diamond | 243 | 158 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium ADurb.Bin242 | |||||
| 31694101 | 31694101 | PRJNA688655_P_NODE_7757_length_251_cov_0.865169_g7692_i0 | PRJNA688655 | 7757 | 251 | 0.865169 | 2.17157419 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 44.3 | 0.0117 | NR | MCE9616330.1 | 1932692 | g7692 | i0 | 44.6 | 0.776892430278884 | 65 | 33 | 74.1 | 1 | 1 | 186 | 285 | 349 | MCE9616330.1 DUF2079 domain-containing protein [Lentisphaerota bacterium] | diamond | 195 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 31820536 | 31820536 | PRJNA688655_P_NODE_15837_length_242_cov_0.911243_g15772_i0 | PRJNA688655 | 15837 | 242 | 0.911243 | 2.20520806 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 51.2 | 3.67e-5 | NR | MBO5695572.1 | 2053569 | g15772 | i0 | 41 | 1.8595041322314 | 78 | 43 | 93 | 2 | 2 | 226 | 390 | 467 | MBO5695572.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 450 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 32611479 | 32611479 | PRJNA688655_P_NODE_7680_length_251_cov_0.865169_g7615_i0 | PRJNA688655 | 7680 | 251 | 0.865169 | 2.17157419 | Lentisphaerae bacterium GWF2_5 | 1932692 | Bacteria | Bacteria | 116 | 1.33e-28 | NR | OGV53340.1 | 1798574 | g7615 | i0 | 73.6 | 2.46215139442231 | 72 | 19 | 86.1 | 0 | 36 | 251 | 4 | 75 | OGV53340.1 MAG: hypothetical protein A2X45_17300 [Lentisphaerae bacterium GWF2_50_93] | diamond | 618 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium GWF2_50_93 |
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);;