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

16 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax_phylum = "Actinomycetota"

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
13168975	13168975	PRJNA407368_S_NODE_971_length_648_cov_4.794830_g897_i0	PRJNA407368	971	648	4.79483	31.0704984	unclassified Actinomyces	2609248	Bacteria	Bacteria	229	3.87e-72	NR	WP_065427139.1	2609248	g897	i0	88.9	0.625	135	14	62	1	404	3	5	139	WP_065427139.1 MULTISPECIES: response regulator transcription factor [unclassified Actinomyces]	diamond	405	229	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces
17659261	17659261	PRJNA407368_S_NODE_4694_length_260_cov_7.480519_g4592_i0	PRJNA407368	4694	260	7.480519	19.4493494	Bacteria	2	Bacteria	Bacteria	144	1.24e-37	NR	WP_204011322.1	795644	g4592	i0	75.6	78.75	86	21	99.2	0	1	258	685	770	WP_204011322.1 aminomethyl-transferring glycine dehydrogenase [Sphaerimonospora thailandensis]	diamond	20475	144	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sphaerimonospora	Sphaerimonospora thailandensis
26663634	26663634	PRJNA407368_S_NODE_5381_length_236_cov_4.019324_g5279_i0	PRJNA407368	5381	236	4.019324	9.48560464	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	46.6	5.94e-4	NR	MDZ4248651.1	2518612	g5279	i0	45.5	0.699152542372881	55	29	69.9	1	166	2	1	54	MDZ4248651.1 HNH endonuclease [Candidatus Nanopelagicales bacterium]	diamond	165	46.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
26980466	26980466	PRJNA407368_S_NODE_5902_length_222_cov_3.331606_g5800_i0	PRJNA407368	5902	222	3.331606	7.39616532	Agromyces sp. LHK192	2498704	Bacteria	Bacteria	42.7	0.0283	NR	WP_127792068.1	2498704	g5800	i0	39.1	0.864864864864865	64	32	77	1	32	202	155	218	WP_127792068.1 family 78 glycoside hydrolase catalytic domain [Agromyces sp. LHK192]	diamond	192	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces sp. LHK192
27896589	27896589	PRJNA407368_S_NODE_6605_length_206_cov_4.039548_g6503_i0	PRJNA407368	6605	206	4.039548	8.32146888	Corynebacterium sp. MSK	1720	Bacteria	Bacteria	63.2	5.21e-10	NR	WP_284799116.1	3377090	g6503	i0	60.5	3.11650485436893	38	15	55.3	0	201	88	111	148	WP_284799116.1 HNH endonuclease signature motif containing protein [Corynebacterium kefirresidentii]	diamond	642	63.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. MSK071
28338788	28338788	PRJNA407368_S_NODE_8546_length_174_cov_2.179310_g8444_i0	PRJNA407368	8546	174	2.17931	3.7919994	Intrasporangium sp.	1925024	Bacteria	Bacteria	42	0.00463	NR	WP_331928557.1	1925024	g8444	i0	53.5	1.72413793103448	43	20	74.1	0	174	46	18	60	WP_331928557.1 hypothetical protein [Intrasporangium sp.]	diamond	300	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Intrasporangium	Intrasporangium sp.
29632889	29632889	PRJNA407368_S_NODE_7630_length_187_cov_2.468354_g7528_i0	PRJNA407368	7630	187	2.468354	4.61582198	Propionibacterium ruminifibrarum	1962131	Bacteria	Bacteria	41.6	0.0434	NR	SPF69569.1	1962131	g7528	i0	68	0.401069518716578	25	8	40.1	0	78	152	17	41	SPF69569.1 hypothetical protein PROPJV5_2556, partial [Propionibacterium ruminifibrarum]	diamond	75	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionibacterium	Propionibacterium ruminifibrarum
29871017	29871017	PRJNA407368_S_NODE_1611_length_495_cov_7.040773_g1517_i0	PRJNA407368	1611	495	7.040773	34.85182635	Bacteria	2	Bacteria	Bacteria	107	5.639999999999999e-24	NR	HAP89878.1	1667	g1517	i0	43.4	1.65454545454545	136	71	82.4	2	410	3	8	137	HAP89878.1 hypothetical protein [Arthrobacter sp.]	diamond	819	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp.
30075329	30075329	PRJNA407368_S_NODE_4212_length_280_cov_7.446215_g4110_i0	PRJNA407368	4212	280	7.446215	20.849402	Rhodococcoides fascians	1828	Bacteria	Bacteria	49.3	2.69e-4	NR	WP_032389217.1	1828	g4110	i0	32.2	0.932142857142857	87	59	93.2	0	18	278	9	95	WP_032389217.1 SGNH/GDSL hydrolase family protein [Rhodococcoides fascians]	diamond	261	49.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
30454952	30454952	PRJNA407368_S_NODE_1313_length_552_cov_3.864245_g1227_i0	PRJNA407368	1313	552	3.864245	21.3306324	Bifidobacterium pullorum	78448	Bacteria	Bacteria	154	1.17e-44	NR	WP_204469887.1	78448	g1227	i0	64.8	0.695652173913043	128	27	59.8	1	193	522	4	131	WP_204469887.1 hypothetical protein, partial [Bifidobacterium pullorum]	diamond	384	154	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium pullorum
30707291	30707291	PRJNA407368_S_NODE_6374_length_211_cov_6.873626_g6272_i0	PRJNA407368	6374	211	6.873626	14.50335086	Lawsonella	1847725	Bacteria	Bacteria	149	1.7799999999999994e-42	NR	WP_290599223.1	1847725	g6272	i0	100	0.995260663507109	70	0	99.5	0	210	1	157	226	WP_290599223.1 MULTISPECIES: DUF2993 domain-containing protein [Lawsonella]	diamond	210	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
30770709	30770709	PRJNA407368_S_NODE_3514_length_313_cov_3.415493_g3412_i0	PRJNA407368	3514	313	3.415493	10.69049309	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	45.8	0.00659	NR	HEX3387831.1	2339230	g3412	i0	37.7	1.33226837060703	69	43	66.1	0	59	265	89	157	HEX3387831.1 epoxide hydrolase [Streptosporangiaceae bacterium]	diamond	417	45.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
30897125	30897125	PRJNA407368_S_NODE_6274_length_214_cov_2.286486_g6172_i0	PRJNA407368	6274	214	2.286486	4.89308004	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	51.6	2.04e-6	NR	HQY16693.1	2497619	g6172	i0	83.9	0.434579439252336	31	3	43.5	1	124	32	32	60	HQY16693.1 hypothetical protein [Ilumatobacteraceae bacterium]	diamond	93	51.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
31055203	31055203	PRJNA407368_S_NODE_8455_length_175_cov_2.301370_g8353_i0	PRJNA407368	8455	175	2.30137	4.0273975	uncultured Arthrobacter sp.	114050	Bacteria	Bacteria	56.6	1.51e-7	NR	WP_294567586.1	114050	g8353	i0	45.9	1.04571428571429	61	28	99.4	2	175	2	147	205	WP_294567586.1 hypothetical protein [uncultured Arthrobacter sp.]	diamond	183	56.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	uncultured Arthrobacter sp.
31640701	31640701	PRJNA407368_S_NODE_5576_length_230_cov_4.184080_g5474_i0	PRJNA407368	5576	230	4.18408	9.623384	Bacteria	2	Bacteria	Bacteria	97.1	2.01e-22	NR	MFA7266888.1	2518612	g5474	i0	87.7	1.48695652173913	57	7	74.3	0	58	228	46	102	MFA7266888.1 indole-3-glycerol phosphate synthase TrpC [Candidatus Nanopelagicales bacterium]	diamond	342	97.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
31940230	31940230	PRJNA407368_S_NODE_6637_length_205_cov_18.897727_g6535_i0	PRJNA407368	6637	205	18.897727	38.74034035	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	42.7	0.021	NR	HST17223.1	2838783	g6535	i0	49	0.717073170731707	49	23	68.8	2	184	44	32	80	HST17223.1 hypothetical protein [Gaiellaceae bacterium]	diamond	147	42.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae 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);;