metadata: contig_metadata: 15 rows where bioproject = "PRJNA700095", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA700095", 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
11387774	11387774	PRJNA700095_P_NODE_42869_length_269_cov_1.010204_g41605_i0	PRJNA700095	42869	269	1.010204	2.71744876	Caldilinea	233191	Bacteria	Bacteria	115	3.1e-21	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g41605	i0	80.795	60.2379182156134	151	26	55	3	105	253	918	769	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	16204	115	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
22360298	22360298	PRJNA700095_P_NODE_20698_length_387_cov_1.289809_g19435_i0	PRJNA700095	20698	387	1.289809	4.99156083	Anaerolineae bacterium	2052143	Bacteria	Bacteria	210	1.51e-60	NR	MCB0208079.1	2052143	g19435	i0	77.3	11.906976744186	128	29	99.2	0	386	3	143	270	MCB0208079.1 valine--tRNA ligase [Anaerolineae bacterium]	diamond	4608	210	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
26967314	26967314	PRJNA700095_P_NODE_68542_length_229_cov_4.000000_g67277_i0	PRJNA700095	68542	229	4	9.16	Ktedonobacterales	388448	Bacteria	Bacteria	78.6	7.55e-15	NR	WP_126552552.1	2014872	g67277	i0	58.3	3.82532751091703	72	26	94.3	3	1	216	499	566	WP_126552552.1 hypothetical protein [Dictyobacter kobayashii]	diamond	876	78.6	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter kobayashii
27683338	27683338	PRJNA700095_P_NODE_43964_length_266_cov_1.569948_g42700_i0	PRJNA700095	43964	266	1.569948	4.17606168	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	61.2	9.06e-9	NR	RPJ63373.1	2026734	g42700	i0	38.8	1.73684210526316	85	49	94.7	2	256	5	12	94	RPJ63373.1 MAG: alpha/beta fold hydrolase, partial [Dehalococcoidia bacterium]	diamond	462	61.2	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27903768	27903768	PRJNA700095_P_NODE_32865_length_297_cov_2.812500_g31601_i0	PRJNA700095	32865	297	2.8125	8.353125	Anaerolineales bacterium	2073117	Bacteria	Bacteria	70.9	9.05e-12	NR	HND47413.1	2073117	g31601	i0	40.7	0.919191919191919	91	52	90.9	2	3	272	379	468	HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium]	diamond	273	70.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
28061802	28061802	PRJNA700095_P_NODE_45765_length_262_cov_1.603175_g44501_i0	PRJNA700095	45765	262	1.603175	4.2003185	uncultured Ardenticatena sp.	1771905	Bacteria	Bacteria	43.9	0.0161	NR	QOZ05507.1	1771905	g44501	i0	33.3	2.20992366412214	63	39	72.1	1	67	255	9	68	QOZ05507.1 NosZ, partial [uncultured Ardenticatena sp.]	diamond	579	43.9	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Ardenticatenales	Ardenticatenaceae	Ardenticatena	uncultured Ardenticatena sp.
28125022	28125022	PRJNA700095_P_NODE_23685_length_355_cov_2.507092_g22421_i0	PRJNA700095	23685	355	2.507092	8.9001766	Dictyobacter kobayashii	2014872	Bacteria	Bacteria	57	1.36e-6	NR	WP_126552552.1	2014872	g22421	i0	32	1.57183098591549	103	63	87	2	46	354	120	215	WP_126552552.1 hypothetical protein [Dictyobacter kobayashii]	diamond	558	57	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter kobayashii
28787860	28787860	PRJNA700095_P_NODE_107_length_3663_cov_5.594708_g53_i0	PRJNA700095	107	3663	5.594708	204.93415404	Anaerolineales bacterium	2073117	Bacteria	Bacteria	352	1.41e-103	NR	HND47413.1	2073117	g53	i0	38.5	0.435708435708436	532	313	42.6	10	1889	3448	99	628	HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium]	diamond	1596	352	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29514097	29514097	PRJNA700095_P_NODE_31710_length_303_cov_3.630435_g30446_i0	PRJNA700095	31710	303	3.630435	11.00021805	Chloroflexota bacterium	2026724	Bacteria	Bacteria	73.9	1.91e-13	NR	NCF64494.1	2026724	g30446	i0	56.9	4.43564356435644	65	27	64.4	1	106	300	1	64	NCF64494.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium]	diamond	1344	73.9	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
29734990	29734990	PRJNA700095_P_NODE_32710_length_298_cov_2.031111_g31446_i0	PRJNA700095	32710	298	2.031111	6.05271078	Anaerolineae bacterium	2052143	Bacteria	Bacteria	118	2.6499999999999996e-31	NR	PWH17893.1	2052143	g31446	i0	62	2.80872483221477	100	36	98.7	2	4	297	3	102	PWH17893.1 MAG: hypothetical protein DDG59_07215 [Anaerolineae bacterium]	diamond	837	118	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29956357	29956357	PRJNA700095_P_NODE_23591_length_356_cov_1.579505_g22327_i0	PRJNA700095	23591	356	1.579505	5.6230378	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	70.9	1.41e-11	NR	MBI1278418.1	2024896	g22327	i0	52.7	1.41573033707865	55	26	46.3	0	173	337	1	55	MBI1278418.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Anaerolineaceae bacterium]	diamond	504	70.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae		Anaerolineaceae bacterium
30125298	30125298	PRJNA700095_P_NODE_22352_length_368_cov_4.006780_g21088_i0	PRJNA700095	22352	368	4.00678	14.7449504	Bacteria	2	Bacteria	Bacteria	140	2.1499999999999993e-40	NR	RMF38973.1	2026724	g21088	i0	59.7	12.741847826087	119	48	97	0	357	1	4	122	RMF38973.1 MAG: RidA family protein [Chloroflexota bacterium]	diamond	4689	141	0.99290780141844	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30188616	30188616	PRJNA700095_P_NODE_44872_length_264_cov_1.602094_g43608_i0	PRJNA700095	44872	264	1.602094	4.22952816	root	1	Root_unresolved	Root_unresolved	113	2.3e-29	NR	OQA99668.1	1852858	g43608	i0	68.2	3	85	27	96.6	0	3	257	5	89	OQA99668.1 MAG: Chaperone protein YajL [Chloroflexi bacterium ADurb.Bin222]	diamond	792	114	0.991228070175439	Bacteria	Bacillati	Chloroflexota					Chloroflexi bacterium ADurb.Bin222
32674720	32674720	PRJNA700095_P_NODE_1040_length_1692_cov_4.263125_g679_i0	PRJNA700095	1040	1692	4.263125	72.132075	Anaerolineales bacterium	2073117	Bacteria	Bacteria	139	1.48e-30	NR	HND47414.1	2073117	g679	i0	37.6	0.386524822695035	218	131	38.5	4	1171	521	22	235	HND47414.1 hypothetical protein [Anaerolineales bacterium]	diamond	654	139	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32843376	32843376	PRJNA700095_P_NODE_55140_length_248_cov_0.880000_g53876_i0	PRJNA700095	55140	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	90.9	4.43e-20	NR	WP_007916255.1	363277	g53876	i0	63.3	4.72983870967742	79	29	95.6	0	246	10	19	97	WP_007916255.1 glucose 1-dehydrogenase [Ktedonobacter racemifer]	diamond	1173	90.9	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacter	Ktedonobacter racemifer

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