metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA980839" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA980839" 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_species
3508647	3508647	PRJNA980839_P_NODE_183883_length_260_cov_1.395722_g180099_i0	PRJNA980839	183883	260	1.395722	3.6288772	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	63.9	1.09e-5	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g180099	i0	100	3.01153846153846	34	0	13	0	3	36	1013243	1013276	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	783	63.9	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
6062407	6062407	PRJNA980839_P_NODE_234805_length_242_cov_0.911243_g231021_i0	PRJNA980839	234805	242	0.911243	2.20520806	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	340	4.15e-89	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g231021	i0	92.116	98.1404958677686	241	19	99	0	2	242	2451783	2451543	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	23750	340	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
9886714	9886714	PRJNA980839_P_NODE_210088_length_248_cov_0.880000_g206304_i0	PRJNA980839	210088	248	0.88	2.1824	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621703428\|emb\|OY760687.1\|	2026734	g206304	i0	100	0.112903225806452	28	0	11	0	42	69	315601	315574	MAG: Dehalococcoidia bacterium isolate f61cd74f-1a2a-4ce7-9ca1-272438b93162 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidia bacterium
9888529	9888529	PRJNA980839_P_NODE_87108_length_397_cov_1.425926_g83324_i0	PRJNA980839	87108	397	1.425926	5.66092622	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	662	0	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g83324	i0	96.734	611.191435768262	398	12	100	1	1	397	1858555	1858158	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	242643	662	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
11163405	11163405	PRJNA980839_P_NODE_65309_length_490_cov_1.458034_g61527_i0	PRJNA980839	65309	490	1.458034	7.1443666	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	660	0	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g61527	i0	91.02	55.3142857142857	490	42	99	1	3	490	1028485	1027996	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	27104	660	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
12438076	12438076	PRJNA980839_P_NODE_227970_length_243_cov_1.811765_g224186_i0	PRJNA980839	227970	243	1.811765	4.40258895	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	278	3.3200000000000004e-70	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g224186	i0	87.552	1.11934156378601	241	28	99	2	1	240	2745395	2745634	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	272	278	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
12438323	12438323	PRJNA980839_P_NODE_240190_length_240_cov_2.269461_g236406_i0	PRJNA980839	240190	240	2.269461	5.4467064	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	390	4.029999999999999e-104	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g236406	i0	96.218	88.7541666666667	238	9	99	0	3	240	1026921	1026684	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	21301	390	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	uncultured Chloroflexia bacterium
14985568	14985568	PRJNA980839_P_NODE_162732_length_276_cov_1.517241_g158948_i0	PRJNA980839	162732	276	1.517241	4.18758516	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	183	8.629999999999998e-42	NTclustered	gi\|2893358439\|emb\|OZ220731.1\|	2026734	g158948	i0	79.921	83.6594202898551	254	47	91	4	1	252	1605278	1605027	MAG: Dehalococcoidia bacterium isolate 4e89fbe3-e5a8-4f6c-a4f9-b322f53a0d40 genome assembly, chromosome: 1	blastn	23090	183	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidia bacterium
23911405	23911405	PRJNA980839_P_NODE_221179_length_245_cov_0.895349_g217395_i0	PRJNA980839	221179	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	283	7.2e-72	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g217395	i0	87.654	2.97959183673469	243	30	99	0	1	243	1936449	1936207	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	730	283	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);;