metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA315314" 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
380956	380956	PRJNA315314_S_NODE_2981_length_458_cov_8.850816_g2663_i0	PRJNA315314	2981	458	8.850816	40.53673728	root	1	Root_unresolved	Root_unresolved	196	6.3599999999999985e-56	NR	WP_375767882.1	48	g2663	i0	72	17.3515283842795	132	37	86.5	0	398	3	542	673	WP_375767882.1 LysM peptidoglycan-binding domain-containing protein [Archangium gephyra]	diamond	7947	197	0.99492385786802	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
26631205	26631205	PRJNA315314_S_NODE_22501_length_175_cov_3.568493_g22180_i0	PRJNA315314	22501	175	3.568493	6.24486275	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.1	0.00176	NR	MCX7959833.1	2026735	g22180	i0	37.8	0.771428571428571	45	28	77.1	0	35	169	42	86	MCX7959833.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	135	45.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27200544	27200544	PRJNA315314_S_NODE_25262_length_167_cov_1.000000_g24941_i0	PRJNA315314	25262	167	1	1.67	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	53.9	1.35e-6	NR	MBI5642334.1	2026735	g24941	i0	50	3.64670658682635	54	25	97	1	166	5	153	204	MBI5642334.1 SDR family oxidoreductase [Deltaproteobacteria bacterium]	diamond	609	53.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27485181	27485181	PRJNA315314_S_NODE_25903_length_165_cov_1.727941_g25582_i0	PRJNA315314	25903	165	1.727941	2.85110265	Hyalangium minutum	394096	Bacteria	Bacteria	43.1	0.0093	NR	WP_052420032.1	394096	g25582	i0	43.4	1.92727272727273	53	30	96.4	0	163	5	279	331	WP_052420032.1 zinc-binding alcohol dehydrogenase family protein [Hyalangium minutum]	diamond	318	43.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium minutum
27548266	27548266	PRJNA315314_S_NODE_8024_length_285_cov_5.101562_g7703_i0	PRJNA315314	8024	285	5.101562	14.5394517	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	57	6.18e-7	NR	HLL00416.1	2484252	g7703	i0	44.1	1.78947368421053	93	44	97.9	2	280	2	1470	1554	HLL00416.1 Ig-like domain-containing protein [Myxococcaceae bacterium]	diamond	510	57	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28053368	28053368	PRJNA315314_S_NODE_19545_length_187_cov_1.506329_g19224_i0	PRJNA315314	19545	187	1.506329	2.81683523	Sandaracinaceae bacterium	2510337	Bacteria	Bacteria	61.6	8.8e-10	NR	MBK6580377.1	2510337	g19224	i0	66	0.850267379679144	53	15	80.2	2	37	186	6	58	MBK6580377.1 tyrosine--tRNA ligase [Sandaracinaceae bacterium]	diamond	159	61.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
28084979	28084979	PRJNA315314_S_NODE_32545_length_150_cov_1.669421_g32224_i0	PRJNA315314	32545	150	1.669421	2.5041315	Hyalangium versicolor	2861190	Bacteria	Bacteria	45.4	3.24e-4	NR	WP_224367607.1	2861190	g32224	i0	61.8	1.36	34	13	68	0	103	2	1	34	WP_224367607.1 GFA family protein [Hyalangium versicolor]	diamond	204	45.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium versicolor
28179551	28179551	PRJNA315314_S_NODE_7266_length_299_cov_3.629630_g6945_i0	PRJNA315314	7266	299	3.62963	10.8525937	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	50.8	9.62e-5	NR	MBL8617982.1	2026735	g6945	i0	41.3	0.632107023411371	63	36	62.2	1	36	221	55	117	MBL8617982.1 DUF2786 domain-containing protein [Deltaproteobacteria bacterium]	diamond	189	50.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28242728	28242728	PRJNA315314_S_NODE_17126_length_199_cov_1.341176_g16805_i0	PRJNA315314	17126	199	1.341176	2.66894024	Myxococcota bacterium	2818507	Bacteria	Bacteria	67	5.8e-11	NR	MCK6572461.1	2818507	g16805	i0	54.5	0.829145728643216	55	25	82.9	0	34	198	150	204	MCK6572461.1 hypothetical protein [Myxococcota bacterium]	diamond	165	67	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29839065	29839065	PRJNA315314_S_NODE_12511_length_230_cov_2.179104_g12190_i0	PRJNA315314	12511	230	2.179104	5.0119392	Pseudomonadati	3379134	Bacteria	Bacteria	76.6	3.58e-14	NR	HMV68259.1	2818507	g12190	i0	45.2	4.43478260869565	73	40	95.2	0	3	221	364	436	HMV68259.1 M13 family metallopeptidase [Myxococcota bacterium]	diamond	1020	76.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30769540	30769540	PRJNA315314_S_NODE_22654_length_175_cov_1.561644_g22333_i0	PRJNA315314	22654	175	1.561644	2.732877	Pyxidicoccus sp. 3LG	3383247	Bacteria	Bacteria	77.4	8.64e-15	NR	MFP2926531.1	3383247	g22333	i0	63.5	0.891428571428571	52	19	89.1	0	158	3	200	251	MFP2926531.1 hypothetical protein [Pyxidicoccus sp. 3LG]	diamond	156	77.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus sp. 3LG
30832625	30832625	PRJNA315314_S_NODE_4854_length_364_cov_5.426866_g4533_i0	PRJNA315314	4854	364	5.426866	19.75379224	Myxococcota bacterium	2818507	Bacteria	Bacteria	89.4	1.81e-20	NR	MEQ1507343.1	2818507	g4533	i0	50	0.807692307692308	98	42	77.5	2	42	323	1	95	MEQ1507343.1 hypothetical protein [Myxococcota bacterium]	diamond	294	89.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31559891	31559891	PRJNA315314_S_NODE_19956_length_185_cov_2.288462_g19635_i0	PRJNA315314	19956	185	2.288462	4.2336547	Cystobacter fuscus	43	Bacteria	Bacteria	57.4	1.16e-7	NR	WP_095988966.1	43	g19635	i0	43.3	1.08648648648649	67	32	98.9	2	184	2	69	135	WP_095988966.1 M13 family metallopeptidase [Cystobacter fuscus]	diamond	201	57.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
31970869	31970869	PRJNA315314_S_NODE_1038_length_757_cov_18.226648_g824_i0	PRJNA315314	1038	757	18.226648	137.97572536	Stigmatella erecta	83460	Bacteria	Bacteria	52.4	7.14e-4	NR	WP_143076215.1	83460	g824	i0	45.5	0.21796565389696201	55	29	21.4	1	756	595	160	214	WP_143076215.1 hypothetical protein [Stigmatella erecta]	diamond	165	52.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella erecta
32509142	32509142	PRJNA315314_S_NODE_9219_length_267_cov_1.823529_g8898_i0	PRJNA315314	9219	267	1.823529	4.86882243	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	89	4.76e-19	NR	MBW2716049.1	2026735	g8898	i0	53.7	1.8876404494382	82	37	92.1	1	20	265	157	237	MBW2716049.1 OmpA family protein [Deltaproteobacteria bacterium]	diamond	504	89	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);;