metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA453111" and tax_kingdom = "Bacillati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
22117974	22117974	PRJNA453111_P_NODE_658_length_1009_cov_1.802350_g598_i0	PRJNA453111	658	1009	1.80235	18.1857115	Enterococcus	1350	Bacteria	Bacteria	390	8.249999999999998e-132	NR	WP_413133017.1	37734	g598	i0	56.7	3.00891972249752	337	133	96.3	2	2	973	29	365	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	3036	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
27123620	27123620	PRJNA453111_P_NODE_10182_length_251_cov_0.814607_g10090_i0	PRJNA453111	10182	251	0.814607	2.04466357	Brevibacterium	1696	Bacteria	Bacteria	43.1	0.0277	NR	WP_332839751.1	946573	g10090	i0	51.4	1.32669322709163	37	17	43	1	236	129	210	246	WP_332839751.1 glycosyltransferase family 2 protein [Brevibacterium yomogidense]	diamond	333	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium yomogidense
27913410	27913410	PRJNA453111_P_NODE_6345_length_321_cov_1.862903_g6253_i0	PRJNA453111	6345	321	1.862903	5.97991863	Enterococcus	1350	Bacteria	Bacteria	124	9.619999999999999e-32	NR	WP_413133017.1	37734	g6253	i0	55.8	1.94392523364486	104	45	97.2	1	3	314	206	308	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	624	125	0.992	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
28402538	28402538	PRJNA453111_P_NODE_8026_length_286_cov_0.995305_g7934_i0	PRJNA453111	8026	286	0.995305	2.8465723	Clostridia bacterium	2044939	Bacteria	Bacteria	44.7	0.0139	NR	QRN85737.1	2044939	g7934	i0	34.8	0.692307692307692	66	37	62.9	1	56	235	235	300	QRN85737.1 InlB B-repeat-containing protein [Clostridia bacterium]	diamond	198	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28686971	28686971	PRJNA453111_P_NODE_12687_length_242_cov_1.366864_g12595_i0	PRJNA453111	12687	242	1.366864	3.30781088	Enterococcus mundtii	53346	Bacteria	Bacteria	48.9	2.35e-4	NR	WP_010736445.1	53346	g12595	i0	35.7	3.47107438016529	70	45	86.8	0	213	4	22	91	WP_010736445.1 pectate lyase family protein [Enterococcus mundtii]	diamond	840	48.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus mundtii
29002892	29002892	PRJNA453111_P_NODE_12648_length_243_cov_0.894118_g12556_i0	PRJNA453111	12648	243	0.894118	2.17270674	Dactylosporangium fulvum	53359	Bacteria	Bacteria	42.7	0.0363	NR	WP_259862636.1	53359	g12556	i0	40	0.679012345679012	55	28	61.7	1	48	197	443	497	WP_259862636.1 HNH endonuclease signature motif containing protein [Dactylosporangium fulvum]	diamond	165	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium fulvum
29223649	29223649	PRJNA453111_P_NODE_12589_length_243_cov_0.905882_g12497_i0	PRJNA453111	12589	243	0.905882	2.20129326	Actinokineospora auranticolor	155976	Bacteria	Bacteria	42.4	0.0477	NR	PPK65354.1	155976	g12497	i0	31.2	0.950617283950617	77	52	93.8	1	243	16	23	99	PPK65354.1 hypothetical protein CLV40_1146 [Actinokineospora auranticolor]	diamond	231	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora auranticolor
29444234	29444234	PRJNA453111_P_NODE_1410_length_694_cov_1.621578_g1322_i0	PRJNA453111	1410	694	1.621578	11.25375132	Melissococcus plutonius	33970	Bacteria	Bacteria	130	7.26e-32	NR	WP_231849637.1	33970	g1322	i0	44.6	1.45244956772334	168	88	70.5	1	493	5	35	202	WP_231849637.1 pectate lyase family protein [Melissococcus plutonius]	diamond	1008	130	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
32415787	32415787	PRJNA453111_P_NODE_12899_length_242_cov_0.911243_g12807_i0	PRJNA453111	12899	242	0.911243	2.20520806	Nesterenkonia massiliensis	1232429	Bacteria	Bacteria	147	5.93e-39	NR	WP_044494056.1	1232429	g12807	i0	97.5	0.991735537190083	80	2	99.2	0	242	3	324	403	WP_044494056.1 UvrD-helicase domain-containing protein [Nesterenkonia massiliensis]	diamond	240	147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia massiliensis

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