contig_metadata
9 rows where bioproject = "PRJNA1022587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162662 | 162662 | PRJNA1022587_S_NODE_301_length_408_cov_2.585075_g299_i0 | PRJNA1022587 | 301 | 408 | 2.585075 | 10.547106 | Allobaculum sp. Allo2 | 2853432 | Bacteria | Bacteria | 466 | 1.18e-126 | NTclustered | gi|2212771376|gb|CP078088.1| | 2853432 | g299 | i0 | 87.561 | 168.830882352941 | 410 | 42 | 100 | 5 | 1 | 408 | 743946 | 743544 | Allobaculum sp. Allo2 chromosome, complete genome | blastn | 68883 | 466 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Allobaculum | Allobaculum sp. Allo2 | ||
| 2279329 | 2279329 | PRJNA1022587_S_NODE_982_length_275_cov_1.138614_g980_i0 | PRJNA1022587 | 982 | 275 | 1.138614 | 3.1311885 | Ligilactobacillus | 2767887 | Bacteria | Bacteria | 507 | 4.49e-139 | NTclustered | gi|1809148386|gb|CP040852.1| | 1622 | g980 | i0 | 100 | 174.178181818182 | 274 | 0 | 99 | 0 | 2 | 275 | 1077414 | 1077141 | Ligilactobacillus murinus strain V10 chromosome, complete genome | blastn | 47899 | 507 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Ligilactobacillus | Ligilactobacillus murinus | ||
| 3554660 | 3554660 | PRJNA1022587_S_NODE_1223_length_254_cov_1.480663_g1221_i0 | PRJNA1022587 | 1223 | 254 | 1.480663 | 3.76088402 | root | 1 | Root_unresolved | Root_unresolved | 470 | 5.37e-128 | NTclustered | gi|1720595190|gb|CP031776.1| | 1404 | g1221 | i0 | 100 | 185.614173228346 | 254 | 0 | 100 | 0 | 1 | 254 | 6150510 | 6150763 | Priestia megaterium strain Ni2-3 chromosome | blastn | 47146 | 470 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Priestia | Priestia megaterium | ||
| 3554662 | 3554662 | PRJNA1022587_S_NODE_1383_length_247_cov_0.885057_g1381_i0 | PRJNA1022587 | 1383 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.05e-124 | NTclustered | gi|1796975023|gb|CP033086.1| | 1280 | g1381 | i0 | 100 | 43.668016194332 | 247 | 0 | 100 | 0 | 1 | 247 | 2426470 | 2426716 | Staphylococcus aureus strain WH9628 chromosome | blastn | 10786 | 457 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 3554667 | 3554667 | PRJNA1022587_S_NODE_523_length_337_cov_1.537879_g521_i0 | PRJNA1022587 | 523 | 337 | 1.537879 | 5.18265223 | Ligilactobacillus | 2767887 | Bacteria | Bacteria | 623 | 5.369999999999999e-174 | NTclustered | gi|2533431055|gb|CP129339.1| | 1605 | g521 | i0 | 100 | 641.878338278932 | 337 | 0 | 100 | 0 | 1 | 337 | 1368154 | 1368490 | Ligilactobacillus animalis strain SRCM217969 chromosome, complete genome | blastn | 216313 | 623 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Ligilactobacillus | Ligilactobacillus animalis | ||
| 7815254 | 7815254 | PRJNA1022587_S_NODE_307_length_407_cov_1.568862_g305_i0 | PRJNA1022587 | 307 | 407 | 1.568862 | 6.38526834 | Erysipelotrichaceae bacterium ASTB_g | 3027452 | Bacteria | Bacteria | 477 | 5.439999999999998e-130 | NTclustered | gi|2556949764|gb|CP117813.1| | 3027452 | g305 | i0 | 87.893 | 505.461916461916 | 413 | 40 | 99 | 10 | 2 | 407 | 81483 | 81074 | Erysipelotrichaceae bacterium ASTB_g chromosome, complete genome | blastn | 205723 | 477 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Erysipelotrichaceae bacterium ASTB_g | |||
| 8657277 | 8657277 | PRJNA1022587_S_NODE_227_length_444_cov_1.571429_g225_i0 | PRJNA1022587 | 227 | 444 | 1.571429 | 6.97714476 | Ligilactobacillus | 2767887 | Bacteria | Bacteria | 811 | 0 | NTclustered | gi|2533431055|gb|CP129339.1| | 1605 | g225 | i0 | 99.774 | 584.002252252252 | 442 | 1 | 99 | 0 | 3 | 444 | 470777 | 470336 | Ligilactobacillus animalis strain SRCM217969 chromosome, complete genome | blastn | 259297 | 811 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillaceae | Ligilactobacillus | Ligilactobacillus animalis | ||
| 11641285 | 11641285 | PRJNA1022587_S_NODE_30_length_930_cov_4.585764_g28_i0 | PRJNA1022587 | 30 | 930 | 4.585764 | 42.6476052 | Allobaculum sp. Allo2 | 2853432 | Bacteria | Bacteria | 1382 | 0 | NTclustered | gi|2212771376|gb|CP078088.1| | 2853432 | g28 | i0 | 93.576 | 591.315053763441 | 934 | 49 | 99 | 10 | 2 | 930 | 2440134 | 2441061 | Allobaculum sp. Allo2 chromosome, complete genome | blastn | 549923 | 1382 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Allobaculum | Allobaculum sp. Allo2 | ||
| 15465461 | 15465461 | PRJNA1022587_S_NODE_1173_length_259_cov_0.962366_g1171_i0 | PRJNA1022587 | 1173 | 259 | 0.962366 | 2.49252794 | Allobaculum sp. Allo2 | 2853432 | Bacteria | Bacteria | 158 | 4.859999999999999e-34 | NTclustered | gi|2212771376|gb|CP078088.1| | 2853432 | g1171 | i0 | 89.764 | 15.069498069498099 | 127 | 8 | 48 | 4 | 5 | 129 | 743579 | 743456 | Allobaculum sp. Allo2 chromosome, complete genome | blastn | 3903 | 158 | 1 | Bacteria | Bacillati | Bacillota | Erysipelotrichia | Erysipelotrichales | Erysipelotrichaceae | Allobaculum | Allobaculum sp. Allo2 |
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);;