metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1143173" 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
4112920	4112920	PRJNA1143173_P_NODE_10504_length_310_cov_3.902954_g10478_i0	PRJNA1143173	10504	310	3.902954	12.0991574	Sorangium cellulosum	56	Bacteria	Bacteria	128	4.68e-25	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g10478	i0	82.877	8.16774193548387	146	21	46	4	7	150	8829826	8829969	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	2532	128	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4113027	4113027	PRJNA1143173_P_NODE_15024_length_298_cov_10.528889_g14998_i0	PRJNA1143173	15024	298	10.528889	31.37608922	Sorangium cellulosum	56	Bacteria	Bacteria	99	3.51e-16	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g14998	i0	87.209	4.51677852348993	86	11	29	0	213	298	1234470	1234555	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1346	99	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5389945	5389945	PRJNA1143173_P_NODE_7845_length_310_cov_8.451477_g7819_i0	PRJNA1143173	7845	310	8.451477	26.1995787	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	141	6.01e-29	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g7819	i0	75.532	11.1258064516129	282	54	97	14	6	280	1578136	1578409	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	3449	141	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6663823	6663823	PRJNA1143173_P_NODE_13126_length_299_cov_8.938053_g13100_i0	PRJNA1143173	13126	299	8.938053	26.72477847	Sorangium cellulosum	56	Bacteria	Bacteria	93.5	1.64e-14	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g13100	i0	78.621	4.18394648829431	145	27	48	4	4	146	11165285	11165427	Sorangium cellulosum So0157-2, complete genome	blastn	1251	93.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11765012	11765012	PRJNA1143173_P_NODE_31550_length_253_cov_4.838889_g31524_i0	PRJNA1143173	31550	253	4.838889	12.24238917	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	259	1.26e-64	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g31524	i0	85.259	7.5296442687747	251	37	99	0	3	253	11408971	11409221	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	1905	259	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
13040072	13040072	PRJNA1143173_P_NODE_31151_length_254_cov_5.408840_g31125_i0	PRJNA1143173	31151	254	5.40884	13.7384536	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	189	1.6799999999999996e-43	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g31125	i0	81.356	4.12992125984252	236	40	92	4	19	252	8882310	8882077	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1049	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15589527	15589527	PRJNA1143173_P_NODE_43873_length_202_cov_9.093023_g43847_i0	PRJNA1143173	43873	202	9.093023	18.36790646	Haliangium ochraceum	80816	Bacteria	Bacteria	126	1.02e-24	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g43847	i0	80	0.841584158415842	170	34	84	0	6	175	6809590	6809421	Haliangium ochraceum DSM 14365, complete genome	blastn	170	126	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
16863342	16863342	PRJNA1143173_P_NODE_26894_length_267_cov_1.412371_g26868_i0	PRJNA1143173	26894	267	1.412371	3.77103057	Pendulispora rubella	2741070	Bacteria	Bacteria	243	1.3500000000000004e-59	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g26868	i0	83.459	1.99250936329588	266	38	99	5	2	264	10205636	10205898	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	532	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16863607	16863607	PRJNA1143173_P_NODE_38594_length_231_cov_5.550633_g38568_i0	PRJNA1143173	38594	231	5.550633	12.82196223	Myxococcus sp. SDU36	2831967	Bacteria	Bacteria	388	1.39e-103	NTclustered	gi\|2513984958\|gb\|CP077414.1\|	2831967	g38568	i0	96.97	46.7705627705628	231	7	100	0	1	231	1240746	1240516	Myxococcus sp. SDU36 chromosome, complete genome	blastn	10804	388	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. SDU36
20688225	20688225	PRJNA1143173_P_NODE_7797_length_310_cov_8.632911_g7771_i0	PRJNA1143173	7797	310	8.632911	26.7620241	Pendulispora rubella	2741070	Bacteria	Bacteria	178	4.58e-40	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g7771	i0	92.683	19.141935483871	123	9	40	0	163	285	9449399	9449521	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	5934	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24512636	24512636	PRJNA1143173_P_NODE_7720_length_310_cov_9.084388_g7694_i0	PRJNA1143173	7720	310	9.084388	28.1616028	Labilithrix luteola	1391654	Bacteria	Bacteria	119	2.8200000000000003e-22	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7694	i0	82.482	0.658064516129032	137	22	44	2	8	143	8814146	8814011	Labilithrix luteola strain DSM 27648, complete genome	blastn	204	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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