metadata: contig_metadata: 9 rows where bioproject = "PRJNA789095", tax_phylum = "Thermodesulfobacteriota" and tax

9 rows where bioproject = "PRJNA789095", 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
17349702	17349702	PRJNA789095_P_NODE_67034_length_250_cov_0.870056_g65700_i0	PRJNA789095	67034	250	0.870056	2.17514	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g65700	i0	95.2	6.724	250	12	100	0	1	250	2868558	2868309	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	1681	396	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
27496176	27496176	PRJNA789095_P_NODE_40703_length_312_cov_0.933054_g39369_i0	PRJNA789095	40703	312	0.933054	2.91112848	Desulfosalsimonadaceae bacterium	3060584	Bacteria	Bacteria	49.7	2.84e-4	NR	MFO8112632.1	3060584	g39369	i0	38.5	0.75	78	42	74	2	310	80	304	376	MFO8112632.1 pyruvate kinase [Desulfosalsimonadaceae bacterium]	diamond	234	49.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosalsimonadaceae		Desulfosalsimonadaceae bacterium
27906312	27906312	PRJNA789095_P_NODE_78365_length_231_cov_3.563291_g77031_i0	PRJNA789095	78365	231	3.563291	8.23120221	Desulfosudaceae bacterium	3068765	Bacteria	Bacteria	42	0.0443	NR	MFP4445594.1	3068765	g77031	i0	37.3	0.766233766233766	59	34	72.7	1	231	64	49	107	MFP4445594.1 chemotaxis protein CheD [Desulfosudaceae bacterium]	diamond	177	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosudaceae		Desulfosudaceae bacterium
28538279	28538279	PRJNA789095_P_NODE_43867_length_306_cov_0.961373_g42533_i0	PRJNA789095	43867	306	0.961373	2.94180138	Desulfocapsa sulfexigens	65555	Bacteria	Bacteria	143	3.2899999999999996e-37	NR	HIP82064.1	65555	g42533	i0	61.8	5	102	39	100	0	306	1	453	554	HIP82064.1 reverse transcriptase-like protein [Desulfocapsa sulfexigens]	diamond	1530	143	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sulfexigens
29043411	29043411	PRJNA789095_P_NODE_81628_length_204_cov_5.412214_g80294_i0	PRJNA789095	81628	204	5.412214	11.04091656	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	58.2	7.93e-8	NR	MCP4337615.1	2053307	g80294	i0	57.1	2	42	18	61.8	0	130	5	444	485	MCP4337615.1 reverse transcriptase family protein [Desulfobulbaceae bacterium]	diamond	408	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29832570	29832570	PRJNA789095_P_NODE_18311_length_589_cov_5.647287_g16991_i0	PRJNA789095	18311	589	5.647287	33.26252043	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	70.9	1.76e-10	NR	MCP4337615.1	2053307	g16991	i0	56.6	0.269949066213922	53	23	27	0	279	437	429	481	MCP4337615.1 reverse transcriptase family protein [Desulfobulbaceae bacterium]	diamond	159	70.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29832571	29832571	PRJNA789095_P_NODE_28691_length_402_cov_5.206687_g27359_i0	PRJNA789095	28691	402	5.206687	20.93088174	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	45.1	0.0298	NR	MCP4337615.1	2053307	g27359	i0	57.6	0.246268656716418	33	14	24.6	0	101	3	464	496	MCP4337615.1 reverse transcriptase family protein [Desulfobulbaceae bacterium]	diamond	99	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
30464868	30464868	PRJNA789095_P_NODE_13193_length_794_cov_4.875173_g11967_i0	PRJNA789095	13193	794	4.875173	38.70887362	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	67.8	8.02e-9	NR	MCP4337615.1	2053307	g11967	i0	61.7	0.532745591939547	47	18	17.8	0	603	743	444	490	MCP4337615.1 reverse transcriptase family protein [Desulfobulbaceae bacterium]	diamond	423	67.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
30622311	30622311	PRJNA789095_P_NODE_79173_length_228_cov_2.432258_g77839_i0	PRJNA789095	79173	228	2.432258	5.54554824	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	44.3	0.00893	NR	MCP4337615.1	2053307	g77839	i0	38.6	1.15789473684211	44	24	53.9	1	165	43	426	469	MCP4337615.1 reverse transcriptase family protein [Desulfobulbaceae bacterium]	diamond	264	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae 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);;