metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1590830	1590830	PRJNA1174234_P_NODE_4442_length_637_cov_2.070922_g4251_i0	PRJNA1174234	4442	637	2.070922	13.19177314	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	571	3.929999999999998e-158	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g4251	i0	82.893	73.0565149136578	643	102	100	8	1	637	8926	9566	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	46537	571	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
4143001	4143001	PRJNA1174234_P_NODE_17564_length_329_cov_1.195312_g17368_i0	PRJNA1174234	17564	329	1.195312	3.93257648	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	425	1.58e-114	NTclustered	gi\|2874253835\|emb\|OY969885.1\|	1672391	g17368	i0	90.184	6.20668693009119	326	32	99	0	1	326	2093287	2093612	MAG: uncultured Chloroflexia bacterium isolate MFD01275.bin.c.5 genome assembly, chromosome: 1	blastn	2042	425	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
5419216	5419216	PRJNA1174234_P_NODE_30685_length_249_cov_0.875000_g30489_i0	PRJNA1174234	30685	249	0.875	2.17875	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|2874254102\|emb\|OY970185.1\|	1672391	g30489	i0	93.173	465.425702811245	249	17	100	0	1	249	1858356	1858604	MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1	blastn	115891	366	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9969036	9969036	PRJNA1174234_P_NODE_2368_length_830_cov_1.266843_g2205_i0	PRJNA1174234	2368	830	1.266843	10.5147969	Herpetosiphon	64	Bacteria	Bacteria	1048	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g2205	i0	89.784	155.357831325301	832	66	99	18	6	830	591	1410	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	128947	1048	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
10519756	10519756	PRJNA1174234_P_NODE_26769_length_264_cov_1.492147_g26573_i0	PRJNA1174234	26769	264	1.492147	3.93926808	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g26573	i0	89.773	26.75	264	27	100	0	1	264	3495523	3495786	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	7062	339	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
11794641	11794641	PRJNA1174234_P_NODE_11810_length_401_cov_1.289634_g11614_i0	PRJNA1174234	11810	401	1.289634	5.17143234	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	316	1.23e-81	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g11614	i0	82.4	200.640897755611	375	54	91	8	38	401	7985	7612	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	80457	316	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
12519597	12519597	PRJNA1174234_P_NODE_15330_length_352_cov_2.580645_g15134_i0	PRJNA1174234	15330	352	2.580645	9.0838704	Herpetosiphon	64	Bacteria	Bacteria	224	6.66e-54	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g15134	i0	78.552	162.201704545455	359	64	100	12	1	352	566	214	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	57095	224	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
15618784	15618784	PRJNA1174234_P_NODE_12153_length_395_cov_1.540373_g11957_i0	PRJNA1174234	12153	395	1.540373	6.08447335	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	121	1.02e-22	NTclustered	gi\|2531976022\|emb\|OY282355.1\|	498747	g11957	i0	85	13.8860759493671	120	16	30	2	274	392	2403026	2402908	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	5485	121	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
16893225	16893225	PRJNA1174234_P_NODE_2914_length_762_cov_2.269956_g2741_i0	PRJNA1174234	2914	762	2.269956	17.29706472	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	1020	0	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g2741	i0	91.712	262.363517060367	736	59	96	2	28	762	8820	8086	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	199921	1020	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
23268406	23268406	PRJNA1174234_P_NODE_6119_length_550_cov_2.469602_g5923_i0	PRJNA1174234	6119	550	2.469602	13.582811	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	939	0	NTclustered	gi\|197360223\|gb\|EU979011.1\|	166587	g5923	i0	97.464	97.8872727272727	552	10	100	4	1	550	2	551	Uncultured Chloroflexi bacterium clone g2 16S ribosomal RNA gene, partial sequence	blastn	53838	939	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota 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);;