metadata: contig_metadata: 9 rows where bioproject = "PRJNA330616" and tax

9 rows where bioproject = "PRJNA330616" 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
5493159	5493159	PRJNA330616_P_NODE_18145_length_197_cov_1.851351_g17736_i0	PRJNA330616	18145	197	1.851351	3.64716147	Anaerolineales bacterium	2073117	Bacteria	Bacteria	340	3.2499999999999995e-89	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g17736	i0	97.959	37.7868020304569	196	4	99	0	2	197	1576437	1576242	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	7444	340	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
16966978	16966978	PRJNA330616_P_NODE_18354_length_196_cov_2.000000_g17945_i0	PRJNA330616	18354	196	2	3.92	Anaerolineales bacterium	2073117	Bacteria	Bacteria	158	3.49e-34	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g17945	i0	91.964	95.7295918367347	112	9	57	0	62	173	1576656	1576545	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	18763	158	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
16967220	16967220	PRJNA330616_P_NODE_6534_length_327_cov_1.435252_g6125_i0	PRJNA330616	6534	327	1.435252	4.69327404	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	307	5.94e-79	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g6125	i0	84.52	91.9847094801223	323	37	98	8	8	327	671121	671433	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	30079	307	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
27580077	27580077	PRJNA330616_P_NODE_6664_length_324_cov_1.112727_g6255_i0	PRJNA330616	6664	324	1.112727	3.60523548	Roseiflexaceae bacterium	2762507	Bacteria	Bacteria	122	1.0099999999999999e-32	NR	HET9222194.1	2762507	g6255	i0	84.1	2.55555555555556	69	11	63.9	0	113	319	1	69	HET9222194.1 tail fiber protein [Roseiflexaceae bacterium]	diamond	828	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexaceae bacterium
29491825	29491825	PRJNA330616_P_NODE_29610_length_163_cov_1.342105_g29201_i0	PRJNA330616	29610	163	1.342105	2.18763115	Bacteria	2	Bacteria	Bacteria	55.8	6.84e-8	NR	MEZ4590034.1	2026724	g29201	i0	56	2.87116564417178	50	22	92	0	14	163	78	127	MEZ4590034.1 GNAT family N-acetyltransferase [Chloroflexota bacterium]	diamond	468	56.2	0.99288256227758	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29695210	29695210	PRJNA330616_P_NODE_24030_length_172_cov_1.951220_g23621_i0	PRJNA330616	24030	172	1.95122	3.3560984	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	48.5	1.21e-4	NR	HNT53909.1	2024896	g23621	i0	42.1	3.9593023255814	57	33	99.4	0	172	2	167	223	HNT53909.1 aminoglycoside phosphotransferase family protein [Anaerolineaceae bacterium]	diamond	681	48.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
29948287	29948287	PRJNA330616_P_NODE_18031_length_198_cov_1.302013_g17622_i0	PRJNA330616	18031	198	1.302013	2.57798574	Chloroflexota bacterium	2026724	Bacteria	Bacteria	49.7	1.31e-5	NR	MEL7432661.1	2026724	g17622	i0	50.9	2.59090909090909	53	26	80.3	0	159	1	38	90	MEL7432661.1 30S ribosomal protein S13 [Chloroflexota bacterium]	diamond	513	49.7	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31054367	31054367	PRJNA330616_P_NODE_29255_length_164_cov_0.886957_g28846_i0	PRJNA330616	29255	164	0.886957	1.45460948	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	67	1.49e-11	NR	MDR3573577.1	2024896	g28846	i0	59.3	0.98780487804878	54	22	98.8	0	162	1	150	203	MDR3573577.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	162	67	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
31148401	31148401	PRJNA330616_P_NODE_16195_length_208_cov_1.283019_g15786_i0	PRJNA330616	16195	208	1.283019	2.66867952	Anaerolineae bacterium	2052143	Bacteria	Bacteria	50.4	4.41e-5	NR	MCB0192781.1	2052143	g15786	i0	42.9	0.807692307692308	56	28	76.4	2	39	197	504	558	MCB0192781.1 AAA family ATPase [Anaerolineae bacterium]	diamond	168	50.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae 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);;