metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_phylum = "Calditrichota"

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
10359985	10359985	PRJNA1011844_P_NODE_25229_length_1085_cov_4.975296_g19247_i0	PRJNA1011844	25229	1085	4.975296	53.9819616	Caldithrix abyssi	187145	Bacteria	Bacteria	131	6.36e-30	NR	WP_006927233.1	187145	g19247	i0	28.7	0.934562211981567	338	181	92.4	10	75	1076	44	325	WP_006927233.1 GxGYxYP domain-containing protein [Caldithrix abyssi]	diamond	1014	131	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
27635107	27635107	PRJNA1011844_P_NODE_100704_length_325_cov_2.111111_g92134_i0	PRJNA1011844	100704	325	2.111111	6.86111075	Calditrichota bacterium	2212469	Bacteria	Bacteria	105	2.01e-24	NR	MCB0283442.1	2212469	g92134	i0	71.9	1.2	64	18	59.1	0	130	321	112	175	MCB0283442.1 thiolase family protein [Calditrichota bacterium]	diamond	390	105	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28266357	28266357	PRJNA1011844_P_NODE_60326_length_524_cov_8.026608_g51933_i0	PRJNA1011844	60326	524	8.026608	42.05942592	Calditrichota bacterium	2212469	Bacteria	Bacteria	68.6	2.49e-10	NR	MCB0258994.1	2212469	g51933	i0	35.2	1.31679389312977	125	72	71.6	4	377	3	92	207	MCB0258994.1 alpha/beta fold hydrolase [Calditrichota bacterium]	diamond	690	68.6	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
29710875	29710875	PRJNA1011844_P_NODE_173070_length_222_cov_4.053691_g164489_i0	PRJNA1011844	173070	222	4.053691	8.99919402	Bacteria	2	Bacteria	Bacteria	64.7	5.41e-10	NR	NOX38147.1	2212469	g164489	i0	50	3.45945945945946	64	32	86.5	0	192	1	1008	1071	NOX38147.1 amino acid adenylation domain-containing protein [Calditrichota bacterium]	diamond	768	65.1	0.993855606758833	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
29869166	29869166	PRJNA1011844_P_NODE_123011_length_279_cov_1.888350_g114434_i0	PRJNA1011844	123011	279	1.88835	5.2684965	Bacteria	2	Bacteria	Bacteria	112	8.66e-27	NR	KAA3603901.1	2212469	g114434	i0	58.1	5.59139784946237	86	36	92.5	0	11	268	284	369	KAA3603901.1 MAG: proline--tRNA ligase [Calditrichota bacterium]	diamond	1560	112	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30477249	30477249	PRJNA1011844_P_NODE_178393_length_204_cov_2.923664_g169811_i0	PRJNA1011844	178393	204	2.923664	5.96427456	Caldithrix sp. RBG_13_44_9	1797576	Bacteria	Bacteria	57.8	9.61e-9	NR	OGB65894.1	1797576	g169811	i0	62.5	1.14705882352941	40	15	58.8	0	184	65	11	50	OGB65894.1 MAG: RNA-binding protein [Caldithrix sp. RBG_13_44_9]	diamond	234	57.8	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix sp. RBG_13_44_9
30501038	30501038	PRJNA1011844_P_NODE_23073_length_1149_cov_4.923792_g17449_i0	PRJNA1011844	23073	1149	4.923792	56.57437008	Pseudomonadati	3379134	Bacteria	Bacteria	159	9.22e-41	NR	HGY57143.1	187145	g17449	i0	39	5.93211488250653	231	123	59.8	5	16	702	198	412	HGY57143.1 DUF1015 domain-containing protein [Caldithrix abyssi]	diamond	6816	159	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
31393824	31393824	PRJNA1011844_P_NODE_74396_length_428_cov_3.966197_g65904_i0	PRJNA1011844	74396	428	3.966197	16.97532316	Calditrichota bacterium	2212469	Bacteria	Bacteria	46.6	0.0123	NR	MFC2170384.1	2212469	g65904	i0	34.6	0.546728971962617	78	49	54	2	122	352	66	142	MFC2170384.1 glycosyltransferase [Calditrichota bacterium]	diamond	234	46.6	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota 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);;