metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1102048" 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
211745	211745	PRJNA1102048_P_NODE_13681_length_249_cov_0.875000_g13577_i0	PRJNA1102048	13681	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g13577	i0	91.165	97.4457831325301	249	22	100	0	1	249	241124	241372	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	24264	339	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia bacterium
2762365	2762365	PRJNA1102048_P_NODE_10143_length_277_cov_1.132353_g10039_i0	PRJNA1102048	10143	277	1.132353	3.13661781	Anaerolineales bacterium	2073117	Bacteria	Bacteria	414	2.82e-111	NTclustered	gi\|2556906889\|gb\|CP129483.1\|	2073117	g10039	i0	93.818	174.797833935018	275	17	99	0	3	277	2030282	2030556	MAG: Anaerolineales bacterium isolate cMAG.13 chromosome, complete genome	blastn	48419	414	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
10415186	10415186	PRJNA1102048_P_NODE_7989_length_308_cov_0.978723_g7885_i0	PRJNA1102048	7989	308	0.978723	3.01446684	Anaerolineales bacterium	2073117	Bacteria	Bacteria	490	5.14e-134	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g7885	i0	96.61	317.655844155844	295	10	96	0	14	308	1575681	1575975	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	97838	490	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
12965513	12965513	PRJNA1102048_P_NODE_11791_length_259_cov_1.397849_g11687_i0	PRJNA1102048	11791	259	1.397849	3.6204289099999998	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g11687	i0	100	0.108108108108108	28	0	11	0	60	87	705148	705175	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiformaceae bacterium
14240461	14240461	PRJNA1102048_P_NODE_14172_length_248_cov_0.880000_g14068_i0	PRJNA1102048	14172	248	0.88	2.1824	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	263	9.519999999999998e-66	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g14068	i0	86.235	197.435483870968	247	28	99	3	2	248	2063356	2063596	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	48964	263	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia			uncultured Chloroflexia 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);;