metadata: contig_metadata: 5 rows where bioproject = "PRJNA1008624" and tax

5 rows where bioproject = "PRJNA1008624" 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
12908356	12908356	PRJNA1008624_P_NODE_6891_length_319_cov_8.729630_g6703_i0	PRJNA1008624	6891	319	8.72963	27.8475197	Desulfovibrio subterraneus	2718620	Bacteria	Bacteria	147	1.33e-30	NTclustered	gi\|2419088003\|gb\|CP087381.1\|	2718620	g6703	i0	79.018	101.495297805643	224	39	69	7	29	248	1200995	1200776	Desulfovibrio subterraneus strain ND17 chromosome, complete genome	blastn	32377	147	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio subterraneus
26591023	26591023	PRJNA1008624_P_NODE_22881_length_182_cov_1.315789_g22693_i0	PRJNA1008624	22881	182	1.315789	2.39473598	Desulfovibrio falkowii	3136602	Bacteria	Bacteria	55.5	5.27e-7	NR	WP_407844967.1	3136602	g22693	i0	51.9	3.70879120879121	52	22	80.8	1	5	151	114	165	WP_407844967.1 type II restriction endonuclease [Desulfovibrio falkowii]	diamond	675	55.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio falkowii
26717546	26717546	PRJNA1008624_P_NODE_28461_length_168_cov_0.873950_g28273_i0	PRJNA1008624	28461	168	0.87395	1.468236	Smithella sp.	2053614	Bacteria	Bacteria	53.9	1.5e-6	NR	MEN6621322.1	2053614	g28273	i0	63.6	1.17857142857143	33	12	58.9	0	164	66	25	57	MEN6621322.1 hypothetical protein [Smithella sp.]	diamond	198	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
27666542	27666542	PRJNA1008624_P_NODE_36704_length_162_cov_0.920354_g36516_i0	PRJNA1008624	36704	162	0.920354	1.49097348	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	52.8	3.03e-6	NR	NIQ16564.1	2080303	g36516	i0	45.1	0.944444444444444	51	28	94.4	0	8	160	190	240	NIQ16564.1 PBSX family phage terminase large subunit [Candidatus Dadabacteria bacterium]	diamond	153	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
32815721	32815721	PRJNA1008624_P_NODE_4120_length_421_cov_5.567204_g3933_i0	PRJNA1008624	4120	421	5.567204	23.43792884	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	62.4	1.49e-9	NR	CBX28568.1	201089	g3933	i0	43	0.612826603325416	86	44	59.9	2	275	24	3	85	CBX28568.1 hypothetical protein N47_G38920 [uncultured Desulfobacterium sp.]	diamond	258	62.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.

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