metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA983848" 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_species
26937268	26937268	PRJNA983848_P_NODE_154302_length_245_cov_0.906977_g148419_i0	PRJNA983848	154302	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	52.8	1.11e-5	NR	MCB9739322.1	2026735	g148419	i0	38.3	4.84897959183674	81	49	99.2	1	1	243	74	153	MCB9739322.1 ATP-binding cassette domain-containing protein [Deltaproteobacteria bacterium]	diamond	1188	53.1	0.994350282485876	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
27847518	27847518	PRJNA983848_P_NODE_139224_length_252_cov_1.698324_g133341_i0	PRJNA983848	139224	252	1.698324	4.27977648	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.7	0.0404	NR	HEU4429896.1	2818507	g133341	i0	45.7	0.547619047619048	46	25	54.8	0	193	56	13	58	HEU4429896.1 rhomboid family intramembrane serine protease [Myxococcota bacterium]	diamond	138	42.7	1	Bacteria	Pseudomonadati	Myxococcota				Myxococcota bacterium
29268307	29268307	PRJNA983848_P_NODE_96929_length_308_cov_2.063830_g91046_i0	PRJNA983848	96929	308	2.06383	6.3565964	Myxococcota bacterium	2818507	Bacteria	Bacteria	43.5	0.035	NR	MEE2703528.1	2818507	g91046	i0	39.2	0.496753246753247	51	31	49.7	0	291	139	97	147	MEE2703528.1 1-(5-phosphoribosyl)-5-[(5-phosphoribosylamino)methylideneamino]imidazole-4-carboxamide isomerase [Myxococcota bacterium]	diamond	153	43.5	1	Bacteria	Pseudomonadati	Myxococcota				Myxococcota bacterium
30822229	30822229	PRJNA983848_P_NODE_62934_length_407_cov_2.401198_g57052_i0	PRJNA983848	62934	407	2.401198	9.77287586	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	2.82e-5	NR	MBW2606464.1	2026735	g57052	i0	32.3	3.62653562653563	96	62	69.3	3	73	354	164	258	MBW2606464.1 insulinase family protein [Deltaproteobacteria bacterium]	diamond	1476	54.3	0.992633517495396	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
31005797	31005797	PRJNA983848_P_NODE_143514_length_250_cov_0.881356_g137631_i0	PRJNA983848	143514	250	0.881356	2.20339	Myxococcales bacterium	2026763	Bacteria	Bacteria	92.4	1.23e-19	NR	MBL8685666.1	2026763	g137631	i0	62	1.932	79	30	94.8	0	249	13	268	346	MBL8685666.1 deoxyribodipyrimidine photo-lyase [Myxococcales bacterium]	diamond	483	92.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales		Myxococcales bacterium
31258640	31258640	PRJNA983848_P_NODE_159955_length_242_cov_0.923077_g154072_i0	PRJNA983848	159955	242	0.923077	2.23384634	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	138	2.2899999999999998e-38	NR	HEX2673937.1	2268199	g154072	i0	85	0.991735537190083	80	12	99.2	0	2	241	167	246	HEX2673937.1 hypothetical protein [Polyangiaceae bacterium]	diamond	240	138	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangiaceae bacterium
31416787	31416787	PRJNA983848_P_NODE_107016_length_291_cov_1.935780_g101133_i0	PRJNA983848	107016	291	1.93578	5.6331198	Polyangia bacterium	3058050	Bacteria	Bacteria	41.2	0.0424	NR	HEY7954277.1	3058050	g101133	i0	29.9	0.690721649484536	67	44	69.1	1	16	216	11	74	HEY7954277.1 hypothetical protein [Polyangia bacterium]	diamond	201	41.2	1	Bacteria	Pseudomonadati	Myxococcota				Polyangia bacterium
32681398	32681398	PRJNA983848_P_NODE_1120_length_5476_cov_8.243568_g860_i0	PRJNA983848	1120	5476	8.243568	451.41778368	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	100	5.46e-17	NR	MCC6623602.1	2026735	g860	i0	32.5	0.12490869247626	228	99	11.1	8	839	1447	624	821	MCC6623602.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	684	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium

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