contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA283169" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26947460 | 26947460 | PRJNA283169_P_NODE_7402_length_165_cov_0.862069_g7339_i0 | PRJNA283169 | 7402 | 165 | 0.862069 | 1.42241385 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 47.4 | 2.43e-4 | NR | MBV8176842.1 | 2026799 | g7339 | i0 | 64.9 | 1.34545454545455 | 37 | 13 | 67.3 | 0 | 116 | 6 | 56 | 92 | MBV8176842.1 DUF3560 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 222 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27579580 | 27579580 | PRJNA283169_S_NODE_1984_length_200_cov_0.052980_g1970_i0 | PRJNA283169 | 1984 | 200 | 0.05298 | 0.10596 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 46.2 | 0.00107 | NR | MEI6076722.1 | 2026799 | g1970 | i0 | 55.3 | 0.57 | 38 | 17 | 57 | 0 | 199 | 86 | 197 | 234 | MEI6076722.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 114 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27895271 | 27895271 | PRJNA283169_S_NODE_1145_length_251_cov_0.123762_g1131_i0 | PRJNA283169 | 1145 | 251 | 0.123762 | 0.31064262 | Nibricoccus sp. IMCC34717 | 3034021 | Bacteria | Bacteria | 43.1 | 0.0286 | NR | WP_404423401.1 | 3034021 | g1131 | i0 | 25.3 | 0.896414342629482 | 75 | 55 | 89.6 | 1 | 22 | 246 | 239 | 312 | WP_404423401.1 LacI family DNA-binding transcriptional regulator [Nibricoccus sp. IMCC34717] | diamond | 225 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus sp. IMCC34717 | |
| 28148127 | 28148127 | PRJNA283169_S_NODE_2365_length_186_cov_0.116788_g2351_i0 | PRJNA283169 | 2365 | 186 | 0.116788 | 0.21722568 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 45.4 | 3.73e-4 | NR | MEI9961334.1 | 2052186 | g2351 | i0 | 58.6 | 0.467741935483871 | 29 | 12 | 46.8 | 0 | 183 | 97 | 30 | 58 | MEI9961334.1 hypothetical protein [Limisphaerales bacterium] | diamond | 87 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales bacterium | |||
| 28179297 | 28179297 | PRJNA283169_P_NODE_2906_length_243_cov_1.587629_g2843_i0 | PRJNA283169 | 2906 | 243 | 1.587629 | 3.85793847 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 134 | 1.6299999999999998e-35 | NR | RFC52986.1 | 2026799 | g2843 | i0 | 90.1 | 0.876543209876543 | 71 | 7 | 87.7 | 0 | 213 | 1 | 1 | 71 | RFC52986.1 MAG: Outer membrane protein assembly factor BamB, contains PQQ-like beta-propeller repeat [Verrucomicrobiota bacterium] | diamond | 213 | 134 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28368892 | 28368892 | PRJNA283169_P_NODE_3046_length_237_cov_2.186170_g2983_i0 | PRJNA283169 | 3046 | 237 | 2.18617 | 5.1812229 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 58.9 | 4.21e-8 | NR | MBL9207032.1 | 2006848 | g2983 | i0 | 52.7 | 0.69620253164557 | 55 | 26 | 69.6 | 0 | 185 | 21 | 1 | 55 | MBL9207032.1 GNAT family N-acetyltransferase [Opitutaceae bacterium] | diamond | 165 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30295700 | 30295700 | PRJNA283169_P_NODE_2112_length_282_cov_0.875536_g2050_i0 | PRJNA283169 | 2112 | 282 | 0.875536 | 2.46901152 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 72.4 | 2.17e-12 | NR | MDB6120228.1 | 2026800 | g2050 | i0 | 77.1 | 0.51063829787234 | 48 | 11 | 51.1 | 0 | 275 | 132 | 691 | 738 | MDB6120228.1 glycosyl transferase group 1 [Verrucomicrobiaceae bacterium] | diamond | 144 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30327397 | 30327397 | PRJNA283169_P_NODE_4372_length_202_cov_0.980392_g4309_i0 | PRJNA283169 | 4372 | 202 | 0.980392 | 1.98039184 | Limisphaera sp. | 2838792 | Bacteria | Bacteria | 80.9 | 8.05e-16 | NR | MCS7090330.1 | 2838792 | g4309 | i0 | 62.7 | 3.98019801980198 | 67 | 24 | 99.5 | 1 | 2 | 202 | 65 | 130 | MCS7090330.1 hypothetical protein [Limisphaera sp.] | diamond | 804 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaeraceae | Limisphaera | Limisphaera sp. | |
| 31622698 | 31622698 | PRJNA283169_S_NODE_1756_length_210_cov_0.093168_g1742_i0 | PRJNA283169 | 1756 | 210 | 0.093168 | 0.1956528 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 42.4 | 0.00879 | NR | HYZ72762.1 | 2201154 | g1742 | i0 | 38.9 | 1.02857142857143 | 72 | 38 | 94.3 | 2 | 1 | 198 | 27 | 98 | HYZ72762.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 216 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32273360 | 32273360 | PRJNA283169_P_NODE_7218_length_165_cov_0.896552_g7155_i0 | PRJNA283169 | 7218 | 165 | 0.896552 | 1.4793108 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 102 | 3e-24 | NR | MSU62835.1 | 2024890 | g7155 | i0 | 83.6 | 5 | 55 | 9 | 100 | 0 | 1 | 165 | 197 | 251 | MSU62835.1 hypothetical protein [Pedosphaera sp.] | diamond | 825 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 32823781 | 32823781 | PRJNA283169_P_NODE_4300_length_203_cov_1.077922_g4237_i0 | PRJNA283169 | 4300 | 203 | 1.077922 | 2.18818166 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 47.8 | 3.77e-4 | NR | HXP82587.1 | 2499141 | g4237 | i0 | 39.3 | 0.901477832512315 | 61 | 36 | 90.1 | 1 | 14 | 196 | 43 | 102 | HXP82587.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 183 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia 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);;