contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA680334" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3721141 | 3721141 | PRJNA680334_S_NODE_82443_length_163_cov_4.753846_g81957_i0 | PRJNA680334 | 82443 | 163 | 4.753846 | 7.74876898 | Verrucomicrobium | 2735 | Bacteria | Bacteria | 200 | 4.589999999999999e-47 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g81957 | i0 | 89.441 | 168.39263803681 | 161 | 14 | 98 | 2 | 1 | 159 | 347 | 506 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 27448 | 200 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 7027911 | 7027911 | PRJNA680334_S_NODE_15246_length_276_cov_8.242798_g14760_i0 | PRJNA680334 | 15246 | 276 | 8.242798 | 22.75012248 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 196 | 1.11e-45 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g14760 | i0 | 80.135 | 1.07608695652174 | 297 | 31 | 99 | 18 | 1 | 273 | 1818519 | 1818811 | Luteolibacter sp. SL250 chromosome | blastn | 297 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 8303756 | 8303756 | PRJNA680334_S_NODE_84007_length_162_cov_4.775194_g83521_i0 | PRJNA680334 | 84007 | 162 | 4.775194 | 7.73581428 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 220 | 3.49e-53 | NTclustered | gi|12583975|gb|AF245379.1|AF245379 | 48466 | g83521 | i0 | 91.772 | 278.530864197531 | 158 | 13 | 98 | 0 | 5 | 162 | 2190 | 2347 | Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence | blastn | 45122 | 220 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 17227585 | 17227585 | PRJNA680334_S_NODE_30554_length_223_cov_6.284211_g30068_i0 | PRJNA680334 | 30554 | 223 | 6.284211 | 14.01379053 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 351 | 1.74e-92 | NTclustered | gi|2836248208|gb|CP121322.1| | 1962973 | g30068 | i0 | 95.853 | 199.856502242152 | 217 | 9 | 97 | 0 | 7 | 223 | 1009882 | 1010098 | MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome | blastn | 44568 | 351 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 18501351 | 18501351 | PRJNA680334_S_NODE_10115_length_313_cov_7.096429_g9629_i0 | PRJNA680334 | 10115 | 313 | 7.096429 | 22.21182277 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 217 | 9.81e-52 | NTclustered | gi|1815841271|gb|CP049143.1| | 2711231 | g9629 | i0 | 80 | 47.3546325878594 | 320 | 42 | 97 | 19 | 1 | 305 | 5627106 | 5627418 | Roseimicrobium sp. ORNL1 chromosome, complete genome | blastn | 14822 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 19776154 | 19776154 | PRJNA680334_S_NODE_16676_length_269_cov_3.169492_g16190_i0 | PRJNA680334 | 16676 | 269 | 3.169492 | 8.52593348 | Prosthecobacter dejongeii | 48465 | Bacteria | Bacteria | 268 | 2.2499999999999994e-67 | NTclustered | gi|183579826|emb|AM905423.1| | 48465 | g16190 | i0 | 84.982 | 285.650557620818 | 273 | 32 | 100 | 7 | 1 | 269 | 1346 | 1079 | Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251 | blastn | 76840 | 268 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter dejongeii |
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);;