metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA546018" 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
510643	510643	PRJNA546018_S_NODE_11841_length_495_cov_2.470046_g11517_i0	PRJNA546018	11841	495	2.470046	12.2267277	Myxococcus sp. MxC21-1	3041439	Bacteria	Bacteria	278	7.32e-70	NTclustered	gi\|2592002496\|gb\|CP123278.1\|	3041439	g11517	i0	78.125	9.54545454545454	448	90	90	7	20	463	4140688	4141131	Myxococcus sp. MxC21-1 chromosome, complete genome	blastn	4725	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MxC21-1
510964	510964	PRJNA546018_S_NODE_33901_length_267_cov_1.893204_g33576_i0	PRJNA546018	33901	267	1.893204	5.05485468	Archangium gephyra	48	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g33576	i0	84.167	1.25468164794007	120	15	44	4	9	126	8620833	8620950	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	335	113	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
8163898	8163898	PRJNA546018_S_NODE_39767_length_244_cov_1.770492_g39442_i0	PRJNA546018	39767	244	1.770492	4.32000048	Myxococcus fulvus	33	Bacteria	Bacteria	368	1.92e-97	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g39442	i0	96.413	3.66803278688525	223	8	91	0	22	244	2617290	2617512	Myxococcus fulvus 124B02, complete genome	blastn	895	368	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8163920	8163920	PRJNA546018_S_NODE_40867_length_241_cov_1.961111_g40542_i0	PRJNA546018	40867	241	1.961111	4.72627751	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	161	3.45e-35	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g40542	i0	82.703	41.9211618257261	185	28	76	4	51	234	1112064	1112245	Anaeromyxobacter paludicola DNA, complete genome	blastn	10103	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
10715223	10715223	PRJNA546018_S_NODE_40809_length_241_cov_2.711111_g40484_i0	PRJNA546018	40809	241	2.711111	6.53377751	Myxococcus fulvus	33	Bacteria	Bacteria	252	1.99e-62	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g40484	i0	89.796	20.0829875518672	196	20	81	0	22	217	821643	821448	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4840	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
10715593	10715593	PRJNA546018_S_NODE_9469_length_564_cov_6.192843_g9150_i0	PRJNA546018	9469	564	6.192843	34.92763452	Myxococcus landrumensis	2813577	Bacteria	Bacteria	580	5.729999999999999e-161	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g9150	i0	86.213	10.5620567375887	544	65	96	10	3	541	5170267	5169729	Myxococcus landrumus strain SCHIC003 chromosome	blastn	5957	580	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
11322152	11322152	PRJNA546018_S_NODE_11489_length_504_cov_2.573363_g11165_i0	PRJNA546018	11489	504	2.573363	12.96974952	Myxococcus	32	Bacteria	Bacteria	665	0	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g11165	i0	92.81	43.2579365079365	459	33	91	0	20	478	10226377	10226835	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	21802	671	0.991058122205663	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
11989631	11989631	PRJNA546018_S_NODE_25170_length_317_cov_4.867188_g24845_i0	PRJNA546018	25170	317	4.867188	15.42898596	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	270	7.529999999999999e-68	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g24845	i0	86.694	1.80441640378549	248	27	77	5	24	268	1348725	1348969	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	572	270	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17697199	17697199	PRJNA546018_S_NODE_41394_length_239_cov_1.859551_g41069_i0	PRJNA546018	41394	239	1.859551	4.44432689	Myxococcus	32	Bacteria	Bacteria	259	1.18e-64	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g41069	i0	88.073	14.5564853556485	218	26	91	0	1	218	5982549	5982766	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	3479	259	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus

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