contig_metadata
6 rows where bioproject = "PRJEB673", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9062147 | 9062147 | PRJEB673_P_NODE_1228_length_850_cov_8.323926_g1019_i0 | PRJEB673 | 1228 | 850 | 8.323926 | 70.753371 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 1352 | 0 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g1019 | i0 | 96.569 | 279.321176470588 | 816 | 28 | 96 | 0 | 1 | 816 | 4717234 | 4716419 | Luteolibacter sp. SL250 chromosome | blastn | 237423 | 1352 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 10337986 | 10337986 | PRJEB673_P_NODE_6589_length_338_cov_2.917492_g6240_i0 | PRJEB673 | 6589 | 338 | 2.917492 | 9.86112296 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 508 | 1.58e-139 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g6240 | i0 | 93.787 | 102.062130177515 | 338 | 21 | 100 | 0 | 1 | 338 | 3261715 | 3261378 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 34497 | 508 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 18846973 | 18846973 | PRJEB673_P_NODE_5835_length_364_cov_5.939210_g5486_i0 | PRJEB673 | 5835 | 364 | 5.93921 | 21.6187244 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 468 | 2.89e-127 | NTclustered | gi|2647781590|dbj|AP024702.1| | 490095 | g5486 | i0 | 91.74 | 392.796703296703 | 339 | 24 | 93 | 4 | 1 | 337 | 775555 | 775891 | Haloferula helveola CN-1 DNA, complete genome | blastn | 142978 | 470 | 0.995744680851064 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 27571201 | 27571201 | PRJEB673_P_NODE_12104_length_156_cov_1.322314_g11755_i0 | PRJEB673 | 12104 | 156 | 1.322314 | 2.06280984 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 60.5 | 6.49e-9 | NR | MDH4372957.1 | 2026799 | g11755 | i0 | 54.9 | 0.980769230769231 | 51 | 23 | 98.1 | 0 | 156 | 4 | 552 | 602 | MDH4372957.1 glycosyltransferase [Verrucomicrobiota bacterium] | diamond | 153 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31962250 | 31962250 | PRJEB673_P_NODE_12418_length_154_cov_1.008403_g12069_i0 | PRJEB673 | 12418 | 154 | 1.008403 | 1.55294062 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 79 | 1.22e-15 | NR | WP_322282923.1 | 1965333 | g12069 | i0 | 75.5 | 5.68831168831169 | 49 | 12 | 95.5 | 0 | 3 | 149 | 265 | 313 | WP_322282923.1 alkene reductase [Prosthecobacter sp.] | diamond | 876 | 79 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32057191 | 32057191 | PRJEB673_P_NODE_3698_length_518_cov_1.418219_g3371_i0 | PRJEB673 | 3698 | 518 | 1.418219 | 7.34637442 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 131 | 3.0999999999999996e-32 | NR | MBL9134577.1 | 2026801 | g3371 | i0 | 76.5 | 4.22200772200772 | 81 | 19 | 46.9 | 0 | 274 | 516 | 363 | 443 | MBL9134577.1 phosphoenolpyruvate carboxykinase (ATP) [Verrucomicrobiales bacterium] | diamond | 2187 | 131 | 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);;