metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA454503" 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
18294356	18294356	PRJNA454503_P_NODE_65155_length_208_cov_0.884354_g64826_i0	PRJNA454503	65155	208	0.884354	1.83945632	Myxococcota bacterium	2818507	Bacteria	Bacteria	110	5.72e-28	NR	MEZ0312461.1	2818507	g64826	i0	91.5	0.850961538461538	59	5	85.1	0	31	207	4	62	MEZ0312461.1 TetR/AcrR family transcriptional regulator [Myxococcota bacterium]	diamond	177	110	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
22119043	22119043	PRJNA454503_P_NODE_47438_length_218_cov_1.656051_g47109_i0	PRJNA454503	47438	218	1.656051	3.61019118	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	136	2.9199999999999996e-35	NR	MBA2540744.1	2026735	g47109	i0	97.2	1.98165137614679	72	2	99.1	0	218	3	233	304	MBA2540744.1 response regulator [Deltaproteobacteria bacterium]	diamond	432	136	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26727537	26727537	PRJNA454503_P_NODE_69521_length_207_cov_0.890411_g69192_i0	PRJNA454503	69521	207	0.890411	1.84315077	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	56.6	1.84e-8	NR	HEY3803016.1	2212474	g69192	i0	80.6	0.521739130434783	36	7	52.2	0	99	206	4	39	HEY3803016.1 hypothetical protein [Kofleriaceae bacterium]	diamond	108	56.6	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27138962	27138962	PRJNA454503_P_NODE_36962_length_230_cov_1.988166_g36633_i0	PRJNA454503	36962	230	1.988166	4.5727818	Myxococcota bacterium	2818507	Bacteria	Bacteria	92.8	5.37e-20	NR	HMV70023.1	2818507	g36633	i0	70.5	2.81739130434783	61	18	79.6	0	205	23	26	86	HMV70023.1 MopE-related protein [Myxococcota bacterium]	diamond	648	92.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27486952	27486952	PRJNA454503_P_NODE_52503_length_213_cov_1.296053_g52174_i0	PRJNA454503	52503	213	1.296053	2.76059289	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	88.6	1.8e-18	NR	MDO8527159.1	2026735	g52174	i0	60	2.87323943661972	70	27	97.2	1	2	208	240	309	MDO8527159.1 DUF1156 domain-containing protein [Deltaproteobacteria bacterium]	diamond	612	88.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28212874	28212874	PRJNA454503_P_NODE_34986_length_233_cov_1.377907_g34657_i0	PRJNA454503	34986	233	1.377907	3.21052331	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	81.3	1.5e-16	NR	HVV86035.1	2212474	g34657	i0	65.6	0.785407725321888	61	21	78.5	0	197	15	15	75	HVV86035.1 hypothetical protein [Kofleriaceae bacterium]	diamond	183	81.3	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30455638	30455638	PRJNA454503_P_NODE_35833_length_232_cov_1.298246_g35504_i0	PRJNA454503	35833	232	1.298246	3.01193072	Polyangia bacterium	3058050	Bacteria	Bacteria	115	1.09e-27	NR	HMF41143.1	3058050	g35504	i0	81.6	0.982758620689655	76	14	98.3	0	231	4	11	86	HMF41143.1 tetratricopeptide repeat protein [Polyangia bacterium]	diamond	228	115	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30549985	30549985	PRJNA454503_P_NODE_32453_length_236_cov_1.485714_g32124_i0	PRJNA454503	32453	236	1.485714	3.50628504	Labilithrix sp.	1971228	Bacteria	Bacteria	91.7	1.48e-19	NR	MDB4937664.1	1971228	g32124	i0	66.7	4.70338983050847	78	21	92.8	1	229	11	29	106	MDB4937664.1 Flagellar hook-length control protein FliK [Labilithrix sp.]	diamond	1110	91.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
31181665	31181665	PRJNA454503_P_NODE_49435_length_216_cov_1.677419_g49106_i0	PRJNA454503	49435	216	1.677419	3.62322504	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	90.9	1.68e-19	NR	MBA3457857.1	2026735	g49106	i0	70	1.95833333333333	70	21	97.2	0	215	6	319	388	MBA3457857.1 lamin tail domain-containing protein [Deltaproteobacteria bacterium]	diamond	423	90.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31245155	31245155	PRJNA454503_P_NODE_38475_length_229_cov_0.976190_g38146_i0	PRJNA454503	38475	229	0.97619	2.2354751	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.0162	NR	MBI3079629.1	2026735	g38146	i0	37.8	1.91266375545852	45	27	59	1	54	188	81	124	MBI3079629.1 hydantoinase B/oxoprolinase family protein [Deltaproteobacteria bacterium]	diamond	438	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31276709	31276709	PRJNA454503_P_NODE_37775_length_229_cov_1.970238_g37446_i0	PRJNA454503	37775	229	1.970238	4.51184502	Myxococcota bacterium	2818507	Bacteria	Bacteria	65.1	7.21e-11	NR	HET6345509.1	2818507	g37446	i0	55.9	0.890829694323144	68	30	89.1	0	24	227	36	103	HET6345509.1 type II secretion system protein GspM [Myxococcota bacterium]	diamond	204	65.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31434894	31434894	PRJNA454503_P_NODE_38076_length_229_cov_1.547619_g37747_i0	PRJNA454503	38076	229	1.547619	3.54404751	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	119	1.59e-29	NR	HEX5058701.1	2212474	g37747	i0	75.3	0.956331877729258	73	18	95.6	0	1	219	420	492	HEX5058701.1 hypothetical protein [Kofleriaceae bacterium]	diamond	219	119	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
32194291	32194291	PRJNA454503_P_NODE_43098_length_223_cov_1.604938_g42769_i0	PRJNA454503	43098	223	1.604938	3.57901174	Myxococcales bacterium	2026763	Bacteria	Bacteria	58.5	6.41e-8	NR	MCA9594328.1	2026763	g42769	i0	64.9	0.901345291479821	37	13	49.8	0	113	223	1	37	MCA9594328.1 4-hydroxy-tetrahydrodipicolinate synthase [Myxococcales bacterium]	diamond	201	58.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32321118	32321118	PRJNA454503_P_NODE_82659_length_203_cov_0.915493_g82330_i0	PRJNA454503	82659	203	0.915493	1.85845079	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	108	1.43e-27	NR	MBA2542933.1	2026735	g82330	i0	74.6	0.990147783251232	67	17	99	0	3	203	41	107	MBA2542933.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	201	108	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);;