metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
1411433	1411433	PRJEB75230_P_NODE_186302_length_215_cov_4.014085_g186120_i0	PRJEB75230	186302	215	4.014085	8.63028275	Myxococcus stipitatus	83455	Bacteria	Bacteria	394	2.7299999999999994e-105	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g186120	i0	100	239.73488372093	213	0	99	0	1	213	4690156	4689944	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	51543	394	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
2271464	2271464	PRJEB75230_P_NODE_96762_length_266_cov_1.196891_g96580_i0	PRJEB75230	96762	266	1.196891	3.18373006	Bacteria	2	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g96580	i0	100	1.68421052631579	28	0	11	0	131	158	5721028	5721001	Myxococcus xanthus strain DK1050 chromosome	blastn	448	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5238708	5238708	PRJEB75230_P_NODE_135105_length_248_cov_1.320000_g134923_i0	PRJEB75230	135105	248	1.32	3.2736	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2107726022\|gb\|CP070840.1\|	2026735	g134923	i0	96.875	0.129032258064516	32	0	13	1	72	102	237082	237051	MAG: Deltaproteobacteria bacterium isolate bin101 chromosome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
5240336	5240336	PRJEB75230_P_NODE_74985_length_284_cov_1.388626_g74803_i0	PRJEB75230	74985	284	1.388626	3.94369784	Labilithrix luteola	1391654	Bacteria	Bacteria	398	2.9199999999999993e-106	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g74803	i0	91.93	137.640845070423	285	21	100	2	1	284	3942386	3942103	Labilithrix luteola strain DSM 27648, complete genome	blastn	39090	398	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6514580	6514580	PRJEB75230_P_NODE_155486_length_245_cov_0.895349_g155304_i0	PRJEB75230	155486	245	0.895349	2.19360505	Archangium gephyra	48	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g155304	i0	90.535	23.8448979591837	243	22	99	1	1	242	3936316	3936558	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	5842	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
9063699	9063699	PRJEB75230_P_NODE_15508_length_410_cov_3.293769_g15326_i0	PRJEB75230	15508	410	3.293769	13.5044529	Myxococcus stipitatus	83455	Bacteria	Bacteria	734	0	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g15326	i0	99.022	282.214634146341	409	4	99	0	2	410	4690561	4690969	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	115708	734	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
15438780	15438780	PRJEB75230_P_NODE_148673_length_246_cov_0.890173_g148491_i0	PRJEB75230	148673	246	0.890173	2.18982558	Archangium violaceum	83451	Bacteria	Bacteria	198	2.7e-46	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g148491	i0	83.636	51.8048780487805	220	26	87	9	7	221	10277349	10277563	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	12744	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
16713406	16713406	PRJEB75230_P_NODE_180814_length_241_cov_0.916667_g180632_i0	PRJEB75230	180814	241	0.916667	2.20916747	Corallococcus coralloides	184914	Bacteria	Bacteria	135	2.0900000000000003e-27	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g180632	i0	77.22	1.0746887966805	259	41	100	8	1	241	7675255	7675513	Corallococcus coralloides DSM 2259, complete genome	blastn	259	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
17988407	17988407	PRJEB75230_P_NODE_21595_length_377_cov_3.085526_g21413_i0	PRJEB75230	21595	377	3.085526	11.63243302	Myxococcus stipitatus	83455	Bacteria	Bacteria	691	0	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g21413	i0	99.735	80.3501326259947	377	1	100	0	1	377	6690619	6690243	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	30292	691	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
19261400	19261400	PRJEB75230_P_NODE_110776_length_255_cov_2.697802_g110594_i0	PRJEB75230	110776	255	2.697802	6.8793951	Corallococcus exercitus	2316736	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g110594	i0	99.608	258.470588235294	255	1	100	0	1	255	87285	87031	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	65910	466	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
20122300	20122300	PRJEB75230_P_NODE_122936_length_250_cov_1.463277_g122754_i0	PRJEB75230	122936	250	1.463277	3.6581925	Corallococcus	83461	Bacteria	Bacteria	449	6.87e-122	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g122754	i0	99.197	231.872	249	2	99	0	2	250	143675	143923	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	57968	449	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
21812698	21812698	PRJEB75230_P_NODE_116398_length_251_cov_6.393258_g116216_i0	PRJEB75230	116398	251	6.393258	16.04707758	Corallococcus coralloides	184914	Bacteria	Bacteria	387	5.489999999999998e-103	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g116216	i0	94.422	41.6254980079681	251	14	100	0	1	251	7567021	7566771	Corallococcus coralloides DSM 2259, complete genome	blastn	10448	387	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);;