metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_kingdom = "Orthornavirae"

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_species
27106168	27106168	PRJNA340009_P_NODE_52802_length_179_cov_1.569231_g52495_i0	PRJNA340009	52802	179	1.569231	2.80892349	Ripofruz virus	3130512	Viruses	Viruses	51.6	1.16e-5	NR	WZH59774.1	3130512	g52495	i0	45.6	0.955307262569832	57	27	88.8	1	178	20	7	63	WZH59774.1 MAG: putative capsid protein [Ripofruz virus]	diamond	171	51.6	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Ripofruz virus
27327642	27327642	PRJNA340009_P_NODE_28583_length_232_cov_1.005464_g28276_i0	PRJNA340009	28583	232	1.005464	2.33267648	Qianjiang hepeli-like virus 17	3348979	Viruses	Viruses	107	3.05e-25	NR	XHA85837.1	3348979	g28276	i0	79.7	0.827586206896552	64	13	82.8	0	230	39	305	368	XHA85837.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 17]	diamond	192	107	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 17
28748467	28748467	PRJNA340009_P_NODE_68907_length_164_cov_0.886957_g68600_i0	PRJNA340009	68907	164	0.886957	1.45460948	Iflaviridae sp.	1955145	Viruses	Viruses	48.1	1.59e-4	NR	XCO48761.1	1955145	g68600	i0	45.2	0.768292682926829	42	23	76.8	0	1	126	319	360	XCO48761.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.]	diamond	126	48.1	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae	Iflaviridae sp.
29159091	29159091	PRJNA340009_P_NODE_40709_length_200_cov_1.006623_g40402_i0	PRJNA340009	40709	200	1.006623	2.013246	Qianjiang hepeli-like virus 17	3348979	Viruses	Viruses	78.6	5.03e-15	NR	XHA85836.1	3348979	g40402	i0	51.6	0.96	64	31	96	0	194	3	780	843	XHA85836.1 MAG: polyprotein [Qianjiang hepeli-like virus 17]	diamond	192	78.6	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 17
30169346	30169346	PRJNA340009_P_NODE_54492_length_176_cov_55.244094_g54185_i0	PRJNA340009	54492	176	55.244094	97.22960544	Chronagark virus	3129972	Viruses	Viruses	68.6	1.16e-11	NR	WZH59040.1	3129972	g54185	i0	57.1	1.90909090909091	56	24	95.5	0	9	176	323	378	WZH59040.1 MAG: RNA-dependent RNA polymerase, partial [Chronagark virus]	diamond	336	68.6	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Chronagark virus
30232652	30232652	PRJNA340009_P_NODE_22672_length_256_cov_1.111111_g22365_i0	PRJNA340009	22672	256	1.111111	2.84444416	Qianjiang hepeli-like virus 17	3348979	Viruses	Viruses	98.2	1.4e-21	NR	XHA85836.1	3348979	g22365	i0	56.6	0.97265625	83	36	97.3	0	249	1	65	147	XHA85836.1 MAG: polyprotein [Qianjiang hepeli-like virus 17]	diamond	249	98.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 17
30660662	30660662	PRJNA340009_P_NODE_70193_length_163_cov_23.973684_g69886_i0	PRJNA340009	70193	163	23.973684	39.07710492	Viruses	10239	Viruses	Viruses	85.9	7.99e-18	NR	UUV42151.1	2971793	g69886	i0	69.2	1.93251533742331	52	16	95.7	0	2	157	1405	1456	UUV42151.1 MAG: nonstructural protein [Macrobrachium rosenbergii virus 8]	diamond	315	86.7	0.990772779700115	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Macrobrachium rosenbergii virus 8
30738075	30738075	PRJNA340009_P_NODE_12994_length_325_cov_1.630435_g12687_i0	PRJNA340009	12994	325	1.630435	5.29891375	Tolivirales sp.	2809914	Viruses	Viruses	167	2.38e-48	NR	XOE99483.1	2809914	g12687	i0	71	1.97538461538462	107	31	98.8	0	325	5	159	265	XOE99483.1 MAG: hypothetical protein, partial [Tolivirales sp.]	diamond	642	167	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales		Tolivirales sp.
31623305	31623305	PRJNA340009_P_NODE_64536_length_166_cov_0.871795_g64229_i0	PRJNA340009	64536	166	0.871795	1.4471797	Flumine Astrovirus 22	2940951	Viruses	Viruses	47	4.15e-4	NR	UQB75984.1	2940951	g64229	i0	42.6	0.975903614457831	54	30	97.6	1	166	5	213	265	UQB75984.1 RNA-dependent RNA polymerase [Flumine Astrovirus 22]	diamond	162	47	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Flumine Astrovirus 22
31939550	31939550	PRJNA340009_P_NODE_67697_length_165_cov_0.879310_g67390_i0	PRJNA340009	67697	165	0.87931	1.4508615	Mayzas noda-like virus	2929641	Viruses	Viruses	76.3	1.63e-14	NR	UQE85432.1	2929641	g67390	i0	69.1	1	55	14	94.5	1	8	163	120	174	UQE85432.1 putative capsid protein [Mayzas noda-like virus]	diamond	165	76.3	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Mayzas noda-like virus
32572705	32572705	PRJNA340009_P_NODE_69599_length_164_cov_0.886957_g69292_i0	PRJNA340009	69599	164	0.886957	1.45460948	Nodaviridae sp.	1955166	Viruses	Viruses	44.3	0.00367	NR	USC30115.1	1955166	g69292	i0	33.3	2.96341463414634	54	36	98.8	0	1	162	314	367	USC30115.1 MAG: putative RNA-dependent RNA polymerase, partial [Nodaviridae sp.]	diamond	486	44.3	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Nodaviridae 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);;