metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Pisuviricota"

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
3465134	3465134	PRJNA939369_S_NODE_33223_length_292_cov_1.100457_g32806_i0	PRJNA939369	33223	292	1.100457	3.21333444	Camellia sinensis secoviridae virus 1	2957729	Viruses	Viruses	199	7.429999999999999e-57	NR	USS99170.1	2957729	g32806	i0	95.8	6.9041095890411	96	4	98.6	0	3	290	1779	1874	USS99170.1 polyprotein [Camellia sinensis secoviridae virus 1]	diamond	2016	199	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae		Camellia sinensis secoviridae virus 1
16217224	16217224	PRJNA939369_S_NODE_2453_length_716_cov_1.819596_g2069_i0	PRJNA939369	2453	716	1.819596	13.02830736	Picobirnavirus sp.	1907787	Viruses	Viruses	370	2.84e-123	NR	QXV86716.1	1907787	g2069	i0	75.2	0.99720670391061506	238	59	99.7	0	714	1	130	367	QXV86716.1 MAG: RNA-dependent RNA-polymerase [Picobirnavirus sp.]	diamond	714	370	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Picobirnavirus sp.
21316231	21316231	PRJNA939369_S_NODE_1117_length_990_cov_2.451472_g809_i0	PRJNA939369	1117	990	2.451472	24.2695728	Orthopicobirnavirus	2948851	Viruses	Viruses	425	1.2599999999999996e-143	NR	USE08238.1	1907787	g809	i0	63.5	4.85151515151515	329	115	99.1	2	981	1	124	449	USE08238.1 MAG: putative RNA-dependent RNA polymerase, partial [Picobirnavirus sp.]	diamond	4803	429	0.990675990675991	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Picobirnavirus sp.
27031900	27031900	PRJNA939369_S_NODE_72902_length_242_cov_2.201183_g72485_i0	PRJNA939369	72902	242	2.201183	5.32686286	Orthopicobirnavirus	2948851	Viruses	Viruses	122	1.25e-30	NR	UAW00543.1	442302	g72485	i0	75.3	1.92148760330579	77	19	95.5	0	1	231	44	120	UAW00543.1 MAG: RNA-dependent RNA polymerase [Porcine picobirnavirus]	diamond	465	123	0.991869918699187	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Porcine picobirnavirus
28098810	28098810	PRJNA939369_S_NODE_33225_length_292_cov_1.073059_g32808_i0	PRJNA939369	33225	292	1.073059	3.13333228	Marmot picobirnavirus	2161795	Viruses	Viruses	61.2	9.35e-9	NR	AVX53416.1	2161795	g32808	i0	46.6	0.75	73	39	75	0	68	286	121	193	AVX53416.1 putative ORF1 [Marmot picobirnavirus]	diamond	219	61.2	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Marmot picobirnavirus
29930423	29930423	PRJNA939369_S_NODE_20291_length_336_cov_2.148289_g19874_i0	PRJNA939369	20291	336	2.148289	7.21825104	Marmot picobirnavirus	2161795	Viruses	Viruses	94.4	3.9e-21	NR	AVX53416.1	2161795	g19874	i0	63.8	0.714285714285714	80	29	71.4	0	37	276	14	93	AVX53416.1 putative ORF1 [Marmot picobirnavirus]	diamond	240	94.4	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Marmot picobirnavirus
30909811	30909811	PRJNA939369_S_NODE_2654_length_694_cov_1.975845_g2260_i0	PRJNA939369	2654	694	1.975845	13.7123643	Marmot picobirnavirus	2161795	Viruses	Viruses	102	3.96e-21	NR	AVX53395.1	2161795	g2260	i0	35.8	2.48991354466859	162	91	70	2	497	12	44	192	AVX53395.1 putative capsid [Marmot picobirnavirus]	diamond	1728	102	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Marmot picobirnavirus
30948484	30948484	PRJNA939369_S_NODE_6854_length_484_cov_1.423358_g6437_i0	PRJNA939369	6854	484	1.423358	6.88905272	Stralarivirus	2948915	Viruses	Viruses	184	1.06e-50	NR	BBG58107.1	1676255	g6437	i0	95.7	2.87603305785124	93	4	57.6	0	484	206	450	542	BBG58107.1 polyprotein, partial [Cnidium vein yellowing virus 2]	diamond	1392	184	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Cnidium vein yellowing virus 2
31320476	31320476	PRJNA939369_S_NODE_1035_length_1027_cov_1.708595_g749_i0	PRJNA939369	1035	1027	1.708595	17.54727065	Marmot picobirnavirus	2161795	Viruses	Viruses	319	2.15e-102	NR	AVX53417.1	2161795	g749	i0	49.6	0.984420642648491	337	160	96.4	5	3	992	115	448	AVX53417.1 putative capsid, partial [Marmot picobirnavirus]	diamond	1011	319	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Marmot picobirnavirus
31889823	31889823	PRJNA939369_S_NODE_197_length_2435_cov_6.287045_g83_i0	PRJNA939369	197	2435	6.287045	153.08954575	Marmot picobirnavirus	2161795	Viruses	Viruses	414	4.68e-133	NR	AVX53417.1	2161795	g83	i0	48.2	0.590143737166324	479	221	57.4	9	1399	2	2	466	AVX53417.1 putative capsid, partial [Marmot picobirnavirus]	diamond	1437	414	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Marmot picobirnavirus

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