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

11 rows where analysis = "blastn", bioproject = "PRJNA421571" 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
422919	422919	PRJNA421571_P_NODE_38541_length_481_cov_1.352941_g35994_i0	PRJNA421571	38541	481	1.352941	6.50764621	Myxococcus stipitatus	83455	Bacteria	Bacteria	71.3	1.29e-7	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g35994	i0	92	0.162162162162162	50	4	10	0	432	481	6846749	6846700	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	78	71.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
1085996	1085996	PRJNA421571_P_NODE_63361_length_327_cov_1.149606_g60812_i0	PRJNA421571	63361	327	1.149606	3.75921162	Polyangiaceae	49	Bacteria	Bacteria	143	1.77e-29	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g60812	i0	75.658	5.1345565749235504	304	65	91	8	2	299	11677950	11678250	Sorangium cellulosum So0157-2, complete genome	blastn	1679	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4914347	4914347	PRJNA421571_P_NODE_88804_length_257_cov_1.255435_g86255_i0	PRJNA421571	88804	257	1.255435	3.22646795	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g86255	i0	100	0.217898832684825	28	0	11	0	80	107	5474407	5474380	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6188334	6188334	PRJNA421571_P_NODE_102325_length_244_cov_0.900585_g99776_i0	PRJNA421571	102325	244	0.900585	2.1974274	Myxococcales	29	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g99776	i0	97.131	99.8770491803279	244	7	100	0	1	244	6190185	6190428	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	24370	412	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
6189085	6189085	PRJNA421571_P_NODE_62065_length_331_cov_2.089147_g59516_i0	PRJNA421571	62065	331	2.089147	6.91507657	Bacteria	2	Bacteria	Bacteria	244	4.79e-60	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g59516	i0	80.818	97.5075528700906	318	55	95	6	5	319	13350175	13349861	Sorangium cellulosum So0157-2, complete genome	blastn	32275	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7464246	7464246	PRJNA421571_P_NODE_86506_length_262_cov_1.449735_g83957_i0	PRJNA421571	86506	262	1.449735	3.7983057	Corallococcus	83461	Bacteria	Bacteria	58.4	5.14e-4	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g83957	i0	100	0.583969465648855	31	0	12	0	51	81	7296622	7296592	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	153	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
11903118	11903118	PRJNA421571_P_NODE_90490_length_253_cov_1.711111_g87941_i0	PRJNA421571	90490	253	1.711111	4.32911083	Nannocystis punicea	2995304	Bacteria	Bacteria	176	1.31e-39	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g87941	i0	85.549	55.8102766798419	173	20	68	5	27	198	4910565	4910397	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	14120	176	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
13175586	13175586	PRJNA421571_P_NODE_101971_length_244_cov_0.900585_g99422_i0	PRJNA421571	101971	244	0.900585	2.1974274	Labilithrix luteola	1391654	Bacteria	Bacteria	298	2.56e-76	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g99422	i0	90	17.5819672131148	230	23	94	0	15	244	709724	709495	Labilithrix luteola strain DSM 27648, complete genome	blastn	4290	298	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15724498	15724498	PRJNA421571_P_NODE_101853_length_244_cov_0.900585_g99304_i0	PRJNA421571	101853	244	0.900585	2.1974274	Archangium gephyra	48	Bacteria	Bacteria	143	1.27e-29	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g99304	i0	78.541	5.04508196721311	233	38	94	7	1	230	7715170	7715393	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1231	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
15726701	15726701	PRJNA421571_P_NODE_79153_length_279_cov_1.412621_g76604_i0	PRJNA421571	79153	279	1.412621	3.94121259	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	158	5.29e-34	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g76604	i0	80.088	2.83512544802867	226	33	79	11	7	227	2481896	2481678	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	791	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15726900	15726900	PRJNA421571_P_NODE_86933_length_261_cov_1.515957_g84384_i0	PRJNA421571	86933	261	1.515957	3.95664777	Corallococcus coralloides	184914	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g84384	i0	100	0.10727969348659	28	0	11	0	1	28	6239401	6239374	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides

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