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

8 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
2181631	2181631	PRJNA929922_P_NODE_144062_length_244_cov_0.900585_g143522_i0	PRJNA929922	144062	244	0.900585	2.1974274	Labilithrix luteola	1391654	Bacteria	Bacteria	211	3.43e-50	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g143522	i0	86	0.819672131147541	200	25	81	3	40	237	4878813	4879011	Labilithrix luteola strain DSM 27648, complete genome	blastn	200	211	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6009256	6009256	PRJNA929922_P_NODE_133165_length_246_cov_0.890173_g132625_i0	PRJNA929922	133165	246	0.890173	2.18982558	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	128	3.59e-25	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g132625	i0	78.571	0.853658536585366	210	33	83	10	7	210	8852903	8852700	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	210	128	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11109983	11109983	PRJNA929922_P_NODE_150309_length_243_cov_0.905882_g149769_i0	PRJNA929922	150309	243	0.905882	2.20129326	Sorangium cellulosum	56	Bacteria	Bacteria	106	1.66e-18	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g149769	i0	75.591	10.1646090534979	254	41	99	14	3	241	12310325	12310572	Sorangium cellulosum So0157-2, complete genome	blastn	2470	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11110192	11110192	PRJNA929922_P_NODE_160769_length_241_cov_0.916667_g160229_i0	PRJNA929922	160769	241	0.916667	2.20916747	Polyangium aurulentum	2567896	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g160229	i0	81.78	0.979253112033195	236	37	97	6	1	233	1700438	1700670	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	236	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
12384827	12384827	PRJNA929922_P_NODE_117650_length_249_cov_0.875000_g117110_i0	PRJNA929922	117650	249	0.875	2.17875	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	182	2.75e-41	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g117110	i0	81.25	5.6706827309237	256	20	94	12	7	239	335128	335378	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	1412	182	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
17483718	17483718	PRJNA929922_P_NODE_106854_length_251_cov_0.865169_g106314_i0	PRJNA929922	106854	251	0.865169	2.17157419	Archangium violaceum	83451	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g106314	i0	93.814	9.80478087649402	194	12	77	0	58	251	11274598	11274405	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	2461	292	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
20379990	20379990	PRJNA929922_P_NODE_163996_length_241_cov_0.916667_g163456_i0	PRJNA929922	163996	241	0.916667	2.20916747	Sorangium	39643	Bacteria	Bacteria	263	9.21e-66	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g163456	i0	86.307	7.9253112033195	241	33	100	0	1	241	4516723	4516963	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	1910	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21307968	21307968	PRJNA929922_P_NODE_126617_length_248_cov_0.862857_g126077_i0	PRJNA929922	126617	248	0.862857	2.13988536	Archangium violaceum	83451	Bacteria	Bacteria	185	2.1199999999999998e-42	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g126077	i0	88.387	2.71370967741935	155	17	62	1	95	248	10506903	10507057	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	673	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum

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