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

6 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax_phylum = "Chloroflexota"

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_species
18841621	18841621	PRJEB43370_P_NODE_8335_length_167_cov_0.881356_g8292_i0	PRJEB43370	8335	167	0.881356	1.47186452	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.6	8.57e-19	NR	RMF04208.1	2026724	g8292	i0	76.4	1.97604790419162	55	12	98.8	1	1	165	140	193	RMF04208.1 MAG: glutamate synthase subunit beta [Chloroflexota bacterium]	diamond	330	88.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28132401	28132401	PRJEB43370_P_NODE_4945_length_203_cov_1.350649_g4902_i0	PRJEB43370	4945	203	1.350649	2.74181747	PVC group	1783257	Bacteria	Bacteria	54.3	1.77e-6	NR	MCU0510773.1	2052143	g4902	i0	48.5	1.95073891625616	66	29	91.6	3	186	1	34	98	MCU0510773.1 GEVED domain-containing protein [Anaerolineae bacterium]	diamond	396	54.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28454866	28454866	PRJEB43370_P_NODE_8126_length_168_cov_0.873950_g8083_i0	PRJEB43370	8126	168	0.87395	1.468236	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	51.6	9.96e-6	NR	MFN8487977.1	2614250	g8083	i0	40	0.982142857142857	55	32	96.4	1	166	5	770	824	MFN8487977.1 right-handed parallel beta-helix repeat-containing protein [Caldilineaceae bacterium]	diamond	165	51.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilineaceae bacterium
30254917	30254917	PRJEB43370_P_NODE_2632_length_267_cov_1.426606_g2589_i0	PRJEB43370	2632	267	1.426606	3.80903802	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42.7	0.0458	NR	MCI0521422.1	2026724	g2589	i0	30.6	1.10112359550562	98	56	96.6	3	9	266	107	204	MCI0521422.1 hypothetical protein [Chloroflexota bacterium]	diamond	294	42.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30563612	30563612	PRJEB43370_P_NODE_4373_length_214_cov_1.018182_g4330_i0	PRJEB43370	4373	214	1.018182	2.17890948	PVC group	1783257	Bacteria	Bacteria	114	3.0899999999999998e-28	NR	HET8945310.1	2026734	g4330	i0	72.9	5.85981308411215	70	19	98.1	0	214	5	132	201	HET8945310.1 lipid-transfer protein [Dehalococcoidia bacterium]	diamond	1254	115	0.991304347826087	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
30570324	30570324	PRJEB43370_P_NODE_2573_length_270_cov_0.941176_g2530_i0	PRJEB43370	2573	270	0.941176	2.5411752	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	68.6	4.14e-11	NR	MBE0431096.1	2026734	g2530	i0	50	1.66666666666667	64	31	71.1	1	217	26	175	237	MBE0431096.1 amidohydrolase [Dehalococcoidia bacterium]	diamond	450	68.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium

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