metadata: contig_metadata: 9 rows where bioproject = "PRJNA691918" and tax

9 rows where bioproject = "PRJNA691918" 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
2454510	2454510	PRJNA691918_S_NODE_162_length_203_cov_17858.604651_g161_i0	PRJNA691918	162	203	17858.604651	36252.96744153	Flavobacterium	237	Bacteria	Bacteria	285	1.6e-72	NTclustered	gi\|2119752067\|dbj\|AP025185.1\|	1751056	g161	i0	98.75	434.23645320197	160	2	79	0	41	200	1148706	1148547	Flavobacterium ammonificans SHINM13 DNA, complete genome	blastn	88150	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammonificans
3731046	3731046	PRJNA691918_S_NODE_143_length_210_cov_15928.184358_g142_i0	PRJNA691918	143	210	15928.184358	33449.1871518	Alistipes	239759	Bacteria	Bacteria	141	3.82e-29	NTclustered	gi\|2777727142\|dbj\|AP031448.1\|	328814	g142	i0	81.765	46.2714285714286	170	29	81	2	39	208	1108546	1108713	Alistipes shahii k32-0107-C7 DNA, complete genome	blastn	9717	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes shahii
7051108	7051108	PRJNA691918_S_NODE_126_length_216_cov_16598.113514_g125_i0	PRJNA691918	126	216	16598.113514	35851.92519024	uncultured Bacteroidia bacterium	1129257	Bacteria	Bacteria	167	6.52e-37	NTclustered	gi\|2308952747\|emb\|OX044357.1\|	1129257	g125	i0	84.483	58.5555555555556	174	22	79	4	45	215	2406343	2406514	MAG: uncultured Bacteroidia bacterium isolate B_MB356 genome assembly, chromosome: B_MB356_contig-1	blastn	12648	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				uncultured Bacteroidia bacterium
7051109	7051109	PRJNA691918_S_NODE_166_length_202_cov_17929.491228_g165_i0	PRJNA691918	166	202	17929.491228	36217.57228056	Flavobacterium crocinum	2183896	Bacteria	Bacteria	159	1.01e-34	NTclustered	gi\|1389162878\|gb\|CP029255.1\|	2183896	g165	i0	84.848	563.049504950495	165	17	79	8	4	162	23845	23683	Flavobacterium crocinum strain HYN0056 chromosome, complete genome	blastn	113736	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium crocinum
12658602	12658602	PRJNA691918_S_NODE_190_length_197_cov_18045.915663_g189_i0	PRJNA691918	190	197	18045.915663	35550.45385611	Flavobacteriaceae	49546	Bacteria	Bacteria	268	1.5599999999999998e-67	NTclustered	gi\|1834819635\|gb\|CP051546.1\|	239	g189	i0	99.324	416.954314720812	148	1	75	0	49	196	56043	56190	MAG: Flavobacterium sp. isolate NK2020 chromosome	blastn	82140	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
14701477	14701477	PRJNA691918_S_NODE_352_length_170_cov_6.151079_g351_i0	PRJNA691918	352	170	6.151079	10.4568343	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	135	1.37e-27	NTclustered	gi\|2621703596\|emb\|OY761460.1\|	2053594	g351	i0	81.287	82.7411764705882	171	28	100	4	4	170	1871371	1871201	MAG: Prolixibacteraceae bacterium isolate b0120b26-81c1-4e5c-b488-535878dd73d8 genome assembly, chromosome: 1	blastn	14066	135	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
21074943	21074943	PRJNA691918_S_NODE_57_length_250_cov_13654.908676_g56_i0	PRJNA691918	57	250	13654.908676	34137.27169	Bacteroidota bacterium	1898104	Bacteria	Bacteria	123	3.5099999999999993e-31	NR	MFM1971365.1	1898104	g56	i0	75	0.912	76	19	91.2	0	1	228	114	189	MFM1971365.1 Phytophthora parasitica virus [Bacteroidota bacterium]	diamond	228	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
24131120	24131120	PRJNA691918_S_NODE_159_length_204_cov_17744.508671_g158_i0	PRJNA691918	159	204	17744.508671	36198.79768884	Bacteria	2	Bacteria	Bacteria	82.4	2.27e-11	NTclustered	gi\|1173527474\|gb\|CP015402.2\|	1796646	g158	i0	94.34	43.7941176470588	53	3	26	0	115	167	2294362	2294310	Muribaculum intestinale strain YL27 chromosome, complete genome	blastn	8934	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Muribaculum	Muribaculum intestinale
29387962	29387962	PRJNA691918_S_NODE_289_length_179_cov_20.114865_g288_i0	PRJNA691918	289	179	20.114865000000002	36.00560835	Sphingobacteriia bacterium 28-36-52	1970573	Bacteria	Bacteria	58.9	3.09e-8	NR	OYY99577.1	1970573	g288	i0	86.2	0.486033519553073	29	4	48.6	0	92	178	1	29	OYY99577.1 MAG: hypothetical protein B7Y37_13885 [Sphingobacteriia bacterium 28-36-52]	diamond	87	58.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia				Sphingobacteriia bacterium 28-36-52

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