metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax_phylum = "Uroviricota"

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_species
16991234	16991234	PRJNA400171_S_NODE_2274_length_259_cov_2.869565_g2184_i0	PRJNA400171	2274	259	2.869565	7.43217335	Caudoviricetes sp.	2832643	Viruses	Viruses	112	3.56e-28	NR	XOS60640.1	2832643	g2184	i0	73.8	0.972972972972973	84	22	97.3	0	254	3	11	94	XOS60640.1 MAG: hypothetical protein MSP0234_87 [Caudoviricetes sp.]	diamond	252	112	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
19539520	19539520	PRJNA400171_S_NODE_416_length_454_cov_3.402353_g327_i0	PRJNA400171	416	454	3.402353	15.44668262	Caudoviricetes sp.	2832643	Viruses	Viruses	204	6.79e-58	NR	XOR25440.1	2832643	g327	i0	73.3	1.98237885462555	150	40	99.1	0	452	3	171	320	XOR25440.1 MAG: gp187 protein [Caudoviricetes sp.]	diamond	900	204	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
26726859	26726859	PRJNA400171_S_NODE_6221_length_179_cov_2.766667_g6131_i0	PRJNA400171	6221	179	2.766667	4.95233393	Caudoviricetes sp.	2832643	Viruses	Viruses	42.4	0.00755	NR	XOR79739.1	2832643	g6131	i0	63	0.452513966480447	27	9	45.3	1	82	162	1	26	XOR79739.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	81	42.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
27391663	27391663	PRJNA400171_S_NODE_943_length_345_cov_3.284810_g853_i0	PRJNA400171	943	345	3.28481	11.3325945	Caudoviricetes sp.	2832643	Viruses	Viruses	133	1.19e-37	NR	XOS60614.1	2832643	g853	i0	80.8	0.678260869565217	78	15	67.8	0	111	344	1	78	XOS60614.1 MAG: hypothetical protein MSP0234_61 [Caudoviricetes sp.]	diamond	234	133	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
27644312	27644312	PRJNA400171_S_NODE_6944_length_171_cov_3.049296_g6854_i0	PRJNA400171	6944	171	3.049296	5.21429616	Caudoviricetes sp.	2832643	Viruses	Viruses	64.7	2.57e-11	NR	XOR79738.1	2832643	g6854	i0	65.4	1.85964912280702	52	11	78.9	1	167	33	94	145	XOR79738.1 MAG: crossover junction endodeoxyribonuclease rusA [Caudoviricetes sp.]	diamond	318	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
27739166	27739166	PRJNA400171_S_NODE_4944_length_196_cov_2.826347_g4854_i0	PRJNA400171	4944	196	2.826347	5.53964012	Caudoviricetes sp.	2832643	Viruses	Viruses	45.4	4.02e-4	NR	XOR23014.1	2832643	g4854	i0	50	0.489795918367347	32	13	49	1	175	80	60	88	XOR23014.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	96	45.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
28433499	28433499	PRJNA400171_S_NODE_8366_length_158_cov_2.558140_g8276_i0	PRJNA400171	8366	158	2.55814	4.0418612	Caudoviricetes sp.	2832643	Viruses	Viruses	97.1	4.55e-24	NR	XOS60613.1	2832643	g8276	i0	82.7	0.987341772151899	52	9	98.7	0	158	3	65	116	XOS60613.1 MAG: tail-component protein [Caudoviricetes sp.]	diamond	156	97.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
29790939	29790939	PRJNA400171_S_NODE_6051_length_181_cov_4.019737_g5961_i0	PRJNA400171	6051	181	4.019737	7.27572397	Caudoviricetes sp.	2832643	Viruses	Viruses	93.6	9.38e-23	NR	DAL14413.1	2832643	g5961	i0	76.7	0.994475138121547	60	14	99.4	0	180	1	10	69	DAL14413.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.]	diamond	180	93.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
29854342	29854342	PRJNA400171_S_NODE_4871_length_197_cov_3.119048_g4781_i0	PRJNA400171	4871	197	3.119048	6.14452456	Microbacterium phage Evcara	3241072	Viruses	Viruses	40.8	0.011	NR	XGU07829.1	3241072	g4781	i0	46.2	0.791878172588833	52	25	79.2	1	193	38	1	49	XGU07829.1 hypothetical protein SEA_EVCARA_21 [Microbacterium phage Evcara]	diamond	156	40.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Microbacterium phage Evcara
29980677	29980677	PRJNA400171_S_NODE_411_length_456_cov_2.716628_g322_i0	PRJNA400171	411	456	2.716628	12.38782368	Caudoviricetes sp.	2832643	Viruses	Viruses	127	5.07e-34	NR	XOR22969.1	2832643	g322	i0	56.3	0.782894736842105	119	49	78.3	1	29	385	58	173	XOR22969.1 MAG: Gp52 protein [Caudoviricetes sp.]	diamond	357	127	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
30612400	30612400	PRJNA400171_S_NODE_8693_length_155_cov_4.015873_g8603_i0	PRJNA400171	8693	155	4.015873	6.22460315	Caudoviricetes sp.	2832643	Viruses	Viruses	46.6	4.92e-4	NR	XOR22972.1	2832643	g8603	i0	66.7	0.638709677419355	33	11	63.9	0	55	153	871	903	XOR22972.1 MAG: gp186 protein [Caudoviricetes sp.]	diamond	99	46.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
32130403	32130403	PRJNA400171_S_NODE_7958_length_162_cov_1.924812_g7868_i0	PRJNA400171	7958	162	1.924812	3.11819544	Caudoviricetes sp.	2832643	Viruses	Viruses	87	2.71e-18	NR	XOR83630.1	2832643	g7868	i0	65.4	2.90740740740741	52	18	96.3	0	5	160	263	314	XOR83630.1 MAG: Int [Caudoviricetes sp.]	diamond	471	87	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
32288785	32288785	PRJNA400171_S_NODE_2319_length_258_cov_2.305677_g2229_i0	PRJNA400171	2319	258	2.305677	5.94864666	Caudoviricetes sp.	2832643	Viruses	Viruses	84.3	1.47e-18	NR	XOS60642.1	2832643	g2229	i0	52.3	0.755813953488372	65	30	75.6	1	258	64	75	138	XOS60642.1 MAG: hypothetical protein MSP0234_89 [Caudoviricetes sp.]	diamond	195	84.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
32320410	32320410	PRJNA400171_S_NODE_5659_length_186_cov_2.777070_g5569_i0	PRJNA400171	5659	186	2.77707	5.1653502	Caudoviricetes sp.	2832643	Viruses	Viruses	123	1.7e-32	NR	XOR22959.1	2832643	g5569	i0	87.1	1	62	8	100	0	186	1	158	219	XOR22959.1 MAG: phage head morphogenesis protein [Caudoviricetes sp.]	diamond	186	123	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
32667508	32667508	PRJNA400171_S_NODE_3840_length_215_cov_3.150538_g3750_i0	PRJNA400171	3840	215	3.150538	6.7736567	Caudoviricetes sp.	2832643	Viruses	Viruses	44.3	0.00306	NR	XOS60642.1	2832643	g3750	i0	55.9	0.948837209302326	34	15	47.4	0	111	212	51	84	XOS60642.1 MAG: hypothetical protein MSP0234_89 [Caudoviricetes sp.]	diamond	204	44.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
32887853	32887853	PRJNA400171_S_NODE_8760_length_155_cov_2.380952_g8670_i0	PRJNA400171	8760	155	2.380952	3.6904756	Caudoviricetes sp.	2832643	Viruses	Viruses	79.7	1.03e-15	NR	XOR25440.1	2832643	g8670	i0	74.5	0.987096774193548	51	13	98.7	0	1	153	502	552	XOR25440.1 MAG: gp187 protein [Caudoviricetes sp.]	diamond	153	79.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes 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);;