metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1063685" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1063685" and tax_phylum = "Ignavibacteriota"

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
14208125	14208125	PRJNA1063685_S_NODE_23272_length_480_cov_1.275184_g22732_i0	PRJNA1063685	23272	480	1.275184	6.1208832	Bacteria	2	Bacteria	Bacteria	209	5e-62	NR	OLD60255.1	1805219	g22732	i0	59.1	19.2	154	63	96.3	0	478	17	155	308	OLD60255.1 MAG: glutamate--tRNA ligase, partial [Ignavibacteria bacterium 13_1_40CM_2_61_4]	diamond	9216	209	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium 13_1_40CM_2_61_4
27003677	27003677	PRJNA1063685_S_NODE_26902_length_452_cov_1.482850_g26361_i0	PRJNA1063685	26902	452	1.48285	6.702482	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	127	1.37e-30	NR	MFA6978190.1	2651163	g26361	i0	43.8	2.01769911504425	146	78	94.2	2	427	2	886	1031	MFA6978190.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	912	127	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27415064	27415064	PRJNA1063685_S_NODE_70063_length_250_cov_1.468927_g69520_i0	PRJNA1063685	70063	250	1.468927	3.6723175	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	78.2	1.13e-14	NR	HMQ69735.1	2053306	g69520	i0	53.6	0.828	69	28	78	1	238	44	161	229	HMQ69735.1 hypothetical protein [Ignavibacteria bacterium]	diamond	207	78.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
28235420	28235420	PRJNA1063685_S_NODE_42826_length_353_cov_5.953571_g42283_i0	PRJNA1063685	42826	353	5.953571	21.01610563	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	136	2.15e-34	NR	MBV6443925.1	2651163	g42283	i0	64.2	0.926345609065156	109	39	92.6	0	329	3	446	554	MBV6443925.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	327	136	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
29466736	29466736	PRJNA1063685_S_NODE_5530_length_718_cov_4.741085_g5077_i0	PRJNA1063685	5530	718	4.741085	34.0409903	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	48.1	0.0151	NR	MBM4179868.1	2053306	g5077	i0	35.6	0.363509749303621	87	46	32.2	3	323	93	225	311	MBM4179868.1 hypothetical protein [Ignavibacteria bacterium]	diamond	261	48.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30098561	30098561	PRJNA1063685_S_NODE_2852_length_828_cov_10.174834_g2470_i0	PRJNA1063685	2852	828	10.174834	84.24762552	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	55.8	1.06e-5	NR	MCX7908948.1	2053306	g2470	i0	30.7	1.50724637681159	137	66	47.8	4	587	192	31	143	MCX7908948.1 Hsp20/alpha crystallin family protein [Ignavibacteria bacterium]	diamond	1248	55.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30257040	30257040	PRJNA1063685_S_NODE_23812_length_475_cov_12.552239_g23272_i0	PRJNA1063685	23812	475	12.552239	59.62313525	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	82.4	5.73e-15	NR	MBK9331464.1	2053306	g23272	i0	34.8	1.78105263157895	135	81	81.5	3	26	412	297	430	MBK9331464.1 metallophosphoesterase [Ignavibacteria bacterium]	diamond	846	82.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30288656	30288656	PRJNA1063685_S_NODE_20812_length_502_cov_5.153846_g20274_i0	PRJNA1063685	20812	502	5.153846	25.87230692	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	65.9	8.99e-11	NR	MCB0711289.1	2026749	g20274	i0	41	0.466135458167331	78	45	46	1	84	314	8	85	MCB0711289.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	234	65.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
32090269	32090269	PRJNA1063685_S_NODE_38578_length_376_cov_1.864686_g38035_i0	PRJNA1063685	38578	376	1.864686	7.01121936	Melioribacter sp.	2052167	Bacteria	Bacteria	99.4	2.5299999999999998e-24	NR	NJD21331.1	2052167	g38035	i0	58.3	1.61968085106383	96	40	76.6	0	66	353	2	97	NJD21331.1 hypothetical protein [Melioribacter sp.]	diamond	609	99.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter sp.
32596466	32596466	PRJNA1063685_S_NODE_39520_length_371_cov_1.808725_g38977_i0	PRJNA1063685	39520	371	1.808725	6.71036975	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	235	4.31e-72	NR	MDD5361129.1	2053306	g38977	i0	88.6	1.98921832884097	123	14	99.5	0	369	1	92	214	MDD5361129.1 amidohydrolase [Ignavibacteria bacterium]	diamond	738	235	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;