metadata: contig_metadata: 8 rows where bioproject = "PRJNA340009", tax_phylum = "Kitrinoviricota" and tax

8 rows where bioproject = "PRJNA340009", tax_phylum = "Kitrinoviricota" 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_species
23344265	23344265	PRJNA340009_P_NODE_53119_length_178_cov_100.441860_g52812_i0	PRJNA340009	53119	178	100.44186	178.7865108	Tombusviridae sp.	2583950	Viruses	Viruses	76.8	8.94e-10	NTclustered	gi\|2171145671\|gb\|MZ218459.1\|	2583950	g52812	i0	85	0.449438202247191	80	6	42	5	82	155	4898	4819	MAG: Tombusviridae sp. isolate 214-k141_171437 genomic sequence	blastn	80	76.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Tombusviridae sp.
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
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
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
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.
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);;