metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax_phylum = "Myxococcota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2082175	2082175	PRJNA807685_P_NODE_1822_length_3487_cov_3.486377_g1503_i0	PRJNA807685	1822	3487	3.486377	121.56996599	Sorangium cellulosum	56	Bacteria	Bacteria	734	0	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g1503	i0	80.384	26.998566102667	989	174	28	17	500	1479	3036095	3035118	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	94144	734	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
2082436	2082436	PRJNA807685_P_NODE_53922_length_166_cov_1.868217_g52849_i0	PRJNA807685	53922	166	1.868217	3.10124022	Minicystis rosea	888845	Bacteria	Bacteria	150	4.79e-32	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g52849	i0	83.234	1.00602409638554	167	24	99	4	2	166	9724323	9724159	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	167	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
2498333	2498333	PRJNA807685_P_NODE_4242_length_1189_cov_2.292535_g3574_i0	PRJNA807685	4242	1189	2.292535	27.25824115	Polyangiaceae	49	Bacteria	Bacteria	704	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g3574	i0	78.232	50.8015138772077	1199	192	98	56	2	1161	6181018	6182186	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	60403	706	0.997167138810198	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3357458	3357458	PRJNA807685_P_NODE_32903_length_220_cov_1.273224_g31830_i0	PRJNA807685	32903	220	1.273224	2.8010928	Labilithrix luteola	1391654	Bacteria	Bacteria	274	3.82e-69	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g31830	i0	89.401	3.62727272727273	217	23	99	0	1	217	813589	813373	Labilithrix luteola strain DSM 27648, complete genome	blastn	798	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4635084	4635084	PRJNA807685_P_NODE_47644_length_177_cov_1.257143_g46571_i0	PRJNA807685	47644	177	1.257143	2.22514311	Chondromyces crocatus	52	Bacteria	Bacteria	274	2.93e-69	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g46571	i0	96.933	151.254237288136	163	5	92	0	15	177	1431846	1432008	Chondromyces crocatus strain Cm c5, complete genome	blastn	26772	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
5909956	5909956	PRJNA807685_P_NODE_3505_length_1484_cov_2.756738_g2952_i0	PRJNA807685	3505	1484	2.756738	40.90999192	Stigmatella aurantiaca	41	Bacteria	Bacteria	649	0	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g2952	i0	76.656	24.2270889487871	1208	261	81	19	2	1197	4685967	4687165	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	35953	649	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
16108793	16108793	PRJNA807685_P_NODE_11373_length_482_cov_1.220225_g10318_i0	PRJNA807685	11373	482	1.220225	5.8814845	Minicystis rosea	888845	Bacteria	Bacteria	348	5.35e-91	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g10318	i0	82.31	56.9066390041494	407	66	84	6	52	455	196139	196542	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	27429	348	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
23759270	23759270	PRJNA807685_P_NODE_51779_length_170_cov_0.834586_g50706_i0	PRJNA807685	51779	170	0.834586	1.4187962	Sorangium cellulosum	56	Bacteria	Bacteria	278	2.15e-70	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g50706	i0	96.429	31.9352941176471	168	6	99	0	1	168	6070106	6069939	Sorangium cellulosum 'So ce 56' complete genome	blastn	5429	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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);;