metadata: contig_metadata: 23 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax

23 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_kingdom = "Bacillati"

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
26737194	26737194	PRJNA801875_P_NODE_3581_length_173_cov_1.949275_g3478_i0	PRJNA801875	3581	173	1.949275	3.37224575	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	42.4	0.0204	NR	MDJ0594391.1	3036786	g3478	i0	43.9	0.988439306358382	57	31	97.1	1	2	169	1009	1065	MDJ0594391.1 malectin domain-containing carbohydrate-binding protein [Pleurocapsa sp. MO_226.B13]	diamond	171	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
26778319	26778319	PRJNA801875_P_NODE_2681_length_207_cov_1.755814_g2578_i0	PRJNA801875	2681	207	1.755814	3.63453498	Streptomyces	1883	Bacteria	Bacteria	64.3	5.55e-10	NR	WP_121175631.1	1938830	g2578	i0	53.7	3.84057971014493	67	31	97.1	0	202	2	238	304	WP_121175631.1 RICIN domain-containing protein [Streptomyces sp. 1114.5]	diamond	795	64.7	0.993817619783617	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 1114.5
26864601	26864601	PRJNA801875_P_NODE_2741_length_204_cov_1.396450_g2638_i0	PRJNA801875	2741	204	1.39645	2.848758	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	82	1.2e-17	NR	MBX9724270.1	2364082	g2638	i0	97.5	0.588235294117647	40	1	58.8	0	203	84	131	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	120	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26968042	26968042	PRJNA801875_P_NODE_2902_length_197_cov_1.172840_g2799_i0	PRJNA801875	2902	197	1.17284	2.3104948	root	1	Root_unresolved	Root_unresolved	75.9	2.61e-16	NR	HEN0035530.1	1311	g2799	i0	74.5	11.1167512690355	51	13	77.7	0	35	187	14	64	HEN0035530.1 hypothetical protein [Streptococcus agalactiae]	diamond	2190	76.6	0.990861618798956	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
27117145	27117145	PRJNA801875_P_NODE_2582_length_212_cov_2.141243_g2479_i0	PRJNA801875	2582	212	2.141243	4.53943516	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	108	7.14e-26	NR	HEY9756413.1	3088181	g2479	i0	72.5	0.976415094339623	69	19	97.6	0	6	212	191	259	HEY9756413.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Oculatellaceae cyanobacterium]	diamond	207	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27212014	27212014	PRJNA801875_P_NODE_4662_length_152_cov_1.000000_g4559_i0	PRJNA801875	4662	152	1	1.52	Mycobacterium sp.	1785	Bacteria	Bacteria	63.5	4.86e-10	NR	MDF2581377.1	1785	g4559	i0	60.4	3.61184210526316	48	19	94.7	0	4	147	548	595	MDF2581377.1 hypothetical protein [Mycobacterium sp.]	diamond	549	63.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27338759	27338759	PRJNA801875_P_NODE_2403_length_224_cov_2.153439_g2300_i0	PRJNA801875	2403	224	2.153439	4.82370336	Streptomyces chisholmiae	3075540	Bacteria	Bacteria	51.6	2.24e-5	NR	WP_311669225.1	3075540	g2300	i0	44.2	1.03125	77	37	97.8	2	223	5	554	628	WP_311669225.1 non-ribosomal peptide synthetase, partial [Streptomyces chisholmiae]	diamond	231	51.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces chisholmiae
27686340	27686340	PRJNA801875_P_NODE_1624_length_299_cov_2.420455_g1521_i0	PRJNA801875	1624	299	2.420455	7.23716045	Metabacillus flavus	2823519	Bacteria	Bacteria	76.3	3.62e-14	NR	WP_211560879.1	2823519	g1521	i0	53.3	1.8561872909699	92	39	92.3	3	281	6	2	89	WP_211560879.1 SDR family NAD(P)-dependent oxidoreductase [Metabacillus flavus]	diamond	555	76.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Metabacillus	Metabacillus flavus
27821334	27821334	PRJNA801875_P_NODE_3884_length_166_cov_1.786260_g3781_i0	PRJNA801875	3884	166	1.78626	2.9651916	FCB group	1783270	Bacteria	Bacteria	45.1	0.00205	NR	WP_212904154.1	69208	g3781	i0	46.9	4.51807228915663	49	25	88.6	1	162	16	619	666	WP_212904154.1 DsrE/DsrF/DrsH-like family protein [Clostridium polyendosporum]	diamond	750	45.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium polyendosporum
28317469	28317469	PRJNA801875_P_NODE_1466_length_320_cov_1.564912_g1363_i0	PRJNA801875	1466	320	1.564912	5.0077184	Chloroflexota bacterium	2026724	Bacteria	Bacteria	77.8	7.89e-15	NR	NCF64494.1	2026724	g1363	i0	48.8	1.63125	84	41	78.8	2	12	263	8	89	NCF64494.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	522	77.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
28484271	28484271	PRJNA801875_P_NODE_1586_length_303_cov_2.753731_g1483_i0	PRJNA801875	1586	303	2.753731	8.34380493	PVC group	1783257	Bacteria	Bacteria	139	1.35e-38	NR	WP_007905470.1	363277	g1483	i0	64.6	1.95049504950495	99	35	98	0	6	302	43	141	WP_007905470.1 glucose 1-dehydrogenase [Ktedonobacter racemifer]	diamond	591	139	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacter	Ktedonobacter racemifer
28727938	28727938	PRJNA801875_P_NODE_2007_length_255_cov_2.645455_g1904_i0	PRJNA801875	2007	255	2.645455	6.74591025	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	126	2.21e-35	NR	MBX9692690.1	2847862	g1904	i0	91.8	0.717647058823529	61	5	71.8	0	1	183	57	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	183	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29210580	29210580	PRJNA801875_P_NODE_2129_length_244_cov_1.851675_g2026_i0	PRJNA801875	2129	244	1.851675	4.518087	Cyanophyceae	3028117	Bacteria	Bacteria	65.9	2.34e-10	NR	WP_107670899.1	2082950	g2026	i0	63.5	4.73360655737705	52	10	63.9	1	6	161	309	351	WP_107670899.1 alkene reductase [Cyanothece sp. BG0011]	diamond	1155	66.2	0.995468277945619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. BG0011
29296250	29296250	PRJNA801875_P_NODE_2409_length_224_cov_1.174603_g2306_i0	PRJNA801875	2409	224	1.174603	2.63111072	Micrococcales bacterium	2026762	Bacteria	Bacteria	55.1	1.25e-6	NR	NBR25029.1	2026762	g2306	i0	50.9	0.763392857142857	57	27	76.3	1	220	50	219	274	NBR25029.1 hypothetical protein [Micrococcales bacterium]	diamond	171	55.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales			Micrococcales bacterium
29391111	29391111	PRJNA801875_P_NODE_3209_length_184_cov_2.389262_g3106_i0	PRJNA801875	3209	184	2.389262	4.39624208	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	88.2	2.44e-19	NR	MBO1351640.1	2480853	g3106	i0	67.2	2.95108695652174	61	20	99.5	0	1	183	146	206	MBO1351640.1 SDR family oxidoreductase [Hormoscilla sp. GUM202]	diamond	543	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
30211948	30211948	PRJNA801875_P_NODE_1892_length_269_cov_2.226496_g1789_i0	PRJNA801875	1892	269	2.226496	5.98927424	Actinomycetes bacterium	1883427	Bacteria	Bacteria	69.7	3.11e-12	NR	MEI6294978.1	1883427	g1789	i0	50.7	0.79182156133829	71	35	79.2	0	224	12	4	74	MEI6294978.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium]	diamond	213	69.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
30654345	30654345	PRJNA801875_P_NODE_2953_length_195_cov_0.987500_g2850_i0	PRJNA801875	2953	195	0.9875	1.925625	Listeria ivanovii	1638	Bacteria	Bacteria	49.3	7.51e-5	NR	WP_325176422.1	1638	g2850	i0	36.4	1.01538461538462	66	38	96.9	2	3	191	42	106	WP_325176422.1 hypothetical protein [Listeria ivanovii]	diamond	198	49.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria ivanovii
30685923	30685923	PRJNA801875_P_NODE_3193_length_185_cov_1.326667_g3090_i0	PRJNA801875	3193	185	1.326667	2.45433395	Cyanobacteria bacterium P01_H01_bin.153	3023316	Bacteria	Bacteria	94.4	8.3e-23	NR	MEM1309679.1	3023316	g3090	i0	71.2	4.63783783783784	59	17	95.7	0	6	182	87	145	MEM1309679.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_H01_bin.153]	diamond	858	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.153
30812377	30812377	PRJNA801875_P_NODE_994_length_415_cov_6.413158_g891_i0	PRJNA801875	994	415	6.413158	26.6146057	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	53.9	3.58e-6	NR	MEI3251335.1	3022870	g891	i0	53.3	10.5036144578313	60	28	43.4	0	224	45	53	112	MEI3251335.1 30S ribosomal protein S13 [Candidatus Gastranaerophilaceae bacterium]	diamond	4359	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
30970558	30970558	PRJNA801875_P_NODE_874_length_447_cov_3.538835_g772_i0	PRJNA801875	874	447	3.538835	15.81859245	Actinomycetota bacterium	2900548	Bacteria	Bacteria	159	3.75e-46	NR	MEY2634385.1	2900548	g772	i0	59.9	1.90604026845638	142	57	95.3	0	438	13	66	207	MEY2634385.1 hypothetical protein [Actinomycetota bacterium]	diamond	852	159	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
31444603	31444603	PRJNA801875_P_NODE_4296_length_158_cov_1.105691_g4193_i0	PRJNA801875	4296	158	1.105691	1.74699178	Chloroflexales bacterium	2725990	Bacteria	Bacteria	65.9	8.17e-11	NR	MEI6776524.1	2725990	g4193	i0	58.8	1.93670886075949	51	21	96.8	0	154	2	546	596	MEI6776524.1 MBG domain-containing protein [Chloroflexales bacterium]	diamond	306	65.9	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales			Chloroflexales bacterium
31760857	31760857	PRJNA801875_P_NODE_4797_length_150_cov_1.043478_g4694_i0	PRJNA801875	4797	150	1.043478	1.565217	Marmoricola sp.	1909296	Bacteria	Bacteria	47.8	1.74e-4	NR	MCW2846527.1	1909296	g4694	i0	45.7	2.8	46	21	92	1	149	12	179	220	MCW2846527.1 transporter [Marmoricola sp.]	diamond	420	47.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola sp.
32307960	32307960	PRJNA801875_P_NODE_2459_length_220_cov_2.421622_g2356_i0	PRJNA801875	2459	220	2.421622	5.3275684	Bacillati	1783272	Bacteria	Bacteria	77.8	1.26e-14	NR	WP_298917448.1	340711	g2356	i0	55.6	6.69545454545455	72	32	98.2	0	5	220	817	888	WP_298917448.1 amino acid adenylation domain-containing protein [uncultured Nostoc sp.]	diamond	1473	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.

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