metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA806354" 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
27884281	27884281	PRJNA806354_P_NODE_37705_length_247_cov_0.885057_g37596_i0	PRJNA806354	37705	247	0.885057	2.18609079	Bacillota	1239	Bacteria	Bacteria	130	3.85e-37	NR	ERJ83094.1	1321784	g37596	i0	89.3	4.45748987854251	75	8	91.1	0	23	247	1	75	ERJ83094.1 ribosomal protein S10 [Peptostreptococcaceae bacterium oral taxon 113 str. W5053]	diamond	1101	130	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae		Peptostreptococcaceae bacterium oral taxon 113
29706305	29706305	PRJNA806354_P_NODE_41130_length_241_cov_0.916667_g41021_i0	PRJNA806354	41130	241	0.916667	2.20916747	Flavonifractor plautii	292800	Bacteria	Bacteria	52	1.29e-5	NR	WP_271956687.1	292800	g41021	i0	62.2	0.970954356846473	37	14	46.1	0	114	4	3	39	WP_271956687.1 SDR family NAD(P)-dependent oxidoreductase [Flavonifractor plautii]	diamond	234	52	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Flavonifractor	Flavonifractor plautii
30307426	30307426	PRJNA806354_P_NODE_35392_length_251_cov_0.865169_g35283_i0	PRJNA806354	35392	251	0.865169	2.17157419	Sporomusa sp. KB1	943346	Bacteria	Bacteria	91.7	3.17e-21	NR	WP_145093600.1	943346	g35283	i0	57.7	1.87649402390438	78	33	93.2	0	5	238	24	101	WP_145093600.1 phage protein [Sporomusa sp. KB1]	diamond	471	91.7	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa sp. KB1
31381516	31381516	PRJNA806354_P_NODE_38116_length_246_cov_0.890173_g38007_i0	PRJNA806354	38116	246	0.890173	2.18982558	Staphylococcus aureus	1280	Bacteria	Bacteria	105	1.2099999999999999e-27	NR	WP_228595085.1	1280	g38007	i0	64.3	0.853658536585366	70	25	85.4	0	240	31	1	70	WP_228595085.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	210	105	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
31413013	31413013	PRJNA806354_P_NODE_37196_length_247_cov_2.695402_g37087_i0	PRJNA806354	37196	247	2.695402	6.65764294	Clostridiales bacterium	1898207	Bacteria	Bacteria	106	1.02e-26	NR	MCI6603410.1	1898207	g37087	i0	100	0.619433198380567	51	0	61.9	0	246	94	148	198	MCI6603410.1 sulfurtransferase-like selenium metabolism protein YedF [Clostridiales bacterium]	diamond	153	106	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
31792338	31792338	PRJNA806354_P_NODE_39937_length_243_cov_0.905882_g39828_i0	PRJNA806354	39937	243	0.905882	2.20129326	Lacticaseibacillus paracasei	1597	Bacteria	Bacteria	69.3	2.82e-13	NR	MFK5282075.1	1597	g39828	i0	72.5	0.62962962962963	51	13	61.7	1	72	221	7	57	MFK5282075.1 hypothetical protein [Lacticaseibacillus paracasei]	diamond	153	69.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei

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