metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax_superkingdom = "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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
27167103	27167103	PRJNA1195551_S_NODE_7622_length_325_cov_12.068841_g7269_i0	PRJNA1195551	7622	325	12.068841	39.22373325	Nanning tick virus 2	2972366	Viruses	Viruses	121	2.86e-29	NR	UYL95418.1	2972366	g7269	i0	52.8	0.996923076923077	108	51	99.7	0	325	2	266	373	UYL95418.1 MAG: RNA-dependent RNA polymerase [Nanning tick virus 2]	diamond	324	121	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae		Nanning tick virus 2
27514839	27514839	PRJNA1195551_S_NODE_483_length_1957_cov_17.714361_g447_i0	PRJNA1195551	483	1957	17.714361	346.67004477	Moloney murine leukemia virus	11801	Viruses	Viruses	1280	0	NR	NP_057933.2	11801	g447	i0	97.8	2.99233520694941	650	14	99.6	0	8	1957	680	1329	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5856	1280	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28114595	28114595	PRJNA1195551_S_NODE_4145_length_419_cov_2.205405_g3792_i0	PRJNA1195551	4145	419	2.205405	9.24064695	Pandoravirus celtis	2568002	Viruses	Viruses	48.5	0.00164	NR	QBZ81330.1	2568002	g3792	i0	35.6	0.522673031026253	73	41	52.3	1	35	253	178	244	QBZ81330.1 hypothetical protein pclt_cds_740 [Pandoravirus celtis]	diamond	219	48.5	1	Viruses						Pandoravirus	Pandoravirus celtis
28146503	28146503	PRJNA1195551_S_NODE_32645_length_178_cov_1.255814_g32292_i0	PRJNA1195551	32645	178	1.255814	2.23534892	Murid betaherpesvirus 1	10366	Viruses	Viruses	41.6	0.0408	NR	AWV68369.1	10366	g32292	i0	50	0.606741573033708	36	18	60.7	0	154	47	344	379	AWV68369.1 m117.1 protein [Murid betaherpesvirus 1]	diamond	108	41.6	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Muromegalovirus	Muromegalovirus muridbeta1
31558032	31558032	PRJNA1195551_S_NODE_43516_length_155_cov_2.679245_g43163_i0	PRJNA1195551	43516	155	2.679245	4.15282975	Pandoravirus macleodensis	2107707	Viruses	Viruses	41.2	0.0394	NR	YP_009480761.1	2107707	g43163	i0	43.6	0.754838709677419	39	22	75.5	0	12	128	228	266	YP_009480761.1 hypothetical protein pmac_cds_77 [Pandoravirus macleodensis]	diamond	117	41.2	1	Viruses						Pandoravirus	Pandoravirus macleodensis
31779109	31779109	PRJNA1195551_S_NODE_38197_length_166_cov_2.102564_g37844_i0	PRJNA1195551	38197	166	2.102564	3.49025624	Pimephales minnow adintovirus	2609864	Viruses	Viruses	58.2	2.82e-8	NR	DAC81394.1	2609864	g37844	i0	69.4	0.650602409638554	36	11	65.1	0	108	1	7	42	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	diamond	108	58.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
32903860	32903860	PRJNA1195551_S_NODE_14680_length_255_cov_1.514563_g14327_i0	PRJNA1195551	14680	255	1.514563	3.86213565	Microvirus	10842	Viruses	Viruses	150	1.58e-40	NR	DAF98539.1	2825010	g14327	i0	80	2	85	17	100	0	255	1	354	438	DAF98539.1 MAG TPA: Major capsid protein [Microviridae sp. ctuZ46]	diamond	510	150	1	Viruses	Sangervirae	Phixviricota	Malgrandaviricetes	Petitvirales	Microviridae		Microviridae sp. ctuZ46

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