contig_metadata
11 rows where bioproject = "PRJEB673" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134868 | 134868 | PRJEB673_P_NODE_10001_length_182_cov_3.877551_g9652_i0 | PRJEB673 | 10001 | 182 | 3.877551 | 7.05714282 | Myxococcus sp. 116781 | 422003 | Bacteria | Bacteria | 292 | 8.38e-75 | NTclustered | gi|152956905|emb|AM489521.1| | 422003 | g9652 | i0 | 95.604 | 114.016483516484 | 182 | 8 | 100 | 0 | 1 | 182 | 191 | 10 | Myxococcus sp. 116781 partial 16S rRNA gene, strain 116781 | blastn | 20751 | 292 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. 116781 | ||
| 1409434 | 1409434 | PRJEB673_P_NODE_10682_length_170_cov_1.481481_g10333_i0 | PRJEB673 | 10682 | 170 | 1.481481 | 2.5185177 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 99 | 1.8e-16 | NTclustered | gi|1950807334|gb|CP066680.1| | 2026735 | g10333 | i0 | 82.759 | 0.682352941176471 | 116 | 14 | 66 | 6 | 58 | 170 | 309485 | 309373 | MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome | blastn | 116 | 99 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 2270418 | 2270418 | PRJEB673_P_NODE_4262_length_467_cov_4.111111_g3919_i0 | PRJEB673 | 4262 | 467 | 4.111111 | 19.19888837 | Archangiaceae | 39 | Bacteria | Bacteria | 636 | 9.849999999999997e-178 | NTclustered | gi|2244675|emb|X87291.1| | 41 | g3919 | i0 | 92.551 | 240.706638115632 | 443 | 33 | 95 | 0 | 10 | 452 | 1164 | 722 | S.aurantiaca 23S rRNA gene | blastn | 112410 | 641 | 0.992199687987519 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 4823356 | 4823356 | PRJEB673_P_NODE_1304_length_830_cov_1.938365_g1088_i0 | PRJEB673 | 1304 | 830 | 1.938365 | 16.0884295 | Stigmatella | 40 | Bacteria | Bacteria | 1062 | 0 | NTclustered | gi|507148216|ref|NR_103023.1| | 41 | g1088 | i0 | 89.94 | 250.24578313253 | 835 | 68 | 99 | 12 | 1 | 828 | 848 | 23 | Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence | blastn | 207704 | 1062 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 6098476 | 6098476 | PRJEB673_P_NODE_2245_length_650_cov_2.276423_g1968_i0 | PRJEB673 | 2245 | 650 | 2.276423 | 14.7967495 | Stigmatella | 40 | Bacteria | Bacteria | 824 | 0 | NTclustered | gi|507148216|ref|NR_103023.1| | 41 | g1968 | i0 | 89.124 | 201.524615384615 | 662 | 52 | 100 | 16 | 1 | 650 | 1870 | 1217 | Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence | blastn | 130991 | 824 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 9062172 | 9062172 | PRJEB673_P_NODE_2328_length_641_cov_1.719472_g2047_i0 | PRJEB673 | 2328 | 641 | 1.719472 | 11.02181552 | Myxococcales | 29 | Bacteria | Bacteria | 63.5 | 1e-7 | NR | MBL8934140.1 | 1872627 | g2047 | i0 | 63.6 | 1.2402496099844 | 44 | 16 | 20.6 | 0 | 638 | 507 | 470 | 513 | MBL8934140.1 hypothetical protein [Archangium sp.] | diamond | 795 | 63.9 | 0.993740219092332 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 12474238 | 12474238 | PRJEB673_P_NODE_5550_length_377_cov_1.216374_g5201_i0 | PRJEB673 | 5550 | 377 | 1.216374 | 4.58572998 | Myxococcus | 32 | Bacteria | Bacteria | 472 | 2.3299999999999996e-128 | NTclustered | gi|1691485482|gb|CP017169.1| | 34 | g5201 | i0 | 89.628 | 253.440318302387 | 376 | 32 | 99 | 6 | 5 | 377 | 373664 | 373293 | Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome | blastn | 95547 | 472 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 25221450 | 25221450 | PRJEB673_P_NODE_8220_length_291_cov_2.718750_g7871_i0 | PRJEB673 | 8220 | 291 | 2.71875 | 7.9115625 | Myxococcales | 29 | Bacteria | Bacteria | 425 | 1.38e-114 | NTclustered | gi|470488931|ref|NR_076895.1| | 33 | g7871 | i0 | 93.127 | 279.426116838488 | 291 | 18 | 100 | 2 | 1 | 291 | 2953 | 2665 | Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence | blastn | 81313 | 425 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 27761005 | 27761005 | PRJEB673_P_NODE_4184_length_475_cov_1.984091_g3844_i0 | PRJEB673 | 4184 | 475 | 1.984091 | 9.42443225 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 53.5 | 7.36e-5 | NR | MDR0965324.1 | 2026763 | g3844 | i0 | 51.1 | 1.13684210526316 | 45 | 20 | 27.2 | 2 | 464 | 336 | 54 | 98 | MDR0965324.1 hypothetical protein [Myxococcales bacterium] | diamond | 540 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29458199 | 29458199 | PRJEB673_P_NODE_11290_length_162_cov_2.874016_g10941_i0 | PRJEB673 | 11290 | 162 | 2.874016 | 4.65590592 | root | 1 | Root_unresolved | Root_unresolved | 83.2 | 5.72e-19 | NR | MCA9640749.1 | 2026763 | g10941 | i0 | 82.7 | 6.85185185185185 | 52 | 9 | 96.3 | 0 | 5 | 160 | 54 | 105 | MCA9640749.1 hypothetical protein [Myxococcales bacterium] | diamond | 1110 | 83.6 | 0.995215311004785 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31677518 | 31677518 | PRJEB673_P_NODE_9197_length_207_cov_1.395349_g8848_i0 | PRJEB673 | 9197 | 207 | 1.395349 | 2.88837243 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 100 | 9.68e-23 | NR | MBN1655723.1 | 2026735 | g8848 | i0 | 70.1 | 0.971014492753623 | 67 | 20 | 97.1 | 0 | 205 | 5 | 280 | 346 | MBN1655723.1 ATP-dependent protease ATPase subunit HslU [Deltaproteobacteria bacterium] | diamond | 201 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium |
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);;