metadata: contig_metadata: 18 rows where bioproject = "PRJEB7799" and tax

18 rows where bioproject = "PRJEB7799" 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
25527162	25527162	PRJEB7799g_S_NODE_5513_length_178_cov_1.643357_g5297_i0	PRJEB7799	5513	178	1.643357	2.92517546	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	291	2.93e-74	NTclustered	gi\|146430043\|gb\|EF220859.1\|	166587	g5297	i0	96.067	97.4719101123596	178	7	100	0	1	178	699	522	Uncultured Chloroflexi bacterium clone F08_MO02 16S ribosomal RNA gene, partial sequence	blastn	17350	291	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
25527526	25527526	PRJEB7799j_S_NODE_3097_length_170_cov_2.666667_g3092_i0	PRJEB7799	3097	170	2.666667	4.5333339	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	172	1.0499999999999999e-38	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g3092	i0	89.63	8.38235294117647	135	14	79	0	36	170	3495623	3495757	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	1425	172	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
25662174	25662174	PRJEB7799a_S_NODE_410_length_495_cov_18.313043_g375_i0	PRJEB7799	410	495	18.313043	90.64956285	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	333	1.54e-86	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g375	i0	79.83	107.925252525253	471	84	94	11	31	495	3494859	3494394	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	53423	333	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
25664480	25664480	PRJEB7799n_S_NODE_634_length_488_cov_19.181015_g599_i0	PRJEB7799	634	488	19.181015	93.6033532	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	331	5.46e-86	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g599	i0	79.785	112.071721311475	465	86	94	8	22	481	3494413	3494874	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	54691	331	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
25798638	25798638	PRJEB7799c_S_NODE_1419_length_292_cov_3.225681_g1396_i0	PRJEB7799	1419	292	3.225681	9.41898852	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	147	1.21e-30	NTclustered	gi\|374855139\|dbj\|AP011791.1\|	166587	g1396	i0	76.645	34.6472602739726	304	47	98	17	3	287	8071	7773	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06	blastn	10117	147	1	Bacteria		Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
25936570	25936570	PRJEB7799m_S_NODE_444_length_252_cov_4.308756_g439_i0	PRJEB7799	444	252	4.308756	10.85806512	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	180	1e-40	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g439	i0	80.162	26.8650793650794	247	44	97	5	1	244	3494615	3494859	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	6770	180	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
26207061	26207061	PRJEB7799b_S_NODE_270_length_221_cov_5.150538_g269_i0	PRJEB7799	270	221	5.150538	11.38268898	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	161	3.1199999999999995e-35	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g269	i0	89.683	42.9864253393665	126	13	57	0	96	221	2065108	2065233	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	9500	161	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26343365	26343365	PRJEB7799f_S_NODE_1119_length_241_cov_6.480583_g1103_i0	PRJEB7799	1119	241	6.480583	15.61820503	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	165	2.67e-36	NTclustered	gi\|2874253882\|emb\|OY969938.1\|	1672391	g1103	i0	87.162	40.4813278008299	148	16	61	1	1	148	2065252	2065108	MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1	blastn	9756	165	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
26343909	26343909	PRJEB7799j_S_NODE_15_length_551_cov_23.691860_g14_i0	PRJEB7799	15	551	23.69186	130.5421486	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	398	6.049999999999997e-106	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g14	i0	80.529	96.6769509981851	529	94	95	9	28	551	3494379	3494903	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	53269	398	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
26343920	26343920	PRJEB7799k_S_NODE_47_length_472_cov_6.894737_g42_i0	PRJEB7799	47	472	6.894737	32.54315864	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	339	3.1499999999999997e-88	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g42	i0	80	112.040254237288	470	85	99	9	8	472	3494859	3494394	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	52883	339	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
26478786	26478786	PRJEB7799a_S_NODE_2952_length_267_cov_1.952586_g2917_i0	PRJEB7799	2952	267	1.952586	5.21340462	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	263	1.04e-65	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2917	i0	85.019	305.943820224719	267	31	100	5	1	267	3495763	3495506	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	81687	263	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
26480452	26480452	PRJEB7799l_S_NODE_2272_length_287_cov_2.587302_g2243_i0	PRJEB7799	2272	287	2.587302	7.42555674	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	219	2.47e-52	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g2243	i0	81.387	67.8432055749129	274	46	94	5	10	280	3494859	3494588	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	19471	219	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
32947589	32947589	PRJEB7799l_S_NODE_13834_length_154_cov_0.991597_g13805_i0	PRJEB7799	13834	154	0.991597	1.52705938	Chloroflexota bacterium	2026724	Bacteria	Bacteria	80.1	7.48e-16	NR	MEK7216931.1	2026724	g13805	i0	66.7	0.993506493506494	51	17	99.4	0	153	1	261	311	MEK7216931.1 SNF2-related protein [Chloroflexota bacterium]	diamond	153	80.1	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
32957655	32957655	PRJEB7799p_S_NODE_23578_length_156_cov_1.983471_g23555_i0	PRJEB7799	23578	156	1.983471	3.09421476	Bacteria	2	Bacteria	Bacteria	43.1	0.00353	NR	HIB35690.1	2026734	g23555	i0	52.6	8.80769230769231	38	18	73.1	0	156	43	91	128	HIB35690.1 30S ribosomal protein S13 [Dehalococcoidia bacterium]	diamond	1374	43.5	0.990804597701149	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32965390	32965390	PRJEB7799p_S_NODE_9682_length_194_cov_2.408805_g9659_i0	PRJEB7799	9682	194	2.408805	4.6730817	Herpetosiphon sp.	71864	Bacteria	Bacteria	107	9.17e-26	NR	WP_012189631.1	71864	g9659	i0	79.7	2.96907216494845	64	13	99	0	194	3	186	249	WP_012189631.1 diaminobutyrate--2-oxoglutarate transaminase [Herpetosiphon sp.]	diamond	576	107	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon sp.
32974694	32974694	PRJEB7799i_S_NODE_1066_length_448_cov_2.786925_g1036_i0	PRJEB7799	1066	448	2.786925	12.485424	PVC group	1783257	Bacteria	Bacteria	107	1.26e-23	NR	MCY3567538.1	2026724	g1036	i0	40.9	2.53794642857143	127	74	84.4	1	416	39	1099	1225	MCY3567538.1 AAA domain-containing protein [Chloroflexota bacterium]	diamond	1137	107	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
33066688	33066688	PRJEB7799i_S_NODE_10741_length_154_cov_2.184874_g10711_i0	PRJEB7799	10741	154	2.184874	3.36470596	Chloroflexota bacterium	2026724	Bacteria	Bacteria	76.6	6.2e-15	NR	MFC2041930.1	2026724	g10711	i0	82.6	1.81168831168831	46	8	89.6	0	14	151	109	154	MFC2041930.1 DNA adenine methylase [Chloroflexota bacterium]	diamond	279	76.6	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
33162171	33162171	PRJEB7799i_S_NODE_3928_length_232_cov_1.477157_g3898_i0	PRJEB7799	3928	232	1.477157	3.42700424	Bacteria	2	Bacteria	Bacteria	58.2	1.17e-7	NR	MEI8334807.1	2026724	g3898	i0	48.7	3.45258620689655	76	34	98.3	1	5	232	167	237	MEI8334807.1 IS1182 family transposase [Chloroflexota bacterium]	diamond	801	58.2	1	Bacteria		Bacillati	Chloroflexota					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);;