metadata: contig_metadata: 17 rows where bioproject = "PRJNA615175" and tax

17 rows where bioproject = "PRJNA615175" 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
17172748	17172748	PRJNA615175_P_NODE_21054_length_301_cov_2.245614_g20886_i0	PRJNA615175	21054	301	2.2456140000000002	6.75929814	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	231	3.35e-56	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g20886	i0	81.164	6.81063122923588	292	51	96	4	7	296	7587282	7586993	Corallococcus sp. EGB chromosome, complete genome	blastn	2050	231	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
25376244	25376244	PRJNA615175_P_NODE_9040_length_493_cov_4.866667_g8872_i0	PRJNA615175	9040	493	4.866667	23.99266831	Corallococcus	83461	Bacteria	Bacteria	767	0	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g8872	i0	94.769	295.269776876268	497	18	100	5	1	493	113339	113831	Corallococcus sp. EGB chromosome, complete genome	blastn	145568	773	0.992238033635188	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
28217043	28217043	PRJNA615175_P_NODE_27506_length_252_cov_2.391061_g27338_i0	PRJNA615175	27506	252	2.391061	6.02547372	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	88.6	2.28e-18	NR	HKE17719.1	2212474	g27338	i0	54.2	0.988095238095238	83	37	97.6	1	7	252	81	163	HKE17719.1 glycoside hydrolase family 5 protein [Kofleriaceae bacterium]	diamond	249	88.6	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28248667	28248667	PRJNA615175_P_NODE_10366_length_455_cov_4.405759_g10198_i0	PRJNA615175	10366	455	4.405759	20.04620345	Myxococcota bacterium	2818507	Bacteria	Bacteria	46.2	0.0195	NR	MEO0325632.1	2818507	g10198	i0	37	0.534065934065934	81	38	47.5	4	2	217	615	691	MEO0325632.1 hypothetical protein [Myxococcota bacterium]	diamond	243	46.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28640946	28640946	PRJNA615175_P_NODE_9607_length_475_cov_2.358209_g9439_i0	PRJNA615175	9607	475	2.358209	11.20149275	Pseudomonadati	3379134	Bacteria	Bacteria	149	8.42e-39	NR	MCB9647983.1	2026735	g9439	i0	46.2	4.02315789473684	158	80	96.6	1	6	464	433	590	MCB9647983.1 ATP-dependent metallopeptidase FtsH/Yme1/Tma family protein [Deltaproteobacteria bacterium]	diamond	1911	149	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28754052	28754052	PRJNA615175_P_NODE_6167_length_614_cov_7.000000_g6002_i0	PRJNA615175	6167	614	7	42.98	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	152	2.4399999999999998e-42	NR	MBI2605062.1	2026735	g6002	i0	37.3	0.982084690553746	201	122	96.7	4	598	5	36	235	MBI2605062.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	603	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29101449	29101449	PRJNA615175_P_NODE_22048_length_293_cov_2.200000_g21880_i0	PRJNA615175	22048	293	2.2	6.446	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47	0.00209	NR	TNF24827.1	2026735	g21880	i0	31.2	1.7098976109215	93	52	91.1	3	293	27	1	85	TNF24827.1 MAG: response regulator [Deltaproteobacteria bacterium]	diamond	501	47	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29637762	29637762	PRJNA615175_P_NODE_31110_length_247_cov_0.885057_g30942_i0	PRJNA615175	31110	247	0.885057	2.18609079	Myxococcota bacterium	2818507	Bacteria	Bacteria	140	5.7299999999999995e-37	NR	MDJ0787250.1	2818507	g30942	i0	80.5	1.9919028340081	82	16	99.6	0	247	2	182	263	MDJ0787250.1 proline--tRNA ligase [Myxococcota bacterium]	diamond	492	140	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29922477	29922477	PRJNA615175_P_NODE_29031_length_250_cov_0.870056_g28863_i0	PRJNA615175	29031	250	0.870056	2.17514	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	42.7	0.037	NR	HET9597852.1	2510643	g28863	i0	56.1	0.492	41	17	48	1	3	122	206	246	HET9597852.1 hypothetical protein [Anaeromyxobacteraceae bacterium]	diamond	123	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
30585671	30585671	PRJNA615175_P_NODE_12313_length_408_cov_28.540299_g12145_i0	PRJNA615175	12313	408	28.540299	116.44441992	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	95.5	1.06e-22	NR	MBA2321139.1	2026735	g12145	i0	52.3	0.647058823529412	88	42	64.7	0	71	334	3	90	MBA2321139.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	264	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30807042	30807042	PRJNA615175_P_NODE_7634_length_545_cov_2.838983_g7468_i0	PRJNA615175	7634	545	2.838983	15.472457350000001	Myxococcales bacterium	2026763	Bacteria	Bacteria	75.5	3.15e-12	NR	MBL8684693.1	2026763	g7468	i0	41.7	0.660550458715596	120	69	65.5	1	359	3	7	126	MBL8684693.1 DEAD/DEAH box helicase [Myxococcales bacterium]	diamond	360	75.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31072849	31072849	PRJNA615175_P_NODE_3475_length_834_cov_3.416557_g3328_i0	PRJNA615175	3475	834	3.416557	28.49408538	Chondromyces	50	Bacteria	Bacteria	140	2.34e-33	NR	WP_044250348.1	51	g3328	i0	36.7	1.80575539568345	251	143	85.3	7	832	122	590	838	WP_044250348.1 hypothetical protein [Chondromyces apiculatus]	diamond	1506	140	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces apiculatus
31357390	31357390	PRJNA615175_P_NODE_17096_length_339_cov_1.962406_g16928_i0	PRJNA615175	17096	339	1.962406	6.65255634	Bacteria	2	Bacteria	Bacteria	130	1.77e-32	NR	MBP6833942.1	2026735	g16928	i0	59	2.8141592920354	105	43	92.9	0	9	323	256	360	MBP6833942.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	954	131	0.99236641221374	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31945098	31945098	PRJNA615175_P_NODE_7077_length_568_cov_3.779798_g6912_i0	PRJNA615175	7077	568	3.779798	21.46925264	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	265	1.0499999999999999e-82	NR	MCP4160700.1	2026735	g6912	i0	70.9	0.998239436619718	189	55	99.8	0	568	2	34	222	MCP4160700.1 IS200/IS605 family element transposase accessory protein TnpB [Deltaproteobacteria bacterium]	diamond	567	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32230234	32230234	PRJNA615175_P_NODE_25558_length_267_cov_1.546392_g25390_i0	PRJNA615175	25558	267	1.546392	4.12886664	Myxococcota bacterium	2818507	Bacteria	Bacteria	181	8.21e-53	NR	HEY1099521.1	2818507	g25390	i0	92	0.97752808988764	87	7	97.8	0	5	265	134	220	HEY1099521.1 hypothetical protein [Myxococcota bacterium]	diamond	261	181	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32388218	32388218	PRJNA615175_P_NODE_26899_length_257_cov_1.668478_g26731_i0	PRJNA615175	26899	257	1.668478	4.28798846	Labilithrix luteola	1391654	Bacteria	Bacteria	132	6.13e-36	NR	WP_146654900.1	1391654	g26731	i0	75.3	0.992217898832685	85	21	99.2	0	2	256	67	151	WP_146654900.1 SDR family NAD(P)-dependent oxidoreductase [Labilithrix luteola]	diamond	255	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
32892773	32892773	PRJNA615175_P_NODE_14640_length_370_cov_1.936027_g14472_i0	PRJNA615175	14640	370	1.936027	7.1632999	Myxococcales bacterium	2026763	Bacteria	Bacteria	55.8	3.64e-6	NR	MBL8602125.1	2026763	g14472	i0	44.1	0.551351351351351	68	35	55.1	2	27	230	358	422	MBL8602125.1 endonuclease/exonuclease/phosphatase family protein [Myxococcales bacterium]	diamond	204	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;