metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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
1535119	1535119	PRJNA1120060_P_NODE_3209502_length_231_cov_2.493671_g3191395_i0	PRJNA1120060	3209502	231	2.493671	5.76038001	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	156	1.53e-33	NTclustered	gi\|2874253725\|emb\|OY969567.1\|	1672391	g3191395	i0	79.909	1.42857142857143	219	39	94	4	16	231	1514577	1514793	MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1	blastn	330	156	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
3576925	3576925	PRJNA1120060_P_NODE_2731243_length_247_cov_9.149425_g2713159_i0	PRJNA1120060	2731243	247	9.149425	22.59907975	Bacteria	2	Bacteria	Bacteria	272	1.5699999999999999e-68	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g2713159	i0	86.885	94.4939271255061	244	30	98	2	3	245	151180	150938	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	23340	272	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
4076593	4076593	PRJNA1120060_P_NODE_2294004_length_261_cov_2.845745_g2275945_i0	PRJNA1120060	2294004	261	2.845745	7.42739445	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2621703647\|emb\|OY762633.1\|	2026734	g2275945	i0	100	0.111111111111111	29	0	11	0	191	219	2146184	2146156	MAG: Dehalococcoidia bacterium isolate 17254eae-7cb3-4ac9-839e-465292e2b3d4 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7909732	7909732	PRJNA1120060_P_NODE_2887387_length_244_cov_0.912281_g2869298_i0	PRJNA1120060	2887387	244	0.912281	2.22596564	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g2869298	i0	87.805	11.0532786885246	246	26	100	4	1	244	1253708	1253465	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	2697	285	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15557799	15557799	PRJNA1120060_P_NODE_2727613_length_248_cov_0.885714_g2709530_i0	PRJNA1120060	2727613	248	0.885714	2.19657072	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621702714\|emb\|OY759598.1\|	2026734	g2709530	i0	100	0.112903225806452	28	0	11	0	166	193	709415	709442	MAG: Dehalococcoidia bacterium isolate 9e3974e8-1b76-4a2a-ace1-a6b9f67a3735 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
16808779	16808779	PRJNA1120060_P_NODE_102634_length_565_cov_4.184959_g88068_i0	PRJNA1120060	102634	565	4.184959	23.64501835	Ktedonobacterales bacterium	2306968	Bacteria	Bacteria	62.1	9.25e-5	NTclustered	gi\|2513924934\|gb\|CP126532.1\|	2306968	g88068	i0	97.222	0.80353982300885	36	1	6	0	324	359	3416767	3416802	MAG: Ktedonobacterales bacterium isolate bin_006 chromosome, complete genome	blastn	454	62.1	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales			Ktedonobacterales bacterium
18093764	18093764	PRJNA1120060_P_NODE_1736275_length_283_cov_3.452381_g1718267_i0	PRJNA1120060	1736275	283	3.452381	9.77023823	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2621703217\|emb\|OY762409.1\|	2026734	g1718267	i0	100	0.0989399293286219	28	0	10	0	27	54	485421	485448	MAG: Dehalococcoidia bacterium isolate 38c4f93b-5868-4cd3-8e0a-f10fb6dda0e3 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20649875	20649875	PRJNA1120060_P_NODE_2222497_length_264_cov_1.821990_g2204444_i0	PRJNA1120060	2222497	264	1.82199	4.8100536	Anaerolinea thermophila	167964	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|319993263\|dbj\|AP012029.1\|	926569	g2204444	i0	100	1	264	0	100	0	1	264	1777459	1777722	Anaerolinea thermophila UNI-1 DNA, complete genome	blastn	264	488	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea thermophila
21910745	21910745	PRJNA1120060_P_NODE_1167538_length_310_cov_8.708861_g1149599_i0	PRJNA1120060	1167538	310	8.708861	26.9974691	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	137	7.77e-28	NTclustered	gi\|2891482201\|emb\|OZ219934.1\|	2026734	g1149599	i0	83.221	19.4290322580645	149	25	48	0	160	308	68312	68460	MAG: Dehalococcoidia bacterium isolate d5105c1e-37dd-4811-a55b-ed3c3c49e222 genome assembly, chromosome: 8	blastn	6023	137	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
21913952	21913952	PRJNA1120060_P_NODE_1380478_length_298_cov_7.822222_g1362498_i0	PRJNA1120060	1380478	298	7.822222	23.31022156	Thermobaculum terrenum	166501	Bacteria	Bacteria	122	2.0799999999999994e-23	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g1362498	i0	81.633	2.4496644295302	147	27	49	0	152	298	101124	100978	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	730	122	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
21921147	21921147	PRJNA1120060_P_NODE_1901198_length_276_cov_8.886700_g1883176_i0	PRJNA1120060	1901198	276	8.8867	24.527292	Tepidiformaceae bacterium	3022862	Bacteria	Bacteria	84.2	9e-12	NTclustered	gi\|2893356066\|emb\|OZ220489.1\|	3022862	g1883176	i0	84.524	0.485507246376812	84	13	30	0	1	84	1856946	1857029	MAG: Tepidiformaceae bacterium isolate fe7a5560-ebd3-4005-b60b-c4614588a40b genome assembly, chromosome: 1	blastn	134	84.2	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae		Tepidiformaceae bacterium
23189565	23189565	PRJNA1120060_P_NODE_1400879_length_298_cov_1.782222_g1382899_i0	PRJNA1120060	1400879	298	1.782222	5.31102156	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2621701347\|emb\|OY760067.1\|	2073117	g1382899	i0	96.875	0.10738255033557	32	0	10	1	100	130	931102	931071	MAG: Anaerolineales bacterium isolate e1712b75-d4f6-4c5e-bc49-bbfdc0d5b476 genome assembly, chromosome: 2	blastn	32	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales 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);;