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

5 rows where bioproject = "PRJEB6097" and tax_phylum = "Bacillota"

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
3951648	3951648	PRJEB6097_S_NODE_5764_length_186_cov_3.039735_g5710_i0	PRJEB6097	5764	186	3.039735	5.6539071	Anaerococcus nagyae	1755241	Bacteria	Bacteria	316	5.11e-82	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g5710	i0	97.312	34.3440860215054	186	5	100	0	1	186	121042	121227	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	6388	316	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
12879227	12879227	PRJEB6097_S_NODE_6491_length_158_cov_0.975610_g6437_i0	PRJEB6097	6491	158	0.97561	1.5414638	Peptoniphilus genitalis	3036303	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2246887130\|gb\|CP097885.1\|	3036303	g6437	i0	100	76.3037974683544	158	0	100	0	1	158	292338	292495	Peptoniphilus genitalis strain SAHP1 chromosome, complete genome	blastn	12056	292	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus genitalis
29528442	29528442	PRJEB6097_S_NODE_2570_length_281_cov_47521.256098_g2516_i0	PRJEB6097	2570	281	47521.256098	133534.72963538	Blautia luti	89014	Bacteria	Bacteria	52.4	4.99e-6	NR	WP_207705784.1	89014	g2516	i0	96	0.266903914590747	25	1	26.7	0	201	127	80	104	WP_207705784.1 hypothetical protein, partial [Blautia luti]	diamond	75	52.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia luti
32499925	32499925	PRJEB6097_S_NODE_179_length_511_cov_49582.470588_g125_i0	PRJEB6097	179	511	49582.470588	253366.42470468	Blautia luti	89014	Bacteria	Bacteria	53.5	1.4e-5	NR	WP_207705784.1	89014	g125	i0	100	0.146771037181996	25	0	14.7	0	201	127	80	104	WP_207705784.1 hypothetical protein, partial [Blautia luti]	diamond	75	53.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia luti
32877839	32877839	PRJEB6097_S_NODE_860_length_371_cov_34227.300595_g806_i0	PRJEB6097	860	371	34227.300595	126983.28520745	Blautia luti	89014	Bacteria	Bacteria	51.6	2.45e-5	NR	WP_207705784.1	89014	g806	i0	71.8	0.517520215633423	39	6	27.5	1	198	97	81	119	WP_207705784.1 hypothetical protein, partial [Blautia luti]	diamond	192	51.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Blautia	Blautia luti

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