metadata: contig_metadata: 6 rows where analysis = "diamond" and tax

6 rows where analysis = "diamond" and tax_clade = "CRESS viruses"

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_species
27600326	27600326	PRJNA800053_P_NODE_2964_length_506_cov_2.665127_g2804_i0	PRJNA800053	2964	506	2.665127	13.48554262	Viruses	10239	Viruses	Viruses	46.2	0.0258	NR	QIN94940.1	2709778	g2804	i0	31.3	1.56521739130435	96	63	56.3	2	484	200	163	256	QIN94940.1 MAG: capsid protein [Forsythia suspensa CRESS virus]	diamond	792	46.2	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	Forsythia suspensa CRESS virus
27843597	27843597	PRJNA800053_P_NODE_1404_length_684_cov_6.240589_g1257_i0	PRJNA800053	1404	684	6.240589	42.68562876	Trichosanthes kirilowii CRESS virus	2740170	Viruses	Viruses	51.2	0.00153	NR	QKI29005.1	2740170	g1257	i0	33.8	0.324561403508772	74	49	32.5	0	235	14	133	206	QKI29005.1 Cap [Trichosanthes kirilowii CRESS virus]	diamond	222	51.2	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	Trichosanthes kirilowii CRESS virus
28681836	28681836	PRJNA1148190_P_NODE_330767_length_307_cov_3.598291_g319594_i0	PRJNA1148190	330767	307	3.598291	11.04675337	Kummerowia striata CRESS virus	2740167	Viruses	Viruses	121	1.9499999999999999e-31	NR	QKI29027.1	2740167	g319594	i0	63.9	0.811074918566775	83	30	81.1	0	3	251	179	261	QKI29027.1 Cap [Kummerowia striata CRESS virus]	diamond	249	121	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	Kummerowia striata CRESS virus
30180368	30180368	PRJNA800053_P_NODE_492_length_1054_cov_13.013252_g397_i0	PRJNA800053	492	1054	13.013252	137.15967608	Forsythia suspensa CRESS virus	2709778	Viruses	Viruses	218	8.16e-65	NR	QKI28988.1	2709778	g397	i0	41.5	0.816888045540797	287	158	79.1	5	1040	207	34	319	QKI28988.1 Rep [Forsythia suspensa CRESS virus]	diamond	861	218	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	Forsythia suspensa CRESS virus
31022869	31022869	PRJNA379145_P_NODE_4175_length_1442_cov_70.339957_g3645_i0	PRJNA379145	4175	1442	70.339957	1014.30217994	Lactuca sativa CRESS virus	2709779	Viruses	Viruses	266	2.4699999999999995e-82	NR	QIN94950.1	2709779	g3645	i0	68.3	0.393203883495146	189	60	39.3	0	600	34	93	281	QIN94950.1 MAG: capsid protein [Lactuca sativa CRESS virus]	diamond	567	266	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	Lactuca sativa CRESS virus
31896163	31896163	PRJNA784979_S_NODE_1137_length_487_cov_1.835616_g1095_i0	PRJNA784979	1137	487	1.835616	8.93944992	Viruses	10239	Viruses	Viruses	107	9.36e-25	NR	QGH73619.1	2656678	g1095	i0	37.2	2.87679671457906	164	92	94.9	3	18	479	4	166	QGH73619.1 MAG: Rep protein [CRESS virus sp. ctWOo3]	diamond	1401	107	1	Viruses	CRESS viruses	Shotokuvirae	Cressdnaviricota	CRESS virus sp. ctWOo3

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