metadata: contig_metadata: 8 rows where bioproject = "PRJEB7366", tax_phylum = "Thermodesulfobacteriota" and tax

8 rows where bioproject = "PRJEB7366", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
17986841	17986841	PRJEB7366_P_NODE_22535_length_159_cov_1.112903_g22101_i0	PRJEB7366	22535	159	1.112903	1.76951577	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	60.8	4.74e-9	NR	HID59572.1	2044940	g22101	i0	60.8	2.92452830188679	51	18	96.2	1	3	155	866	914	HID59572.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Desulfobacterales bacterium]	diamond	465	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29465316	29465316	PRJEB7366_P_NODE_11670_length_238_cov_0.985222_g11236_i0	PRJEB7366	11670	238	0.985222	2.34482836	Candidatus Magnetomorum sp.	2739430	Bacteria	Bacteria	43.1	0.0268	NR	MBF0451575.1	2739430	g11236	i0	37.5	0.705882352941177	56	35	70.6	0	67	234	1457	1512	MBF0451575.1 cadherin domain-containing protein [Candidatus Magnetomorum sp.]	diamond	168	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp.
29647548	29647548	PRJEB7366_P_NODE_23730_length_154_cov_1.344538_g23296_i0	PRJEB7366	23730	154	1.344538	2.07058852	root	1	Root_unresolved	Root_unresolved	72.4	3.61e-13	NR	WP_012663130.1	2296	g23296	i0	62	10.7532467532468	50	19	97.4	0	150	1	315	364	WP_012663130.1 thiolase family protein [Desulforapulum autotrophicum]	diamond	1656	72.8	0.994505494505495	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulforapulum	Desulforapulum autotrophicum
30437940	30437940	PRJEB7366_P_NODE_17973_length_181_cov_1.280822_g17539_i0	PRJEB7366	17973	181	1.280822	2.31828782	root	1	Root_unresolved	Root_unresolved	82.4	4.69e-17	NR	KPA19421.1	1509431	g17539	i0	69	11.5524861878453	58	18	96.1	0	176	3	43	100	KPA19421.1 Acetyl-CoA acetyltransferase, partial [Candidatus Magnetomorum sp. HK-1]	diamond	2091	83.2	0.990384615384615	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
30792386	30792386	PRJEB7366_P_NODE_17534_length_184_cov_1.147651_g17100_i0	PRJEB7366	17534	184	1.147651	2.11167784	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	42	0.0318	NR	HTP65832.1	2282154	g17100	i0	54.8	0.505434782608696	31	8	50.5	1	147	55	47	71	HTP65832.1 biosynthetic peptidoglycan transglycosylase [Geobacteraceae bacterium]	diamond	93	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
31772457	31772457	PRJEB7366_P_NODE_8077_length_301_cov_2.406015_g7643_i0	PRJEB7366	8077	301	2.406015	7.24210515	Desulfobacteria bacterium	3024420	Bacteria	Bacteria	43.9	0.0292	NR	HUV03460.1	3024420	g7643	i0	48.9	0.46843853820598	47	16	38.9	2	153	37	84	130	HUV03460.1 CARDB domain-containing protein [Desulfobacteria bacterium]	diamond	141	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria				Desulfobacteria bacterium
32145021	32145021	PRJEB7366_P_NODE_5698_length_375_cov_2.394118_g5265_i0	PRJEB7366	5698	375	2.394118	8.9779425	Pseudomonadati	3379134	Bacteria	Bacteria	172	5.869999999999999e-52	NR	MBI9082145.1	2044940	g5265	i0	76.4	10.464	110	26	88	0	374	45	94	203	MBI9082145.1 NAD(P)H:quinone oxidoreductase [Desulfobacterales bacterium]	diamond	3924	172	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32783769	32783769	PRJEB7366_P_NODE_10840_length_249_cov_2.429907_g10406_i0	PRJEB7366	10840	249	2.429907	6.05046843	Candidatus Electrothrix gigas	2202844	Bacteria	Bacteria	75.1	1.56e-13	NR	MCI5190825.1	2202844	g10406	i0	40.5	3.87951807228916	79	45	95.2	2	244	8	408	484	MCI5190825.1 hypothetical protein [Candidatus Electrothrix gigas]	diamond	966	75.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix gigas

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