metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA314497" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA314497" 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
23332624	23332624	PRJNA314497_P_NODE_1199_length_512_cov_2.198758_g1061_i0	PRJNA314497	1199	512	2.198758	11.25764096	Bacteroidota bacterium	1898104	Bacteria	Bacteria	367	1.28e-123	NR	MBK6986222.1	1898104	g1061	i0	99.4	2.98828125	170	1	99.6	0	3	512	341	510	MBK6986222.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Bacteroidota bacterium]	diamond	1530	367	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
24606676	24606676	PRJNA314497_S_NODE_20_length_1327_cov_7.984592_g15_i0	PRJNA314497	20	1327	7.984592	105.95553584	unclassified Undibacterium	2630295	Bacteria	Bacteria	323	4.27e-100	NR	WP_322119055.1	2630295	g15	i0	63.4	1.81763376036172	279	95	61.9	4	828	7	1	277	WP_322119055.1 MULTISPECIES: chemotaxis protein CheA [unclassified Undibacterium]	diamond	2412	323	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium
26599187	26599187	PRJNA314497_P_NODE_2881_length_306_cov_2.267148_g2730_i0	PRJNA314497	2881	306	2.267148	6.93747288	Pasteurella skyensis	97481	Bacteria	Bacteria	135	5.37e-37	NR	WP_306400629.1	97481	g2730	i0	65.3	4.72549019607843	95	33	93.1	0	293	9	11	105	WP_306400629.1 IS256 family transposase, variant Zn-binding type, partial [Pasteurella skyensis]	diamond	1446	135	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Phocoenobacter	Phocoenobacter skyensis
27516704	27516704	PRJNA314497_S_NODE_1923_length_159_cov_1.923077_g1900_i0	PRJNA314497	1923	159	1.923077	3.05769243	Helicobacter pylori	210	Bacteria	Bacteria	68.2	8.14e-14	NR	GAA8554817.1	210	g1900	i0	80	0.754716981132076	40	8	75.5	0	122	3	4	43	GAA8554817.1 hypothetical protein KYTH17_15160 [Helicobacter pylori]	diamond	120	68.2	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27579765	27579765	PRJNA314497_P_NODE_3044_length_295_cov_3.338346_g2892_i0	PRJNA314497	3044	295	3.338346	9.8481207	Geminicoccus harenae	2498453	Bacteria	Bacteria	52	1.91e-6	NR	WP_222185125.1	2498453	g2892	i0	95.5	0.223728813559322	22	1	22.4	0	293	228	1	22	WP_222185125.1 hypothetical protein, partial [Geminicoccus harenae]	diamond	66	52	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Geminicoccales	Geminicoccaceae	Geminicoccus	Geminicoccus harenae
28116508	28116508	PRJNA314497_S_NODE_1225_length_205_cov_2.732955_g1202_i0	PRJNA314497	1225	205	2.732955	5.60255775	Lawsonella	1847725	Bacteria	Bacteria	121	3.46e-33	NR	WP_290595328.1	1847725	g1202	i0	100	0.878048780487805	60	0	87.8	0	205	26	99	158	WP_290595328.1 MULTISPECIES: dUTP diphosphatase [Lawsonella]	diamond	180	121	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28116509	28116509	PRJNA314497_S_NODE_645_length_296_cov_6.209738_g622_i0	PRJNA314497	645	296	6.209738	18.38082448	Herbaspirillum rubrisubalbicans	80842	Bacteria	Bacteria	60.1	3.48e-9	NR	WP_237742021.1	80842	g622	i0	65.2	0.466216216216216	46	15	46.6	1	259	122	1	45	WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans]	diamond	138	60.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum rubrisubalbicans
28242722	28242722	PRJNA314497_S_NODE_2106_length_151_cov_2.344262_g2083_i0	PRJNA314497	2106	151	2.344262	3.53983562	Anaerococcus lactolyticus	33032	Bacteria	Bacteria	93.6	1.32e-20	NR	WP_004827534.1	33032	g2083	i0	87.8	0.973509933774834	49	6	97.4	0	150	4	3	51	WP_004827534.1 heavy metal translocating P-type ATPase [Anaerococcus lactolyticus]	diamond	147	93.6	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus lactolyticus
28621936	28621936	PRJNA314497_S_NODE_507_length_338_cov_5.944984_g484_i0	PRJNA314497	507	338	5.944984	20.09404592	Herbaspirillum rubrisubalbicans	80842	Bacteria	Bacteria	60.5	3.9e-9	NR	WP_237742021.1	80842	g484	i0	67.9	0.470414201183432	53	15	47	1	106	264	2	52	WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans]	diamond	159	60.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum rubrisubalbicans
29127229	29127229	PRJNA314497_S_NODE_229_length_501_cov_7.108051_g208_i0	PRJNA314497	229	501	7.108051	35.61133551	bacterium	1869227	Bacteria	Bacteria	97.4	1.27e-21	NR	MFN9961035.1	1869227	g208	i0	62.1	0.395209580838323	66	25	39.5	0	303	500	1	66	MFN9961035.1 hypothetical protein [bacterium]	diamond	198	97.4	1	Bacteria								bacterium
29348067	29348067	PRJNA314497_P_NODE_3149_length_286_cov_2.190661_g2997_i0	PRJNA314497	3149	286	2.190661	6.26529046	Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14	1797697	Bacteria	Bacteria	89.4	2.64e-18	NR	OGO93707.1	1797697	g2997	i0	44.4	13.4895104895105	99	51	99.7	1	285	1	382	480	OGO93707.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpA [Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14]	diamond	3858	89.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Coxiellaceae	Coxiella	Coxiella sp. RIFCSPHIGHO2_12_FULL_44_14
30832585	30832585	PRJNA314497_S_NODE_1834_length_162_cov_2.315789_g1811_i0	PRJNA314497	1834	162	2.315789	3.75157818	Peptoniphilus rhinitidis	1175452	Bacteria	Bacteria	105	6.82e-25	NR	WP_316715316.1	1175452	g1811	i0	100	0.981481481481482	53	0	98.1	0	161	3	467	519	WP_316715316.1 preprotein translocase subunit SecA, partial [Peptoniphilus rhinitidis]	diamond	159	105	1	Bacteria		Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis
32336708	32336708	PRJNA314497_S_NODE_1519_length_179_cov_2.773333_g1496_i0	PRJNA314497	1519	179	2.773333	4.96426607	Marinobacter	2742	Bacteria	Bacteria	117	5.57e-30	NR	WP_273017580.1	83889	g1496	i0	91.5	4.94413407821229	59	5	98.9	0	2	178	74	132	WP_273017580.1 MULTISPECIES: polysaccharide deacetylase family protein [unclassified Marinobacter]	diamond	885	117	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter

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