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

10 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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_species
18902027	18902027	PRJNA1240805_P_NODE_4835_length_208_cov_3.245283_g4786_i0	PRJNA1240805	4835	208	3.245283	6.75018864	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	73.2	4.52e-13	NR	XCM68067.1	3003959	g4786	i0	48.3	0.865384615384615	60	31	86.5	0	181	2	1030	1089	XCM68067.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	180	73.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
27484358	27484358	PRJNA1240805_P_NODE_3303_length_256_cov_6.120773_g3254_i0	PRJNA1240805	3303	256	6.120773	15.66917888	Qianjiang marna-like virus 187	3347615	Viruses	Viruses	43.5	0.0236	NR	XHA88380.1	3347615	g3254	i0	50	0.5390625	46	21	51.6	2	29	160	113	158	XHA88380.1 MAG: polyprotein, partial [Qianjiang marna-like virus 187]	diamond	138	43.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Qianjiang marna-like virus 187
27881319	27881319	PRJNA1240805_P_NODE_3525_length_246_cov_5.365482_g3476_i0	PRJNA1240805	3525	246	5.365482	13.19908572	Viruses	10239	Viruses	Viruses	147	4.2599999999999996e-39	NR	URG14989.1	1530251	g3476	i0	84	6.85365853658537	81	13	98.8	0	4	246	231	311	URG14989.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	1686	147	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Picornaviridae sp.
29473241	29473241	PRJNA1240805_P_NODE_8350_length_161_cov_2.383929_g8301_i0	PRJNA1240805	8350	161	2.383929	3.83812569	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	45.8	0.001	NR	XCM68156.1	3003959	g8301	i0	62.2	0.68944099378882	37	14	68.9	0	8	118	75	111	XCM68156.1 MAG: hypothetical protein, partial [Picornavirales sp.]	diamond	111	45.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
29536671	29536671	PRJNA1240805_P_NODE_5510_length_194_cov_7.317241_g5461_i0	PRJNA1240805	5510	194	7.317241	14.19544754	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	63.9	6.56e-10	NR	XCM68232.1	3003959	g5461	i0	50	1.79381443298969	58	29	89.7	0	13	186	984	1041	XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.]	diamond	348	63.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
29568149	29568149	PRJNA1240805_P_NODE_4710_length_210_cov_35.956522_g4661_i0	PRJNA1240805	4710	210	35.956522	75.5086962	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	67.8	3.73e-11	NR	XCM67722.1	3003959	g4661	i0	69	0.6	42	13	60	0	25	150	1808	1849	XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	126	67.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
31179103	31179103	PRJNA1240805_P_NODE_6655_length_177_cov_7.500000_g6606_i0	PRJNA1240805	6655	177	7.5	13.275	Marnaviridae sp.	2715102	Viruses	Viruses	79.3	2e-15	NR	ULF99969.1	2715102	g6606	i0	72.5	0.864406779661017	51	14	86.4	0	153	1	194	244	ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.]	diamond	153	79.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Marnaviridae sp.
31210509	31210509	PRJNA1240805_P_NODE_4255_length_222_cov_6.289017_g4206_i0	PRJNA1240805	4255	222	6.289017	13.96161774	Qianjiang dicistro-like virus 61	3347476	Viruses	Viruses	66.2	1.54e-10	NR	XHA87823.1	3347476	g4206	i0	74.4	0.527027027027027	39	10	52.7	0	22	138	651	689	XHA87823.1 MAG: polyprotein [Qianjiang dicistro-like virus 61]	diamond	117	66.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Qianjiang dicistro-like virus 61
31717050	31717050	PRJNA1240805_P_NODE_6757_length_176_cov_3.811024_g6708_i0	PRJNA1240805	6757	176	3.811024	6.70740224	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	55.5	4.96e-7	NR	QDH90548.1	3003959	g6708	i0	50	0.852272727272727	50	25	85.2	0	155	6	323	372	QDH90548.1 MAG: RNA-dependent RNA polymerase [Picornavirales sp.]	diamond	150	55.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
32886005	32886005	PRJNA1240805_P_NODE_4900_length_206_cov_7.044586_g4851_i0	PRJNA1240805	4900	206	7.044586	14.51184716	Ripistuv virus	3131355	Viruses	Viruses	73.6	3.18e-13	NR	WZH61282.1	3131355	g4851	i0	66.7	0.742718446601942	51	17	74.3	0	155	3	1185	1235	WZH61282.1 MAG: RNA-dependent RNA polymerase, partial [Ripistuv virus]	diamond	153	73.6	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Ripistuv virus

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