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

23 rows where analysis = "diamond", bioproject = "PRJNA692200" 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
9601093	9601093	PRJNA692200_S_NODE_15708_length_184_cov_3.696296_g15651_i0	PRJNA692200	15708	184	3.696296	6.80118464	root	1	Root_unresolved	Root_unresolved	80.1	3.72e-18	NR	MDK0835637.1	1502	g15651	i0	71.4	27.3260869565217	49	14	79.9	0	3	149	18	66	MDK0835637.1 peptidylprolyl isomerase [Clostridium perfringens]	diamond	5028	80.9	0.990111248454882	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
12152105	12152105	PRJNA692200_S_NODE_530_length_499_cov_145.008889_g497_i0	PRJNA692200	530	499	145.008889	723.59435611	Brevibacillus fulvus	1125967	Bacteria	Bacteria	143	7.079999999999998e-41	NR	WP_204516782.1	1125967	g497	i0	61.1	4.15430861723447	113	44	67.9	0	61	399	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	2073	143	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
18524559	18524559	PRJNA692200_S_NODE_13075_length_199_cov_2.466667_g13018_i0	PRJNA692200	13075	199	2.466667	4.90866733	Bacteria	2	Bacteria	Bacteria	67.8	2.57e-11	NR	WP_075892009.1	454133	g13018	i0	71.8	3.85929648241206	39	11	58.8	0	1	117	298	336	WP_075892009.1 type I glyceraldehyde-3-phosphate dehydrogenase [[Limnothrix rosea] IAM M-220]	diamond	768	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Limnothrix rosea] IAM M-220
22350357	22350357	PRJNA692200_S_NODE_8878_length_234_cov_337.064865_g8821_i0	PRJNA692200	8878	234	337.064865	788.7317841	Synechocystis sp.	1143	Bacteria	Bacteria	81.3	4.52e-18	NR	MEB3228129.1	1143	g8821	i0	77.6	1.25641025641026	49	11	62.8	0	232	86	39	87	MEB3228129.1 peptidylprolyl isomerase [Synechocystis sp.]	diamond	294	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp.
27114000	27114000	PRJNA692200_S_NODE_13782_length_195_cov_1.267123_g13725_i0	PRJNA692200	13782	195	1.267123	2.47088985	Defluviitaleaceae bacterium	2660712	Bacteria	Bacteria	41.6	0.0492	NR	MCL2378803.1	2660712	g13725	i0	45.2	0.646153846153846	42	20	61.5	2	136	17	265	305	MCL2378803.1 hypothetical protein [Defluviitaleaceae bacterium]	diamond	126	41.6	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Defluviitaleaceae		Defluviitaleaceae bacterium
27788950	27788950	PRJNA692200_S_NODE_10084_length_223_cov_1.149425_g10027_i0	PRJNA692200	10084	223	1.149425	2.56321775	Bacillati	1783272	Bacteria	Bacteria	75.5	4.11e-16	NR	MEO0563457.1	2026724	g10027	i0	75.6	6.75336322869955	45	11	60.5	0	85	219	3	47	MEO0563457.1 cold-shock protein [Chloroflexota bacterium]	diamond	1506	75.9	0.994729907773386	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27966913	27966913	PRJNA692200_S_NODE_7325_length_252_cov_6.073892_g7268_i0	PRJNA692200	7325	252	6.073892	15.30620784	Cuspidothrix sp.	3019649	Bacteria	Bacteria	47	0.00137	NR	MFM7408094.1	3019649	g7268	i0	65.5	1.03571428571429	29	10	34.5	0	3	89	728	756	MFM7408094.1 FG-GAP-like repeat-containing protein [Cuspidothrix sp.]	diamond	261	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cuspidothrix	Cuspidothrix sp.
27978266	27978266	PRJNA692200_S_NODE_10165_length_222_cov_1.716763_g10108_i0	PRJNA692200	10165	222	1.716763	3.81121386	Mycobacteriales	85007	Bacteria	Bacteria	43.9	0.00393	NR	WP_325613105.1	1785	g10108	i0	43.9	1.40540540540541	41	23	55.4	0	68	190	87	127	WP_325613105.1 hypothetical protein [Mycobacterium sp.]	diamond	312	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27978269	27978269	PRJNA692200_S_NODE_4105_length_309_cov_1.507692_g4048_i0	PRJNA692200	4105	309	1.507692	4.65876828	Peptostreptococcus	1257	Bacteria	Bacteria	112	2.28e-29	NR	WP_002845271.1	1257	g4048	i0	58.9	7.96116504854369	90	37	87.4	0	5	274	32	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	2460	112	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
28420522	28420522	PRJNA692200_S_NODE_726_length_472_cov_4.680851_g688_i0	PRJNA692200	726	472	4.680851	22.09361672	root	1	Root_unresolved	Root_unresolved	47.4	8.05e-4	NR	MER2170548.1	126157	g688	i0	46.2	0.889830508474576	52	27	32.4	1	208	56	1	52	MER2170548.1 hypothetical protein [Psychrobacillus psychrodurans]	diamond	420	47.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Psychrobacillus	Psychrobacillus psychrodurans
28598596	28598596	PRJNA692200_S_NODE_13587_length_196_cov_1.632653_g13530_i0	PRJNA692200	13587	196	1.632653	3.19999988	Actinomycetota bacterium	2900548	Bacteria	Bacteria	41.6	0.0471	NR	MEY3805953.1	2900548	g13530	i0	68	0.38265306122449	25	8	38.3	0	51	125	10	34	MEY3805953.1 Bacterial regulatory protein luxR family [Actinomycetota bacterium]	diamond	75	41.6	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
28736107	28736107	PRJNA692200_S_NODE_21527_length_163_cov_1.342105_g21470_i0	PRJNA692200	21527	163	1.342105	2.18763115	Bacteria	2	Bacteria	Bacteria	58.2	4.61e-8	NR	NDD45436.1	2448804	g21470	i0	50	1.84049079754601	50	25	92	0	159	10	180	229	NDD45436.1 translation initiation factor IF-3 [Synechococcaceae bacterium WB9_4xB_025]	diamond	300	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae bacterium WB9_4xB_025
28882512	28882512	PRJNA692200_S_NODE_13288_length_198_cov_1.154362_g13231_i0	PRJNA692200	13288	198	1.154362	2.28563676	Bifidobacterium breve	1685	Bacteria	Bacteria	45.4	0.00193	NR	AUD81564.1	1685	g13231	i0	54.5	0.5	33	15	50	0	154	56	12	44	AUD81564.1 hypothetical protein NRBB51_1480 [Bifidobacterium breve]	diamond	99	45.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium breve
29608447	29608447	PRJNA692200_S_NODE_18170_length_173_cov_1.241935_g18113_i0	PRJNA692200	18170	173	1.241935	2.14854755	Nonomuraea sp. SBT364	1580530	Bacteria	Bacteria	56.6	9.44e-8	NR	WP_063780813.1	1580530	g18113	i0	56.6	0.919075144508671	53	23	91.9	0	11	169	125	177	WP_063780813.1 lysoplasmalogenase [Nonomuraea sp. SBT364]	diamond	159	56.6	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Nonomuraea	Nonomuraea sp. SBT364
30283898	30283898	PRJNA692200_S_NODE_14892_length_188_cov_2.762590_g14835_i0	PRJNA692200	14892	188	2.76259	5.1936692	Bacteria	2	Bacteria	Bacteria	52	9.61e-6	NR	WP_299569843.1	259311	g14835	i0	42.9	15.3829787234043	56	32	89.4	0	187	20	356	411	WP_299569843.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [uncultured Williamsia sp.]	diamond	2892	52.4	0.99236641221374	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	uncultured Williamsia sp.
30335750	30335750	PRJNA692200_S_NODE_20272_length_166_cov_1.384615_g20215_i0	PRJNA692200	20272	166	1.384615	2.2984609	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	46.2	7.85e-4	NR	MCH4039956.1	1898203	g20215	i0	40	0.903614457831325	50	30	90.4	0	16	165	153	202	MCH4039956.1 glycosyltransferase [Lachnospiraceae bacterium]	diamond	150	46.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
30493381	30493381	PRJNA692200_S_NODE_2973_length_341_cov_2.702055_g2916_i0	PRJNA692200	2973	341	2.702055	9.21400755	Anaerolineae bacterium	2052143	Bacteria	Bacteria	62.4	1.04e-9	NR	MCW5848612.1	2052143	g2916	i0	49.3	0.607038123167155	69	35	60.7	0	43	249	56	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	207	62.4	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31156485	31156485	PRJNA692200_S_NODE_435_length_517_cov_14.869658_g402_i0	PRJNA692200	435	517	14.869658	76.87613186	Dehalococcoidales bacterium	2026733	Bacteria	Bacteria	94	5.1800000000000006e-21	NR	MDO9333994.1	2026733	g402	i0	92.5	0.307543520309478	53	3	30.2	1	5	160	83	135	MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium]	diamond	159	94	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales			Dehalococcoidales bacterium
31378288	31378288	PRJNA692200_S_NODE_2336_length_365_cov_3.085443_g2279_i0	PRJNA692200	2336	365	3.085443	11.26186695	Actinoalloteichus hymeniacidonis	340345	Bacteria	Bacteria	49.7	4.57e-4	NR	WP_069845689.1	340345	g2279	i0	46	1.1013698630137	50	27	41.1	0	359	210	215	264	WP_069845689.1 S49 family peptidase [Actinoalloteichus hymeniacidonis]	diamond	402	49.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinoalloteichus	Actinoalloteichus hymeniacidonis
31694400	31694400	PRJNA692200_S_NODE_14157_length_192_cov_4.286713_g14100_i0	PRJNA692200	14157	192	4.286713	8.23048896	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.6	0.0499	NR	NOH04063.1	2026724	g14100	i0	45.9	0.578125	37	20	57.8	0	180	70	419	455	NOH04063.1 dipeptidase [Chloroflexota bacterium]	diamond	111	41.6	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
31725997	31725997	PRJNA692200_S_NODE_16997_length_178_cov_1.922481_g16940_i0	PRJNA692200	16997	178	1.922481	3.42201618	Actinomycetota bacterium	2900548	Bacteria	Bacteria	41.6	0.0415	NR	MBW3669565.1	2900548	g16940	i0	40.4	0.960674157303371	57	27	89.3	2	16	174	585	638	MBW3669565.1 LuxR C-terminal-related transcriptional regulator [Actinomycetota bacterium]	diamond	171	41.6	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
31789126	31789126	PRJNA692200_S_NODE_21457_length_163_cov_1.763158_g21400_i0	PRJNA692200	21457	163	1.763158	2.87394754	Synechococcus sp. CCY 9618	2815602	Bacteria	Bacteria	80.9	4.61e-17	NR	WP_216903717.1	2815602	g21400	i0	64.8	12.920245398773	54	19	99.4	0	2	163	151	204	WP_216903717.1 peroxiredoxin [Synechococcus sp. CCY 9618]	diamond	2106	80.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCY 9618
32074129	32074129	PRJNA692200_S_NODE_9658_length_227_cov_1.612360_g9601_i0	PRJNA692200	9658	227	1.61236	3.6600572	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	45.4	0.003	NR	MEA5018092.1	2049044	g9601	i0	50	0.475770925110132	36	18	47.6	0	222	115	188	223	MEA5018092.1 dienelactone hydrolase family protein [Erysipelotrichaceae bacterium]	diamond	108	45.4	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae 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);;