metadata: contig_metadata: 20 rows where bioproject = "PRJNA1120771", tax_phylum = "Myxococcota" and tax

20 rows where bioproject = "PRJNA1120771", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
9956583	9956583	PRJNA1120771_S_NODE_24348_length_242_cov_1.603015_g23948_i0	PRJNA1120771	24348	242	1.603015	3.8792963	Stigmatella	40	Bacteria	Bacteria	375	1.14e-99	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g23948	i0	94.628	211.97520661157	242	13	100	0	1	242	81	322	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	51298	375	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
11755106	11755106	PRJNA1120771_S_NODE_17990_length_272_cov_2.034934_g17590_i0	PRJNA1120771	17990	272	2.034934	5.53502048	Myxococcota bacterium	2818507	Bacteria	Bacteria	78.2	1e-15	NR	MCK6502336.1	2818507	g17590	i0	66	5.85661764705882	50	17	55.1	0	4	153	118	167	MCK6502336.1 peptidylprolyl isomerase [Myxococcota bacterium]	diamond	1593	78.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
15579561	15579561	PRJNA1120771_S_NODE_34133_length_210_cov_2.586826_g33733_i0	PRJNA1120771	34133	210	2.586826	5.4323346	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g33733	i0	100	0.133333333333333	28	0	13	0	11	38	5442877	5442904	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
18128305	18128305	PRJNA1120771_S_NODE_22115_length_251_cov_3.326923_g21715_i0	PRJNA1120771	22115	251	3.326923	8.35057673	Pseudomonadati	3379134	Bacteria	Bacteria	119	1.63e-29	NR	MCB9570003.1	2026763	g21715	i0	73.5	4.02788844621514	83	19	99.2	1	250	2	347	426	MCB9570003.1 adenosylhomocysteinase [Myxococcales bacterium]	diamond	1011	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27291419	27291419	PRJNA1120771_S_NODE_31203_length_218_cov_2.245714_g30803_i0	PRJNA1120771	31203	218	2.245714	4.89565652	Myxococcus sp.	1929279	Bacteria	Bacteria	75.1	5.56e-14	NR	MBE2248907.1	1929279	g30803	i0	53.5	1.95412844036697	71	28	95	2	216	10	221	288	MBE2248907.1 M14 family metallocarboxypeptidase [Myxococcus sp.]	diamond	426	75.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp.
27754577	27754577	PRJNA1120771_S_NODE_19924_length_261_cov_3.793578_g19524_i0	PRJNA1120771	19924	261	3.793578	9.90123858	Bacteria	2	Bacteria	Bacteria	46.6	0.00178	NR	MDW8245882.1	2510337	g19524	i0	38.2	1.44827586206897	68	28	78.2	2	4	207	126	179	MDW8245882.1 hypothetical protein [Sandaracinaceae bacterium]	diamond	378	47	0.991489361702128	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
28049200	28049200	PRJNA1120771_S_NODE_28005_length_228_cov_2.351351_g27605_i0	PRJNA1120771	28005	228	2.351351	5.36108028	Labilithrix sp.	1971228	Bacteria	Bacteria	116	5.48e-29	NR	HSO39330.1	1971228	g27605	i0	73.7	1	76	20	100	0	1	228	200	275	HSO39330.1 ABC transporter permease [Labilithrix sp.]	diamond	228	116	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
28144165	28144165	PRJNA1120771_S_NODE_6405_length_393_cov_2.891429_g6005_i0	PRJNA1120771	6405	393	2.891429	11.36331597	Myxococcales bacterium	2026763	Bacteria	Bacteria	45.1	0.0271	NR	MBL8678567.1	2026763	g6005	i0	40	0.648854961832061	85	45	60.3	2	81	317	399	483	MBL8678567.1 DUF853 family protein [Myxococcales bacterium]	diamond	255	45.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28270045	28270045	PRJNA1120771_S_NODE_9866_length_337_cov_2.874150_g9466_i0	PRJNA1120771	9866	337	2.87415	9.6858855	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	44.7	0.023	NR	WP_269013013.1	2996782	g9466	i0	44.8	0.516320474777448	58	32	51.6	0	161	334	658	715	WP_269013013.1 Hsp70 family protein [Corallococcus sp. NCRR]	diamond	174	44.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
28522965	28522965	PRJNA1120771_S_NODE_29207_length_224_cov_3.093923_g28807_i0	PRJNA1120771	29207	224	3.093923	6.93038752	Sandaracinaceae bacterium	2510337	Bacteria	Bacteria	43.5	0.0152	NR	MBK8588858.1	2510337	g28807	i0	41.1	0.75	56	28	75	1	41	208	274	324	MBK8588858.1 hypothetical protein [Sandaracinaceae bacterium]	diamond	168	43.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
29469740	29469740	PRJNA1120771_S_NODE_30250_length_221_cov_1.719101_g29850_i0	PRJNA1120771	30250	221	1.719101	3.79921321	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	122	2.22e-34	NR	TMA97294.1	2026735	g29850	i0	84.7	1.92760180995475	72	11	97.7	0	3	218	9	80	TMA97294.1 MAG: peptidoglycan-binding protein [Deltaproteobacteria bacterium]	diamond	426	122	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29880743	29880743	PRJNA1120771_S_NODE_25031_length_239_cov_3.071429_g24631_i0	PRJNA1120771	25031	239	3.071429	7.34071531	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42	0.0412	NR	MBS2027623.1	2026735	g24631	i0	41.5	0.514644351464435	41	22	49	1	137	21	1	41	MBS2027623.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	123	42	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30354948	30354948	PRJNA1120771_S_NODE_16212_length_283_cov_1.341667_g15812_i0	PRJNA1120771	16212	283	1.341667	3.79691761	Nannocystis pusilla	889268	Bacteria	Bacteria	43.5	0.0215	NR	WP_224193151.1	889268	g15812	i0	33.8	0.816254416961131	77	41	81.6	2	19	249	71	137	WP_224193151.1 hypothetical protein [Nannocystis pusilla]	diamond	231	43.5	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
30438742	30438742	PRJNA1120771_S_NODE_33253_length_212_cov_5.473373_g32853_i0	PRJNA1120771	33253	212	5.473373	11.60355076	Bacteria	2	Bacteria	Bacteria	62.4	5.82e-10	NR	HQP35242.1	2268199	g32853	i0	61	1.7688679245283	41	16	58	0	205	83	128	168	HQP35242.1 peptidylprolyl isomerase [Polyangiaceae bacterium]	diamond	375	62.8	0.993630573248408	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30575376	30575376	PRJNA1120771_S_NODE_16293_length_282_cov_3.523013_g15893_i0	PRJNA1120771	16293	282	3.523013	9.93489666	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	81.6	1.72e-17	NR	MBW1975642.1	2026735	g15893	i0	52.4	0.872340425531915	82	39	87.2	0	31	276	46	127	MBW1975642.1 50S ribosomal protein L7/L12 [Deltaproteobacteria bacterium]	diamond	246	81.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30859974	30859974	PRJNA1120771_S_NODE_25634_length_237_cov_1.345361_g25234_i0	PRJNA1120771	25634	237	1.345361	3.18850557	Myxococcales bacterium	2026763	Bacteria	Bacteria	48.5	3.17e-4	NR	MCB9640782.1	2026763	g25234	i0	48.9	0.569620253164557	45	23	57	0	2	136	1126	1170	MCB9640782.1 DUF924 family protein [Myxococcales bacterium]	diamond	135	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31018030	31018030	PRJNA1120771_S_NODE_20135_length_260_cov_4.608295_g19735_i0	PRJNA1120771	20135	260	4.608295	11.981567	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	50.8	4.46e-5	NR	HEY8145956.1	2212474	g19735	i0	38.2	1.77692307692308	76	44	84.2	1	260	42	150	225	HEY8145956.1 type 1 glutamine amidotransferase [Kofleriaceae bacterium]	diamond	462	50.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31112537	31112537	PRJNA1120771_S_NODE_14415_length_295_cov_1.571429_g14015_i0	PRJNA1120771	14415	295	1.571429	4.63571555	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.0384	NR	MBP1683886.1	2026735	g14015	i0	44.4	0.457627118644068	45	23	45.8	1	232	98	330	372	MBP1683886.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium]	diamond	135	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31576432	31576432	PRJNA1120771_S_NODE_9916_length_336_cov_12.569966_g9516_i0	PRJNA1120771	9916	336	12.569966	42.23508576	Pseudomonadati	3379134	Bacteria	Bacteria	84	1.65e-17	NR	HVE86554.1	2026763	g9516	i0	47.8	10.3839285714286	90	44	80.4	2	335	66	97	183	HVE86554.1 lipocalin family protein [Myxococcales bacterium]	diamond	3489	84	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32061555	32061555	PRJNA1120771_S_NODE_27978_length_228_cov_2.881081_g27578_i0	PRJNA1120771	27978	228	2.881081	6.56886468	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.1	0.0223	NR	MCE9575740.1	2026735	g27578	i0	56.4	0.513157894736842	39	17	51.3	0	6	122	501	539	MCE9575740.1 M4 family metallopeptidase [Deltaproteobacteria bacterium]	diamond	117	43.1	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);;