contig_metadata
7 rows where bioproject = "PRJNA674050" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4471559 | 4471559 | PRJNA674050_P_NODE_21144_length_255_cov_1.521978_g20941_i0 | PRJNA674050 | 21144 | 255 | 1.521978 | 3.8810439 | Prosthecobacter algae | 1144682 | Bacteria | Bacteria | 472 | 1.5e-128 | NTclustered | gi|959494970|ref|NR_133826.1| | 1144682 | g20941 | i0 | 100 | 99.6941176470588 | 255 | 0 | 100 | 0 | 1 | 255 | 1271 | 1017 | Prosthecobacter algae strain EBTL04 16S ribosomal RNA, partial sequence | blastn | 25422 | 472 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter algae | |
| 7544232 | 7544232 | PRJNA674050_P_NODE_35126_length_244_cov_1.286550_g34923_i0 | PRJNA674050 | 35126 | 244 | 1.28655 | 3.139182 | Luteolibacter | 518753 | Bacteria | Bacteria | 427 | 3.13e-115 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g34923 | i0 | 98.354 | 286.790983606557 | 243 | 4 | 99 | 0 | 1 | 243 | 2217268 | 2217510 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 69977 | 427 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 27144563 | 27144563 | PRJNA674050_P_NODE_30302_length_247_cov_0.896552_g30099_i0 | PRJNA674050 | 30302 | 247 | 0.896552 | 2.21448344 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 102 | 5.5e-23 | NR | MCX6971249.1 | 2026799 | g30099 | i0 | 67.1 | 0.923076923076923 | 76 | 25 | 92.3 | 0 | 229 | 2 | 465 | 540 | MCX6971249.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 228 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28155783 | 28155783 | PRJNA674050_P_NODE_27165_length_249_cov_0.886364_g26962_i0 | PRJNA674050 | 27165 | 249 | 0.886364 | 2.20704636 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72.4 | 1.35e-12 | NR | MBI5773599.1 | 2026799 | g26962 | i0 | 79.1 | 0.518072289156627 | 43 | 9 | 51.8 | 0 | 248 | 120 | 145 | 187 | MBI5773599.1 DUF1080 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 129 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28850062 | 28850062 | PRJNA674050_P_NODE_26148_length_250_cov_0.875706_g25945_i0 | PRJNA674050 | 26148 | 250 | 0.875706 | 2.189265 | Phragmitibacter flavus | 2576071 | Bacteria | Bacteria | 161 | 2.31e-47 | NR | WP_138087427.1 | 2576071 | g25945 | i0 | 91.5 | 0.984 | 82 | 7 | 98.4 | 0 | 248 | 3 | 156 | 237 | WP_138087427.1 TatD family hydrolase [Phragmitibacter flavus] | diamond | 246 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Phragmitibacter | Phragmitibacter flavus | |
| 29418441 | 29418441 | PRJNA674050_P_NODE_8169_length_314_cov_1.253112_g7966_i0 | PRJNA674050 | 8169 | 314 | 1.253112 | 3.93477168 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 66.6 | 6.77e-11 | NR | HEX2861528.1 | 1961806 | g7966 | i0 | 50 | 0.764331210191083 | 80 | 39 | 76.4 | 1 | 73 | 312 | 23 | 101 | HEX2861528.1 hypothetical protein [Lacunisphaera sp.] | diamond | 240 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 31788321 | 31788321 | PRJNA674050_P_NODE_20657_length_256_cov_2.972678_g20454_i0 | PRJNA674050 | 20657 | 256 | 2.972678 | 7.61005568 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 50.8 | 3.77e-6 | NR | MDF1659962.1 | 2026801 | g20454 | i0 | 33.3 | 1.51171875 | 66 | 44 | 77.3 | 0 | 227 | 30 | 4 | 69 | MDF1659962.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 387 | 50.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);;