contig_metadata
11 rows where bioproject = "PRJNA930380", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909391 | 909391 | PRJNA930380_P_NODE_13361_length_244_cov_1.754386_g13308_i0 | PRJNA930380 | 13361 | 244 | 1.754386 | 4.28070184 | Lactobacillus iners | 147802 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|2769739957|gb|CP160078.1| | 147802 | g13308 | i0 | 100 | 13 | 244 | 0 | 100 | 0 | 1 | 244 | 630222 | 629979 | Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome | blastn | 3172 | 451 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Lactobacillus | Lactobacillus iners | ||
| 3460233 | 3460233 | PRJNA930380_P_NODE_13723_length_243_cov_0.905882_g13670_i0 | PRJNA930380 | 13723 | 243 | 0.905882 | 2.20129326 | Lactobacillus iners | 147802 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|2769739957|gb|CP160078.1| | 147802 | g13670 | i0 | 100 | 482.934156378601 | 243 | 0 | 100 | 0 | 1 | 243 | 2614 | 2372 | Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome | blastn | 117353 | 449 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Lactobacillus | Lactobacillus iners | ||
| 4737728 | 4737728 | PRJNA930380_P_NODE_14304_length_241_cov_0.916667_g14251_i0 | PRJNA930380 | 14304 | 241 | 0.916667 | 2.20916747 | Enterococcus faecalis | 1351 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|2236315023|gb|CP097042.1| | 1351 | g14251 | i0 | 100 | 100 | 241 | 0 | 100 | 0 | 1 | 241 | 2059909 | 2060149 | Enterococcus faecalis strain AT34 chromosome, complete genome | blastn | 24100 | 446 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecalis | ||
| 7287552 | 7287552 | PRJNA930380_P_NODE_6046_length_291_cov_1.412844_g5993_i0 | PRJNA930380 | 6046 | 291 | 1.412844 | 4.11137604 | Peptococcus niger | 2741 | Bacteria | Bacteria | 322 | 1.86e-83 | NTclustered | gi|288511|emb|X68428.1| | 2741 | g5993 | i0 | 88.806 | 312.460481099656 | 268 | 23 | 91 | 4 | 25 | 290 | 1244 | 1506 | P.niger gene for 23S rRNA | blastn | 90926 | 322 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Peptococcaceae | Peptococcus | Peptococcus niger | ||
| 12388639 | 12388639 | PRJNA930380_P_NODE_8350_length_281_cov_1.086538_g8297_i0 | PRJNA930380 | 8350 | 281 | 1.086538 | 3.05317178 | Lactobacillus iners | 147802 | Bacteria | Bacteria | 520 | 5.909999999999999e-143 | NTclustered | gi|2769739957|gb|CP160078.1| | 147802 | g8297 | i0 | 100 | 489.224199288256 | 281 | 0 | 100 | 0 | 1 | 281 | 3374 | 3094 | Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome | blastn | 137472 | 520 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Lactobacillus | Lactobacillus iners | ||
| 16557445 | 16557445 | PRJNA930380_P_NODE_9613_length_273_cov_2.075000_g9560_i0 | PRJNA930380 | 9613 | 273 | 2.075 | 5.66475 | Streptococcus | 1301 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|1539699848|emb|LR134265.1| | 1311 | g9560 | i0 | 100 | 6.15384615384615 | 28 | 0 | 10 | 0 | 125 | 152 | 1435754 | 1435781 | Streptococcus agalactiae strain NCTC8184 genome assembly, chromosome: 1 | blastn | 1680 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus agalactiae | ||
| 21311443 | 21311443 | PRJNA930380_P_NODE_13837_length_243_cov_0.905882_g13784_i0 | PRJNA930380 | 13837 | 243 | 0.905882 | 2.20129326 | Ruthenibacterium sp. | 1905345 | Bacteria | Bacteria | 70.1 | 1.02e-13 | NR | MEG2435696.1 | 1905345 | g13784 | i0 | 70.4 | 0.666666666666667 | 54 | 15 | 66.7 | 1 | 219 | 58 | 24 | 76 | MEG2435696.1 hypothetical protein [Ruthenibacterium sp.] | diamond | 162 | 70.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Ruthenibacterium | Ruthenibacterium sp. | ||
| 26613234 | 26613234 | PRJNA930380_P_NODE_10681_length_263_cov_1.484211_g10628_i0 | PRJNA930380 | 10681 | 263 | 1.484211 | 3.90347493 | Polycladomyces zharkentensis | 2807616 | Bacteria | Bacteria | 43.1 | 0.0351 | NR | WP_205492801.1 | 2807616 | g10628 | i0 | 31.9 | 0.821292775665399 | 72 | 39 | 70.7 | 2 | 213 | 28 | 1 | 72 | WP_205492801.1 DNA internalization-related competence protein ComEC/Rec2 [Polycladomyces zharkentensis] | diamond | 216 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Thermoactinomycetaceae | Polycladomyces | Polycladomyces zharkentensis | ||
| 27688786 | 27688786 | PRJNA930380_P_NODE_4744_length_302_cov_3.401747_g4691_i0 | PRJNA930380 | 4744 | 302 | 3.401747 | 10.27327594 | Brockia lithotrophica | 933949 | Bacteria | Bacteria | 43.5 | 0.00591 | NR | MBE3550665.1 | 933949 | g4691 | i0 | 44.7 | 0.754966887417219 | 38 | 21 | 37.7 | 0 | 158 | 271 | 29 | 66 | MBE3550665.1 hypothetical protein [Brockia lithotrophica] | diamond | 228 | 43.5 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillales Family X. Incertae Sedis | Brockia | Brockia lithotrophica | ||
| 30948468 | 30948468 | PRJNA930380_P_NODE_8114_length_282_cov_1.129187_g8061_i0 | PRJNA930380 | 8114 | 282 | 1.129187 | 3.18430734 | root | 1 | Root_unresolved | Root_unresolved | 54.3 | 5.04e-6 | NR | WP_330942623.1 | 1328 | g8061 | i0 | 40.9 | 7.02127659574468 | 66 | 37 | 68.1 | 1 | 69 | 260 | 429 | 494 | WP_330942623.1 reverse transcriptase domain-containing protein, partial [Streptococcus anginosus] | diamond | 1980 | 54.7 | 0.992687385740402 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus anginosus | ||
| 31099058 | 31099058 | PRJNA930380_P_NODE_11795_length_250_cov_0.870056_g11742_i0 | PRJNA930380 | 11795 | 250 | 0.870056 | 2.17514 | Terrisporobacter sp. | 1965305 | Bacteria | Bacteria | 50.4 | 9.49e-6 | NR | MEG1411258.1 | 1965305 | g11742 | i0 | 76.7 | 0.36 | 30 | 7 | 36 | 0 | 90 | 1 | 1 | 30 | MEG1411258.1 hypothetical protein [Terrisporobacter sp.] | diamond | 90 | 50.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Terrisporobacter | Terrisporobacter sp. |
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);;