metadata: contig_metadata: 13 rows where bioproject = "PRJNA630162" and tax

13 rows where bioproject = "PRJNA630162" and tax_clade = "Cruciviruses"

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_species
26764230	26764230	PRJNA630162_P_NODE_50821_length_247_cov_2.590909_g49298_i0	PRJNA630162	50821	247	2.590909	6.39954523	Skomarfal virus 9	3063420	Viruses	Viruses	119	1.22e-30	NR	WPR18616.1	3063420	g49298	i0	71.3	0.97165991902834	80	23	97.2	0	242	3	109	188	WPR18616.1 MAG: capsid protein [Skomarfal virus 9]	diamond	240	119	1	Viruses	Cruciviruses	Skomarfal virus 9
27523017	27523017	PRJNA630162_P_NODE_158423_length_162_cov_2.486726_g156900_i0	PRJNA630162	158423	162	2.486726	4.02849612	Cruciviridae sp.	1955495	Viruses	Viruses	58.2	4.6e-8	NR	AQU11725.1	1955495	g156900	i0	55.8	1.59259259259259	52	23	96.3	0	7	162	283	334	AQU11725.1 capsid protein [Cruciviridae sp.]	diamond	258	58.2	1	Viruses	Cruciviruses	Cruciviridae sp.
28009560	28009560	PRJNA630162_P_NODE_134885_length_168_cov_1.420168_g133362_i0	PRJNA630162	134885	168	1.420168	2.38588224	Viruses	10239	Viruses	Viruses	55.1	5.84e-7	NR	AQU11734.1	1955495	g133362	i0	54.3	1.75	46	20	80.4	1	164	30	236	281	AQU11734.1 capsid protein [Cruciviridae sp.]	diamond	294	55.5	0.992792792792793	Viruses	Cruciviruses	Cruciviridae sp.
29177774	29177774	PRJNA630162_P_NODE_60209_length_227_cov_3.544944_g58686_i0	PRJNA630162	60209	227	3.544944	8.04702288	Viruses	10239	Viruses	Viruses	42.4	0.0409	NR	QMW68670.1	2761222	g58686	i0	51.4	0.951541850220264	35	16	44.9	1	104	3	106	140	QMW68670.1 capsid protein [Crucivirus-133]	diamond	216	42.4	1	Viruses	Cruciviruses	Crucivirus-133
29228328	29228328	PRJNA630162_P_NODE_171949_length_152_cov_3.349515_g170426_i0	PRJNA630162	171949	152	3.349515	5.0912628	Skomarfal virus 9	3063420	Viruses	Viruses	53.1	2.18e-6	NR	WPR18616.1	3063420	g170426	i0	56.3	1.91447368421053	48	21	94.7	0	2	145	57	104	WPR18616.1 MAG: capsid protein [Skomarfal virus 9]	diamond	291	53.1	1	Viruses	Cruciviruses	Skomarfal virus 9
29354515	29354515	PRJNA630162_P_NODE_165729_length_158_cov_3.146789_g164206_i0	PRJNA630162	165729	158	3.146789	4.97192662	Crucivirus sp.	2569971	Viruses	Viruses	65.9	8.04e-11	NR	QKV51304.1	2569971	g164206	i0	73.8	1.59493670886076	42	11	79.7	0	9	134	156	197	QKV51304.1 putative capsid protein [Crucivirus sp.]	diamond	252	65.9	1	Viruses	Cruciviruses	Crucivirus sp.
30315076	30315076	PRJNA630162_P_NODE_171892_length_152_cov_3.601942_g170369_i0	PRJNA630162	171892	152	3.601942	5.47495184	Viruses	10239	Viruses	Viruses	67.4	2.13e-11	NR	AQU11727.1	1955495	g170369	i0	76.6	10.9934210526316	47	11	92.8	0	144	4	187	233	AQU11727.1 capsid protein [Cruciviridae sp.]	diamond	1671	67.4	1	Viruses	Cruciviruses	Cruciviridae sp.
30460206	30460206	PRJNA630162_P_NODE_113313_length_178_cov_1.356589_g111790_i0	PRJNA630162	113313	178	1.356589	2.41472842	Crucivirus sp.	2569971	Viruses	Viruses	69.7	4.78e-12	NR	QKV51215.1	2569971	g111790	i0	64.3	3.7752808988764	56	20	94.4	0	171	4	153	208	QKV51215.1 putative capsid protein [Crucivirus sp.]	diamond	672	69.7	1	Viruses	Cruciviruses	Crucivirus sp.
30554412	30554412	PRJNA630162_P_NODE_117233_length_176_cov_1.314961_g115710_i0	PRJNA630162	117233	176	1.314961	2.31433136	Crucivirus sp.	2569971	Viruses	Viruses	72.8	3.81e-13	NR	QKV51169.1	2569971	g115710	i0	62.3	4.46590909090909	53	20	90.3	0	8	166	148	200	QKV51169.1 putative capsid protein [Crucivirus sp.]	diamond	786	72.8	1	Viruses	Cruciviruses	Crucivirus sp.
31186206	31186206	PRJNA630162_P_NODE_116055_length_176_cov_2.511811_g114532_i0	PRJNA630162	116055	176	2.511811	4.42078736	Skomarfal virus 9	3063420	Viruses	Viruses	72	4.75e-13	NR	WPR18616.1	3063420	g114532	i0	60.4	0.903409090909091	53	21	90.3	0	10	168	16	68	WPR18616.1 MAG: capsid protein [Skomarfal virus 9]	diamond	159	72	1	Viruses	Cruciviruses	Skomarfal virus 9
31376400	31376400	PRJNA630162_P_NODE_147036_length_165_cov_1.413793_g145513_i0	PRJNA630162	147036	165	1.413793	2.33275845	Crucivirus-349	2761280	Viruses	Viruses	68.9	7.09e-12	NR	QMW68814.1	2761280	g145513	i0	61.5	0.945454545454545	52	20	94.5	0	6	161	116	167	QMW68814.1 capsid protein [Crucivirus-349]	diamond	156	68.9	1	Viruses	Cruciviruses	Crucivirus-349
31408098	31408098	PRJNA630162_P_NODE_45396_length_262_cov_4.638498_g43873_i0	PRJNA630162	45396	262	4.638498	12.15286476	Cruciviridae sp.	1955495	Viruses	Viruses	109	1.56e-25	NR	AQU11727.1	1955495	g43873	i0	63.5	1.94656488549618	85	31	97.3	0	258	4	166	250	AQU11727.1 capsid protein [Cruciviridae sp.]	diamond	510	109	1	Viruses	Cruciviruses	Cruciviridae sp.
32167266	32167266	PRJNA630162_P_NODE_120978_length_174_cov_1.360000_g119455_i0	PRJNA630162	120978	174	1.36	2.3664	Crucivirus-1	2761215	Viruses	Viruses	66.2	7.61e-11	NR	QMW68656.1	2761215	g119455	i0	47.5	1.96551724137931	59	29	98.3	1	4	174	241	299	QMW68656.1 capsid protein [Crucivirus-102]	diamond	342	66.2	1	Viruses	Cruciviruses	Crucivirus-102

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