metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA804229" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA804229" 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
26936408	26936408	PRJNA804229_S_NODE_73402_length_237_cov_1.953608_g72444_i0	PRJNA804229	73402	237	1.953608	4.63005096	FCB group	1783270	Bacteria	Bacteria	63.9	2.65e-10	NR	MCB6638902.1	33039	g72444	i0	43.1	18.2278481012658	72	41	91.1	0	20	235	104	175	MCB6638902.1 type I restriction endonuclease [[Ruminococcus] torques]	diamond	4320	64.3	0.993779160186625	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	[Ruminococcus] torques
27591464	27591464	PRJNA804229_S_NODE_162284_length_160_cov_1.230769_g161326_i0	PRJNA804229	162284	160	1.230769	1.9692304	uncultured Finegoldia sp.	328009	Bacteria	Bacteria	61.2	3.5e-9	NR	WP_297813376.1	328009	g161326	i0	61.9	0.7875	42	16	78.8	0	160	35	77	118	WP_297813376.1 hypothetical protein [uncultured Finegoldia sp.]	diamond	126	61.2	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	uncultured Finegoldia sp.
27843693	27843693	PRJNA804229_S_NODE_120004_length_186_cov_1.678322_g119046_i0	PRJNA804229	120004	186	1.678322	3.12167892	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	126	2.79e-33	NR	MCC8160947.1	2485925	g119046	i0	93.4	6.88709677419355	61	4	98.4	0	3	185	261	321	MCC8160947.1 DNA cytosine methyltransferase [Oscillospiraceae bacterium]	diamond	1281	126	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28547612	28547612	PRJNA804229_S_NODE_185807_length_151_cov_0.888889_g184849_i0	PRJNA804229	185807	151	0.888889	1.34222239	Eubacteriales	186802	Bacteria	Bacteria	62	1.45e-9	NR	WP_373844743.1	1506	g184849	i0	62.5	7.62913907284768	48	16	95.4	1	149	6	260	305	WP_373844743.1 restriction endonuclease PLD domain-containing protein [Clostridium sp.]	diamond	1152	62.4	0.993589743589744	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp.
28949183	28949183	PRJNA804229_S_NODE_95708_length_208_cov_1.448485_g94750_i0	PRJNA804229	95708	208	1.448485	3.0128488	Massilistercora timonensis	2086584	Bacteria	Bacteria	43.9	0.00426	NR	WP_106790073.1	2086584	g94750	i0	39.2	0.735576923076923	51	31	73.6	0	192	40	31	81	WP_106790073.1 DMT family transporter [Massilistercora timonensis]	diamond	153	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Massilistercora	Massilistercora timonensis
29991035	29991035	PRJNA804229_S_NODE_61431_length_258_cov_1.204651_g60473_i0	PRJNA804229	61431	258	1.204651	3.10799958	Chengkuizengella marina	2507566	Bacteria	Bacteria	45.4	0.0049	NR	WP_160644907.1	2507566	g60473	i0	34.8	0.802325581395349	69	40	74.4	1	50	241	86	154	WP_160644907.1 methyl-accepting chemotaxis protein [Chengkuizengella marina]	diamond	207	45.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Chengkuizengella	Chengkuizengella marina
30591218	30591218	PRJNA804229_S_NODE_110513_length_194_cov_1.271523_g109555_i0	PRJNA804229	110513	194	1.271523	2.46675462	Dellaglioa algida	105612	Bacteria	Bacteria	58.2	7.11e-8	NR	WP_112250570.1	105612	g109555	i0	47.6	0.974226804123711	63	32	95.9	1	189	4	751	813	WP_112250570.1 DEAD/DEAH box helicase [Dellaglioa algida]	diamond	189	58.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Dellaglioa	Dellaglioa algida
31065460	31065460	PRJNA804229_S_NODE_108215_length_196_cov_1.254902_g107257_i0	PRJNA804229	108215	196	1.254902	2.45960792	Clostridium botulinum	1491	Bacteria	Bacteria	56.2	3.27e-7	NR	WP_162266818.1	1491	g107257	i0	55.1	3	49	22	75	0	155	9	59	107	WP_162266818.1 restriction endonuclease subunit S [Clostridium botulinum]	diamond	588	56.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium botulinum
32362324	32362324	PRJNA804229_S_NODE_132939_length_177_cov_1.432836_g131981_i0	PRJNA804229	132939	177	1.432836	2.53611972	Paenibacillus cremeus	2163881	Bacteria	Bacteria	43.5	0.00815	NR	WP_144851517.1	2163881	g131981	i0	46.9	0.830508474576271	49	25	81.4	1	16	159	16	64	WP_144851517.1 carbohydrate ABC transporter permease [Paenibacillus cremeus]	diamond	147	43.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cremeus

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