metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1047749" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1047749" 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
9102753	9102753	PRJNA1047749_P_NODE_34328_length_270_cov_1.304569_g34061_i0	PRJNA1047749	34328	270	1.304569	3.5223363	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	171	6.549999999999999e-38	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g34061	i0	80	4.4	235	43	86	4	37	269	316483	316715	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	1188	171	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
9102869	9102869	PRJNA1047749_P_NODE_42328_length_243_cov_9.194118_g42061_i0	PRJNA1047749	42328	243	9.194118	22.34170674	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	200	7.39e-47	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g42061	i0	82.479	0.962962962962963	234	35	95	5	2	232	953085	953315	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	234	200	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
10378210	10378210	PRJNA1047749_P_NODE_21529_length_310_cov_5.219409_g21262_i0	PRJNA1047749	21529	310	5.219409	16.1801679	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	95.3	4.74e-15	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g21262	i0	81.356	2.45483870967742	118	21	38	1	185	301	2617377	2617260	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	761	95.3	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12928985	12928985	PRJNA1047749_P_NODE_40151_length_249_cov_3.892045_g39884_i0	PRJNA1047749	40151	249	3.892045	9.69119205	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g39884	i0	81.463	4.36144578313253	205	37	82	1	36	240	6712341	6712544	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	1086	167	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
12928989	12928989	PRJNA1047749_P_NODE_40511_length_248_cov_4.737143_g40244_i0	PRJNA1047749	40511	248	4.737143	11.74811464	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	132	2.8e-26	NTclustered	gi\|148566298\|gb\|CP000686.1\|	357808	g40244	i0	80.11	3.05645161290323	181	32	72	4	64	242	4897927	4898105	Roseiflexus sp. RS-1, complete genome	blastn	758	132	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1
13763440	13763440	PRJNA1047749_P_NODE_19611_length_312_cov_3.083682_g19344_i0	PRJNA1047749	19611	312	3.083682	9.62108784	root	1	Root_unresolved	Root_unresolved	278	4.42e-70	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g19344	i0	100	200.24358974359	150	0	94	0	2	151	564335	564484	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	62476	278	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14203635	14203635	PRJNA1047749_P_NODE_20412_length_312_cov_2.682008_g20145_i0	PRJNA1047749	20412	312	2.682008	8.36786496	Litorilinea aerophila	1204385	Bacteria	Bacteria	259	1.6e-64	NTclustered	gi\|393193706\|gb\|JQ733906.1\|	1204385	g20145	i0	97.987	191.948717948718	149	3	94	0	162	310	5331	5479	Litorilinea aerophila strain PRI-4131 small subunit ribosomal RNA, tRNA-Ile (trnI), and large subunit ribosomal RNA genes, complete sequence	blastn	59888	259	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Litorilinea	Litorilinea aerophila
15477688	15477688	PRJNA1047749_P_NODE_20273_length_312_cov_2.753138_g20006_i0	PRJNA1047749	20273	312	2.753138	8.58979056	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	183	9.909999999999998e-42	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g20006	i0	92.248	0.413461538461538	129	10	41	0	1	129	2149889	2150017	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	129	183	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17588007	17588007	PRJNA1047749_P_NODE_26054_length_299_cov_9.358407_g25787_i0	PRJNA1047749	26054	299	9.358407	27.98163693	Bacteria	2	Bacteria	Bacteria	76.8	1.65e-9	NTclustered	gi\|2518551077\|emb\|OX638330.1\|	543031	g25787	i0	86.957	1.72909698996656	69	7	23	2	228	295	5825309	5825376	MAG: uncultured Caldilineaceae bacterium isolate 76db5b8c-001f-43e6-88b1-0bf759d03ef1 genome assembly, chromosome: 1	blastn	517	76.8	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		uncultured Caldilineaceae bacterium
18026681	18026681	PRJNA1047749_P_NODE_18015_length_312_cov_4.158996_g17748_i0	PRJNA1047749	18015	312	4.158996	12.97606752	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	137	7.83e-28	NTclustered	gi\|2893358404\|emb\|OZ220695.1\|	3022862	g17748	i0	84.286	1.53525641025641	140	22	45	0	12	151	1335896	1336035	MAG: Tepidiformaceae bacterium isolate d5d77930-af5a-4506-8b4e-3340c6a42e1f genome assembly, chromosome: 1	blastn	479	137	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
19300696	19300696	PRJNA1047749_P_NODE_21136_length_311_cov_5.630252_g20869_i0	PRJNA1047749	21136	311	5.630252	17.51008372	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	156	2.15e-33	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g20869	i0	87.591	36.2250803858521	137	13	43	4	168	302	6266164	6266030	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	11266	156	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
20575996	20575996	PRJNA1047749_P_NODE_20257_length_312_cov_2.761506_g19990_i0	PRJNA1047749	20257	312	2.761506	8.61589872	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	130	1.31e-25	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g19990	i0	82.237	0.487179487179487	152	25	48	2	162	312	8373013	8372863	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	152	130	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
23127273	23127273	PRJNA1047749_P_NODE_24059_length_301_cov_3.881579_g23792_i0	PRJNA1047749	24059	301	3.881579	11.68355279	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	121	7.57e-23	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g23792	i0	84.375	1.96677740863787	128	14	42	4	11	135	1051930	1051806	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	592	121	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);;