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

11 rows where analysis = "blastn", bioproject = "PRJNA737474" 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
25587384	25587384	PRJNA737474g_S_NODE_383945_length_245_cov_1.052326_g382651_i0	PRJNA737474	383945	245	1.052326	2.5781987	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	130	9.93e-26	NTclustered	gi\|2874254132\|emb\|OY970217.1\|	1672391	g382651	i0	79.459	2.8734693877551	185	36	75	2	6	189	2112046	2111863	MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1	blastn	704	130	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
25723626	25723626	PRJNA737474g_S_NODE_396386_length_244_cov_1.040936_g395092_i0	PRJNA737474	396386	244	1.040936	2.53988384	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	355	1.5e-93	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g395092	i0	98.99	0.811475409836066	198	2	81	0	1	198	1474436	1474239	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	198	355	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
25851115	25851115	PRJNA737474f_S_NODE_24635_length_422_cov_2.573066_g23958_i0	PRJNA737474	24635	422	2.573066	10.85833852	Chloroflexota bacterium	2026724	Bacteria	Bacteria	65.8	5.22e-6	NTclustered	gi\|2891482054\|emb\|OZ219802.1\|	2026724	g23958	i0	100	252.971563981043	35	0	8	0	2	36	1275794	1275828	MAG: Chloroflexota bacterium isolate 50a8419b-8e17-430b-920a-11f3287aca29 genome assembly, chromosome: 2	blastn	106754	65.8	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
25854648	25854648	PRJNA737474g_S_NODE_121659_length_312_cov_0.882845_g120365_i0	PRJNA737474	121659	312	0.882845	2.7544764	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	132	3.64e-26	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g120365	i0	81.287	0.823717948717949	171	25	54	7	138	304	8558824	8558657	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	257	132	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26130268	26130268	PRJNA737474g_S_NODE_280989_length_257_cov_1.168478_g279695_i0	PRJNA737474	280989	257	1.168478	3.00298846	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	73.1	1.79e-8	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g279695	i0	92.157	2.49805447470817	51	4	33	0	140	190	11174753	11174703	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	642	73.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26131869	26131869	PRJNA737474g_S_NODE_393909_length_244_cov_1.526316_g392615_i0	PRJNA737474	393909	244	1.526316	3.72421104	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|269790643\|gb\|CP001826.1\|	525904	g392615	i0	97.541	1	244	6	100	0	1	244	440924	440681	Thermobaculum terrenum ATCC BAA-798 chromosome 2, complete sequence	blastn	244	418	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26253163	26253163	PRJNA737474d_S_NODE_14310_length_407_cov_2.110778_g13718_i0	PRJNA737474	14310	407	2.110778	8.59086646	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	296	1.63e-75	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g13718	i0	80.605	21.982800982801	397	65	96	11	14	404	861024	861414	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	8947	296	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26258189	26258189	PRJNA737474f_S_NODE_159238_length_263_cov_1.810526_g158560_i0	PRJNA737474	159238	263	1.810526	4.76168338	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	357	4.54e-94	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g158560	i0	97.156	0.802281368821293	211	6	80	0	1	211	21984	22194	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	211	357	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
26397016	26397016	PRJNA737474f_S_NODE_53927_length_334_cov_2.149425_g53249_i0	PRJNA737474	53927	334	2.149425	7.1790795	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	311	4.7000000000000005e-80	NTclustered	gi\|2874253788\|emb\|OY969772.1\|	1672391	g53249	i0	84.713	41.6287425149701	314	45	93	3	1	312	861233	861545	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.2.42 genome assembly, chromosome: 1	blastn	13904	311	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26531884	26531884	PRJNA737474f_S_NODE_279208_length_241_cov_18750.666667_g278530_i0	PRJNA737474	279208	241	18750.666667	45189.10666747	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	76.8	1.29e-9	NTclustered	gi\|2166239447\|dbj\|LC662861.1\|	2026734	g278530	i0	97.778	178.427385892116	45	0	18	1	155	198	5115	5159	Dehalococcoidia bacterium ARSSAG-00000218 DNA, putative prophage region, clone: 00000218_pp1	blastn	43001	76.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26533419	26533419	PRJNA737474f_S_NODE_61776_length_324_cov_0.892430_g61098_i0	PRJNA737474	61776	324	0.89243	2.8914732	Thermobaculum terrenum ATCC BAA-798	525904	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g61098	i0	100	1	324	0	100	0	1	324	747904	747581	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	324	599	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum

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