contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2440195 | 2440195 | PRJNA670521_P_NODE_12562_length_511_cov_2.095890_g11826_i0 | PRJNA670521 | 12562 | 511 | 2.09589 | 10.7099979 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 258 | 2.49e-80 | NR | MCW0216825.1 | 1965333 | g11826 | i0 | 77.6 | 1.99608610567515 | 170 | 38 | 99.8 | 0 | 511 | 2 | 245 | 414 | MCW0216825.1 thermosome subunit alpha [Prosthecobacter sp.] | diamond | 1020 | 258 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 3189143 | 3189143 | PRJNA670521_P_NODE_67083_length_257_cov_1.668478_g66338_i0 | PRJNA670521 | 67083 | 257 | 1.668478 | 4.28798846 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 76.6 | 9.82e-15 | NR | HUR58326.1 | 2006848 | g66338 | i0 | 48.8 | 1.91439688715953 | 82 | 39 | 95.7 | 1 | 251 | 6 | 97 | 175 | HUR58326.1 MTAP family purine nucleoside phosphorylase [Opitutaceae bacterium] | diamond | 492 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 4466326 | 4466326 | PRJNA670521_P_NODE_80664_length_246_cov_1.381503_g79919_i0 | PRJNA670521 | 80664 | 246 | 1.381503 | 3.39849738 | Luteolibacter sp. AS25 | 3135776 | Bacteria | Bacteria | 59.3 | 5.42e-8 | NR | WP_411827508.1 | 3135776 | g79919 | i0 | 68.3 | 1.04878048780488 | 41 | 13 | 50 | 0 | 125 | 3 | 4 | 44 | WP_411827508.1 sulfatase family protein [Luteolibacter sp. AS25] | diamond | 258 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. AS25 | |
| 14667357 | 14667357 | PRJNA670521_P_NODE_78932_length_247_cov_0.885057_g78187_i0 | PRJNA670521 | 78932 | 247 | 0.885057 | 2.18609079 | Puniceicoccales bacterium | 2478473 | Bacteria | Bacteria | 153 | 4.49e-41 | NR | MDR2862525.1 | 2478473 | g78187 | i0 | 84.1 | 3.98380566801619 | 82 | 13 | 99.6 | 0 | 1 | 246 | 1109 | 1190 | MDR2862525.1 DNA-directed RNA polymerase subunit beta [Puniceicoccales bacterium] | diamond | 984 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccales bacterium | |||
| 20291393 | 20291393 | PRJNA670521_P_NODE_87776_length_243_cov_0.905882_g87031_i0 | PRJNA670521 | 87776 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 144 | 1.61e-39 | NR | PAW86008.1 | 1982324 | g87031 | i0 | 85 | 26.6296296296296 | 80 | 12 | 98.8 | 0 | 241 | 2 | 190 | 269 | PAW86008.1 MAG: RNA helicase [Pedosphaera sp. Tous-C6FEB] | diamond | 6471 | 145 | 0.993103448275862 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. Tous-C6FEB | |
| 28597733 | 28597733 | PRJNA670521_P_NODE_92567_length_241_cov_0.916667_g91822_i0 | PRJNA670521 | 92567 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 59.7 | 3.93e-8 | NR | MFN0127000.1 | 2026801 | g91822 | i0 | 49.2 | 0.784232365145228 | 63 | 31 | 77.2 | 1 | 217 | 32 | 288 | 350 | MFN0127000.1 ankyrin repeat domain-containing protein [Verrucomicrobiales bacterium] | diamond | 189 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29513079 | 29513079 | PRJNA670521_P_NODE_77690_length_248_cov_0.880000_g76945_i0 | PRJNA670521 | 77690 | 248 | 0.88 | 2.1824 | Spartobacteria bacterium | 2052183 | Bacteria | Bacteria | 45.8 | 3.32e-4 | NR | MEP6976208.1 | 2052183 | g76945 | i0 | 70 | 0.362903225806452 | 30 | 9 | 36.3 | 0 | 247 | 158 | 40 | 69 | MEP6976208.1 hypothetical protein [Spartobacteria bacterium] | diamond | 90 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Spartobacteria bacterium | ||||
| 30915293 | 30915293 | PRJNA670521_P_NODE_84434_length_245_cov_0.895349_g83689_i0 | PRJNA670521 | 84434 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 100 | 1.81e-22 | NR | WP_013044052.1 | 395922 | g83689 | i0 | 63.8 | 6.97959183673469 | 80 | 27 | 96.7 | 2 | 245 | 9 | 685 | 763 | WP_013044052.1 FAD-dependent oxidoreductase [Coraliomargarita akajimensis] | diamond | 1710 | 101 | 0.99009900990099 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Coraliomargaritaceae | Coraliomargarita | Coraliomargarita akajimensis | |
| 30934897 | 30934897 | PRJNA670521_P_NODE_88554_length_243_cov_0.905882_g87809_i0 | PRJNA670521 | 88554 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 102 | 5.15e-23 | NR | MFO1436728.1 | 2026800 | g87809 | i0 | 64.6 | 2.97530864197531 | 79 | 28 | 97.5 | 0 | 239 | 3 | 2376 | 2454 | MFO1436728.1 putative Ig domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 723 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31598892 | 31598892 | PRJNA670521_P_NODE_5236_length_771_cov_1.295129_g4562_i0 | PRJNA670521 | 5236 | 771 | 1.295129 | 9.98544459 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 83.2 | 2.65e-14 | NR | MCW0218190.1 | 1965333 | g4562 | i0 | 29.2 | 0.813229571984436 | 209 | 126 | 72.8 | 3 | 624 | 64 | 42 | 250 | MCW0218190.1 hypothetical protein [Prosthecobacter sp.] | diamond | 627 | 83.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32104838 | 32104838 | PRJNA670521_P_NODE_92758_length_241_cov_0.916667_g92013_i0 | PRJNA670521 | 92758 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 45.8 | 0.00301 | NR | HVU09389.1 | 2499141 | g92013 | i0 | 55 | 0.49792531120332 | 40 | 18 | 49.8 | 0 | 233 | 114 | 3687 | 3726 | HVU09389.1 LamG-like jellyroll fold domain-containing protein [Verrucomicrobiia bacterium] | diamond | 120 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32168356 | 32168356 | PRJNA670521_P_NODE_49998_length_296_cov_1.035874_g49253_i0 | PRJNA670521 | 49998 | 296 | 1.035874 | 3.06618704 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 67.8 | 1.11e-10 | NR | HEX2750029.1 | 2026801 | g49253 | i0 | 47.2 | 5.35135135135135 | 89 | 41 | 84.1 | 4 | 260 | 12 | 669 | 757 | HEX2750029.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 1584 | 67.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales 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);;