metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_phylum = "Bacillota"

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
10342441	10342441	PRJEB81171_P_NODE_5549_length_286_cov_1.422535_g5422_i0	PRJEB81171	5549	286	1.422535	4.0684501	Bacillales	1385	Bacteria	Bacteria	172	7.06e-51	NR	WP_252907790.1	1282	g5422	i0	92.6	1.97202797202797	94	7	98.6	0	283	2	1	94	WP_252907790.1 replication initiator protein A [Staphylococcus epidermidis]	diamond	564	172	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10342500	10342500	PRJEB81171_P_NODE_8289_length_250_cov_0.881356_g8162_i0	PRJEB81171	8289	250	0.881356	2.20339	Streptococcus mitis	28037	Bacteria	Bacteria	110	4.51e-26	NR	WP_414367229.1	28037	g8162	i0	88	0.996	83	10	99.6	0	249	1	1027	1109	WP_414367229.1 DUF1542 domain-containing protein, partial [Streptococcus mitis]	diamond	249	110	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
27382042	27382042	PRJEB81171_P_NODE_8803_length_247_cov_1.781609_g8676_i0	PRJEB81171	8803	247	1.781609	4.40057423	Clostridiales bacterium	1898207	Bacteria	Bacteria	79.3	2.57e-15	NR	HBD64214.1	1898207	g8676	i0	95.1	2.48987854251012	41	2	49.8	0	50	172	1	41	HBD64214.1 hypothetical protein [Clostridiales bacterium]	diamond	615	79.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27539910	27539910	PRJEB81171_P_NODE_9304_length_245_cov_0.906977_g9177_i0	PRJEB81171	9304	245	0.906977	2.22209365	Desulfosporosinus youngiae	339862	Bacteria	Bacteria	55.1	1.73e-6	NR	WP_007787651.1	339862	g9177	i0	31.3	0.979591836734694	80	55	98	0	242	3	394	473	WP_007787651.1 helix-turn-helix domain-containing protein [Desulfosporosinus youngiae]	diamond	240	55.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Desulfitobacteriaceae	Desulfosporosinus	Desulfosporosinus youngiae
27761147	27761147	PRJEB81171_P_NODE_10004_length_242_cov_0.923077_g9877_i0	PRJEB81171	10004	242	0.923077	2.23384634	Pseudobutyrivibrio sp. YE44	1520802	Bacteria	Bacteria	57.4	1.19e-7	NR	WP_090418450.1	1520802	g9877	i0	41.4	2.56611570247934	70	41	86.8	0	237	28	87	156	WP_090418450.1 viroplasmin family protein [Pseudobutyrivibrio sp. YE44]	diamond	621	57.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Pseudobutyrivibrio	Pseudobutyrivibrio sp. YE44
28732394	28732394	PRJEB81171_P_NODE_6167_length_276_cov_1.536946_g6040_i0	PRJEB81171	6167	276	1.536946	4.24197096	Terrisporobacter	1505652	Bacteria	Bacteria	52.8	1.6e-5	NR	WP_039680921.1	1577792	g6040	i0	88	1.08695652173913	25	3	27.2	0	275	201	518	542	WP_039680921.1 aspartate 4-decarboxylase [Terrisporobacter othiniensis]	diamond	300	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Terrisporobacter	Terrisporobacter othiniensis
29024187	29024187	PRJEB81171_P_NODE_8808_length_247_cov_1.706897_g8681_i0	PRJEB81171	8808	247	1.706897	4.21603559	Halanaerobium praevalens	2331	Bacteria	Bacteria	43.9	0.00124	NR	WP_014553795.1	2331	g8681	i0	58.6	1.05668016194332	29	12	35.2	0	90	4	5	33	WP_014553795.1 hypothetical protein [Halanaerobium praevalens]	diamond	261	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium praevalens
29055514	29055514	PRJEB81171_P_NODE_8548_length_249_cov_0.886364_g8421_i0	PRJEB81171	8548	249	0.886364	2.20704636	Bacillota bacterium	1879010	Bacteria	Bacteria	60.5	1.06e-8	NR	HOB44499.1	1879010	g8421	i0	44.6	1.98795180722892	83	35	98.8	2	249	4	127	199	HOB44499.1 N-acetylmuramoyl-L-alanine amidase [Bacillota bacterium]	diamond	495	60.5	1	Bacteria	Bacillati	Bacillota					Bacillota bacterium
29497394	29497394	PRJEB81171_P_NODE_6690_length_268_cov_1.338462_g6563_i0	PRJEB81171	6690	268	1.338462	3.58707816	Ruminiclostridium cellobioparum	29355	Bacteria	Bacteria	146	3.91e-39	NR	WP_027628342.1	29355	g6563	i0	89.9	0.996268656716418	89	9	99.6	0	2	268	139	227	WP_027628342.1 ATP-binding protein [Ruminiclostridium cellobioparum]	diamond	267	146	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminiclostridium	Ruminiclostridium cellobioparum
29908067	29908067	PRJEB81171_P_NODE_10031_length_242_cov_0.923077_g9904_i0	PRJEB81171	10031	242	0.923077	2.23384634	Streptococcus parasanguinis	1318	Bacteria	Bacteria	43.9	0.00105	NR	WP_195327468.1	1318	g9904	i0	100	0.272727272727273	22	0	27.3	0	67	2	1	22	WP_195327468.1 ribbon-helix-helix protein, CopG family [Streptococcus parasanguinis]	diamond	66	43.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
30223757	30223757	PRJEB81171_P_NODE_7632_length_253_cov_1.233333_g7505_i0	PRJEB81171	7632	253	1.233333	3.12033249	Halanaerobium saccharolyticum	43595	Bacteria	Bacteria	71.6	5.2e-13	NR	WP_133514852.1	43595	g7505	i0	63.3	0.58102766798419	49	18	58.1	0	3	149	161	209	WP_133514852.1 hypothetical protein [Halanaerobium saccharolyticum]	diamond	147	71.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Halanaerobiales	Halanaerobiaceae	Halanaerobium	Halanaerobium saccharolyticum
30887351	30887351	PRJEB81171_P_NODE_8494_length_249_cov_0.886364_g8367_i0	PRJEB81171	8494	249	0.886364	2.20704636	Veillonellaceae bacterium DNF	2049049	Bacteria	Bacteria	156	2.29e-45	NR	KXB93571.1	1588754	g8367	i0	95.1	0.987951807228916	82	4	98.8	0	248	3	12	93	KXB93571.1 ABC transporter, substrate-binding protein, family 3 [Veillonellaceae bacterium DNF00626]	diamond	246	156	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae		Veillonellaceae bacterium DNF00626
31456423	31456423	PRJEB81171_P_NODE_7056_length_262_cov_1.396825_g6929_i0	PRJEB81171	7056	262	1.396825	3.6596815	Fastidiosipila sanguinis	236753	Bacteria	Bacteria	101	1.2500000000000001e-22	NR	WP_106011716.1	236753	g6929	i0	50.6	0.99618320610687	87	43	99.6	0	262	2	731	817	WP_106011716.1 magnesium-translocating P-type ATPase [Fastidiosipila sanguinis]	diamond	261	101	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Fastidiosipila	Fastidiosipila sanguinis
31614454	31614454	PRJEB81171_P_NODE_8476_length_249_cov_0.886364_g8349_i0	PRJEB81171	8476	249	0.886364	2.20704636	Anaerococcus provencensis	938293	Bacteria	Bacteria	70.9	4.98e-12	NR	WP_044566925.1	938293	g8349	i0	50	0.963855421686747	80	40	96.4	0	242	3	780	859	WP_044566925.1 AAA family ATPase [Anaerococcus provencensis]	diamond	240	70.9	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus provencensis

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