metadata: contig_metadata: 11 rows where bioproject = "PRJNA597223" and tax

11 rows where bioproject = "PRJNA597223" 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
3119945	3119945	PRJNA597223_P_NODE_26883_length_297_cov_3.095420_g25037_i0	PRJNA597223	26883	297	3.09542	9.1933974	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	134	9.58e-27	NTclustered	gi\|2893358382\|emb\|OZ220676.1\|	2614250	g25037	i0	91.753	20.5454545454545	97	6	32	2	27	122	358022	357927	MAG: Caldilineaceae bacterium isolate 6911f4b3-f793-4dac-9473-b80504ec0e1d genome assembly, chromosome: 1	blastn	6102	134	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
5673119	5673119	PRJNA597223_P_NODE_65065_length_179_cov_1.666667_g63219_i0	PRJNA597223	65065	179	1.666667	2.98333393	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	230	6.529999999999999e-56	NTclustered	gi\|2874253860\|emb\|OY969916.1\|	1672391	g63219	i0	91.617	16.4134078212291	167	12	93	2	1	166	275774	275939	MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1	blastn	2938	230	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
6947051	6947051	PRJNA597223_P_NODE_14126_length_449_cov_4.120773_g12346_i0	PRJNA597223	14126	449	4.120773	18.50227077	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	355	2.96e-93	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g12346	i0	81.25	76.4432071269488	448	76	99	8	1	443	3496109	3495665	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	34323	355	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
8222763	8222763	PRJNA597223_P_NODE_80347_length_157_cov_2.172131_g78501_i0	PRJNA597223	80347	157	2.172131	3.41024567	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	1.61e-31	NTclustered	gi\|2874253704\|emb\|OY969431.1\|	1672391	g78501	i0	84.177	55.2165605095541	158	20	99	3	3	157	64494	64649	MAG: uncultured Chloroflexia bacterium isolate MFD02979.bin.c.2 genome assembly, chromosome: 1	blastn	8669	148	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
15168965	15168965	PRJNA597223_P_NODE_73932_length_165_cov_1.792308_g72086_i0	PRJNA597223	73932	165	1.792308	2.9573082	Caldilinea	233191	Bacteria	Bacteria	198	1.67e-46	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g72086	i0	89.024	131.581818181818	164	12	99	3	2	165	539	696	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	21711	198	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
17718564	17718564	PRJNA597223_P_NODE_49654_length_198_cov_2.202454_g47808_i0	PRJNA597223	49654	198	2.202454	4.36085892	Bacteria	2	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2320774688\|gb\|CP075527.1\|	2073117	g47808	i0	94.286	0.353535353535354	35	2	18	0	28	62	897913	897879	MAG: Anaerolineales bacterium isolate TGS_CHL4 chromosome	blastn	70	54.7	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
18992028	18992028	PRJNA597223_P_NODE_20355_length_358_cov_2.888545_g18521_i0	PRJNA597223	20355	358	2.888545	10.3409911	Caldilinea	233191	Bacteria	Bacteria	351	2.99e-92	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g18521	i0	85.549	176.466480446927	346	37	96	4	5	348	1570	1236	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	63175	351	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
21542731	21542731	PRJNA597223_P_NODE_82917_length_154_cov_3.773109_g81071_i0	PRJNA597223	82917	154	3.773109	5.81058786	Chloroflexus	1107	Bacteria	Bacteria	87.9	3.46e-13	NTclustered	gi\|470483916\|ref\|NR_076619.1\|	152260	g81071	i0	85.227	6.62987012987013	88	9	56	4	28	114	1313	1229	Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence	blastn	1021	87.9	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aggregans
24092710	24092710	PRJNA597223_P_NODE_53139_length_191_cov_1.788462_g51293_i0	PRJNA597223	53139	191	1.788462	3.41596242	Caldilinea	233191	Bacteria	Bacteria	91.6	3.48e-14	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g51293	i0	77.143	3.18848167539267	175	29	86	10	3	167	494	321	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	609	91.6	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
26636596	26636596	PRJNA597223_P_NODE_57421_length_187_cov_1.052632_g55575_i0	PRJNA597223	57421	187	1.052632	1.96842184	Chloroflexota bacterium	2026724	Bacteria	Bacteria	62.4	1.4e-10	NR	MEX0629275.1	2026724	g55575	i0	55.7	1.9572192513369	61	27	97.9	0	3	185	19	79	MEX0629275.1 CopG family transcriptional regulator [Chloroflexota bacterium]	diamond	366	62.4	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27048280	27048280	PRJNA597223_P_NODE_73862_length_165_cov_1.992308_g72016_i0	PRJNA597223	73862	165	1.992308	3.2873082	Candidatus Ribeiella danica	3140698	Bacteria	Bacteria	85.5	1.09e-17	NR	MBK9714445.1	3140698	g72016	i0	71.7	6.74545454545455	53	15	96.4	0	160	2	76	128	MBK9714445.1 flotillin family protein [Candidatus Ribeiella danica]	diamond	1113	85.5	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Candidatus Ribeiella	Candidatus Ribeiella danica

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