metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
555720	555720	PRJNA565584_P_NODE_180321_length_248_cov_1.760000_g179169_i0	PRJNA565584	180321	248	1.76	4.3648	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	69.4	2.23e-7	NTclustered	gi\|2874253736\|emb\|OY969578.1\|	1672391	g179169	i0	90.385	1.03629032258065	52	5	21	0	166	217	335532	335583	MAG: uncultured Chloroflexia bacterium isolate MFD05674.bin.c.2 genome assembly, chromosome: 1	blastn	257	69.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
557060	557060	PRJNA565584_P_NODE_51321_length_415_cov_2.233918_g50170_i0	PRJNA565584	51321	415	2.233918	9.2707597	Roseiflexus castenholzii	120962	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g50170	i0	96.875	0.0771084337349398	32	0	7	1	198	228	4536298	4536329	Roseiflexus castenholzii DSM 13941, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
5659988	5659988	PRJNA565584_P_NODE_207865_length_242_cov_1.733728_g206713_i0	PRJNA565584	207865	242	1.733728	4.19562176	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g206713	i0	86.667	6.52479338842975	225	24	90	4	1	219	1028526	1028302	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	1579	244	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
8208338	8208338	PRJNA565584_P_NODE_158987_length_256_cov_1.715847_g157835_i0	PRJNA565584	158987	256	1.715847	4.39256832	Chloroflexota bacterium	2026724	Bacteria	Bacteria	147	1.04e-30	NTclustered	gi\|1985684846\|gb\|CP069394.1\|	2026724	g157835	i0	77.432	176.59765625	257	50	99	8	1	254	1474874	1474623	Chloroflexi bacterium strain ZRK35 chromosome, complete genome	blastn	45209	147	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
12033646	12033646	PRJNA565584_P_NODE_113770_length_286_cov_1.140845_g112618_i0	PRJNA565584	113770	286	1.140845	3.2628167	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	169	2.52e-37	NTclustered	gi\|2621703475\|emb\|OY762538.1\|	3022862	g112618	i0	80.804	8.96153846153846	224	35	77	6	54	273	1475452	1475671	MAG: Tepidiformaceae bacterium isolate 22918afd-2252-4b5b-9d47-9fe66d5d45bf genome assembly, chromosome: 1	blastn	2563	169	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
12035183	12035183	PRJNA565584_P_NODE_197470_length_245_cov_0.895349_g196318_i0	PRJNA565584	197470	245	0.895349	2.19360505	Anaerolineales bacterium	2073117	Bacteria	Bacteria	231	2.65e-56	NTclustered	gi\|2556895010\|gb\|CP129480.1\|	2073117	g196318	i0	89.56	1.04897959183673	182	19	100	0	64	245	2413529	2413348	MAG: Anaerolineales bacterium isolate cMAG.16 chromosome, complete genome	blastn	257	231	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
13309577	13309577	PRJNA565584_P_NODE_167511_length_251_cov_0.865169_g166359_i0	PRJNA565584	167511	251	0.865169	2.17157419	Aggregatilineales bacterium	2952883	Bacteria	Bacteria	243	1.2600000000000001e-59	NTclustered	gi\|2621701642\|emb\|OY760398.1\|	2952883	g166359	i0	91.111	573.900398406375	180	15	71	1	29	207	381929	382108	MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1	blastn	144049	243	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Aggregatilineales			Aggregatilineales bacterium
13309998	13309998	PRJNA565584_P_NODE_195191_length_245_cov_0.895349_g194039_i0	PRJNA565584	195191	245	0.895349	2.19360505	Chloroflexota bacterium	2026724	Bacteria	Bacteria	67.6	7.9e-7	NTclustered	gi\|2621701252\|emb\|OY759972.1\|	2026724	g194039	i0	95.238	172.2	42	2	18	0	175	216	1866091	1866132	MAG: Chloroflexota bacterium isolate 55c93f92-7b64-48b2-973a-1fcfb2e6d712 genome assembly, chromosome: 1	blastn	42189	67.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
14584131	14584131	PRJNA565584_P_NODE_153312_length_260_cov_1.588235_g152160_i0	PRJNA565584	153312	260	1.588235	4.129411	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	207	4.78e-49	NTclustered	gi\|2874253698\|emb\|OY969424.1\|	1672391	g152160	i0	91.503	138.123076923077	153	9	58	4	44	194	973221	973371	MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1	blastn	35912	207	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14584852	14584852	PRJNA565584_P_NODE_196512_length_245_cov_0.895349_g195360_i0	PRJNA565584	196512	245	0.895349	2.19360505	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	270	5.609999999999999e-68	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g195360	i0	86.531	5.13469387755102	245	33	100	0	1	245	218297	218541	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	1258	270	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
14585213	14585213	PRJNA565584_P_NODE_219932_length_232_cov_2.421384_g218780_i0	PRJNA565584	219932	232	2.421384	5.61761088	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	67.6	7.41e-7	NTclustered	gi\|2621703574\|emb\|OY761449.1\|	2026734	g218780	i0	100	10.3879310344828	36	0	16	0	197	232	3146731	3146766	MAG: Dehalococcoidia bacterium isolate 8faaec51-6d46-4fc3-9050-60b85d5760d4 genome assembly, chromosome: 1	blastn	2410	67.6	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
15857046	15857046	PRJNA565584_P_NODE_106393_length_290_cov_2.041475_g105241_i0	PRJNA565584	106393	290	2.041475	5.9202775	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	313	1.12e-80	NTclustered	gi\|2874253981\|emb\|OY970306.1\|	1672391	g105241	i0	86.713	253.465517241379	286	33	98	4	1	283	1027878	1028161	MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1	blastn	73505	313	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
17132052	17132052	PRJNA565584_P_NODE_106254_length_290_cov_2.437788_g105102_i0	PRJNA565584	106254	290	2.437788	7.0695852	Anaerolineaceae bacterium oral taxon 439	1889813	Bacteria	Bacteria	387	6.48e-103	NTclustered	gi\|1061024832\|gb\|CP017039.1\|	1889813	g105102	i0	91.197	1.07586206896552	284	25	98	0	1	284	1581506	1581789	Anaerolineaceae bacterium oral taxon 439 strain W11661 chromosome, complete genome	blastn	312	387	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium oral taxon 439
17134970	17134970	PRJNA565584_P_NODE_62954_length_374_cov_1.976744_g61803_i0	PRJNA565584	62954	374	1.976744	7.39302256	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	71.3	9.83e-8	NTclustered	gi\|2108129769\|gb\|CP070729.1\|	2026734	g61803	i0	100	0.379679144385027	38	0	10	0	183	220	165115	165152	MAG: Dehalococcoidia bacterium isolate bin423 chromosome	blastn	142	71.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
19682510	19682510	PRJNA565584_P_NODE_198996_length_244_cov_1.444444_g197844_i0	PRJNA565584	198996	244	1.444444	3.52444336	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|311336157\|gb\|HQ183884.1\|	166587	g197844	i0	99.59	99.905737704918	244	1	100	0	1	244	889	646	Uncultured Chloroflexi bacterium clone De2127 16S ribosomal RNA gene, partial sequence	blastn	24377	446	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23508807	23508807	PRJNA565584_P_NODE_221059_length_229_cov_2.858974_g219907_i0	PRJNA565584	221059	229	2.858974	6.54705046	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	89.8	1.56e-13	NTclustered	gi\|2621703574\|emb\|OY761449.1\|	2026734	g219907	i0	85.714	18.6419213973799	84	12	37	0	14	97	441855	441772	MAG: Dehalococcoidia bacterium isolate 8faaec51-6d46-4fc3-9050-60b85d5760d4 genome assembly, chromosome: 1	blastn	4269	89.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia 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);;