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

5 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Synergistota"

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
32965741	32965741	PRJNA1233465a_S_NODE_103554_length_226_cov_1.429379_g102280_i0	PRJNA1233465	103554	226	1.429379	3.23039654	Acetomicrobium sp. S15 = DSM 1	1872099	Bacteria	Bacteria	59.7	3.04e-8	NR	WP_198470857.1	2529858	g102280	i0	41.9	1.99115044247788	74	42	96.9	1	7	225	146	219	WP_198470857.1 glycosyltransferase [Acetomicrobium sp. S15 = DSM 107314]	diamond	450	59.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium sp. S15 = DSM 107314
33070204	33070204	PRJNA1233465e_S_NODE_99821_length_193_cov_1.062500_g98511_i0	PRJNA1233465	99821	193	1.0625	2.050625	Synergistaceae bacterium	2053624	Bacteria	Bacteria	43.5	0.00947	NR	HQH79645.1	2053624	g98511	i0	39.7	0.901554404145078	58	29	90.2	2	178	5	118	169	HQH79645.1 hypothetical protein [Synergistaceae bacterium]	diamond	174	43.5	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
33085043	33085043	PRJNA1233465a_S_NODE_122950_length_211_cov_2.018519_g121676_i0	PRJNA1233465	122950	211	2.018519	4.25907509	Synergistaceae bacterium	2053624	Bacteria	Bacteria	127	5.37e-34	NR	NLX75696.1	2053624	g121676	i0	100	0.981042654028436	69	0	98.1	0	2	208	207	275	NLX75696.1 GGDEF domain-containing protein [Synergistaceae bacterium]	diamond	207	127	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
33102708	33102708	PRJNA1233465b_S_NODE_107454_length_268_cov_1.652968_g105769_i0	PRJNA1233465	107454	268	1.652968	4.42995424	Synergistaceae bacterium	2053624	Bacteria	Bacteria	109	2.0500000000000003e-27	NR	NLX75697.1	2053624	g105769	i0	100	0.593283582089552	53	0	59.3	0	110	268	1	53	NLX75697.1 response regulator transcription factor [Synergistaceae bacterium]	diamond	159	109	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
33102732	33102732	PRJNA1233465b_S_NODE_121390_length_256_cov_1.507246_g119705_i0	PRJNA1233465	121390	256	1.507246	3.85854976	Synergistaceae bacterium	2053624	Bacteria	Bacteria	157	2.07e-45	NR	NLX75696.1	2053624	g119705	i0	100	0.984375	84	0	98.4	0	2	253	192	275	NLX75696.1 GGDEF domain-containing protein [Synergistaceae bacterium]	diamond	252	157	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;