metadata: contig_metadata: 8 rows where bioproject = "PRJNA376117", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA376117", tax_kingdom = "Pseudomonadati" 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
17651217	17651217	PRJNA376117_P_NODE_17614_length_329_cov_1.203125_g17312_i0	PRJNA376117	17614	329	1.203125	3.95828125	Desulfobulbus	893	Bacteria	Bacteria	484	2.5799999999999996e-132	NTclustered	gi\|470487339\|ref\|NR_076814.1\|	894	g17312	i0	93.293	224.26443768997	328	22	99	0	1	328	1566	1893	Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence	blastn	73783	484	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
28008148	28008148	PRJNA376117_P_NODE_38305_length_247_cov_0.885057_g38003_i0	PRJNA376117	38305	247	0.885057	2.18609079	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	73.9	7.35e-14	NR	HSR10174.1	2202153	g38003	i0	54.9	2.62348178137652	51	23	61.9	0	241	89	162	212	HSR10174.1 CAP domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	648	73.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28639641	28639641	PRJNA376117_P_NODE_6707_length_518_cov_1.982022_g6406_i0	PRJNA376117	6707	518	1.982022	10.26687396	Pseudomonadati	3379134	Bacteria	Bacteria	247	1.28e-80	NR	WP_207163832.1	2815309	g6406	i0	71.8	9.86872586872587	170	47	97.9	1	508	2	2	171	WP_207163832.1 NAD(P)H:quinone oxidoreductase [Geobacter benzoatilyticus]	diamond	5112	249	0.991967871485944	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
28748614	28748614	PRJNA376117_P_NODE_17627_length_329_cov_1.199219_g17325_i0	PRJNA376117	17627	329	1.199219	3.94543051	Desulfovibrio ferrophilus	241368	Bacteria	Bacteria	64.7	1.98e-9	NR	WP_126378189.1	241368	g17325	i0	36	0.911854103343465	100	63	91.2	1	309	10	350	448	WP_126378189.1 adenylate/guanylate cyclase domain-containing protein [Desulfovibrio ferrophilus]	diamond	300	64.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio ferrophilus
29965689	29965689	PRJNA376117_P_NODE_32051_length_257_cov_1.673913_g31749_i0	PRJNA376117	32051	257	1.673913	4.30195641	Thermodesulfobacteriales	188710	Bacteria	Bacteria	50.8	6.28e-5	NR	WP_068670026.1	999894	g31749	i0	41.8	3.03501945525292	67	32	75.9	3	17	211	213	274	WP_068670026.1 WSC domain-containing protein [Thermosulfurimonas dismutans]	diamond	780	50.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermosulfurimonas	Thermosulfurimonas dismutans
30675067	30675067	PRJNA376117_P_NODE_18193_length_324_cov_1.219124_g17891_i0	PRJNA376117	18193	324	1.219124	3.94996176	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	163	1.06e-46	NR	MDD2389771.1	2044940	g17891	i0	75.5	1.96296296296296	106	26	98.1	0	3	320	205	310	MDD2389771.1 branched-chain amino acid aminotransferase [Desulfobacterales bacterium]	diamond	636	163	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
31718425	31718425	PRJNA376117_P_NODE_9677_length_432_cov_1.927577_g9375_i0	PRJNA376117	9677	432	1.927577	8.32713264	Syntrophales bacterium	2928017	Bacteria	Bacteria	190	4.8399999999999995e-56	NR	MCK9275744.1	2928017	g9375	i0	62.9	4.17361111111111	151	48	99.3	2	430	2	94	244	MCK9275744.1 thiolase family protein [Syntrophales bacterium]	diamond	1803	190	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
32368523	32368523	PRJNA376117_P_NODE_12499_length_383_cov_4.735484_g12197_i0	PRJNA376117	12499	383	4.735484	18.13690372	Bacteria	2	Bacteria	Bacteria	50.4	3.02e-4	NR	MDH3957808.1	2049433	g12197	i0	47.5	2.72584856396867	61	26	47.8	1	186	4	229	283	MDH3957808.1 S1C family serine protease [Desulfobacteraceae bacterium]	diamond	1044	50.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae 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);;