contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15057895 | 15057895 | PRJNA1126198_P_NODE_199752_length_293_cov_0.909091_g199032_i0 | PRJNA1126198 | 199752 | 293 | 0.909091 | 2.66363663 | PVC group | 1783257 | Bacteria | Bacteria | 128 | 4.3899999999999995e-25 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g199032 | i0 | 81.699 | 20.4505119453925 | 153 | 28 | 52 | 0 | 3 | 155 | 3317499 | 3317651 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 5992 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 15583947 | 15583947 | PRJNA1126198_P_NODE_116613_length_331_cov_1.790698_g115894_i0 | PRJNA1126198 | 116613 | 331 | 1.790698 | 5.92721038 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 298 | 3.63e-76 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g115894 | i0 | 83.234 | 143.546827794562 | 334 | 46 | 100 | 8 | 1 | 331 | 276759 | 276433 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 47514 | 298 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 18132761 | 18132761 | PRJNA1126198_P_NODE_100675_length_342_cov_1.457249_g99956_i0 | PRJNA1126198 | 100675 | 342 | 1.457249 | 4.98379158 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 246 | 1.38e-60 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g99956 | i0 | 93.373 | 78.7251461988304 | 166 | 11 | 49 | 0 | 177 | 342 | 3261422 | 3261587 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 26924 | 246 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 18133254 | 18133254 | PRJNA1126198_P_NODE_373735_length_251_cov_1.629213_g373014_i0 | PRJNA1126198 | 373735 | 251 | 1.629213 | 4.08932463 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 65.8 | 2.92e-6 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g373014 | i0 | 97.368 | 3.70517928286853 | 38 | 1 | 15 | 0 | 171 | 208 | 3512617 | 3512580 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 930 | 65.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 19407403 | 19407403 | PRJNA1126198_P_NODE_368336_length_252_cov_0.871508_g367615_i0 | PRJNA1126198 | 368336 | 252 | 0.871508 | 2.19620016 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 226 | 1.2699999999999999e-54 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g367615 | i0 | 86.473 | 11.6428571428571 | 207 | 26 | 82 | 2 | 7 | 212 | 318241 | 318446 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 2934 | 226 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 21958415 | 21958415 | PRJNA1126198_P_NODE_406358_length_248_cov_0.891429_g405637_i0 | PRJNA1126198 | 406358 | 248 | 0.891429 | 2.21074392 | Congregicoccus parvus | 3081749 | Bacteria | Bacteria | 73.1 | 1.72e-8 | NTclustered | gi|2599616993|dbj|AP028972.1| | 3081749 | g405637 | i0 | 95.556 | 0.181451612903226 | 45 | 2 | 18 | 0 | 1 | 45 | 489189 | 489233 | Opitutales bacterium ASA1 DNA, complete genome | blastn | 45 | 73.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Alterococcaceae | Congregicoccus | Congregicoccus parvus |
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);;