metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA927284" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA927284" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
17479995	17479995	PRJNA927284_P_NODE_6354_length_211_cov_1.384615_g6147_i0	PRJNA927284	6354	211	1.384615	2.92153765	Undibacterium	401469	Bacteria	Bacteria	118	2.8199999999999997e-30	NR	WP_189357611.1	1131567	g6147	i0	91.3	1.96208530805687	69	6	98.1	0	3	209	15	83	WP_189357611.1 porin [Undibacterium squillarum]	diamond	414	119	0.991596638655462	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium squillarum
22579013	22579013	PRJNA927284_P_NODE_6018_length_221_cov_1.739583_g5811_i0	PRJNA927284	6018	221	1.739583	3.84447843	Salmonella sp. s54925	3159674	Bacteria	Bacteria	80.1	1.19e-17	NR	WP_411027451.1	3159674	g5811	i0	93	1.81900452488688	43	3	58.4	0	89	217	4	46	WP_411027451.1 MC/SLC25 family protein, partial [Salmonella sp. s54925]	diamond	402	80.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella sp. s54925
26676254	26676254	PRJNA927284_P_NODE_461_length_1178_cov_3.141862_g376_i0	PRJNA927284	461	1178	3.141862	37.01113436	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	178	2.3399999999999998e-46	NR	HSE15878.1	2283092	g376	i0	48.2	1.16638370118846	218	96	53.5	5	945	316	107	315	HSE15878.1 matrixin family metalloprotease [Pyrinomonadaceae bacterium]	diamond	1374	178	1	Bacteria		Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27056451	27056451	PRJNA927284_P_NODE_7622_length_181_cov_1.967105_g7415_i0	PRJNA927284	7622	181	1.967105	3.56046005	Segatella copri	165179	Bacteria	Bacteria	40	0.028	NR	RGS16953.1	165179	g7415	i0	51	0.812154696132597	49	22	79.6	2	38	181	25	72	RGS16953.1 hypothetical protein DWY11_05730, partial [Segatella copri]	diamond	147	40	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
27340992	27340992	PRJNA927284_P_NODE_6923_length_196_cov_1.383234_g6716_i0	PRJNA927284	6923	196	1.383234	2.71113864	Oceanobacillus limi	930131	Bacteria	Bacteria	71.6	8.83e-13	NR	WP_090867954.1	930131	g6716	i0	46.2	0.994897959183674	65	34	99.5	1	2	196	101	164	WP_090867954.1 formylglycine-generating enzyme family protein [Oceanobacillus limi]	diamond	195	71.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus limi
27853192	27853192	PRJNA927284_P_NODE_3784_length_322_cov_2.197952_g3578_i0	PRJNA927284	3784	322	2.197952	7.07740544	Myxococcales	29	Bacteria	Bacteria	80.9	3.41e-15	NR	MET0406658.1	1965334	g3578	i0	48	4.13664596273292	98	35	85.7	3	21	296	184	271	MET0406658.1 matrixin family metalloprotease [Cystobacter sp.]	diamond	1332	81.3	0.995079950799508	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter sp.
27908932	27908932	PRJNA927284_P_NODE_7465_length_184_cov_1.793548_g7258_i0	PRJNA927284	7465	184	1.793548	3.30012832	Candidatus Epilinea brevis	3140586	Bacteria	Bacteria	42.7	0.0176	NR	MBK8539097.1	3140586	g7258	i0	50.9	0.929347826086957	57	27	91.3	1	168	1	1073	1129	MBK8539097.1 VWA domain-containing protein [Candidatus Epilinea brevis]	diamond	171	42.7	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Epilineales	Candidatus Epilineaceae	Candidatus Epilinea	Candidatus Epilinea brevis
28105723	28105723	PRJNA927284_P_NODE_7305_length_187_cov_2.430380_g7098_i0	PRJNA927284	7305	187	2.43038	4.5448106	Pseudomonadati	3379134	Bacteria	Bacteria	62	2.88e-9	NR	MBK9459220.1	2044944	g7098	i0	46.4	2.53475935828877	56	30	89.8	0	2	169	749	804	MBK9459220.1 cadherin-like domain-containing protein [Sphingobacteriales bacterium]	diamond	474	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
28193180	28193180	PRJNA927284_P_NODE_2686_length_410_cov_3.574803_g2487_i0	PRJNA927284	2686	410	3.574803	14.6566923	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	46.2	0.0121	NR	HEV3269691.1	2320511	g2487	i0	41.5	0.951219512195122	53	31	38.8	0	226	68	34	86	HEV3269691.1 ATP-binding protein [Candidatus Rhabdochlamydia sp.]	diamond	390	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
28509174	28509174	PRJNA927284_P_NODE_687_length_953_cov_2.990260_g376_i1	PRJNA927284	687	953	2.99026	28.4971778	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	178	2.859999999999999e-47	NR	HSE15878.1	2283092	g376	i1	48.2	1.44176285414481	218	96	66.1	5	720	91	107	315	HSE15878.1 matrixin family metalloprotease [Pyrinomonadaceae bacterium]	diamond	1374	178	1	Bacteria		Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28951375	28951375	PRJNA927284_P_NODE_7568_length_182_cov_2.352941_g7361_i0	PRJNA927284	7568	182	2.352941	4.28235262	Cyanobacteria bacterium J06638_20	3023208	Bacteria	Bacteria	53.1	3.44e-6	NR	MEO1211654.1	3023208	g7361	i0	46.9	0.807692307692308	49	26	80.8	0	35	181	229	277	MEO1211654.1 reverse transcriptase family protein [Cyanobacteria bacterium J06638_20]	diamond	147	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06638_20
30758702	30758702	PRJNA927284_P_NODE_3594_length_336_cov_1.840391_g3389_i0	PRJNA927284	3594	336	1.840391	6.18371376	Pseudomonadati	3379134	Bacteria	Bacteria	78.6	2.88e-14	NR	HEY0840344.1	1971226	g3389	i0	72	9.46428571428571	50	14	44.6	0	334	185	556	605	HEY0840344.1 M2 family metallopeptidase [Vulgatibacter sp.]	diamond	3180	78.6	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter sp.
30853419	30853419	PRJNA927284_P_NODE_8114_length_172_cov_1.748252_g7907_i0	PRJNA927284	8114	172	1.748252	3.00699344	root	1	Root_unresolved	Root_unresolved	80.9	2.08e-18	NR	TOF73137.1	670	g7907	i0	69.1	7.67441860465116	55	17	95.9	0	6	170	5	59	TOF73137.1 hypothetical protein CGJ15_27410, partial [Vibrio parahaemolyticus]	diamond	1320	81.3	0.995079950799508	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio parahaemolyticus
30941239	30941239	PRJNA927284_P_NODE_2414_length_442_cov_2.329298_g2219_i0	PRJNA927284	2414	442	2.329298	10.29549716	unclassified Psychrobacter	196806	Bacteria	Bacteria	45.1	0.0162	NR	WP_192519134.1	196806	g2219	i0	43.5	0.420814479638009	62	30	42.1	2	393	208	67	123	WP_192519134.1 MULTISPECIES: hypothetical protein [unclassified Psychrobacter]	diamond	186	45.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter
32237999	32237999	PRJNA927284_P_NODE_78_length_2298_cov_20.235787_g61_i0	PRJNA927284	78	2298	20.235787	465.01838526	Clostridium perfringens	1502	Bacteria	Bacteria	224	1.5e-64	NR	MDJ8942385.1	1502	g61	i0	72.8	0.785900783289817	151	41	19.7	0	212	664	43	193	MDJ8942385.1 hypothetical protein [Clostridium perfringens]	diamond	1806	224	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
32781574	32781574	PRJNA927284_P_NODE_8660_length_162_cov_2.729323_g8453_i0	PRJNA927284	8660	162	2.729323	4.42150326	root	1	Root_unresolved	Root_unresolved	107	1.39e-25	NR	WP_337456038.1	562	g8453	i0	96.3	674.944444444444	54	2	100	0	162	1	111	164	WP_337456038.1 tubulin alpha chain, partial [Escherichia coli]	diamond	109341	108	0.990740740740741	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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);;