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

14 rows where bioproject = "PRJEB65099" and tax_phylum = "Thermodesulfobacteriota"

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
2680059	2680059	PRJEB65099_P_NODE_5783_length_248_cov_0.891429_g5678_i0	PRJEB65099	5783	248	0.891429	2.21074392	Desulfoglaeba alkanexedens	361111	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|1649181537\|gb\|CP040098.1\|	980445	g5678	i0	84.188	2.84677419354839	234	35	94	2	1	233	1287467	1287235	Desulfoglaeba alkanexedens ALDC chromosome, complete genome	blastn	706	226	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulfoglaeba	Desulfoglaeba alkanexedens
7782325	7782325	PRJEB65099_P_NODE_5407_length_250_cov_0.881356_g5302_i0	PRJEB65099	5407	250	0.881356	2.20339	Trichlorobacter lovleyi	313985	Bacteria	Bacteria	412	9.02e-111	NTclustered	gi\|189419341\|gb\|CP001089.1\|	398767	g5302	i0	96.414	2.008	251	8	100	1	1	250	1813410	1813660	Geobacter lovleyi SZ, complete genome	blastn	502	412	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Trichlorobacter	Trichlorobacter lovleyi
19255525	19255525	PRJEB65099_P_NODE_6476_length_244_cov_0.912281_g6371_i0	PRJEB65099	6476	244	0.912281	2.22596564	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	152	2.34e-41	NR	MEF8943601.1	2683721	g6371	i0	92.5	0.983606557377049	80	6	98.4	0	242	3	405	484	MEF8943601.1 sigma-54-dependent Fis family transcriptional regulator [Desulfohalobiaceae bacterium]	diamond	240	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
20530925	20530925	PRJEB65099_P_NODE_5317_length_251_cov_0.876404_g5212_i0	PRJEB65099	5317	251	0.876404	2.19977404	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	122	2.8799999999999997e-30	NR	MEF8889613.1	2683721	g5212	i0	92.9	0.836653386454183	70	5	83.7	0	42	251	643	712	MEF8889613.1 heavy metal translocating P-type ATPase [Desulfohalobiaceae bacterium]	diamond	210	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
24355783	24355783	PRJEB65099_P_NODE_6560_length_244_cov_0.912281_g6455_i0	PRJEB65099	6560	244	0.912281	2.22596564	Desulfocurvibacter africanus	873	Bacteria	Bacteria	268	2.01e-67	NTclustered	gi\|367460290\|gb\|CP003221.1\|	690850	g6455	i0	86.585	99.8811475409836	246	29	100	4	1	244	112126	111883	Desulfocurvibacter africanus subsp. africanus str. Walvis Bay chromosome, complete genome	blastn	24371	268	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
27033887	27033887	PRJEB65099_P_NODE_4462_length_265_cov_1.625000_g4357_i0	PRJEB65099	4462	265	1.625	4.30625	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	117	4.44e-29	NR	MCF8086007.1	2683721	g4357	i0	95.2	0.70188679245283	62	3	70.2	0	264	79	315	376	MCF8086007.1 aspartate kinase [Desulfohalobiaceae bacterium]	diamond	186	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
27476316	27476316	PRJEB65099_P_NODE_4603_length_261_cov_1.329787_g4498_i0	PRJEB65099	4603	261	1.329787	3.47074407	Desulfonatronovibrionaceae bacterium	3107345	Bacteria	Bacteria	105	1.05e-24	NR	MFP4168014.1	3107345	g4498	i0	83	0.609195402298851	53	9	60.9	0	161	3	3	55	MFP4168014.1 ISL3 family transposase [Desulfonatronovibrionaceae bacterium]	diamond	159	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae		Desulfonatronovibrionaceae bacterium
30065372	30065372	PRJEB65099_P_NODE_5192_length_251_cov_2.320225_g5087_i0	PRJEB65099	5192	251	2.320225	5.82376475	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	84.7	3.38e-17	NR	MEF8823681.1	2683721	g5087	i0	92.7	0.49003984063745	41	3	49	0	1	123	37	77	MEF8823681.1 TRAP transporter substrate-binding protein [Desulfohalobiaceae bacterium]	diamond	123	84.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
30823819	30823819	PRJEB65099_P_NODE_6894_length_242_cov_0.923077_g6789_i0	PRJEB65099	6894	242	0.923077	2.23384634	Geobacter sp.	46610	Bacteria	Bacteria	99.4	7.379999999999999e-23	NR	MBI1919625.1	46610	g6789	i0	58.1	2.75206611570248	74	31	91.7	0	16	237	159	232	MBI1919625.1 LysR family transcriptional regulator [Geobacter sp.]	diamond	666	99.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
31266237	31266237	PRJEB65099_P_NODE_3995_length_280_cov_1.270531_g3890_i0	PRJEB65099	3995	280	1.270531	3.5574868	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	55.8	1.37e-6	NR	MBS3754618.1	2044940	g3890	i0	96.3	0.289285714285714	27	1	28.9	0	81	1	1	27	MBS3754618.1 bifunctional phosphopantothenoylcysteine decarboxylase/phosphopantothenate--cysteine ligase CoaBC [Desulfobacterales bacterium]	diamond	81	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32310462	32310462	PRJEB65099_P_NODE_3639_length_292_cov_1.319635_g3534_i0	PRJEB65099	3639	292	1.319635	3.8533342	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	157	6.98e-44	NR	MEF8888407.1	2683721	g3534	i0	93.8	0.821917808219178	80	5	82.2	0	1	240	61	140	MEF8888407.1 FAD-linked oxidase C-terminal domain-containing protein [Desulfohalobiaceae bacterium]	diamond	240	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32342000	32342000	PRJEB65099_P_NODE_6939_length_242_cov_0.923077_g6834_i0	PRJEB65099	6939	242	0.923077	2.23384634	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	152	1.39e-41	NR	MEF8889104.1	2683721	g6834	i0	92.5	0.991735537190083	80	6	99.2	0	2	241	55	134	MEF8889104.1 ExeM/NucH family extracellular endonuclease [Desulfohalobiaceae bacterium]	diamond	240	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32436997	32436997	PRJEB65099_P_NODE_5379_length_250_cov_1.333333_g5274_i0	PRJEB65099	5379	250	1.333333	3.3333325	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	149	4.28e-40	NR	MEF8824518.1	2683721	g5274	i0	88	1.992	83	10	99.6	0	2	250	307	389	MEF8824518.1 FAD-dependent oxidoreductase [Desulfohalobiaceae bacterium]	diamond	498	149	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32689115	32689115	PRJEB65099_P_NODE_6800_length_242_cov_0.923077_g6695_i0	PRJEB65099	6800	242	0.923077	2.23384634	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	99.8	5.2e-23	NR	HSC35316.1	2202153	g6695	i0	96.2	0.644628099173554	52	2	64.5	0	86	241	1	52	HSC35316.1 ROK family protein [Thermodesulfobacteriota bacterium]	diamond	156	99.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota 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);;