metadata: contig_metadata: 9 rows where bioproject = "PRJDB12134" and tax

9 rows where bioproject = "PRJDB12134" 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
74	74	PRJDB12134_P_NODE_1_length_13118_cov_3.495745_g0_i0	PRJDB12134	1	13118	3.495745	458.5718291	Anaerolineae bacterium	2052143	Bacteria	Bacteria	375	1.07e-113	NR	MCL6509847.1	2052143	g0	i0	70.4	0.112974538801647	247	72	5.6	1	4396	5136	48	293	MCL6509847.1 replication initiator protein A [Anaerolineae bacterium]	diamond	1482	375	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
1274310	1274310	PRJDB12134_P_NODE_2_length_10017_cov_3.492257_g0_i1	PRJDB12134	2	10017	3.492257	349.81938369	Anaerolineae bacterium	2052143	Bacteria	Bacteria	375	8.03e-114	NR	MCL6509847.1	2052143	g0	i1	70.4	0.147948487571129	247	72	7.4	1	8723	7983	48	293	MCL6509847.1 replication initiator protein A [Anaerolineae bacterium]	diamond	1482	375	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
3826327	3826327	PRJDB12134_P_NODE_9364_length_301_cov_1.697368_g9229_i0	PRJDB12134	9364	301	1.697368	5.10907768	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	359	1.4699999999999998e-94	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g9229	i0	88.158	180.06976744186	304	32	100	4	1	301	598117	598419	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	54201	359	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
6378382	6378382	PRJDB12134_P_NODE_1766_length_827_cov_2.797082_g1657_i0	PRJDB12134	1766	827	2.797082	23.13186814	Anaerolineae bacterium	2052143	Bacteria	Bacteria	247	3.59e-78	NR	MCL6509815.1	2052143	g1657	i0	63.2	0.896009673518742	247	84	89.6	1	744	4	7	246	MCL6509815.1 P-type conjugative transfer protein TrbJ [Anaerolineae bacterium]	diamond	741	247	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
10203077	10203077	PRJDB12134_P_NODE_9_length_5412_cov_2.811950_g5_i0	PRJDB12134	9	5412	2.81195	152.182734	Anaerolineae bacterium	2052143	Bacteria	Bacteria	419	5.05e-129	NR	MCL6509811.1	2052143	g5	i0	72.6	0.155764966740576	281	75	15.5	2	1674	2513	77	356	MCL6509811.1 P-type conjugative transfer protein TrbG [Anaerolineae bacterium]	diamond	843	419	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
11183953	11183953	PRJDB12134_P_NODE_6409_length_402_cov_1.355623_g6274_i0	PRJDB12134	6409	402	1.355623	5.44960446	Caldilineaceae	475964	Bacteria	Bacteria	536	8.729999999999998e-148	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g6274	i0	90.796	55.1616915422886	402	35	100	2	1	402	1282	1681	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	22175	536	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
12753550	12753550	PRJDB12134_P_NODE_13611_length_246_cov_0.901734_g13476_i0	PRJDB12134	13611	246	0.901734	2.21826564	Candidatus Promineifilum breve	1806508	Bacteria	Bacteria	278	3.37e-70	NTclustered	gi\|1041165931\|emb\|LN890655.2\|	1806508	g13476	i0	87.5	50.2032520325203	240	30	98	0	2	241	597679	597440	Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I	blastn	12350	278	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae	Candidatus Promineifilum	Candidatus Promineifilum breve
24225889	24225889	PRJDB12134_P_NODE_13600_length_246_cov_0.901734_g13465_i0	PRJDB12134	13600	246	0.901734	2.21826564	Chloroflexus aurantiacus	1108	Bacteria	Bacteria	152	2.13e-32	NTclustered	gi\|163666892\|gb\|CP000909.1\|	324602	g13465	i0	86.62	37.3983739837398	142	14	57	5	51	190	4903187	4903325	Chloroflexus aurantiacus J-10-fl, complete genome	blastn	9200	152	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
30032482	30032482	PRJDB12134_P_NODE_13771_length_245_cov_0.906977_g13636_i0	PRJDB12134	13771	245	0.906977	2.22209365	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	78.6	5.48e-15	NR	MFN8464591.1	2614250	g13636	i0	56.3	0.979591836734694	80	26	86.9	1	9	221	38	117	MFN8464591.1 hypothetical protein [Caldilineaceae bacterium]	diamond	240	78.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae 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);;