contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2459988 | 2459988 | PRJNA703759_P_NODE_14862_length_351_cov_1.122302_g14386_i0 | PRJNA703759 | 14862 | 351 | 1.122302 | 3.93928002 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 121 | 8.959999999999999e-23 | NTclustered | gi|226525288|gb|FJ872373.1| | 156588 | g14386 | i0 | 91.111 | 10.5754985754986 | 90 | 6 | 25 | 2 | 2 | 90 | 17047 | 16959 | Uncultured Verrucomicrobia bacterium clone 118 genomic sequence | blastn | 3712 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 3235732 | 3235732 | PRJNA703759_P_NODE_44823_length_246_cov_0.901734_g44347_i0 | PRJNA703759 | 44823 | 246 | 0.901734 | 2.21826564 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 159 | 1.27e-34 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g44347 | i0 | 81.407 | 30.6869918699187 | 199 | 33 | 80 | 4 | 31 | 227 | 574406 | 574210 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 7549 | 159 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 3235818 | 3235818 | PRJNA703759_P_NODE_48323_length_244_cov_0.912281_g47847_i0 | PRJNA703759 | 48323 | 244 | 0.912281 | 2.22596564 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 124 | 4.599999999999999e-24 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g47847 | i0 | 96.104 | 2.92213114754098 | 77 | 2 | 32 | 1 | 39 | 115 | 485713 | 485638 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 713 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 3736770 | 3736770 | PRJNA703759_P_NODE_51843_length_237_cov_2.292683_g51367_i0 | PRJNA703759 | 51843 | 237 | 2.292683 | 5.43365871 | Verrucomicrobium | 2735 | Bacteria | Bacteria | 392 | 1.0999999999999999e-104 | NTclustered | gi|242246546|emb|FN424008.1| | 114704 | g51367 | i0 | 97.403 | 95.5400843881856 | 231 | 4 | 97 | 2 | 1 | 230 | 282 | 53 | Uncultured Verrucomicrobium sp. partial 16S rRNA gene, clone Paila10-57 | blastn | 22643 | 392 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | uncultured Verrucomicrobium sp. | |
| 9612479 | 9612479 | PRJNA703759_P_NODE_14528_length_354_cov_1.590747_g14052_i0 | PRJNA703759 | 14528 | 354 | 1.590747 | 5.63124438 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 204 | 8.74e-48 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g14052 | i0 | 78.797 | 2.67796610169492 | 316 | 58 | 88 | 8 | 44 | 354 | 4139013 | 4139324 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 948 | 204 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 10888760 | 10888760 | PRJNA703759_P_NODE_43009_length_247_cov_0.896552_g42533_i0 | PRJNA703759 | 43009 | 247 | 0.896552 | 2.21448344 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 191 | 4.53e-44 | NTclustered | gi|1815841271|gb|CP049143.1| | 2711231 | g42533 | i0 | 82.143 | 1.91093117408907 | 224 | 38 | 90 | 2 | 19 | 241 | 5846309 | 5846531 | Roseimicrobium sp. ORNL1 chromosome, complete genome | blastn | 472 | 191 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 |
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);;