metadata: contig_metadata: 8 rows where bioproject = "PRJNA599208" and tax

8 rows where bioproject = "PRJNA599208" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4399912	4399912	PRJNA599208_P_NODE_3344_length_472_cov_1.434483_g3150_i0	PRJNA599208	3344	472	1.434483	6.77075976	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	459	2.3199999999999993e-124	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g3150	i0	84.881	250.919491525424	463	60	98	6	11	472	3495907	3495454	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	118434	459	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
8225439	8225439	PRJNA599208_P_NODE_4747_length_373_cov_2.181548_g4552_i0	PRJNA599208	4747	373	2.181548	8.13717404	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	579	1.3199999999999996e-160	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g4552	i0	94.638	177.876675603217	373	20	100	0	1	373	598454	598826	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	66348	579	1	Bacteria		Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
15874913	15874913	PRJNA599208_P_NODE_12333_length_185_cov_1.472973_g12137_i0	PRJNA599208	12333	185	1.472973	2.72500005	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	176	8.98e-40	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g12137	i0	88.356	72.4864864864865	146	17	79	0	37	182	1026805	1026660	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	13410	176	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20974487	20974487	PRJNA599208_P_NODE_14277_length_167_cov_1.938462_g14081_i0	PRJNA599208	14277	167	1.938462	3.23723154	Chloroflexota bacterium	2026724	Bacteria	Bacteria	124	2.9299999999999998e-24	NTclustered	gi\|2891482052\|emb\|OZ219801.1\|	2026724	g14081	i0	87.273	60.3173652694611	110	12	65	2	59	167	322625	322733	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 1	blastn	10073	124	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
21543309	21543309	PRJNA599208_P_NODE_10537_length_208_cov_1.684211_g10341_i0	PRJNA599208	10537	208	1.684211	3.50315888	Bacillati	1783272	Bacteria	Bacteria	172	1.34e-38	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g10341	i0	82.843	199.711538461538	204	23	96	11	3	201	672383	672579	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	41540	172	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23524538	23524538	PRJNA599208_P_NODE_10259_length_212_cov_2.154286_g10063_i0	PRJNA599208	10259	212	2.154286	4.56708632	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	315	2.15e-81	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g10063	i0	93.427	235.471698113208	213	12	100	2	1	212	1027775	1027986	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	49920	315	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
24798367	24798367	PRJNA599208_P_NODE_12560_length_183_cov_0.863014_g12364_i0	PRJNA599208	12560	183	0.863014	1.57931562	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	154	4.15e-33	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g12364	i0	87.313	68.9781420765027	134	17	73	0	1	134	381967	382100	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	12623	154	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
26699863	26699863	PRJNA599208_P_NODE_9761_length_220_cov_1.688525_g9565_i0	PRJNA599208	9761	220	1.688525	3.714755	Chloroflexota bacterium	2026724	Bacteria	Bacteria	64.7	4.99e-10	NR	MBI2917726.1	2026724	g9565	i0	50.7	2.04545454545455	73	36	99.5	0	2	220	157	229	MBI2917726.1 Ig-like domain-containing protein [Chloroflexota bacterium]	diamond	450	64.7	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota 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);;