metadata: contig_metadata: 31 rows where analysis = "diamond", bioproject = "PRJNA1036688" and tax

31 rows where analysis = "diamond", bioproject = "PRJNA1036688" 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
10372866	10372866	PRJNA1036688_P_NODE_11649_length_155_cov_1.313559_g11357_i0	PRJNA1036688	11649	155	1.313559	2.03601645	Undibacterium	401469	Bacteria	Bacteria	90.9	5.8e-22	NR	WP_189357193.1	401469	g11357	i0	100	0.987096774193548	51	0	98.7	0	2	154	38	88	WP_189357193.1 MULTISPECIES: 50S ribosomal protein L18 [Undibacterium]	diamond	153	90.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium
15472465	15472465	PRJNA1036688_P_NODE_10833_length_162_cov_1.232000_g10541_i0	PRJNA1036688	10833	162	1.232	1.99584	Undibacterium luofuense	2828733	Bacteria	Bacteria	98.2	3.58e-22	NR	WP_212686705.1	2828733	g10541	i0	100	0.981481481481482	53	0	98.1	0	2	160	137	189	WP_212686705.1 catecholate siderophore receptor Fiu [Undibacterium luofuense]	diamond	159	98.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium luofuense
18021571	18021571	PRJNA1036688_P_NODE_9435_length_176_cov_1.633094_g9143_i0	PRJNA1036688	9435	176	1.633094	2.87424544	Stenotrophomonas sp.	69392	Bacteria	Bacteria	98.2	1.2800000000000001e-22	NR	WP_287256582.1	69392	g9143	i0	77.6	0.988636363636364	58	13	98.9	0	174	1	93	150	WP_287256582.1 integrase, partial [Stenotrophomonas sp.]	diamond	174	98.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas sp.
24395680	24395680	PRJNA1036688_P_NODE_10400_length_166_cov_0.992248_g10108_i0	PRJNA1036688	10400	166	0.992248	1.64713168	Brachybacterium	43668	Bacteria	Bacteria	81.6	8.03e-17	NR	WP_377018317.1	2623841	g10108	i0	100	2.96385542168675	41	0	74.1	0	1	123	247	287	WP_377018317.1 MULTISPECIES: carbohydrate ABC transporter permease [unclassified Brachybacterium]	diamond	492	81.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium
26845550	26845550	PRJNA1036688_P_NODE_7381_length_206_cov_1.591716_g7089_i0	PRJNA1036688	7381	206	1.591716	3.27893496	Acinetobacter baumannii	470	Bacteria	Bacteria	118	6.36e-33	NR	WP_227516975.1	470	g7089	i0	96.8	0.902912621359223	62	2	90.3	0	205	20	34	95	WP_227516975.1 hypothetical protein, partial [Acinetobacter baumannii]	diamond	186	118	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
27540847	27540847	PRJNA1036688_P_NODE_11324_length_157_cov_2.875000_g11032_i0	PRJNA1036688	11324	157	2.875	4.51375	uncultured Peptostreptococcus sp.	169971	Bacteria	Bacteria	83.2	5.33e-17	NR	WP_314278689.1	169971	g11032	i0	78.8	0.993630573248408	52	11	99.4	0	1	156	147	198	WP_314278689.1 Rib/alpha-like domain-containing protein, partial [uncultured Peptostreptococcus sp.]	diamond	156	83.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus	uncultured Peptostreptococcus sp.
27540848	27540848	PRJNA1036688_P_NODE_12004_length_152_cov_1.686957_g11712_i0	PRJNA1036688	12004	152	1.686957	2.56417464	[Clostridium] innocuum	1522	Bacteria	Bacteria	78.2	8.08e-17	NR	WP_156113307.1	1522	g11712	i0	74	0.986842105263158	50	13	98.7	0	152	3	80	129	WP_156113307.1 ribonuclease H family protein, partial [[Clostridium] innocuum]	diamond	150	78.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum
27635605	27635605	PRJNA1036688_P_NODE_6004_length_240_cov_0.950739_g5712_i0	PRJNA1036688	6004	240	0.950739	2.2817736	Kitasatospora purpeofusca	67352	Bacteria	Bacteria	42.4	0.0497	NR	WP_266315073.1	67352	g5712	i0	42.1	0.7125	57	31	70	2	204	37	338	393	WP_266315073.1 hypothetical protein [Kitasatospora purpeofusca]	diamond	171	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora purpeofusca
27856420	27856420	PRJNA1036688_P_NODE_10625_length_164_cov_1.181102_g10333_i0	PRJNA1036688	10625	164	1.181102	1.93700728	Prevotella pallens	60133	Bacteria	Bacteria	105	6.3e-25	NR	MBF1514088.1	60133	g10333	i0	96.3	0.98780487804878	54	2	98.8	0	164	3	346	399	MBF1514088.1 DUF11 domain-containing protein [Prevotella pallens]	diamond	162	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella pallens
27856422	27856422	PRJNA1036688_P_NODE_8785_length_184_cov_1.748299_g8493_i0	PRJNA1036688	8785	184	1.748299	3.21687016	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	46.2	9.36e-5	NR	WP_267991923.1	715	g8493	i0	56.3	0.521739130434783	32	14	52.2	0	5	100	34	65	WP_267991923.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	96	46.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
27982798	27982798	PRJNA1036688_P_NODE_8485_length_188_cov_2.013245_g8193_i0	PRJNA1036688	8485	188	2.013245	3.7849006	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	114	1.23e-30	NR	MDO9333994.1	2026733	g8193	i0	91.9	1.97872340425532	62	5	98.9	0	3	188	29	90	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	372	114	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
28203570	28203570	PRJNA1036688_P_NODE_11426_length_157_cov_0.925000_g11134_i0	PRJNA1036688	11426	157	0.925	1.45225	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	60.1	4.06e-10	NR	WP_267992332.1	715	g11134	i0	66.7	0.687898089171974	36	12	68.8	0	49	156	33	68	WP_267992332.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	108	60.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
29214424	29214424	PRJNA1036688_P_NODE_4149_length_309_cov_2.444853_g3857_i0	PRJNA1036688	4149	309	2.444853	7.55459577	Bacillus thuringiensis	1428	Bacteria	Bacteria	42.7	0.0227	NR	WP_197266154.1	1428	g3857	i0	37.9	0.563106796116505	58	30	53.4	2	80	244	26	80	WP_197266154.1 DUF3992 domain-containing protein [Bacillus thuringiensis]	diamond	174	42.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
29245779	29245779	PRJNA1036688_P_NODE_10849_length_162_cov_1.008000_g10557_i0	PRJNA1036688	10849	162	1.008	1.63296	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	60.1	1.48e-9	NR	WP_267994764.1	715	g10557	i0	52	1.85185185185185	50	23	92.6	1	1	150	82	130	WP_267994764.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	300	60.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
29561334	29561334	PRJNA1036688_P_NODE_11810_length_154_cov_0.846154_g11518_i0	PRJNA1036688	11810	154	0.846154	1.30307716	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	73.2	7.97e-15	NR	WP_267995017.1	715	g11518	i0	75.5	0.954545454545455	49	12	95.5	0	2	148	42	90	WP_267995017.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	147	73.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
29719087	29719087	PRJNA1036688_P_NODE_9530_length_175_cov_1.688406_g9238_i0	PRJNA1036688	9530	175	1.688406	2.9547105	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	41.6	0.0399	NR	MFN8864399.1	2021391	g9238	i0	39.6	1.64571428571429	48	27	82.3	1	151	8	381	426	MFN8864399.1 MopE-related protein [Flavobacteriales bacterium]	diamond	288	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29750699	29750699	PRJNA1036688_P_NODE_10591_length_164_cov_1.677165_g10299_i0	PRJNA1036688	10591	164	1.677165	2.7505506	Salmonella enterica	28901	Bacteria	Bacteria	69.3	6.78e-14	NR	WP_218972368.1	28901	g10299	i0	94.4	0.658536585365854	36	2	65.9	0	110	3	1	36	WP_218972368.1 hypothetical protein, partial [Salmonella enterica]	diamond	108	69.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29845660	29845660	PRJNA1036688_P_NODE_11371_length_157_cov_1.625000_g11079_i0	PRJNA1036688	11371	157	1.625	2.55125	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	105	8.56e-27	NR	MEZ5292075.1	2910147	g11079	i0	96.2	0.993630573248408	52	2	99.4	0	2	157	163	214	MEZ5292075.1 methyltransferase domain-containing protein [Vicinamibacterales bacterium]	diamond	156	105	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
30066734	30066734	PRJNA1036688_P_NODE_9232_length_178_cov_2.560284_g8940_i0	PRJNA1036688	9232	178	2.560284	4.55730552	Burkholderiales bacterium	1891238	Bacteria	Bacteria	43.5	0.00112	NR	HXM83151.1	1891238	g8940	i0	78.9	1.24719101123595	19	4	32	0	10	66	46	64	HXM83151.1 membrane protein insertion efficiency factor YidD [Burkholderiales bacterium]	diamond	222	43.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
30161348	30161348	PRJNA1036688_P_NODE_10712_length_163_cov_1.317460_g10420_i0	PRJNA1036688	10712	163	1.31746	2.1474598	Stenotrophomonas sp.	69392	Bacteria	Bacteria	76.6	9.75e-15	NR	WP_287256582.1	69392	g10420	i0	63.5	0.957055214723926	52	19	95.7	0	158	3	246	297	WP_287256582.1 integrase, partial [Stenotrophomonas sp.]	diamond	156	76.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas sp.
30414680	30414680	PRJNA1036688_P_NODE_7093_length_212_cov_1.977143_g6801_i0	PRJNA1036688	7093	212	1.977143	4.19154316	Aphanizomenon sp. 202	88823	Bacteria	Bacteria	72.8	9.34e-15	NR	MDK2413532.1	88823	g6801	i0	66.7	0.806603773584906	57	19	80.7	0	3	173	4	60	MDK2413532.1 hypothetical protein [Aphanizomenon sp. 202]	diamond	171	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon sp. 202
30540704	30540704	PRJNA1036688_P_NODE_8233_length_192_cov_1.393548_g7941_i0	PRJNA1036688	8233	192	1.393548	2.67561216	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	62	9.82e-11	NR	WP_267994951.1	715	g7941	i0	70	0.78125	50	11	71.9	1	190	53	37	86	WP_267994951.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	150	62	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
30793401	30793401	PRJNA1036688_P_NODE_8374_length_190_cov_1.307190_g8082_i0	PRJNA1036688	8374	190	1.30719	2.483661	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	61.2	6.62e-10	NR	WP_267994742.1	715	g8082	i0	83.8	0.58421052631579	37	4	58.4	1	113	3	1	35	WP_267994742.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	111	61.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
30943601	30943601	PRJNA1036688_P_NODE_3674_length_336_cov_7.351171_g3383_i0	PRJNA1036688	3674	336	7.351171	24.69993456	Oxalobacteraceae	75682	Bacteria	Bacteria	204	1.43e-60	NR	WP_223826888.1	1537398	g3383	i0	93.5	5.77678571428571	107	7	95.5	0	1	321	87	193	WP_223826888.1 terminase large subunit [Undibacterium aquatile]	diamond	1941	204	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium aquatile
31203791	31203791	PRJNA1036688_P_NODE_8195_length_192_cov_3.645161_g7903_i0	PRJNA1036688	8195	192	3.645161	6.99870912	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	42.4	0.0255	NR	MFM7118878.1	1913989	g7903	i0	36.7	0.9375	60	29	87.5	2	20	187	316	370	MFM7118878.1 SLC13 family permease [Gammaproteobacteria bacterium]	diamond	180	42.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
31394181	31394181	PRJNA1036688_P_NODE_9096_length_180_cov_1.601399_g8804_i0	PRJNA1036688	9096	180	1.601399	2.8825182	Acinetobacter baumannii	470	Bacteria	Bacteria	119	1.9499999999999998e-32	NR	OIC52161.1	470	g8804	i0	98.3	1	60	1	100	0	180	1	63	122	OIC52161.1 hypothetical protein A7L55_19745 [Acinetobacter baumannii]	diamond	180	119	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
32018637	32018637	PRJNA1036688_P_NODE_8158_length_193_cov_1.500000_g7866_i0	PRJNA1036688	8158	193	1.5	2.895	Azospirillum	191	Bacteria	Bacteria	45.4	0.00216	NR	WP_085556800.1	1720247	g7866	i0	90	0.932642487046632	20	2	31.1	0	2	61	453	472	WP_085556800.1 homospermidine synthase [Azospirillum agricola]	diamond	180	45.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Azospirillaceae	Azospirillum	Azospirillum agricola
32184958	32184958	PRJNA1036688_P_NODE_9198_length_179_cov_0.802817_g8906_i0	PRJNA1036688	9198	179	0.802817	1.43704243	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	105	4.34e-28	NR	WP_369124389.1	715	g8906	i0	87.7	0.955307262569832	57	7	95.5	0	1	171	19	75	WP_369124389.1 integrase catalytic domain-containing protein, partial [Actinobacillus pleuropneumoniae]	diamond	171	105	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae
32596145	32596145	PRJNA1036688_P_NODE_11060_length_160_cov_1.260163_g10768_i0	PRJNA1036688	11060	160	1.260163	2.0162608	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	39.3	0.0363	NR	MDA8389609.1	1913989	g10768	i0	54.8	0.58125	31	14	58.1	0	19	111	20	50	MDA8389609.1 CDGSH iron-sulfur domain-containing protein [Gammaproteobacteria bacterium]	diamond	93	39.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
32784855	32784855	PRJNA1036688_P_NODE_6280_length_232_cov_1.805128_g5988_i0	PRJNA1036688	6280	232	1.805128	4.18789696	Escherichia coli	562	Bacteria	Bacteria	75.1	9.93e-16	NR	MDW3502763.1	562	g5988	i0	62.1	0.75	58	22	75	0	180	7	15	72	MDW3502763.1 retrotransposon gag domain-containing protein [Escherichia coli]	diamond	174	75.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32847902	32847902	PRJNA1036688_P_NODE_9320_length_177_cov_2.192857_g9028_i0	PRJNA1036688	9320	177	2.192857	3.88135689	Actinobacillus pleuropneumoniae	715	Bacteria	Bacteria	41.2	0.0114	NR	WP_267994688.1	715	g9028	i0	100	0.322033898305085	19	0	32.2	0	117	173	1	19	WP_267994688.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae]	diamond	57	41.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Actinobacillus	Actinobacillus pleuropneumoniae

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