contig_metadata
7 rows where bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3320818 | 3320818 | PRJNA788929_P_NODE_43263_length_238_cov_4.666667_g42602_i0 | PRJNA788929 | 43263 | 238 | 4.666667 | 11.10666746 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 126 | 1.24e-24 | NTclustered | gi|1815841271|gb|CP049143.1| | 2711231 | g42602 | i0 | 86.957 | 122.084033613445 | 115 | 11 | 48 | 3 | 23 | 137 | 5625796 | 5625686 | Roseimicrobium sp. ORNL1 chromosome, complete genome | blastn | 29056 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 9698055 | 9698055 | PRJNA788929_P_NODE_9068_length_604_cov_58.209040_g8417_i0 | PRJNA788929 | 9068 | 604 | 58.20904 | 351.5826016 | Prosthecobacter fusiformis | 48464 | Bacteria | Bacteria | 918 | 0 | NTclustered | gi|12583974|gb|AF245378.1|AF245378 | 48464 | g8417 | i0 | 96.092 | 242.081125827815 | 563 | 22 | 93 | 0 | 25 | 587 | 179 | 741 | Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence | blastn | 146217 | 918 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter fusiformis | |
| 18621069 | 18621069 | PRJNA788929_P_NODE_43795_length_235_cov_7.753086_g43134_i0 | PRJNA788929 | 43795 | 235 | 7.753086 | 18.2197521 | Ereboglobus luteus | 1796921 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|1387286769|gb|CP023004.1| | 1796921 | g43134 | i0 | 96.97 | 0.140425531914894 | 33 | 1 | 14 | 0 | 23 | 55 | 3303783 | 3303815 | Ereboglobus luteus strain Ho45, complete genome | blastn | 33 | 56.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Ereboglobus | Ereboglobus luteus | |
| 21172151 | 21172151 | PRJNA788929_P_NODE_47137_length_216_cov_9.958042_g46476_i0 | PRJNA788929 | 47137 | 216 | 9.958042 | 21.50937072 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 340 | 3.629999999999999e-89 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g46476 | i0 | 98.446 | 193.523148148148 | 193 | 3 | 89 | 0 | 23 | 215 | 3803649 | 3803841 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 41801 | 340 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 23722079 | 23722079 | PRJNA788929_P_NODE_23739_length_330_cov_21.182879_g23078_i0 | PRJNA788929 | 23739 | 330 | 21.182879 | 69.9035007 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 568 | 2.4899999999999995e-157 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g23078 | i0 | 100 | 252.345454545455 | 307 | 0 | 93 | 0 | 1 | 307 | 1966 | 2272 | Luteolibacter sp. SL250 chromosome | blastn | 83274 | 568 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 29011976 | 29011976 | PRJNA788929_P_NODE_31788_length_278_cov_9.507317_g31127_i0 | PRJNA788929 | 31788 | 278 | 9.507317 | 26.43034126 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 118 | 5.28e-29 | NR | MBJ7423871.1 | 2562705 | g31127 | i0 | 68.4 | 1.7158273381295 | 79 | 25 | 85.3 | 0 | 25 | 261 | 53 | 131 | MBJ7423871.1 condensation domain protein [Akkermansiaceae bacterium] | diamond | 477 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 30148290 | 30148290 | PRJNA788929_P_NODE_44372_length_232_cov_6.559748_g43711_i0 | PRJNA788929 | 44372 | 232 | 6.559748 | 15.21861536 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 90.5 | 7.68e-20 | NR | MEI7928632.1 | 2026801 | g43711 | i0 | 65.2 | 2.63793103448276 | 69 | 23 | 87.9 | 1 | 209 | 6 | 192 | 260 | MEI7928632.1 DUF692 family multinuclear iron-containing protein [Verrucomicrobiales bacterium] | diamond | 612 | 90.5 | 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);;