metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA792582" 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_genus	tax_species
3328153	3328153	PRJNA792582_P_NODE_40463_length_276_cov_2.285714_g39649_i0	PRJNA792582	40463	276	2.285714	6.30857064	Chloroflexota bacterium	2026724	Bacteria	Bacteria	75	5.42e-9	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g39649	i0	95.652	16.3731884057971	46	2	17	0	6	51	4246314	4246359	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	4519	75	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
3766945	3766945	PRJNA792582_P_NODE_1343_length_1334_cov_3.737510_g972_i0	PRJNA792582	1343	1334	3.73751	49.8583834	Chloroflexus	1107	Bacteria	Bacteria	632	3.8299999999999994e-176	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g972	i0	76.357	517.436281859071	1345	220	98	79	26	1334	24	1306	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	690260	632	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
5880327	5880327	PRJNA792582_P_NODE_27425_length_330_cov_1.198444_g26611_i0	PRJNA792582	27425	330	1.198444	3.9548652	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	108	6.54e-19	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26611	i0	73.746	11.9787878787879	339	61	98	22	1	325	1333495	1333819	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	3953	108	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7593764	7593764	PRJNA792582_P_NODE_7306_length_619_cov_6.054945_g6520_i0	PRJNA792582	7306	619	6.054945	37.48010955	Chloroflexus	1107	Bacteria	Bacteria	228	9.499999999999999e-55	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g6520	i0	83.019	37.5961227786753	265	32	42	12	1	259	1905	1648	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	23272	228	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
8429919	8429919	PRJNA792582_P_NODE_15447_length_438_cov_2.000000_g14633_i0	PRJNA792582	15447	438	2	8.76	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	122	3.179999999999999e-23	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g14633	i0	90.323	14.5159817351598	93	9	21	0	165	257	3520995	3521087	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	6358	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
16079362	16079362	PRJNA792582_P_NODE_26953_length_333_cov_1.019231_g26139_i0	PRJNA792582	26953	333	1.019231	3.39403923	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	374	5.9e-99	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g26139	i0	87.164	81.3423423423423	335	36	99	6	2	333	274725	275055	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	27087	374	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17355231	17355231	PRJNA792582_P_NODE_35794_length_289_cov_1.180556_g34980_i0	PRJNA792582	35794	289	1.180556	3.41180684	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	324	5.13e-84	NTclustered	gi\|2874254133\|emb\|OY970218.1\|	1672391	g34980	i0	86.851	4.0242214532872	289	38	100	0	1	289	3623416	3623128	MAG: uncultured Chloroflexia bacterium isolate MFD04716.bin.1.117 genome assembly, chromosome: 1	blastn	1163	324	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
18628367	18628367	PRJNA792582_P_NODE_19555_length_389_cov_1.889241_g18741_i0	PRJNA792582	19555	389	1.889241	7.34914749	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	198	4.51e-46	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g18741	i0	78.947	1.34447300771208	304	55	77	9	89	389	3522299	3522002	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	523	198	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
19904036	19904036	PRJNA792582_P_NODE_60716_length_228_cov_2.425806_g59902_i0	PRJNA792582	60716	228	2.425806	5.53083768	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	2.52e-31	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g59902	i0	92.381	37.0131578947368	105	6	46	2	1	104	273647	273544	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	8439	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
21179484	21179484	PRJNA792582_P_NODE_40317_length_277_cov_1.250000_g39503_i0	PRJNA792582	40317	277	1.25	3.4625	Chloroflexus aggregans	152260	Bacteria	Bacteria	163	1.13e-35	NTclustered	gi\|219541215\|gb\|CP001337.1\|	326427	g39503	i0	79.216	67.7653429602888	255	38	92	9	24	277	805099	805339	Chloroflexus aggregans DSM 9485, complete genome	blastn	18771	163	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
24166872	24166872	PRJNA792582_P_NODE_21659_length_370_cov_1.744108_g20845_i0	PRJNA792582	21659	370	1.744108	6.4531996	Roseiflexus	120961	Bacteria	Bacteria	281	4.120000000000001e-71	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g20845	i0	80.789	441.691891891892	380	55	100	17	1	370	608	979	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	163426	281	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii

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);;