metadata: contig_metadata: 17 rows where bioproject = "PRJNA807685", tax_kingdom = "Bacillati" and tax

17 rows where bioproject = "PRJNA807685", tax_kingdom = "Bacillati" 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
3357398	3357398	PRJNA807685_P_NODE_24123_length_273_cov_1.788136_g23050_i0	PRJNA807685	24123	273	1.788136	4.88161128	PVC group	1783257	Bacteria	Bacteria	99.8	4.75e-22	NR	WP_066782956.1	1707952	g23050	i0	65.3	3.2967032967033	75	26	82.4	0	2	226	474	548	WP_066782956.1 heavy metal translocating P-type ATPase [Chloroflexus islandicus]	diamond	900	100	0.998	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus islandicus
12286009	12286009	PRJNA807685_P_NODE_40850_length_192_cov_1.477419_g39777_i0	PRJNA807685	40850	192	1.477419	2.83664448	Herpetosiphonaceae bacterium	2720503	Bacteria	Bacteria	114	3.74e-28	NR	HZG67231.1	2720503	g39777	i0	91.7	2.84375	60	5	93.8	0	181	2	154	213	HZG67231.1 RelA/SpoT family protein [Herpetosiphonaceae bacterium]	diamond	546	114	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae		Herpetosiphonaceae bacterium
16525558	16525558	PRJNA807685_P_NODE_27953_length_246_cov_1.818182_g26880_i0	PRJNA807685	27953	246	1.818182	4.47272772	Anaerolineae bacterium	2052143	Bacteria	Bacteria	80.5	1.96e-15	NR	MCB0211493.1	2052143	g26880	i0	43.9	3.70731707317073	82	42	95.1	1	11	244	132	213	MCB0211493.1 N-acetylmuramoyl-L-alanine amidase [Anaerolineae bacterium]	diamond	912	80.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
22483599	22483599	PRJNA807685_P_NODE_61018_length_157_cov_1.558333_g59945_i0	PRJNA807685	61018	157	1.558333	2.44658281	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	174	2.65e-39	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g59945	i0	86.792	83.7324840764331	159	17	100	3	1	157	2784561	2784405	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	13146	174	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
27465147	27465147	PRJNA807685_P_NODE_53363_length_167_cov_1.507692_g52290_i0	PRJNA807685	53363	167	1.507692	2.51784564	Anaerolineae bacterium	2052143	Bacteria	Bacteria	91.3	1.06e-19	NR	MCL6509816.1	2052143	g52290	i0	78.2	0.988023952095808	55	11	98.8	1	1	165	488	541	MCL6509816.1 conjugal transfer protein TrbE [Anaerolineae bacterium]	diamond	165	91.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27906769	27906769	PRJNA807685_P_NODE_41765_length_190_cov_1.019608_g40692_i0	PRJNA807685	41765	190	1.019608	1.9372552	Chloroflexota bacterium	2026724	Bacteria	Bacteria	78.2	1.96e-16	NR	MBT9158937.1	2026724	g40692	i0	72.5	0.805263157894737	51	11	75.8	1	150	7	98	148	MBT9158937.1 hypothetical protein [Chloroflexota bacterium]	diamond	153	78.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
28222583	28222583	PRJNA807685_P_NODE_16546_length_363_cov_1.309816_g15476_i0	PRJNA807685	16546	363	1.309816	4.75463208	Chloroflexaceae bacterium	2562117	Bacteria	Bacteria	67.4	3.12e-10	NR	MCS6882386.1	2562117	g15476	i0	37.3	1.81818181818182	110	69	90.9	0	362	33	240	349	MCS6882386.1 DUF4397 domain-containing protein [Chloroflexaceae bacterium]	diamond	660	67.4	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae		Chloroflexaceae bacterium
28917151	28917151	PRJNA807685_P_NODE_26828_length_253_cov_1.972222_g25755_i0	PRJNA807685	26828	253	1.972222	4.98972166	Anaerolineae bacterium	2052143	Bacteria	Bacteria	104	6.81e-25	NR	MCL6509822.1	2052143	g25755	i0	64.6	0.972332015810277	82	26	97.2	1	7	252	3	81	MCL6509822.1 zeta toxin family protein [Anaerolineae bacterium]	diamond	246	104	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29170140	29170140	PRJNA807685_P_NODE_7049_length_711_cov_2.151335_g6116_i0	PRJNA807685	7049	711	2.151335	15.29599185	Anaerolineae bacterium	2052143	Bacteria	Bacteria	249	6.89e-79	NR	MCL6509847.1	2052143	g6116	i0	78.1	1.23206751054852	146	32	61.6	0	272	709	48	193	MCL6509847.1 replication initiator protein A [Anaerolineae bacterium]	diamond	876	249	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29833043	29833043	PRJNA807685_P_NODE_22771_length_285_cov_1.165323_g21698_i0	PRJNA807685	22771	285	1.165323	3.32117055	Anaerolineae bacterium	2052143	Bacteria	Bacteria	54.3	2.52e-6	NR	MCL6509849.1	2052143	g21698	i0	65.8	0.4	38	13	40	0	266	153	165	202	MCL6509849.1 hypothetical protein [Anaerolineae bacterium]	diamond	114	54.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30275628	30275628	PRJNA807685_P_NODE_49232_length_174_cov_1.408759_g48159_i0	PRJNA807685	49232	174	1.408759	2.45124066	Anaerolineae bacterium	2052143	Bacteria	Bacteria	85.1	1.66e-17	NR	MCL6509813.1	2052143	g48159	i0	81	3	58	11	100	0	1	174	154	211	MCL6509813.1 P-type conjugative transfer protein TrbL [Anaerolineae bacterium]	diamond	522	85.1	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30370592	30370592	PRJNA807685_P_NODE_33312_length_218_cov_1.325967_g32239_i0	PRJNA807685	33312	218	1.325967	2.89060806	Kouleothrix sp.	2779161	Bacteria	Bacteria	53.1	2.15e-6	NR	HNP72177.1	2779161	g32239	i0	57.1	0.577981651376147	42	18	57.8	0	2	127	130	171	HNP72177.1 hypothetical protein [Kouleothrix sp.]	diamond	126	53.1	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Kouleothrix	Kouleothrix sp.
30465281	30465281	PRJNA807685_P_NODE_53693_length_167_cov_0.892308_g52620_i0	PRJNA807685	53693	167	0.892308	1.49015436	Chloroflexota bacterium	2026724	Bacteria	Bacteria	90.1	1.65e-19	NR	MDQ2674999.1	2026724	g52620	i0	85.5	0.988023952095808	55	8	98.8	0	167	3	283	337	MDQ2674999.1 glycosyltransferase family 4 protein [Chloroflexota bacterium]	diamond	165	90.1	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31318087	31318087	PRJNA807685_P_NODE_33555_length_217_cov_1.283333_g32482_i0	PRJNA807685	33555	217	1.283333	2.78483261	Chloroflexota bacterium	2026724	Bacteria	Bacteria	42	0.0403	NR	MCL5951753.1	2026724	g32482	i0	38	0.691244239631336	50	29	67.7	2	181	35	121	169	MCL5951753.1 glycerol-3-phosphate acyltransferase [Chloroflexota bacterium]	diamond	150	42	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31318092	31318092	PRJNA807685_P_NODE_54335_length_166_cov_1.023256_g53262_i0	PRJNA807685	54335	166	1.023256	1.69860496	Anaerolineae bacterium	2052143	Bacteria	Bacteria	87.8	1.08e-18	NR	MCL6509837.1	2052143	g53262	i0	76.4	0.993975903614458	55	13	99.4	0	165	1	43	97	MCL6509837.1 hypothetical protein [Anaerolineae bacterium]	diamond	165	87.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31516970	31516970	PRJNA807685_P_NODE_13836_length_415_cov_1.783069_g12774_i0	PRJNA807685	13836	415	1.783069	7.39973635	Bacillati	1783272	Bacteria	Bacteria	201	2.13e-58	NR	MCZ2108426.1	2026734	g12774	i0	94.7	1.63373493975904	113	6	81.7	0	77	415	315	427	MCZ2108426.1 MMPL family transporter [Dehalococcoidia bacterium]	diamond	678	201	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32898171	32898171	PRJNA807685_P_NODE_27980_length_246_cov_1.483254_g26907_i0	PRJNA807685	27980	246	1.483254	3.64880484	Anaerolineae bacterium	2052143	Bacteria	Bacteria	45.8	0.00313	NR	MCC7452295.1	2052143	g26907	i0	35.1	0.939024390243902	77	48	91.5	1	22	246	118	194	MCC7452295.1 O-antigen ligase family protein [Anaerolineae bacterium]	diamond	231	45.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;