metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
2052758	2052758	PRJNA792582_P_NODE_21702_length_370_cov_0.973064_g20888_i0	PRJNA792582	21702	370	0.973064	3.6003368	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	645	1.2699999999999995e-180	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g20888	i0	98.108	134.078378378378	370	7	100	0	1	370	1551251	1550882	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	49609	645	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
2491055	2491055	PRJNA792582_P_NODE_55422_length_245_cov_0.895349_g54608_i0	PRJNA792582	55422	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	375	1.16e-99	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g54608	i0	93.725	24.0081632653061	255	6	100	10	1	245	2419	2673	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	5882	377	0.994694960212202	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5880338	5880338	PRJNA792582_P_NODE_28825_length_322_cov_0.763052_g28011_i0	PRJNA792582	28825	322	0.763052	2.45702744	Myxococcus xanthus	34	Bacteria	Bacteria	586	6.699999999999998e-163	NTclustered	gi\|13959812\|gb\|AY033405.1\|	34	g28011	i0	99.383	100.006211180124	324	0	100	2	1	322	476	799	Myxococcus xanthus USC5-1p and USC5-2p genes, complete cds	blastn	32202	586	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
9705341	9705341	PRJNA792582_P_NODE_45248_length_263_cov_2.231579_g44434_i0	PRJNA792582	45248	263	2.231579	5.86905277	Sorangium cellulosum	56	Bacteria	Bacteria	226	1.3399999999999998e-54	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g44434	i0	91.018	55.9125475285171	167	15	63	0	97	263	7711872	7711706	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	14705	226	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16518485	16518485	PRJNA792582_P_NODE_55413_length_245_cov_0.895349_g54599_i0	PRJNA792582	55413	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	156	1.64e-33	NTclustered	gi\|2621786039\|emb\|OY782497.1\|	2818507	g54599	i0	78.862	18.1551020408163	246	40	99	11	3	245	2487536	2487772	MAG: Myxococcota bacterium isolate 0c961c99-2a7e-4543-b017-306f11f6fc1d genome assembly, chromosome: 1	blastn	4448	156	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
17355319	17355319	PRJNA792582_P_NODE_42914_length_270_cov_1.284264_g42100_i0	PRJNA792582	42914	270	1.284264	3.4675128	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	169	2.36e-37	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g42100	i0	79.916	11.1740740740741	239	41	87	6	37	270	4240520	4240756	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	3017	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
21179595	21179595	PRJNA792582_P_NODE_49357_length_251_cov_2.589888_g48543_i0	PRJNA792582	49357	251	2.589888	6.50061888	Nannocystis punicea	2995304	Bacteria	Bacteria	200	7.679999999999999e-47	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g48543	i0	82.278	90.5697211155378	237	36	94	6	2	235	5862918	5862685	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	22733	200	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
25003651	25003651	PRJNA792582_P_NODE_57280_length_243_cov_1.264706_g56466_i0	PRJNA792582	57280	243	1.264706	3.07323558	Polyangium aurulentum	2567896	Bacteria	Bacteria	274	4.29e-69	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g56466	i0	86.939	106.987654320988	245	30	100	2	1	243	443435	443191	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	25998	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum

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