metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB15333" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB15333" 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
26684819	26684819	PRJEB15333_P_NODE_3661_length_332_cov_1.869258_g3577_i0	PRJEB15333	3661	332	1.869258	6.20593656	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	43.9	0.0393	NR	MBQ6539838.1	2485925	g3577	i0	31.8	0.795180722891566	88	53	75.9	4	3	254	155	239	MBQ6539838.1 sodium:proton antiporter [Oscillospiraceae bacterium]	diamond	264	43.9	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
27633542	27633542	PRJEB15333_P_NODE_17384_length_168_cov_0.873950_g17300_i0	PRJEB15333	17384	168	0.87395	1.468236	Bacillales bacterium	1904864	Bacteria	Bacteria	75.9	2.76e-14	NR	HET7580570.1	1904864	g17300	i0	72.7	1.96428571428571	55	14	98.2	1	2	166	372	425	HET7580570.1 DNA polymerase/3'-5' exonuclease PolX [Bacillales bacterium]	diamond	330	75.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales			Bacillales bacterium
28927936	28927936	PRJEB15333_P_NODE_20528_length_162_cov_0.920354_g20444_i0	PRJEB15333	20528	162	0.920354	1.49097348	Eubacteriales Family XIII. Incertae Sedis	543314	Bacteria	Bacteria	41.2	0.0401	NR	WP_148396037.1	543314	g20444	i0	39.2	0.944444444444444	51	28	90.7	2	16	162	42	91	WP_148396037.1 MULTISPECIES: phosphatase PAP2 family protein [Anaerovoracaceae]	diamond	153	41.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Anaerovoracaceae
31163869	31163869	PRJEB15333_P_NODE_18615_length_166_cov_0.888889_g18531_i0	PRJEB15333	18615	166	0.888889	1.47555574	Bacillaceae	186817	Bacteria	Bacteria	104	3.26e-25	NR	WP_134339215.1	94137	g18531	i0	90.9	27.8313253012048	55	5	99.4	0	165	1	221	275	WP_134339215.1 recombinase RecA [Filobacillus milosensis]	diamond	4620	105	0.990476190476191	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Filobacillus	Filobacillus milosensis

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