metadata: contig_metadata: 11 rows where bioproject = "PRJNA929940" and tax

11 rows where bioproject = "PRJNA929940" 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
20035725	20035725	PRJNA929940_S_NODE_20956_length_225_cov_1.845745_g20721_i0	PRJNA929940	20956	225	1.845745	4.15292625	Polaribacter sp. SA4-10	754397	Bacteria	Bacteria	187	5.26e-43	NTclustered	gi\|1199775334\|gb\|CP019331.1\|	754397	g20721	i0	82.938	42.2888888888889	211	32	93	4	2	210	1035451	1035659	Polaribacter sp. SA4-10 genome	blastn	9515	187	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter sp. SA4-10
20035738	20035738	PRJNA929940_S_NODE_47756_length_163_cov_2.150794_g47521_i0	PRJNA929940	47756	163	2.150794	3.50579422	Lutibacter sp. A64	2918526	Bacteria	Bacteria	121	3.669999999999999e-23	NTclustered	gi\|2201049089\|gb\|CP092487.1\|	2918526	g47521	i0	83.206	2.02453987730061	131	22	80	0	13	143	805178	805308	Lutibacter sp. A64 chromosome, complete genome	blastn	330	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Lutibacter	Lutibacter sp. A64
28224913	28224913	PRJNA929940_S_NODE_50546_length_159_cov_18.581967_g50311_i0	PRJNA929940	50546	159	18.581967	29.54532753	Flavobacterium subsaxonicum	426226	Bacteria	Bacteria	113	1.27e-30	NR	WP_035755215.1	426226	g50311	i0	98.1	19	53	1	100	0	159	1	55	107	WP_035755215.1 MC/SLC25 family protein, partial [Flavobacterium subsaxonicum]	diamond	3021	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium subsaxonicum
28541101	28541101	PRJNA929940_S_NODE_11867_length_280_cov_1.604938_g11632_i0	PRJNA929940	11867	280	1.604938	4.4938264	Bacteroides ilei	1907658	Bacteria	Bacteria	45.4	0.00673	NR	WP_072529844.1	1907658	g11632	i0	34.1	0.878571428571429	82	44	77.1	3	62	277	711	792	WP_072529844.1 SusC/RagA family TonB-linked outer membrane protein [Bacteroides ilei]	diamond	246	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides ilei
28572394	28572394	PRJNA929940_S_NODE_49587_length_161_cov_1.483871_g49352_i0	PRJNA929940	49587	161	1.483871	2.38903231	Mucilaginibacter gilvus	2305909	Bacteria	Bacteria	89	4.040000000000001e-21	NR	WP_134240087.1	2305909	g49352	i0	86.8	2.94409937888199	53	7	98.8	0	1	159	65	117	WP_134240087.1 lipocalin/fatty-acid binding family protein, partial [Mucilaginibacter gilvus]	diamond	474	89.7	0.992196209587514	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter gilvus
28824754	28824754	PRJNA929940_S_NODE_33908_length_187_cov_1.220000_g33673_i0	PRJNA929940	33908	187	1.22	2.2814	Bacteroidetes bacterium OLB1	1898104	Bacteria	Bacteria	42.7	0.0183	NR	KXK46386.1	1617421	g33673	i0	58.1	0.497326203208556	31	13	49.7	0	121	29	222	252	KXK46386.1 MAG: hypothetical protein UZ10_BCD003001284, partial [Bacteroidetes bacterium OLB10]	diamond	93	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium OLB10
28983151	28983151	PRJNA929940_S_NODE_21488_length_222_cov_36.394595_g21253_i0	PRJNA929940	21488	222	36.394595	80.7960009	Flavobacterium subsaxonicum	426226	Bacteria	Bacteria	134	1.4699999999999999e-38	NR	WP_035755212.1	426226	g21253	i0	94.5	2.95945945945946	73	4	98.6	0	222	4	12	84	WP_035755212.1 class I fructose-bisphosphate aldolase, partial [Flavobacterium subsaxonicum]	diamond	657	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium subsaxonicum
29551045	29551045	PRJNA929940_S_NODE_10250_length_295_cov_2.213178_g10015_i0	PRJNA929940	10250	295	2.213178	6.5288751	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	43.1	0.0457	NR	MBK8339295.1	2021391	g10015	i0	37	0.742372881355932	73	45	73.2	1	9	224	249	321	MBK8339295.1 hypothetical protein [Flavobacteriales bacterium]	diamond	219	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29993470	29993470	PRJNA929940_S_NODE_52271_length_157_cov_7.225000_g52036_i0	PRJNA929940	52271	157	7.225	11.34325	Flavobacterium subsaxonicum	426226	Bacteria	Bacteria	112	3.48e-30	NR	WP_035755215.1	426226	g52036	i0	98.1	18.8789808917197	52	1	99.4	0	157	2	55	106	WP_035755215.1 MC/SLC25 family protein, partial [Flavobacterium subsaxonicum]	diamond	2964	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium subsaxonicum
30253403	30253403	PRJNA929940_S_NODE_12832_length_271_cov_3.747863_g12597_i0	PRJNA929940	12832	271	3.747863	10.15670873	Pseudomonadati	3379134	Bacteria	Bacteria	170	1.29e-51	NR	WP_185099574.1	2760087	g12597	i0	93.3	2.98892988929889	90	6	99.6	0	271	2	41	130	WP_185099574.1 hypothetical protein, partial [Aequorivita sp. 609]	diamond	810	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita sp. 609
32427785	32427785	PRJNA929940_S_NODE_15399_length_253_cov_38.111111_g15164_i0	PRJNA929940	15399	253	38.111111	96.42111083	Aequorivita sinensis	1382458	Bacteria	Bacteria	46.6	0.00156	NR	WP_282032518.1	1382458	g15164	i0	87.5	0.569169960474308	24	3	28.5	0	251	180	235	258	WP_282032518.1 apolipoprotein A1/A4/E family protein [Aequorivita sinensis]	diamond	144	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aequorivita	Aequorivita sinensis

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