metadata: contig_metadata: 12 rows where bioproject = "PRJNA657343" and tax

12 rows where bioproject = "PRJNA657343" 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
18475458	18475458	PRJNA657343_P_NODE_43635_length_162_cov_3.070796_g43611_i0	PRJNA657343	43635	162	3.070796	4.97468952	Labilithrix luteola	1391654	Bacteria	Bacteria	169	1.28e-37	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g43611	i0	85.802	291.808641975309	162	19	99	2	1	160	7089034	7089193	Labilithrix luteola strain DSM 27648, complete genome	blastn	47273	169	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18475487	18475487	PRJNA657343_P_NODE_4595_length_357_cov_1.418831_g4572_i0	PRJNA657343	4595	357	1.418831	5.06522667	Myxococcales bacterium	2026763	Bacteria	Bacteria	202	1e-60	NR	MBI4955806.1	2026763	g4572	i0	79.7	14.8739495798319	118	24	99.2	0	357	4	250	367	MBI4955806.1 citrate (Si)-synthase [Myxococcales bacterium]	diamond	5310	202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26923211	26923211	PRJNA657343_P_NODE_9482_length_273_cov_3.727679_g9458_i0	PRJNA657343	9482	273	3.727679	10.17656367	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	141	3.5899999999999998e-40	NR	MBL4635072.1	2212474	g9458	i0	79.3	6.72527472527473	87	18	95.6	0	269	9	43	129	MBL4635072.1 peroxiredoxin [Kofleriaceae bacterium]	diamond	1836	141	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27112806	27112806	PRJNA657343_P_NODE_40522_length_165_cov_0.896552_g40498_i0	PRJNA657343	40522	165	0.896552	1.4793108	Aetherobacter fasciculatus	888830	Bacteria	Bacteria	81.3	2.8e-16	NR	WP_346369895.1	888830	g40498	i0	66	0.963636363636364	53	18	96.4	0	161	3	58	110	WP_346369895.1 OmpA family protein [Aetherobacter fasciculatus]	diamond	159	81.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Aetherobacter	Aetherobacter fasciculatus
27555079	27555079	PRJNA657343_P_NODE_19884_length_208_cov_1.270440_g19860_i0	PRJNA657343	19884	208	1.27044	2.6425152	Myxococcales bacterium	2026763	Bacteria	Bacteria	92	9.27e-20	NR	MBL8684958.1	2026763	g19860	i0	78	1.48557692307692	50	10	70.7	1	3	149	114	163	MBL8684958.1 M15 family metallopeptidase [Myxococcales bacterium]	diamond	309	92	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27650142	27650142	PRJNA657343_P_NODE_40504_length_165_cov_0.896552_g40480_i0	PRJNA657343	40504	165	0.896552	1.4793108	Polyangia bacterium	3058050	Bacteria	Bacteria	46.2	8.01e-4	NR	HEY3353419.1	3058050	g40480	i0	55.9	0.618181818181818	34	15	61.8	0	156	55	324	357	HEY3353419.1 bifunctional serine/threonine-protein kinase/formylglycine-generating enzyme family protein [Polyangia bacterium]	diamond	102	46.2	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28261955	28261955	PRJNA657343_P_NODE_5286_length_339_cov_1.527586_g5263_i0	PRJNA657343	5286	339	1.527586	5.17851654	Bacteria	2	Bacteria	Bacteria	50.4	2.22e-4	NR	MDH5672412.1	2026763	g5263	i0	37.3	1.49557522123894	75	44	66.4	1	47	271	673	744	MDH5672412.1 hypothetical protein [Myxococcales bacterium]	diamond	507	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29418029	29418029	PRJNA657343_P_NODE_30469_length_178_cov_1.480620_g30445_i0	PRJNA657343	30469	178	1.48062	2.6355036	Myxococcota bacterium	2818507	Bacteria	Bacteria	99.8	1.48e-23	NR	HMV66240.1	2818507	g30445	i0	78.2	5.56179775280899	55	12	92.7	0	9	173	42	96	HMV66240.1 pirin family protein [Myxococcota bacterium]	diamond	990	99.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30902880	30902880	PRJNA657343_P_NODE_1314_length_557_cov_4.102362_g1292_i0	PRJNA657343	1314	557	4.102362	22.85015634	Polyangiales bacterium	3034171	Bacteria	Bacteria	53.9	9.58e-5	NR	MFO0628135.1	3034171	g1292	i0	52.1	0.51705565529623	48	20	24.8	2	287	150	170	216	MFO0628135.1 hypothetical protein [Polyangiales bacterium]	diamond	288	53.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
30997713	30997713	PRJNA657343_P_NODE_5054_length_345_cov_2.847973_g5031_i0	PRJNA657343	5054	345	2.847973	9.82550685	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	76.6	1.54e-13	NR	MFO0551775.1	2268199	g5031	i0	40.5	1.00869565217391	116	59	96.5	5	344	12	351	461	MFO0551775.1 FAD-binding protein [Polyangiaceae bacterium]	diamond	348	76.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31186905	31186905	PRJNA657343_P_NODE_37875_length_167_cov_0.881356_g37851_i0	PRJNA657343	37875	167	0.881356	1.47186452	Myxococcota bacterium	2818507	Bacteria	Bacteria	50.1	3.44e-5	NR	MEZ4234778.1	2818507	g37851	i0	55.3	0.844311377245509	47	21	84.4	0	161	21	129	175	MEZ4234778.1 alkaline phosphatase D family protein [Myxococcota bacterium]	diamond	141	50.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31547517	31547517	PRJNA657343_P_NODE_14816_length_232_cov_1.573770_g14792_i0	PRJNA657343	14816	232	1.57377	3.6511464	Minicystis	1649470	Bacteria	Bacteria	106	2.7200000000000004e-27	NR	MFT3774947.1	1971901	g14792	i0	65.3	2.90948275862069	75	26	97	0	230	6	34	108	MFT3774947.1 ERG2 family protein [Minicystis sp.]	diamond	675	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.

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