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

5 rows where bioproject = "PRJNA1168532" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11793786	11793786	PRJNA1168532_S_NODE_248590_length_191_cov_1.412162_g245647_i0	PRJNA1168532	248590	191	1.412162	2.69722942	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	315	1.9e-81	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g245647	i0	96.335	404.910994764398	191	7	100	0	1	191	1236379	1236569	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	77338	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
16342753	16342753	PRJNA1168532_S_NODE_141193_length_269_cov_1.238938_g138250_i0	PRJNA1168532	141193	269	1.238938	3.33274322	Sediminibacterium	504481	Bacteria	Bacteria	392	1.28e-104	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g138250	i0	92.963	54.7769516728625	270	18	100	1	1	269	55376	55645	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	14735	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
20716542	20716542	PRJNA1168532_S_NODE_296497_length_170_cov_1.322835_g293554_i0	PRJNA1168532	296497	170	1.322835	2.2488195	Riemerella anatipestifer	34085	Bacteria	Bacteria	200	4.8e-47	NTclustered	gi\|392495350\|gb\|JQ664681.1\|	34085	g293554	i0	88.889	0.952941176470588	162	18	95	0	8	169	21	182	Riemerella anatipestifer strain X23-4N aminoglycoside-3'-O-phosphotransferase (aph) gene, partial cds	blastn	162	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
30672299	30672299	PRJNA1168532_S_NODE_345493_length_154_cov_1.036036_g342550_i0	PRJNA1168532	345493	154	1.036036	1.59549544	Bacteroidales bacterium	2030927	Bacteria	Bacteria	73.9	5.77e-15	NR	MCI5814055.1	2030927	g342550	i0	100	0.720779220779221	37	0	72.1	0	113	3	1	37	MCI5814055.1 hypothetical protein [Bacteroidales bacterium]	diamond	111	73.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30703965	30703965	PRJNA1168532_S_NODE_302314_length_168_cov_1.128000_g299371_i0	PRJNA1168532	302314	168	1.128	1.89504	Bacteroidales bacterium	2030927	Bacteria	Bacteria	55.8	3.14e-7	NR	MBO5471727.1	2030927	g299371	i0	100	0.482142857142857	27	0	48.2	0	87	167	1	27	MBO5471727.1 TonB-dependent receptor [Bacteroidales bacterium]	diamond	81	55.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales 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);;