metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax_clade = "FCB group"

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
8652781	8652781	PRJNA1001940_S_NODE_85807_length_234_cov_4.926702_g84753_i0	PRJNA1001940	85807	234	4.926702	11.52848268	Bacteroides coprosuis	151276	Bacteria	Bacteria	157	4.77e-43	NR	WP_276776066.1	151276	g84753	i0	96.1	0.987179487179487	77	3	98.7	0	3	233	56	132	WP_276776066.1 trehalase family glycosidase [Bacteroides coprosuis]	diamond	231	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides coprosuis
26590898	26590898	PRJNA1001940_S_NODE_165481_length_169_cov_1.142857_g164427_i0	PRJNA1001940	165481	169	1.142857	1.93142833	Sphingobacterium sp. UT-1RO-CII-1	2995225	Bacteria	Bacteria	89.4	5.08e-21	NR	WP_268230863.1	2995225	g164427	i0	88.7	0.940828402366864	53	6	94.1	0	160	2	27	79	WP_268230863.1 ORF6N domain-containing protein [Sphingobacterium sp. UT-1RO-CII-1]	diamond	159	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. UT-1RO-CII-1
27097533	27097533	PRJNA1001940_S_NODE_59082_length_282_cov_2.983264_g58028_i0	PRJNA1001940	59082	282	2.983264	8.41280448	Niastella sp.	1869183	Bacteria	Bacteria	55.5	1.51e-6	NR	MBO9566002.1	1869183	g58028	i0	89.7	3.3936170212766	29	3	30.9	0	1	87	237	265	MBO9566002.1 class I SAM-dependent methyltransferase [Niastella sp.]	diamond	957	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella sp.
28739764	28739764	PRJNA1001940_S_NODE_154047_length_175_cov_1.454545_g152993_i0	PRJNA1001940	154047	175	1.454545	2.54545375	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.3	0.00432	NR	HYL29474.1	2448054	g152993	i0	45.7	0.788571428571429	46	22	78.9	1	11	148	146	188	HYL29474.1 formimidoylglutamate deiminase [Gemmatimonadales bacterium]	diamond	138	44.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28739768	28739768	PRJNA1001940_S_NODE_79127_length_244_cov_3.019900_g78073_i0	PRJNA1001940	79127	244	3.0199	7.368556	Dysgonamonadaceae bacterium	2065189	Bacteria	Bacteria	138	1.4e-36	NR	MDD2551303.1	2065189	g78073	i0	85.2	1.99180327868852	81	12	99.6	0	244	2	35	115	MDD2551303.1 sodium:proton antiporter NhaD [Dysgonamonadaceae bacterium]	diamond	486	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonamonadaceae bacterium
28992659	28992659	PRJNA1001940_S_NODE_83648_length_237_cov_8.824742_g82594_i0	PRJNA1001940	83648	237	8.824742	20.91463854	Aureitalea sp. L	1872661	Bacteria	Bacteria	42.4	0.047	NR	WP_265198814.1	2816962	g82594	i0	34.3	0.848101265822785	67	43	83.5	1	12	209	230	296	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	201	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
29150586	29150586	PRJNA1001940_S_NODE_54529_length_293_cov_3.368000_g53475_i0	PRJNA1001940	54529	293	3.368	9.86824	Bacteroidales bacterium	2030927	Bacteria	Bacteria	181	1.93e-52	NR	MBO5876770.1	2030927	g53475	i0	100	0.993174061433447	97	0	99.3	0	292	2	363	459	MBO5876770.1 TolC family protein [Bacteroidales bacterium]	diamond	291	181	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29276359	29276359	PRJNA1001940_S_NODE_162349_length_170_cov_2.834646_g161295_i0	PRJNA1001940	162349	170	2.8346460000000002	4.8188982	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	118	5.28e-33	NR	MBR6065094.1	2748031	g161295	i0	98.2	0.988235294117647	56	1	98.8	0	2	169	39	94	MBR6065094.1 cation transporter [Paludibacteraceae bacterium]	diamond	168	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
29654990	29654990	PRJNA1001940_S_NODE_190070_length_157_cov_1.684211_g189016_i0	PRJNA1001940	190070	157	1.684211	2.64421127	Bacteroidales bacterium	2030927	Bacteria	Bacteria	99.4	3.0299999999999996e-23	NR	MBQ2372957.1	2030927	g189016	i0	100	0.898089171974522	47	0	89.8	0	2	142	296	342	MBQ2372957.1 DUF4837 family protein [Bacteroidales bacterium]	diamond	141	99.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29908170	29908170	PRJNA1001940_S_NODE_143211_length_181_cov_3.992754_g142157_i0	PRJNA1001940	143211	181	3.992754	7.22688474	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	78.2	2e-16	NR	MDD6747873.1	2748031	g142157	i0	66.7	0.845303867403315	51	17	84.5	0	164	12	17	67	MDD6747873.1 transcriptional repressor [Paludibacteraceae bacterium]	diamond	153	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
30002945	30002945	PRJNA1001940_S_NODE_141891_length_182_cov_2.071942_g140837_i0	PRJNA1001940	141891	182	2.071942	3.77093444	Bacteroidales bacterium	2030927	Bacteria	Bacteria	106	4.4900000000000006e-27	NR	MDD6787673.1	2030927	g140837	i0	88.3	0.989010989010989	60	7	98.9	0	1	180	62	121	MDD6787673.1 hypothetical protein [Bacteroidales bacterium]	diamond	180	106	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);;