metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax

25 rows where analysis = "diamond", bioproject = "PRJEB65099" 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
1404491	1404491	PRJEB65099_P_NODE_5462_length_250_cov_0.881356_g5357_i0	PRJEB65099	5462	250	0.881356	2.20339	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	150	4.08e-41	NR	MET0324809.1	2497619	g5357	i0	89	1.968	82	9	98.4	0	248	3	9	90	MET0324809.1 glucose-6-phosphate dehydrogenase [Ilumatobacteraceae bacterium]	diamond	492	150	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
9057219	9057219	PRJEB65099_P_NODE_6288_length_245_cov_0.906977_g6183_i0	PRJEB65099	6288	245	0.906977	2.22209365	Curtobacterium	2034	Bacteria	Bacteria	75.5	1.42e-14	NR	WP_133521004.1	2035	g6183	i0	91.9	0.918367346938776	37	3	45.3	0	244	134	167	203	WP_133521004.1 class I SAM-dependent methyltransferase [Curtobacterium flaccumfaciens]	diamond	225	75.9	0.994729907773386	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium flaccumfaciens
12883548	12883548	PRJEB65099_P_NODE_4731_length_257_cov_1.625000_g4626_i0	PRJEB65099	4731	257	1.625	4.17625	Nocardioides sp. NBC_	35761	Bacteria	Bacteria	125	2.2299999999999998e-32	NR	WP_406033827.1	2975999	g4626	i0	75.3	0.992217898832685	85	21	99.2	0	2	256	198	282	WP_406033827.1 damage-control phosphatase ARMT1 family protein [Nocardioides sp. NBC_00163]	diamond	255	125	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. NBC_00163
12883561	12883561	PRJEB65099_P_NODE_6751_length_243_cov_0.870588_g6646_i0	PRJEB65099	6751	243	0.870588	2.11552884	uncultured Friedmanniella sp.	335381	Bacteria	Bacteria	92	1.7e-19	NR	WP_375423596.1	335381	g6646	i0	81.5	0.666666666666667	54	10	66.7	0	82	243	3	56	WP_375423596.1 malto-oligosyltrehalose synthase [uncultured Friedmanniella sp.]	diamond	162	92	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	uncultured Friedmanniella sp.
16706631	16706631	PRJEB65099_P_NODE_6414_length_244_cov_1.456140_g6309_i0	PRJEB65099	6414	244	1.45614	3.5529816	Corynebacterium otitidis	29321	Bacteria	Bacteria	160	1.08e-46	NR	WP_046644615.1	29321	g6309	i0	97.5	0.995901639344262	81	2	99.6	0	243	1	157	237	WP_046644615.1 carboxylating nicotinate-nucleotide diphosphorylase [Corynebacterium otitidis]	diamond	243	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium otitidis
26994963	26994963	PRJEB65099_P_NODE_5822_length_248_cov_0.891429_g5717_i0	PRJEB65099	5822	248	0.891429	2.21074392	Mycobacterium	1763	Bacteria	Bacteria	139	5.53e-39	NR	MDT5154205.1	1785	g5717	i0	84.6	3.7741935483871	78	12	94.4	0	247	14	160	237	MDT5154205.1 hypothetical protein [Mycobacterium sp.]	diamond	936	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27065436	27065436	PRJEB65099_P_NODE_5242_length_251_cov_0.876404_g5137_i0	PRJEB65099	5242	251	0.876404	2.19977404	Corynebacterium otitidis	29321	Bacteria	Bacteria	155	7.23e-45	NR	WP_046644452.1	29321	g5137	i0	100	0.99203187250996006	83	0	99.2	0	249	1	54	136	WP_046644452.1 universal stress protein [Corynebacterium otitidis]	diamond	249	155	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium otitidis
27627325	27627325	PRJEB65099_P_NODE_6564_length_244_cov_0.912281_g6459_i0	PRJEB65099	6564	244	0.912281	2.22596564	Arthrobacter	1663	Bacteria	Bacteria	42.7	0.0363	NR	WP_182977081.1	1258888	g6459	i0	47.6	1.0327868852459	42	22	51.6	0	244	119	128	169	WP_182977081.1 polymer-forming cytoskeletal protein [Arthrobacter cheniae]	diamond	252	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter cheniae
28732309	28732309	PRJEB65099_P_NODE_6867_length_242_cov_0.923077_g6762_i0	PRJEB65099	6867	242	0.923077	2.23384634	Streptomycetaceae	2062	Bacteria	Bacteria	44.7	0.00764	NR	AUY53368.1	2078691	g6762	i0	30.8	2.30578512396694	78	47	96.7	2	241	8	250	320	AUY53368.1 zinc metalloprotease [Streptomyces sp. CB01881]	diamond	558	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CB01881
29528722	29528722	PRJEB65099_P_NODE_6850_length_242_cov_0.923077_g6745_i0	PRJEB65099	6850	242	0.923077	2.23384634	Candidatus Nanopelagicales bacterium	2518612	Bacteria	Bacteria	97.1	8.34e-22	NR	HEV8024664.1	2518612	g6745	i0	75	0.793388429752066	64	16	79.3	0	49	240	1	64	HEV8024664.1 ATP-binding protein [Candidatus Nanopelagicales bacterium]	diamond	192	97.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Candidatus Nanopelagicales			Candidatus Nanopelagicales bacterium
29781188	29781188	PRJEB65099_P_NODE_6171_length_246_cov_0.901734_g6066_i0	PRJEB65099	6171	246	0.901734	2.21826564	Actinomycetota bacterium	2900548	Bacteria	Bacteria	139	1.48e-39	NR	MDP9481475.1	2900548	g6066	i0	81.5	0.98780487804878	81	15	98.8	0	244	2	60	140	MDP9481475.1 GTPase domain-containing protein [Actinomycetota bacterium]	diamond	243	139	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
29812681	29812681	PRJEB65099_P_NODE_5011_length_253_cov_0.866667_g4906_i0	PRJEB65099	5011	253	0.866667	2.19266751	Thermoleophilia bacterium	2026888	Bacteria	Bacteria	107	3.82e-25	NR	MCW2956336.1	2026888	g4906	i0	66.3	0.984189723320158	83	28	98.4	0	249	1	51	133	MCW2956336.1 Stp1/IreP family PP2C-type Ser/Thr phosphatase [Thermoleophilia bacterium]	diamond	249	107	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia				Thermoleophilia bacterium
30223426	30223426	PRJEB65099_P_NODE_5312_length_251_cov_0.876404_g5207_i0	PRJEB65099	5312	251	0.876404	2.19977404	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	100	1.85e-24	NR	HEY7821791.1	2080302	g5207	i0	65.2	0.788844621513944	66	23	78.9	0	1	198	104	169	HEY7821791.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	198	100	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
30350408	30350408	PRJEB65099_P_NODE_4792_length_255_cov_1.714286_g4687_i0	PRJEB65099	4792	255	1.714286	4.3714293	Aestuariimicrobium ganziense	2773677	Bacteria	Bacteria	114	2.24e-29	NR	WP_203569003.1	2773677	g4687	i0	64.7	3	85	30	100	0	255	1	46	130	WP_203569003.1 recombinase family protein [Aestuariimicrobium ganziense]	diamond	765	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Aestuariimicrobium	Aestuariimicrobium ganziense
30381886	30381886	PRJEB65099_P_NODE_5793_length_248_cov_0.891429_g5688_i0	PRJEB65099	5793	248	0.891429	2.21074392	Kocuria carniphila	262208	Bacteria	Bacteria	151	1.6499999999999998e-42	NR	WP_315276703.1	262208	g5688	i0	100	0.955645161290323	79	0	95.6	0	2	238	292	370	WP_315276703.1 alpha/beta hydrolase [Kocuria carniphila]	diamond	237	151	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria carniphila
30792177	30792177	PRJEB65099_P_NODE_3694_length_290_cov_1.437788_g3589_i0	PRJEB65099	3694	290	1.437788	4.1695852	Salinibacterium sp. G-O1	3046208	Bacteria	Bacteria	153	3.15e-42	NR	WP_283504288.1	3046208	g3589	i0	81.3	4.96551724137931	96	18	99.3	0	290	3	68	163	WP_283504288.1 O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase family protein [Salinibacterium sp. G-O1]	diamond	1440	153	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Salinibacterium	Salinibacterium sp. G-O1
31076685	31076685	PRJEB65099_P_NODE_5495_length_250_cov_0.881356_g5390_i0	PRJEB65099	5495	250	0.881356	2.20339	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	139	6.449999999999999e-37	NR	HEX4931009.1	2838783	g5390	i0	86.6	0.984	82	11	98.4	0	3	248	102	183	HEX4931009.1 hypothetical protein [Gaiellaceae bacterium]	diamond	246	139	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
31100970	31100970	PRJEB65099_P_NODE_5155_length_252_cov_0.871508_g5050_i0	PRJEB65099	5155	252	0.871508	2.19620016	Bacteria	2	Bacteria	Bacteria	71.6	1.64e-12	NR	WP_223286673.1	592377	g5050	i0	53.2	2.85714285714286	79	32	91.7	2	236	6	91	166	WP_223286673.1 hypothetical protein [Kocuria atrinae]	diamond	720	72	0.994444444444444	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria atrinae
31456073	31456073	PRJEB65099_P_NODE_6716_length_243_cov_0.917647_g6611_i0	PRJEB65099	6716	243	0.917647	2.22988221	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	167	5.74e-48	NR	WP_303678908.1	1528099	g6611	i0	100	0.962962962962963	78	0	96.3	0	9	242	1	78	WP_303678908.1 glycosyltransferase 87 family protein [Lawsonella clevelandensis]	diamond	234	167	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31677302	31677302	PRJEB65099_P_NODE_4977_length_253_cov_0.866667_g4872_i0	PRJEB65099	4977	253	0.866667	2.19266751	Streptosporangiaceae bacterium	2339230	Bacteria	Bacteria	69.3	1.1e-12	NR	HEY5984964.1	2339230	g4872	i0	66.7	0.569169960474308	48	16	56.9	0	109	252	1	48	HEY5984964.1 hypothetical protein [Streptosporangiaceae bacterium]	diamond	144	69.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae		Streptosporangiaceae bacterium
31740504	31740504	PRJEB65099_P_NODE_3897_length_283_cov_1.485714_g3792_i0	PRJEB65099	3897	283	1.485714	4.20457062	Lawsonella	1847725	Bacteria	Bacteria	147	8.719999999999997e-42	NR	WP_290598459.1	1847725	g3792	i0	100	0.848056537102474	80	0	84.8	0	283	44	168	247	WP_290598459.1 MULTISPECIES: 2-deoxyribose-5-phosphate aldolase [Lawsonella]	diamond	240	147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
31962046	31962046	PRJEB65099_P_NODE_5378_length_250_cov_1.355932_g5273_i0	PRJEB65099	5378	250	1.355932	3.38983	Okibacterium sp. HSC-33S16	2910965	Bacteria	Bacteria	173	2.52e-49	NR	WP_253376697.1	2910965	g5273	i0	98.8	0.996	83	1	99.6	0	2	250	186	268	WP_253376697.1 ABC transporter substrate-binding protein [Okibacterium sp. HSC-33S16]	diamond	249	173	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Okibacterium	Okibacterium sp. HSC-33S16
32151967	32151967	PRJEB65099_P_NODE_6358_length_245_cov_0.906977_g6253_i0	PRJEB65099	6358	245	0.906977	2.22209365	Micromonospora pallida	145854	Bacteria	Bacteria	102	3.85e-23	NR	WP_091641206.1	145854	g6253	i0	64.2	0.991836734693878	81	29	99.2	0	243	1	115	195	WP_091641206.1 ATP-binding protein [Micromonospora pallida]	diamond	243	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora pallida
32405155	32405155	PRJEB65099_P_NODE_3819_length_286_cov_1.267606_g3714_i0	PRJEB65099	3819	286	1.267606	3.62535316	uncultured Williamsia sp.	259311	Bacteria	Bacteria	153	2.6e-44	NR	WP_299570260.1	259311	g3714	i0	93.8	0.839160839160839	80	5	83.9	0	1	240	170	249	WP_299570260.1 MerR family transcriptional regulator [uncultured Williamsia sp.]	diamond	240	153	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	uncultured Williamsia sp.
32405156	32405156	PRJEB65099_P_NODE_6099_length_246_cov_0.901734_g5994_i0	PRJEB65099	6099	246	0.901734	2.21826564	Agromyces larvae	2929802	Bacteria	Bacteria	43.9	0.0104	NR	WP_243558761.1	2929802	g5994	i0	76	0.304878048780488	25	6	30.5	0	170	244	5	29	WP_243558761.1 hypothetical protein [Agromyces larvae]	diamond	75	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces larvae

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