contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA656952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622532 | 622532 | PRJNA656952_P_NODE_41441_length_243_cov_0.905882_g41254_i0 | PRJNA656952 | 41441 | 243 | 0.905882 | 2.20129326 | Terrimicrobium sacchariphilum | 690879 | Bacteria | Bacteria | 162 | 4.82e-45 | NR | WP_075077892.1 | 690879 | g41254 | i0 | 93.8 | 3 | 81 | 5 | 100 | 0 | 1 | 243 | 225 | 305 | WP_075077892.1 biosynthetic-type acetolactate synthase large subunit [Terrimicrobium sacchariphilum] | diamond | 729 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sacchariphilum | |
| 14651328 | 14651328 | PRJNA656952_P_NODE_33112_length_250_cov_0.870056_g32925_i0 | PRJNA656952 | 33112 | 250 | 0.870056 | 2.17514 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 125 | 7.61e-33 | NR | MEQ1861824.1 | 2811408 | g32925 | i0 | 77.8 | 2.916 | 81 | 18 | 97.2 | 0 | 245 | 3 | 122 | 202 | MEQ1861824.1 FtsH protease activity modulator HflK [Chthoniobacteraceae bacterium] | diamond | 729 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 26638074 | 26638074 | PRJNA656952_P_NODE_25481_length_276_cov_1.305419_g25294_i0 | PRJNA656952 | 25481 | 276 | 1.305419 | 3.60295644 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 186 | 7.04e-53 | NR | HEY1108459.1 | 2006848 | g25294 | i0 | 96.7 | 2.96739130434783 | 91 | 3 | 98.9 | 0 | 274 | 2 | 75 | 165 | HEY1108459.1 endonuclease/exonuclease/phosphatase family protein [Opitutaceae bacterium] | diamond | 819 | 186 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 26923183 | 26923183 | PRJNA656952_P_NODE_20582_length_301_cov_1.057018_g20395_i0 | PRJNA656952 | 20582 | 301 | 1.057018 | 3.18162418 | Puniceicoccales bacterium | 2478473 | Bacteria | Bacteria | 44.7 | 0.0149 | NR | MDR2845148.1 | 2478473 | g20395 | i0 | 42.9 | 0.558139534883721 | 56 | 30 | 53.8 | 1 | 165 | 4 | 56 | 111 | MDR2845148.1 ComEC/Rec2 family competence protein [Puniceicoccales bacterium] | diamond | 168 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccales bacterium | |||
| 27314997 | 27314997 | PRJNA656952_P_NODE_44063_length_241_cov_0.916667_g43876_i0 | PRJNA656952 | 44063 | 241 | 0.916667 | 2.20916747 | Opitutaceae | 134623 | Bacteria | Bacteria | 120 | 9.86e-30 | NR | MBA4137518.1 | 1913982 | g43876 | i0 | 76.3 | 2.98755186721992 | 80 | 19 | 99.6 | 0 | 240 | 1 | 217 | 296 | MBA4137518.1 anion transporter [Opitutus sp.] | diamond | 720 | 121 | 0.991735537190083 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 27492205 | 27492205 | PRJNA656952_P_NODE_38723_length_245_cov_0.895349_g38536_i0 | PRJNA656952 | 38723 | 245 | 0.895349 | 2.19360505 | Luteolibacter sp. SL25 | 1962973 | Bacteria | Bacteria | 87 | 3.16e-18 | NR | WP_267674313.1 | 2995170 | g38536 | i0 | 93 | 0.52653061224489806 | 43 | 3 | 52.7 | 0 | 116 | 244 | 111 | 153 | WP_267674313.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Luteolibacter sp. SL250] | diamond | 129 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 29304032 | 29304032 | PRJNA656952_P_NODE_42869_length_242_cov_0.911243_g42682_i0 | PRJNA656952 | 42869 | 242 | 0.911243 | 2.20520806 | Candidatus Didemnitutus | 2055839 | Bacteria | Bacteria | 129 | 3.05e-34 | NR | MEI6108204.1 | 2026771 | g42682 | i0 | 72.5 | 6.94214876033058 | 80 | 22 | 99.2 | 0 | 2 | 241 | 203 | 282 | MEI6108204.1 N-acetylmuramoyl-L-alanine amidase [Opitutia bacterium] | diamond | 1680 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29323297 | 29323297 | PRJNA656952_P_NODE_40949_length_243_cov_0.905882_g40762_i0 | PRJNA656952 | 40949 | 243 | 0.905882 | 2.20129326 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 67.8 | 1.35e-12 | NR | HEY1081890.1 | 1965333 | g40762 | i0 | 91.2 | 0.419753086419753 | 34 | 3 | 42 | 0 | 237 | 136 | 49 | 82 | HEY1081890.1 hypothetical protein [Prosthecobacter sp.] | diamond | 102 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29670372 | 29670372 | PRJNA656952_P_NODE_31950_length_251_cov_0.865169_g31763_i0 | PRJNA656952 | 31950 | 251 | 0.865169 | 2.17157419 | Luteolibacter sp. SL25 | 1962973 | Bacteria | Bacteria | 154 | 1.38e-41 | NR | WP_267670606.1 | 2995170 | g31763 | i0 | 85.5 | 0.99203187250996006 | 83 | 12 | 99.2 | 0 | 2 | 250 | 60 | 142 | WP_267670606.1 FG-GAP repeat domain-containing protein [Luteolibacter sp. SL250] | diamond | 249 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 30776530 | 30776530 | PRJNA656952_P_NODE_33254_length_250_cov_0.870056_g33067_i0 | PRJNA656952 | 33254 | 250 | 0.870056 | 2.17514 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 135 | 1.19e-37 | NR | MEQ1858400.1 | 2811408 | g33067 | i0 | 84.1 | 0.984 | 82 | 13 | 98.4 | 0 | 248 | 3 | 116 | 197 | MEQ1858400.1 hypothetical protein [Chthoniobacteraceae bacterium] | diamond | 246 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 30808047 | 30808047 | PRJNA656952_P_NODE_41794_length_243_cov_0.905882_g41607_i0 | PRJNA656952 | 41794 | 243 | 0.905882 | 2.20129326 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 132 | 1.06e-36 | NR | HEY1048628.1 | 1965333 | g41607 | i0 | 100 | 0.790123456790123 | 64 | 0 | 79 | 0 | 51 | 242 | 1 | 64 | HEY1048628.1 tRNA adenosine(34) deaminase TadA [Prosthecobacter sp.] | diamond | 192 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30934519 | 30934519 | PRJNA656952_P_NODE_35374_length_248_cov_0.880000_g35187_i0 | PRJNA656952 | 35374 | 248 | 0.88 | 2.1824 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 157 | 1.47e-42 | NR | HEY1080616.1 | 1965333 | g35187 | i0 | 90.2 | 0.991935483870968 | 82 | 8 | 99.2 | 0 | 1 | 246 | 447 | 528 | HEY1080616.1 DUF1553 domain-containing protein [Prosthecobacter sp.] | diamond | 246 | 157 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 31693184 | 31693184 | PRJNA656952_P_NODE_36397_length_247_cov_0.885057_g36210_i0 | PRJNA656952 | 36397 | 247 | 0.885057 | 2.18609079 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 104 | 2.7e-26 | NR | MBA4138563.1 | 1913982 | g36210 | i0 | 65.1 | 1.0080971659919 | 83 | 27 | 98.4 | 1 | 3 | 245 | 34 | 116 | MBA4138563.1 hypothetical protein [Opitutus sp.] | diamond | 249 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 31787935 | 31787935 | PRJNA656952_P_NODE_31617_length_251_cov_0.865169_g31430_i0 | PRJNA656952 | 31617 | 251 | 0.865169 | 2.17157419 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 147 | 3.57e-39 | NR | MBI5800124.1 | 2026799 | g31430 | i0 | 91.6 | 0.99203187250996006 | 83 | 7 | 99.2 | 0 | 2 | 250 | 60 | 142 | MBI5800124.1 tetratricopeptide repeat-containing sensor histidine kinase [Verrucomicrobiota bacterium] | diamond | 249 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32041277 | 32041277 | PRJNA656952_P_NODE_33118_length_250_cov_0.870056_g32931_i0 | PRJNA656952 | 33118 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 119 | 3.67e-29 | NR | MFH1499404.1 | 2026799 | g32931 | i0 | 71.1 | 0.996 | 83 | 24 | 99.6 | 0 | 1 | 249 | 411 | 493 | MFH1499404.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 249 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;