metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA782235" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA782235" 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
763272	763272	PRJNA782235_P_NODE_17181_length_250_cov_1.802260_g16992_i0	PRJNA782235	17181	250	1.80226	4.50565	Cystobacter fuscus	43	Bacteria	Bacteria	444	3.1999999999999986e-120	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g16992	i0	98.795	299.48	249	3	99	0	1	249	4450522	4450770	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	74870	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
4591622	4591622	PRJNA782235_P_NODE_19824_length_248_cov_0.880000_g19635_i0	PRJNA782235	19824	248	0.88	2.1824	Archangium gephyra	48	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g19635	i0	85.366	62.7822580645161	164	22	66	2	71	233	854457	854295	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	15570	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
4591703	4591703	PRJNA782235_P_NODE_24864_length_244_cov_0.900585_g24675_i0	PRJNA782235	24864	244	0.900585	2.1974274	Sorangium cellulosum	56	Bacteria	Bacteria	106	1.67e-18	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g24675	i0	82.645	1.72950819672131	121	19	49	2	26	145	12021022	12020903	Sorangium cellulosum So0157-2, complete genome	blastn	422	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4591851	4591851	PRJNA782235_P_NODE_9804_length_291_cov_1.077982_g9615_i0	PRJNA782235	9804	291	1.077982	3.13692762	Cystobacter fuscus	43	Bacteria	Bacteria	479	1.0399999999999996e-130	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g9615	i0	96.54	227.034364261168	289	10	99	0	3	291	7643462	7643750	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	66067	479	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
12242982	12242982	PRJNA782235_P_NODE_24230_length_244_cov_1.280702_g24041_i0	PRJNA782235	24230	244	1.280702	3.12491288	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	248	2.6199999999999997e-61	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g24041	i0	85.95	8.65163934426229	242	22	99	6	3	244	74225	74454	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	2111	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
14791952	14791952	PRJNA782235_P_NODE_21812_length_246_cov_1.780347_g21623_i0	PRJNA782235	21812	246	1.780347	4.37965362	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	294	3.34e-75	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g21623	i0	88.211	28.3739837398374	246	29	100	0	1	246	5126427	5126672	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	6980	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
14792014	14792014	PRJNA782235_P_NODE_26612_length_242_cov_0.911243_g26423_i0	PRJNA782235	26612	242	0.911243	2.20520806	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g26423	i0	90.909	5.3099173553719	143	13	59	0	60	202	5692763	5692621	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	1285	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
17790056	17790056	PRJNA782235_P_NODE_23654_length_245_cov_0.895349_g23465_i0	PRJNA782235	23654	245	0.895349	2.19360505	Nannocystis	53	Bacteria	Bacteria	377	3.21e-100	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g23465	i0	95.378	157.94693877551	238	10	97	1	4	240	668	905	N.exedens 23S rRNA gene	blastn	38697	377	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
21166104	21166104	PRJNA782235_P_NODE_7837_length_322_cov_0.907631_g7648_i0	PRJNA782235	7837	322	0.907631	2.92257182	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	579	1.1199999999999997e-160	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g7648	i0	99.068	299.124223602484	322	3	100	0	1	322	2161384	2161705	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	96318	579	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
24989728	24989728	PRJNA782235_P_NODE_14000_length_264_cov_1.554974_g13811_i0	PRJNA782235	14000	264	1.554974	4.10513136	Myxococcus stipitatus	83455	Bacteria	Bacteria	183	8.2e-42	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g13811	i0	79.389	1.96212121212121	262	52	99	2	1	261	3997782	3998042	Myxococcus stipitatus DSM 14675, complete genome	blastn	518	183	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);;