metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_superkingdom = "Bacteria"

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
6083785	6083785	PRJNA999747_S_NODE_585_length_355_cov_2.435185_g553_i0	PRJNA999747	585	355	2.435185	8.64490675	Lactovum miscens	190387	Bacteria	Bacteria	220	8.96e-71	NR	WP_331035919.1	190387	g553	i0	96.4	0.938028169014084	111	4	93.8	0	6	338	96	206	WP_331035919.1 SGNH/GDSL hydrolase family protein [Lactovum miscens]	diamond	333	220	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactovum	Lactovum miscens
14027989	14027989	PRJNA999747_S_NODE_11_length_1259_cov_11.333876_g9_i0	PRJNA999747	11	1259	11.333876	142.69349884	Deinococcus multiflagellatus	1656887	Bacteria	Bacteria	308	2.8199999999999993e-96	NR	WP_224605023.1	1656887	g9	i0	51.9	0.822081016679905	345	156	82.2	3	1157	123	52	386	WP_224605023.1 S8 family peptidase [Deinococcus multiflagellatus]	diamond	1035	308	1	Bacteria		Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus multiflagellatus
26646395	26646395	PRJNA999747_S_NODE_1881_length_220_cov_3.518519_g1849_i0	PRJNA999747	1881	220	3.518519	7.7407418	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	95.5	1.1199999999999999e-23	NR	NOZ88117.1	2026735	g1849	i0	60.6	2.89090909090909	71	28	96.8	0	214	2	2	72	NOZ88117.1 RNA-binding protein [Deltaproteobacteria bacterium]	diamond	636	95.5	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28479365	28479365	PRJNA999747_S_NODE_3746_length_163_cov_2.560606_g3714_i0	PRJNA999747	3746	163	2.560606	4.17378778	Lactovum miscens	190387	Bacteria	Bacteria	116	2.24e-31	NR	WP_414672544.1	190387	g3714	i0	100	0.975460122699387	53	0	97.5	0	5	163	21	73	WP_414672544.1 SGNH/GDSL hydrolase family protein [Lactovum miscens]	diamond	159	116	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactovum	Lactovum miscens
29022274	29022274	PRJNA999747_S_NODE_4348_length_153_cov_1.819672_g4316_i0	PRJNA999747	4348	153	1.819672	2.78409816	root	1	Root_unresolved	Root_unresolved	79.3	7.73e-17	NR	WP_069817073.1	549819	g4316	i0	74.5	9.82352941176471	47	12	92.2	0	9	149	94	140	WP_069817073.1 hypothetical protein [Streptomyces sp. TP-A0874]	diamond	1503	79.3	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. TP-A0874
29205719	29205719	PRJNA999747_S_NODE_4509_length_150_cov_4.470588_g4477_i0	PRJNA999747	4509	150	4.470588	6.705882	Evansella halocellulosilytica	2011013	Bacteria	Bacteria	41.6	0.0267	NR	WP_218839267.1	2011013	g4477	i0	42.5	0.8	40	23	80	0	143	24	397	436	WP_218839267.1 glycosyl hydrolase family 18 protein [Evansella halocellulosilytica]	diamond	120	41.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Evansella	Evansella halocellulosilytica
29584097	29584097	PRJNA999747_S_NODE_1990_length_215_cov_3.576087_g1958_i0	PRJNA999747	1990	215	3.576087	7.68858705	Porphyromonas gingivalis F	837	Bacteria	Bacteria	78.2	2.56e-17	NR	ERJ68952.1	1227271	g1958	i0	100	3	35	0	48.8	0	110	214	1	35	ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570]	diamond	645	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
30437540	30437540	PRJNA999747_S_NODE_1993_length_215_cov_2.869565_g1961_i0	PRJNA999747	1993	215	2.869565	6.16956475	Mangrovibacterium diazotrophicum	1261403	Bacteria	Bacteria	42	0.0498	NR	WP_170154523.1	1261403	g1961	i0	36.4	0.92093023255814	66	40	92.1	1	1	198	92	155	WP_170154523.1 G8 domain-containing protein [Mangrovibacterium diazotrophicum]	diamond	198	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Mangrovibacterium	Mangrovibacterium diazotrophicum
30664276	30664276	PRJNA999747_S_NODE_2253_length_204_cov_2.473988_g2221_i0	PRJNA999747	2253	204	2.473988	5.04693552	Prevotellaceae	171552	Bacteria	Bacteria	43.9	0.00479	NR	EFC67102.1	575615	g2221	i0	59	2.35294117647059	39	16	57.4	0	204	88	56	94	EFC67102.1 LOW QUALITY PROTEIN: hypothetical protein HMPREF0670_02906, partial [Prevotella sp. oral taxon 317 str. F0108]	diamond	480	44.3	0.99097065462754	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 317
31005963	31005963	PRJNA999747_S_NODE_414_length_403_cov_3.661290_g382_i0	PRJNA999747	414	403	3.66129	14.7549987	Anaerolineales bacterium	2073117	Bacteria	Bacteria	79	1.88e-14	NR	TEU08213.1	2073117	g382	i0	44	0.558312655086849	75	42	55.8	0	11	235	66	140	TEU08213.1 MAG: hypothetical protein E3J25_12350, partial [Anaerolineales bacterium]	diamond	225	79	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32492776	32492776	PRJNA999747_S_NODE_2679_length_190_cov_1.729560_g2647_i0	PRJNA999747	2679	190	1.72956	3.286164	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.5	0.00894	NR	MEI9917451.1	1898104	g2647	i0	43.6	0.868421052631579	55	29	83.7	2	169	11	44	98	MEI9917451.1 DUF4114 domain-containing protein [Bacteroidota bacterium]	diamond	165	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32618875	32618875	PRJNA999747_S_NODE_2600_length_192_cov_2.919255_g2568_i0	PRJNA999747	2600	192	2.919255	5.6049696	Novosphingobium sp.	1874826	Bacteria	Bacteria	57	1.73e-7	NR	MCK9544286.1	1874826	g2568	i0	42.6	0.84375	54	31	84.4	0	164	3	158	211	MCK9544286.1 peroxidase family protein [Novosphingobium sp.]	diamond	162	57	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp.

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