metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA326068" 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
18241070	18241070	PRJNA326068_P_NODE_4175_length_541_cov_2.687500_g3415_i0	PRJNA326068	4175	541	2.6875	14.539375	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	290	6.88e-98	NR	MBX9724270.1	2364082	g3415	i0	92.8	0.842883548983364	152	11	84.3	0	539	84	19	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	456	290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
19515329	19515329	PRJNA326068_P_NODE_8836_length_347_cov_1.833333_g7882_i0	PRJNA326068	8836	347	1.833333	6.36166551	Aquincola	391952	Bacteria	Bacteria	124	9.61e-34	NR	WP_046112008.1	391952	g7882	i0	87.3	0.68299711815562	79	6	64.8	1	225	1	21	99	WP_046112008.1 MULTISPECIES: hypothetical protein [Aquincola]	diamond	237	124	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Aquincola
26821599	26821599	PRJNA326068_P_NODE_13941_length_235_cov_1.820388_g12978_i0	PRJNA326068	13941	235	1.820388	4.2779118	uncultured Acidobacteria bacterium HF4	171953	Bacteria	Bacteria	42	0.0394	NR	ADI18657.1	710731	g12978	i0	36.9	1.07234042553191	84	47	99.6	1	1	234	59	142	ADI18657.1 hypothetical protein [uncultured Acidobacteria bacterium HF4000_26D02]	diamond	252	42	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteria bacterium HF4000_26D02
27137372	27137372	PRJNA326068_P_NODE_5802_length_457_cov_9.481308_g4940_i0	PRJNA326068	5802	457	9.481308	43.32957756	Sphingomonadaceae bacterium PASS1	2015579	Bacteria	Bacteria	120	4.4899999999999997e-32	NR	OYU02204.1	2015579	g4940	i0	70.6	0.557986870897155	85	25	55.8	0	293	39	16	100	OYU02204.1 MAG: hypothetical protein CFE36_06940 [Sphingomonadaceae bacterium PASS1]	diamond	255	120	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae		Sphingomonadaceae bacterium PASS1
27769804	27769804	PRJNA326068_P_NODE_18564_length_171_cov_3.366197_g17601_i0	PRJNA326068	18564	171	3.366197	5.75619687	Odoribacter splanchnicus	28118	Bacteria	Bacteria	49.7	2.91e-5	NR	SPY22707.1	28118	g17601	i0	50.9	0.929824561403509	53	26	93	0	10	168	65	117	SPY22707.1 Uncharacterised protein [Odoribacter splanchnicus]	diamond	159	49.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter splanchnicus
27927462	27927462	PRJNA326068_P_NODE_11065_length_290_cov_15.045977_g10104_i0	PRJNA326068	11065	290	15.045977	43.6333333	Sphingomonadaceae bacterium PASS1	2015579	Bacteria	Bacteria	118	3.28e-32	NR	OYU02204.1	2015579	g10104	i0	71.8	0.879310344827586	85	24	87.9	0	6	260	16	100	OYU02204.1 MAG: hypothetical protein CFE36_06940 [Sphingomonadaceae bacterium PASS1]	diamond	255	118	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae		Sphingomonadaceae bacterium PASS1
28053608	28053608	PRJNA326068_P_NODE_12585_length_259_cov_3.139130_g11622_i0	PRJNA326068	12585	259	3.13913	8.1303467	Novosphingobium sp.	1874826	Bacteria	Bacteria	65.5	2.43e-11	NR	WP_296676571.1	1874826	g11622	i0	68.8	0.555984555984556	48	15	55.6	0	108	251	40	87	WP_296676571.1 hypothetical protein [Novosphingobium sp.]	diamond	144	65.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp.
28242982	28242982	PRJNA326068_P_NODE_19326_length_160_cov_1.847328_g18363_i0	PRJNA326068	19326	160	1.847328	2.9557248	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	48.5	2.52e-5	NR	GIT46276.1	2201156	g18363	i0	55.3	0.88125	47	21	88.1	0	20	160	17	63	GIT46276.1 MAG: hypothetical protein Ct9H300mP12_08610 [Acidimicrobiales bacterium]	diamond	141	48.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
28306319	28306319	PRJNA326068_P_NODE_9706_length_324_cov_4.813559_g8747_i0	PRJNA326068	9706	324	4.813559	15.59593116	Klebsiella pneumoniae	573	Bacteria	Bacteria	85.1	9.33e-19	NR	WP_416532572.1	573	g8747	i0	79.2	1.93518518518519	53	11	49.1	0	160	2	53	105	WP_416532572.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	627	85.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
28527543	28527543	PRJNA326068_P_NODE_5867_length_454_cov_3.124706_g4997_i0	PRJNA326068	5867	454	3.124706	14.18616524	Helicobacter pylori	210	Bacteria	Bacteria	43.1	0.0145	NR	GAA8777965.1	210	g4997	i0	100	0.118942731277533	18	0	11.9	0	164	111	1	18	GAA8777965.1 hypothetical protein BTM122_15620 [Helicobacter pylori]	diamond	54	43.1	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28622215	28622215	PRJNA326068_P_NODE_7647_length_382_cov_7.623229_g6705_i0	PRJNA326068	7647	382	7.623229	29.12073478	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.0204	NR	MEI6341235.1	2026799	g6705	i0	37.9	0.455497382198953	58	34	44	1	129	296	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28811163	28811163	PRJNA326068_P_NODE_18148_length_178_cov_2.691275_g17185_i0	PRJNA326068	18148	178	2.691275	4.7904695	Catalinimonas alkaloidigena	1075417	Bacteria	Bacteria	58.5	9.59e-9	NR	MDF9794741.1	1075417	g17185	i0	69.6	0.775280898876405	46	14	77.5	0	10	147	63	108	MDF9794741.1 hypothetical protein [Catalinimonas alkaloidigena]	diamond	138	58.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Catalimonadaceae	Catalinimonas	Catalinimonas alkaloidigena
28906005	28906005	PRJNA326068_P_NODE_19788_length_154_cov_1.176000_g18825_i0	PRJNA326068	19788	154	1.176	1.81104	Bradyrhizobium	374	Bacteria	Bacteria	86.3	3.37e-18	NR	WP_043855259.1	374	g18825	i0	84	0.974025974025974	50	8	97.4	0	152	3	90	139	WP_043855259.1 MULTISPECIES: hypothetical protein [Bradyrhizobium]	diamond	150	86.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium
29158970	29158970	PRJNA326068_P_NODE_19109_length_163_cov_1.477612_g18146_i0	PRJNA326068	19109	163	1.477612	2.40850756	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.9	4.99e-4	NR	MBX9722867.1	2364082	g18146	i0	80.8	0.478527607361963	26	5	47.9	0	149	72	5	30	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	78	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29474262	29474262	PRJNA326068_P_NODE_18970_length_165_cov_2.022059_g18007_i0	PRJNA326068	18970	165	2.022059	3.33639735	Jonesia quinghaiensis	262806	Bacteria	Bacteria	41.2	0.0451	NR	WP_029067714.1	262806	g18007	i0	58.8	0.618181818181818	34	12	58.2	1	125	30	174	207	WP_029067714.1 MFS transporter [Jonesia quinghaiensis]	diamond	102	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Jonesiaceae	Jonesia	Jonesia quinghaiensis
29506025	29506025	PRJNA326068_P_NODE_6770_length_415_cov_6.196891_g5850_i0	PRJNA326068	6770	415	6.196891	25.71709765	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.1	0.0192	NR	MEI6341235.1	2026799	g5850	i0	37.9	0.419277108433735	58	34	40.5	1	162	329	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29790116	29790116	PRJNA326068_P_NODE_14951_length_221_cov_1.729167_g13988_i0	PRJNA326068	14951	221	1.729167	3.82145907	Nocardiopsis terrae	372655	Bacteria	Bacteria	40.8	0.0137	NR	GHC98517.1	372655	g13988	i0	50	0.542986425339366	40	20	54.3	0	72	191	8	47	GHC98517.1 hypothetical protein GCM10007079_52930 [Nocardiopsis terrae]	diamond	120	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Nocardiopsidaceae	Nocardiopsis	Nocardiopsis terrae
29807493	29807493	PRJNA326068_P_NODE_18891_length_166_cov_2.489051_g17928_i0	PRJNA326068	18891	166	2.489051	4.13182466	Bacteria	2	Bacteria	Bacteria	40.4	0.0315	NR	SBS75384.1	171292	g17928	i0	52.6	1.98795180722892	38	18	68.7	0	114	1	11	48	SBS75384.1 hypothetical protein MHPYR_220060 [uncultured Mycobacterium sp.]	diamond	330	40.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	uncultured Mycobacterium sp.
30028841	30028841	PRJNA326068_P_NODE_11191_length_288_cov_2.332046_g10229_i0	PRJNA326068	11191	288	2.332046	6.71629248	Alphaproteobacteria	28211	Bacteria	Bacteria	45.8	0.00525	NR	MBU6497845.1	2026786	g10229	i0	46.2	3.25	52	16	54.2	1	288	133	493	532	MBU6497845.1 cytochrome c oxidase subunit I [Rhodospirillales bacterium]	diamond	936	45.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales			Rhodospirillales bacterium
30042934	30042934	PRJNA326068_P_NODE_19411_length_159_cov_1.076923_g18448_i0	PRJNA326068	19411	159	1.076923	1.71230757	Bradyrhizobium roseum	3056648	Bacteria	Bacteria	55.5	2.83e-7	NR	WP_300945270.1	3056648	g18448	i0	92.6	1.0188679245283	27	2	50.9	0	77	157	1	27	WP_300945270.1 F0F1 ATP synthase subunit A [Bradyrhizobium roseum]	diamond	162	55.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium roseum
30200729	30200729	PRJNA326068_P_NODE_18052_length_180_cov_1.536424_g17089_i0	PRJNA326068	18052	180	1.536424	2.7655632	Rhizobacter sp. Root4	1909292	Bacteria	Bacteria	56.2	2.34e-8	NR	WP_056465771.1	1736528	g17089	i0	58.3	1	60	22	100	1	180	1	40	96	WP_056465771.1 hypothetical protein [Rhizobacter sp. Root404]	diamond	180	56.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Rhizobacter	Rhizobacter sp. Root404
30422536	30422536	PRJNA326068_P_NODE_19313_length_160_cov_2.152672_g18350_i0	PRJNA326068	19313	160	2.152672	3.4442752	Actinomycetota bacterium	2900548	Bacteria	Bacteria	49.7	4.17e-5	NR	MEY4173123.1	2900548	g18350	i0	75	0.75	40	9	75	1	40	159	173	211	MEY4173123.1 hypothetical protein [Actinomycetota bacterium]	diamond	120	49.7	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
30611562	30611562	PRJNA326068_P_NODE_12973_length_252_cov_1.520179_g12010_i0	PRJNA326068	12973	252	1.520179	3.83085108	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	45.8	0.00321	NR	MBI4420926.1	2026742	g12010	i0	38.7	0.738095238095238	62	38	73.8	0	200	15	255	316	MBI4420926.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	186	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30674813	30674813	PRJNA326068_P_NODE_10133_length_314_cov_2.066667_g9174_i0	PRJNA326068	10133	314	2.066667	6.48933438	Ferruginibacter sp.	1940288	Bacteria	Bacteria	169	2.08e-51	NR	MEO6719837.1	1940288	g9174	i0	79.6	3.9171974522293	103	21	98.4	0	312	4	10	112	MEO6719837.1 PA2169 family four-helix-bundle protein [Ferruginibacter sp.]	diamond	1230	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
31148395	31148395	PRJNA326068_P_NODE_1215_length_954_cov_3.841081_g869_i0	PRJNA326068	1215	954	3.841081	36.64391274	Bacteroidota bacterium	1898104	Bacteria	Bacteria	91.3	1.33e-19	NR	MES2647110.1	1898104	g869	i0	95.5	0.138364779874214	44	2	13.8	0	460	329	4	47	MES2647110.1 hypothetical protein [Bacteroidota bacterium]	diamond	132	91.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31370427	31370427	PRJNA326068_P_NODE_19936_length_152_cov_2.162602_g18973_i0	PRJNA326068	19936	152	2.162602	3.28715504	uncultured actinobacterium HF4	152507	Bacteria	Bacteria	46.6	4.86e-5	NR	ADI18349.1	711002	g18973	i0	62.2	0.730263157894737	37	14	73	0	40	150	26	62	ADI18349.1 hypothetical protein [uncultured actinobacterium HF4000_04C13]	diamond	111	46.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				uncultured actinobacterium HF4000_04C13
32824254	32824254	PRJNA326068_P_NODE_16940_length_199_cov_1.711765_g15977_i0	PRJNA326068	16940	199	1.711765	3.40641235	Bradyrhizobium japonicum	375	Bacteria	Bacteria	42	0.00711	NR	WP_024342609.1	375	g15977	i0	60.7	0.693467336683417	28	11	42.2	0	184	101	52	79	WP_024342609.1 PilZ domain-containing protein [Bradyrhizobium japonicum]	diamond	138	42	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium japonicum

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