metadata: contig_metadata: 5 rows where bioproject = "PRJNA807685", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA807685", 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
8459626	8459626	PRJNA807685_P_NODE_41907_length_189_cov_2.184211_g40834_i0	PRJNA807685	41907	189	2.184211	4.12815879	Desulfobacula toluolica	28223	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|405104673\|emb\|FO203503.1\|	651182	g40834	i0	100	0.148148148148148	28	0	15	0	13	40	2294870	2294897	Desulfobacula toluolica Tol2 complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacula	Desulfobacula toluolica
15250881	15250881	PRJNA807685_P_NODE_4392_length_1139_cov_1.881125_g3710_i0	PRJNA807685	4392	1139	1.881125	21.42601375	Pseudomonadati	3379134	Bacteria	Bacteria	324	7.27e-105	NR	MEW6273102.1	2202153	g3710	i0	72.2	1.8252853380158	237	64	61.9	1	70	774	4	240	MEW6273102.1 glycosyltransferase [Thermodesulfobacteriota bacterium]	diamond	2079	325	0.996923076923077	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
23759002	23759002	PRJNA807685_P_NODE_13979_length_412_cov_1.544000_g12913_i0	PRJNA807685	13979	412	1.544	6.36128	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	206	1.34e-63	NR	MEW6268058.1	2202153	g12913	i0	76.1	2.00970873786408	138	32	99.8	1	412	2	115	252	MEW6268058.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	828	206	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30559479	30559479	PRJNA807685_P_NODE_22833_length_284_cov_2.117409_g21760_i0	PRJNA807685	22833	284	2.117409	6.01344156	Smithella sp.	2053614	Bacteria	Bacteria	54.3	2.48e-7	NR	MEN6623828.1	2053614	g21760	i0	50	0.401408450704225	38	19	40.1	0	104	217	33	70	MEN6623828.1 hypothetical protein [Smithella sp.]	diamond	114	54.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
32583653	32583653	PRJNA807685_P_NODE_30619_length_231_cov_1.216495_g29546_i0	PRJNA807685	30619	231	1.216495	2.81010345	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	43.1	0.0223	NR	MCF8044244.1	2528248	g29546	i0	34.6	0.675324675324675	52	28	59.7	1	53	190	221	272	MCF8044244.1 3-phosphoserine/phosphohydroxythreonine transaminase [Desulfarculaceae bacterium]	diamond	156	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae 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);;