metadata: contig_metadata: 15 rows where bioproject = "PRJNA1164198" and tax

15 rows where bioproject = "PRJNA1164198" 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
4138797	4138797	PRJNA1164198_P_NODE_19304_length_282_cov_1.483254_g19035_i0	PRJNA1164198	19304	282	1.483254	4.18277628	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	324	4.99e-84	NTclustered	gi\|2874254066\|emb\|OY970149.1\|	1672391	g19035	i0	87.857	682.255319148936	280	28	98	6	4	279	566875	566598	MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1	blastn	192396	324	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
7417381	7417381	PRJNA1164198_P_NODE_1886_length_896_cov_1.591738_g1708_i0	PRJNA1164198	1886	896	1.591738	14.26197248	Chloroflexus	1107	Bacteria	Bacteria	778	0	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g1708	i0	84.635	526.6640625	794	108	88	14	86	876	432	1214	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	471891	784	0.99234693877551	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
9239853	9239853	PRJNA1164198_P_NODE_15908_length_310_cov_1.780591_g15639_i0	PRJNA1164198	15908	310	1.780591	5.5198321	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	71.3	7.99e-8	NTclustered	gi\|2621701384\|emb\|OY760104.1\|	2026734	g15639	i0	89.286	1.04193548387097	56	6	18	0	8	63	2421757	2421812	MAG: Dehalococcoidia bacterium isolate 85321599-0a94-4039-bbde-d148f9b3e6b5 genome assembly, chromosome: 1	blastn	323	71.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
21441476	21441476	PRJNA1164198_P_NODE_3797_length_646_cov_1.996510_g3551_i0	PRJNA1164198	3797	646	1.99651	12.8974546	Roseiflexus	120961	Bacteria	Bacteria	333	2.0500000000000006e-86	NTclustered	gi\|470482403\|ref\|NR_076530.1\|	120962	g3551	i0	78.442	58.0495356037152	552	89	83	26	62	599	1761	1226	Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence	blastn	37500	335	0.994029850746269	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
21988671	21988671	PRJNA1164198_P_NODE_12838_length_346_cov_1.135531_g12569_i0	PRJNA1164198	12838	346	1.135531	3.92893726	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	484	2.7199999999999994e-132	NTclustered	gi\|2874253812\|emb\|OY969796.1\|	1672391	g12569	i0	91.931	53.5924855491329	347	26	100	2	1	346	3034399	3034054	MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1	blastn	18543	484	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
22716410	22716410	PRJNA1164198_P_NODE_298_length_1918_cov_3.444444_g250_i0	PRJNA1164198	298	1918	3.444444	66.06443592	Herpetosiphon	64	Bacteria	Bacteria	3109	0	NTclustered	gi\|470482680\|ref\|NR_076546.1\|	65	g250	i0	95.95	84.3149113660063	1926	61	100	16	1	1918	18	1934	Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence	blastn	161716	3114	0.998394348105331	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Herpetosiphonales	Herpetosiphonaceae	Herpetosiphon	Herpetosiphon aurantiacus
26850763	26850763	PRJNA1164198_P_NODE_27221_length_248_cov_0.891429_g26952_i0	PRJNA1164198	27221	248	0.891429	2.21074392	Chloroflexota bacterium	2026724	Bacteria	Bacteria	87	2.55e-19	NR	MXY79866.1	2026724	g26952	i0	48.1	1.92338709677419	79	39	95.6	2	245	9	27	103	MXY79866.1 hypothetical protein [Chloroflexota bacterium]	diamond	477	87	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
26882384	26882384	PRJNA1164198_P_NODE_9681_length_400_cov_0.871560_g9414_i0	PRJNA1164198	9681	400	0.87156	3.48624	Chloroflexus sp. MS-CIW-1	3055768	Bacteria	Bacteria	44.3	0.0405	NR	MDN5272374.1	3055768	g9414	i0	28.1	0.72	96	57	63	2	6	257	60	155	MDN5272374.1 TrkA C-terminal domain-containing protein [Chloroflexus sp. MS-CIW-1]	diamond	288	44.3	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus sp. MS-CIW-1
29314149	29314149	PRJNA1164198_P_NODE_11009_length_375_cov_0.745033_g10741_i0	PRJNA1164198	11009	375	0.745033	2.79387375	Chloroflexota bacterium	2026724	Bacteria	Bacteria	44.3	0.0434	NR	NMD30575.1	2026724	g10741	i0	35.2	0.432	54	35	43.2	0	325	164	411	464	NMD30575.1 transporter [Chloroflexota bacterium]	diamond	162	44.3	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29471708	29471708	PRJNA1164198_P_NODE_6990_length_475_cov_1.430348_g6729_i0	PRJNA1164198	6990	475	1.430348	6.794153	Anaerolineales bacterium	2073117	Bacteria	Bacteria	73.6	8.68e-12	NR	MCA9992201.1	2073117	g6729	i0	34.6	0.966315789473684	153	94	95.4	3	1	453	1307	1455	MCA9992201.1 tandem-95 repeat protein [Anaerolineales bacterium]	diamond	459	73.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29692699	29692699	PRJNA1164198_P_NODE_28310_length_246_cov_0.901734_g28041_i0	PRJNA1164198	28310	246	0.901734	2.21826564	Caldilineaceae bacterium	2614250	Bacteria	Bacteria	117	2.84e-28	NR	MBX3014934.1	2614250	g28041	i0	78.5	1.9390243902439	79	17	96.3	0	242	6	920	998	MBX3014934.1 glycosyl hydrolase [Caldilineaceae bacterium]	diamond	477	117	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae		Caldilineaceae bacterium
29914280	29914280	PRJNA1164198_P_NODE_27331_length_248_cov_0.891429_g27062_i0	PRJNA1164198	27331	248	0.891429	2.21074392	Chloroflexota bacterium	2026724	Bacteria	Bacteria	98.6	2.95e-23	NR	MCL5995919.1	2026724	g27062	i0	63.4	0.991935483870968	82	30	99.2	0	247	2	138	219	MCL5995919.1 zinc metallopeptidase [Chloroflexota bacterium]	diamond	246	98.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29965019	29965019	PRJNA1164198_P_NODE_30771_length_242_cov_0.923077_g30502_i0	PRJNA1164198	30771	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	73.2	7.17e-13	NR	MBL1135783.1	2026724	g30502	i0	56.8	9.3099173553719	74	26	84.3	3	207	4	19	92	MBL1135783.1 hypothetical protein [Chloroflexota bacterium]	diamond	2253	73.2	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30912979	30912979	PRJNA1164198_P_NODE_23374_length_257_cov_1.250000_g23105_i0	PRJNA1164198	23374	257	1.25	3.2125	root	1	Root_unresolved	Root_unresolved	42.7	0.0118	NR	MEA1958913.1	2026724	g23105	i0	77.3	0.560311284046693	22	5	25.7	0	95	160	43	64	MEA1958913.1 LNR domain-containing protein [Chloroflexota bacterium]	diamond	144	42.7	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
32695641	32695641	PRJNA1164198_P_NODE_26420_length_249_cov_0.886364_g26151_i0	PRJNA1164198	26420	249	0.886364	2.20704636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.2	0.0448	NR	MCU0484310.1	2026724	g26151	i0	34.4	0.734939759036145	61	28	59	2	243	97	23	83	MCU0484310.1 hypothetical protein [Chloroflexota bacterium]	diamond	183	41.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);;