metadata: contig_metadata: 15 rows where bioproject = "PRJNA897077" and tax

15 rows where bioproject = "PRJNA897077" 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
2148869	2148869	PRJNA897077_P_NODE_14062_length_264_cov_1.507853_g13935_i0	PRJNA897077	14062	264	1.507853	3.98073192	Stigmatella aurantiaca	41	Bacteria	Bacteria	315	2.79e-81	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g13935	i0	88.213	38.1287878787879	263	31	99	0	1	263	5835269	5835531	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	10066	315	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
3424325	3424325	PRJNA897077_P_NODE_12623_length_279_cov_1.504854_g12496_i0	PRJNA897077	12623	279	1.504854	4.19854266	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	172	8.08e-50	NR	HTV19334.1	2268199	g12496	i0	93.5	2	93	6	100	0	279	1	262	354	HTV19334.1 serine--tRNA ligase [Polyangiaceae bacterium]	diamond	558	172	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
26802451	26802451	PRJNA897077_P_NODE_16861_length_249_cov_0.886364_g16734_i0	PRJNA897077	16861	249	0.886364	2.20704636	Myxococcota bacterium	2818507	Bacteria	Bacteria	132	8.649999999999998e-35	NR	HEX5067653.1	2818507	g16734	i0	81.9	1	83	15	100	0	249	1	326	408	HEX5067653.1 6-phosphofructokinase [Myxococcota bacterium]	diamond	249	132	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27087420	27087420	PRJNA897077_P_NODE_19962_length_242_cov_0.923077_g19835_i0	PRJNA897077	19962	242	0.923077	2.23384634	Myxococcota bacterium	2818507	Bacteria	Bacteria	124	2.5299999999999993e-31	NR	MCK6527060.1	2818507	g19835	i0	69.2	2.87603305785124	78	24	96.7	0	2	235	170	247	MCK6527060.1 M20/M25/M40 family metallo-hydrolase [Myxococcota bacterium]	diamond	696	124	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27245346	27245346	PRJNA897077_P_NODE_19463_length_243_cov_0.917647_g19336_i0	PRJNA897077	19463	243	0.917647	2.22988221	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	154	5.299999999999999e-43	NR	HVK71842.1	2212474	g19336	i0	92.6	1	81	6	100	0	1	243	88	168	HVK71842.1 hypothetical protein [Kofleriaceae bacterium]	diamond	243	154	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27908280	27908280	PRJNA897077_P_NODE_19405_length_243_cov_0.917647_g19278_i0	PRJNA897077	19405	243	0.917647	2.22988221	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	117	4.59e-32	NR	MBW2474250.1	2026735	g19278	i0	98.4	0.790123456790123	64	1	79	0	192	1	1	64	MBW2474250.1 TraR/DksA C4-type zinc finger protein [Deltaproteobacteria bacterium]	diamond	192	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28445483	28445483	PRJNA897077_P_NODE_18526_length_245_cov_0.906977_g18399_i0	PRJNA897077	18526	245	0.906977	2.22209365	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	55.1	1.34e-6	NR	HMJ15863.1	2268199	g18399	i0	63.4	0.502040816326531	41	15	50.2	0	239	117	230	270	HMJ15863.1 DUF1588 domain-containing protein [Polyangiaceae bacterium]	diamond	123	55.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28445486	28445486	PRJNA897077_P_NODE_19586_length_243_cov_0.888235_g19459_i0	PRJNA897077	19586	243	0.888235	2.15841105	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	65.9	2.58e-10	NR	HEV3192348.1	2268199	g19459	i0	50.7	1.80246913580247	69	34	85.2	0	2	208	250	318	HEV3192348.1 sulfatase-like hydrolase/transferase [Polyangiaceae bacterium]	diamond	438	65.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28792460	28792460	PRJNA897077_P_NODE_12567_length_280_cov_1.188406_g12440_i0	PRJNA897077	12567	280	1.188406	3.3275368	Myxococcota bacterium	2818507	Bacteria	Bacteria	132	1.88e-33	NR	HKA14172.1	2818507	g12440	i0	72.8	0.985714285714286	92	25	98.6	0	2	277	158	249	HKA14172.1 filamentous hemagglutinin N-terminal domain-containing protein [Myxococcota bacterium]	diamond	276	132	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29810573	29810573	PRJNA897077_P_NODE_18271_length_246_cov_0.901734_g18144_i0	PRJNA897077	18271	246	0.901734	2.21826564	Pseudomonadati	3379134	Bacteria	Bacteria	97.4	1.79e-21	NR	MCZ6623122.1	2026735	g18144	i0	59.7	1.90243902439024	77	31	93.9	0	7	237	286	362	MCZ6623122.1 tRNA lysidine(34) synthetase TilS [Deltaproteobacteria bacterium]	diamond	468	97.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30529568	30529568	PRJNA897077_P_NODE_19013_length_244_cov_0.912281_g18886_i0	PRJNA897077	19013	244	0.912281	2.22596564	Myxococcota bacterium	2818507	Bacteria	Bacteria	77	1.83e-14	NR	HJN72683.1	2818507	g18886	i0	62.5	0.688524590163934	56	21	68.9	0	1	168	271	326	HJN72683.1 hypothetical protein [Myxococcota bacterium]	diamond	168	77	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31667503	31667503	PRJNA897077_P_NODE_12637_length_279_cov_1.383495_g12510_i0	PRJNA897077	12637	279	1.383495	3.85995105	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	51.2	5.08e-5	NR	MBX3131500.1	2268199	g12510	i0	73.3	1.59139784946237	30	8	32.3	0	190	279	1	30	MBX3131500.1 phosphatidylserine decarboxylase [Polyangiaceae bacterium]	diamond	444	51.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32174019	32174019	PRJNA897077_P_NODE_18798_length_244_cov_1.631579_g18671_i0	PRJNA897077	18798	244	1.631579	3.98105276	Archangium sp.	1872627	Bacteria	Bacteria	44.3	0.0104	NR	MDP3155974.1	1872627	g18671	i0	35.9	0.959016393442623	78	45	91	2	10	231	220	296	MDP3155974.1 hypothetical protein [Archangium sp.]	diamond	234	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
32426949	32426949	PRJNA897077_P_NODE_19539_length_243_cov_0.917647_g19412_i0	PRJNA897077	19539	243	0.917647	2.22988221	Sorangium cellulosum	56	Bacteria	Bacteria	107	1.4199999999999999e-25	NR	WP_129344918.1	56	g19412	i0	65.4	1	81	26	97.5	1	3	239	53	133	WP_129344918.1 serine/threonine-protein kinase [Sorangium cellulosum]	diamond	243	107	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
32836832	32836832	PRJNA897077_P_NODE_15420_length_253_cov_0.866667_g15293_i0	PRJNA897077	15420	253	0.866667	2.19266751	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.7	0.0407	NR	MEO1233093.1	2818507	g15293	i0	39.2	0.604743083003953	51	28	56.9	1	21	164	446	496	MEO1233093.1 DUF2330 domain-containing protein [Myxococcota bacterium]	diamond	153	42.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;