metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA453111" 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
22117974	22117974	PRJNA453111_P_NODE_658_length_1009_cov_1.802350_g598_i0	PRJNA453111	658	1009	1.80235	18.1857115	Enterococcus	1350	Bacteria	Bacteria	390	8.249999999999998e-132	NR	WP_413133017.1	37734	g598	i0	56.7	3.00891972249752	337	133	96.3	2	2	973	29	365	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	3036	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
27913410	27913410	PRJNA453111_P_NODE_6345_length_321_cov_1.862903_g6253_i0	PRJNA453111	6345	321	1.862903	5.97991863	Enterococcus	1350	Bacteria	Bacteria	124	9.619999999999999e-32	NR	WP_413133017.1	37734	g6253	i0	55.8	1.94392523364486	104	45	97.2	1	3	314	206	308	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	624	125	0.992	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
28402538	28402538	PRJNA453111_P_NODE_8026_length_286_cov_0.995305_g7934_i0	PRJNA453111	8026	286	0.995305	2.8465723	Clostridia bacterium	2044939	Bacteria	Bacteria	44.7	0.0139	NR	QRN85737.1	2044939	g7934	i0	34.8	0.692307692307692	66	37	62.9	1	56	235	235	300	QRN85737.1 InlB B-repeat-containing protein [Clostridia bacterium]	diamond	198	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28686971	28686971	PRJNA453111_P_NODE_12687_length_242_cov_1.366864_g12595_i0	PRJNA453111	12687	242	1.366864	3.30781088	Enterococcus mundtii	53346	Bacteria	Bacteria	48.9	2.35e-4	NR	WP_010736445.1	53346	g12595	i0	35.7	3.47107438016529	70	45	86.8	0	213	4	22	91	WP_010736445.1 pectate lyase family protein [Enterococcus mundtii]	diamond	840	48.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus mundtii
29444234	29444234	PRJNA453111_P_NODE_1410_length_694_cov_1.621578_g1322_i0	PRJNA453111	1410	694	1.621578	11.25375132	Melissococcus plutonius	33970	Bacteria	Bacteria	130	7.26e-32	NR	WP_231849637.1	33970	g1322	i0	44.6	1.45244956772334	168	88	70.5	1	493	5	35	202	WP_231849637.1 pectate lyase family protein [Melissococcus plutonius]	diamond	1008	130	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius

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