metadata: contig_metadata: 14 rows where bioproject = "PRJNA835051" and tax

14 rows where bioproject = "PRJNA835051" 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
9754080	9754080	PRJNA835051_S_NODE_43228_length_226_cov_3.087432_g42932_i0	PRJNA835051	43228	226	3.087432	6.97759632	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	62.1	3.34e-5	NTclustered	gi\|2621704111\|emb\|OY761558.1\|	2026734	g42932	i0	100	0.146017699115044	33	0	15	0	1	33	1661584	1661616	MAG: Dehalococcoidia bacterium isolate 6ae818db-717c-4d07-8374-be93c3d6d717 genome assembly, chromosome: 1	blastn	33	62.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
25052005	25052005	PRJNA835051_S_NODE_22260_length_269_cov_2.871681_g21964_i0	PRJNA835051	22260	269	2.871681	7.72482189	Dehalogenimonas sp. WBC-2	943347	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|819627869\|gb\|CP011392.1\|	943347	g21964	i0	100	0.104089219330855	28	0	10	0	228	255	920575	920602	Dehalogenimonas sp. WBC-2, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas sp. WBC-2
27528543	27528543	PRJNA835051_S_NODE_73223_length_191_cov_0.972973_g72927_i0	PRJNA835051	73223	191	0.972973	1.85837843	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.6	0.0478	NR	MEA2619237.1	2026724	g72927	i0	36.5	0.816753926701571	52	24	67.5	2	24	152	330	381	MEA2619237.1 hypothetical protein [Chloroflexota bacterium]	diamond	156	41.6	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
27781304	27781304	PRJNA835051_S_NODE_41084_length_230_cov_1.213904_g40788_i0	PRJNA835051	41084	230	1.213904	2.7919792	Anaerolineae bacterium	2052143	Bacteria	Bacteria	86.3	1.13e-17	NR	MCL4298796.1	2052143	g40788	i0	62.2	0.965217391304348	74	22	96.5	2	228	7	228	295	MCL4298796.1 HNH endonuclease [Anaerolineae bacterium]	diamond	222	86.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
27907224	27907224	PRJNA835051_S_NODE_76445_length_188_cov_1.234483_g76149_i0	PRJNA835051	76445	188	1.234483	2.32082804	Reticulibacter mediterranei	2778369	Bacteria	Bacteria	40	0.0431	NR	WP_220201452.1	2778369	g76149	i0	41.2	0.542553191489362	34	20	54.3	0	139	38	8	41	WP_220201452.1 hypothetical protein [Reticulibacter mediterranei]	diamond	102	40	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Reticulibacteraceae	Reticulibacter	Reticulibacter mediterranei
28412753	28412753	PRJNA835051_S_NODE_86866_length_179_cov_1.411765_g86570_i0	PRJNA835051	86866	179	1.411765	2.52705935	Anaerolineae bacterium	2052143	Bacteria	Bacteria	41.6	0.041	NR	HOT93314.1	2052143	g86570	i0	45.5	0.921787709497207	55	26	88.8	2	168	10	200	252	HOT93314.1 hypothetical protein [Anaerolineae bacterium]	diamond	165	41.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29202148	29202148	PRJNA835051_S_NODE_32289_length_245_cov_2.356436_g31993_i0	PRJNA835051	32289	245	2.356436	5.7732682	Reticulibacter mediterranei	2778369	Bacteria	Bacteria	40.4	0.0335	NR	WP_220208556.1	2778369	g31993	i0	40.4	0.575510204081633	47	28	57.6	0	215	75	8	54	WP_220208556.1 hypothetical protein [Reticulibacter mediterranei]	diamond	141	40.4	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Reticulibacteraceae	Reticulibacter	Reticulibacter mediterranei
30149223	30149223	PRJNA835051_S_NODE_112152_length_161_cov_1.720339_g111856_i0	PRJNA835051	112152	161	1.720339	2.76974579	Ardenticatenia bacterium	2099665	Bacteria	Bacteria	42	0.0221	NR	MDQ7030139.1	2099665	g111856	i0	47.7	0.819875776397516	44	20	76.4	1	157	35	122	165	MDQ7030139.1 polyprenol monophosphomannose synthase [Ardenticatenia bacterium]	diamond	132	42	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia				Ardenticatenia bacterium
30180933	30180933	PRJNA835051_S_NODE_51772_length_214_cov_2.520468_g51476_i0	PRJNA835051	51772	214	2.520468	5.39380152	Chloroflexota bacterium	2026724	Bacteria	Bacteria	48.5	1.1e-4	NR	MBM26495.1	2026724	g51476	i0	57.4	0.658878504672897	47	18	65.9	1	177	37	85	129	MBM26495.1 hypothetical protein [Chloroflexota bacterium]	diamond	141	48.5	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
31698113	31698113	PRJNA835051_S_NODE_124257_length_154_cov_1.477477_g123961_i0	PRJNA835051	124257	154	1.477477	2.27531458	Anaerolineae bacterium	2052143	Bacteria	Bacteria	63.9	1.63e-11	NR	HEC36346.1	2052143	g123961	i0	56	1.94805194805195	50	22	97.4	0	152	3	5	54	HEC36346.1 transposase [Anaerolineae bacterium]	diamond	300	63.9	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
31792777	31792777	PRJNA835051_S_NODE_110597_length_162_cov_1.613445_g110301_i0	PRJNA835051	110597	162	1.613445	2.6137809	Caldilineales bacterium	2306055	Bacteria	Bacteria	41.6	0.0317	NR	MCS6844387.1	2306055	g110301	i0	39.5	0.703703703703704	38	23	70.4	0	121	8	395	432	MCS6844387.1 SH3 domain-containing protein [Caldilineales bacterium]	diamond	114	41.6	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales			Caldilineales bacterium
32552683	32552683	PRJNA835051_S_NODE_61279_length_203_cov_1.475000_g60983_i0	PRJNA835051	61279	203	1.475	2.99425	Thermoflexales bacterium	2497639	Bacteria	Bacteria	40	0.0378	NR	HQX75696.1	2497639	g60983	i0	45	0.591133004926108	40	22	59.1	0	138	19	31	70	HQX75696.1 hypothetical protein [Thermoflexales bacterium]	diamond	120	40	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales			Thermoflexales bacterium
32709788	32709788	PRJNA835051_S_NODE_38580_length_234_cov_1.350785_g38284_i0	PRJNA835051	38580	234	1.350785	3.1608369	Anaerolineae bacterium	2052143	Bacteria	Bacteria	42	0.0374	NR	HSJ57273.1	2052143	g38284	i0	33.3	0.615384615384615	48	32	61.5	0	42	185	13	60	HSJ57273.1 HIT domain-containing protein [Anaerolineae bacterium]	diamond	144	42	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32741517	32741517	PRJNA835051_S_NODE_16340_length_290_cov_2.331984_g16044_i0	PRJNA835051	16340	290	2.331984	6.7627536	Candidatus Promineifilaceae bacterium	3085104	Bacteria	Bacteria	42.7	0.0404	NR	MFN2193541.1	3085104	g16044	i0	33.3	0.682758620689655	66	44	68.3	0	24	221	14	79	MFN2193541.1 vWA domain-containing protein [Candidatus Promineifilaceae bacterium]	diamond	198	42.7	1	Bacteria	Bacillati	Chloroflexota	Ardenticatenia	Candidatus Promineifilales	Candidatus Promineifilaceae		Candidatus Promineifilaceae 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);;