metadata: contig_metadata: 6 rows where bioproject = "PRJNA436017", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA436017", 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
2364481	2364481	PRJNA436017_P_NODE_21442_length_176_cov_2.935252_g21144_i0	PRJNA436017	21442	176	2.935252	5.16604352	Geotalea	2910589	Bacteria	Bacteria	202	1.39e-47	NTclustered	gi\|221562406\|gb\|CP001390.1\|	316067	g21144	i0	87.363	152.011363636364	182	15	100	8	1	176	2114175	2113996	Geobacter daltonii FRC-32, complete genome	blastn	26754	202	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea daltonii
2364552	2364552	PRJNA436017_P_NODE_6002_length_366_cov_2.212766_g5706_i0	PRJNA436017	6002	366	2.212766	8.09872356	Geomonas	2651583	Bacteria	Bacteria	350	1.1e-91	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g5706	i0	84.239	246.950819672131	368	48	99	9	1	364	884916	884555	Geomonas paludis strain RG22 chromosome, complete genome	blastn	90384	350	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
24040791	24040791	PRJNA436017_P_NODE_15879_length_207_cov_1.570588_g15581_i0	PRJNA436017	15879	207	1.570588	3.25111716	Geobacteraceae	213422	Bacteria	Bacteria	185	1.71e-42	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g15581	i0	83.092	178.207729468599	207	31	99	4	1	205	489019	489223	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	36889	185	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
28355458	28355458	PRJNA436017_P_NODE_1886_length_688_cov_7.327189_g1655_i0	PRJNA436017	1886	688	7.327189	50.41106032	Pseudomonadati	3379134	Bacteria	Bacteria	234	2.82e-74	NR	UCD79363.1	2044940	g1655	i0	53.5	2.80813953488372	213	98	92.4	1	17	652	5	217	UCD79363.1 MAG: nitroreductase family protein [Desulfobacterales bacterium]	diamond	1932	236	0.991525423728814	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29443980	29443980	PRJNA436017_P_NODE_16370_length_204_cov_0.922156_g16072_i0	PRJNA436017	16370	204	0.922156	1.88119824	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	80.9	6.15e-17	NR	HXV19802.1	2099678	g16072	i0	56.7	6.13235294117647	60	26	88.2	0	1	180	121	180	HXV19802.1 5-formyltetrahydrofolate cyclo-ligase [Desulfuromonadales bacterium]	diamond	1251	80.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
31197686	31197686	PRJNA436017_P_NODE_21975_length_174_cov_1.948905_g21677_i0	PRJNA436017	21975	174	1.948905	3.3910947	Bacteria	2	Bacteria	Bacteria	56.2	5.59e-8	NR	PIV06593.1	1974100	g21677	i0	78.1	2.75862068965517	32	7	55.2	0	2	97	106	137	PIV06593.1 MAG: nucleoside-diphosphate kinase [Syntrophobacterales bacterium CG03_land_8_20_14_0_80_58_14]	diamond	480	56.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium CG03_land_8_20_14_0_80_58_14

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