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

10 rows where analysis = "diamond", bioproject = "PRJNA556992" 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
22209349	22209349	PRJNA556992_P_NODE_725218_length_250_cov_0.870056_g723029_i0	PRJNA556992	725218	250	0.870056	2.17514	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	159	3.809999999999999e-43	NR	XCM67767.1	3003959	g723029	i0	93.8	0.972	81	5	97.2	0	248	6	270	350	XCM67767.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	243	159	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27331394	27331394	PRJNA556992_P_NODE_145343_length_362_cov_0.941176_g143155_i0	PRJNA556992	145343	362	0.941176	3.40705712	Sclerotium hydrophilum virus 3	3075447	Viruses	Viruses	118	1.82e-28	NR	WNB49993.1	3075447	g143155	i0	56.5	0.76243093922651906	92	40	76.2	0	358	83	418	509	WNB49993.1 coat protein [Sclerotium hydrophilum virus 3]	diamond	276	118	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Sclerotium hydrophilum virus 3
28120520	28120520	PRJNA556992_P_NODE_103405_length_401_cov_2.228659_g101221_i0	PRJNA556992	103405	401	2.228659	8.93692259	Lysoka partiti-like virus	2169481	Viruses	Viruses	165	4.239999999999999e-47	NR	AWV67008.1	2169481	g101221	i0	60.2	0.99501246882793	133	50	98.8	2	397	2	135	265	AWV67008.1 RdRp, partial [Lysoka partiti-like virus]	diamond	399	165	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Lysoka partiti-like virus
28783502	28783502	PRJNA556992_P_NODE_1142827_length_203_cov_4.838462_g1140636_i0	PRJNA556992	1142827	203	4.838462	9.82207786	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	106	6.9899999999999995e-25	NR	UNY42059.1	3003959	g1140636	i0	74.2	1.95073891625616	66	17	97.5	0	202	5	778	843	UNY42059.1 MAG: polyprotein 1 [Picornavirales sp.]	diamond	396	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31374108	31374108	PRJNA556992_P_NODE_16176_length_836_cov_8.491481_g14380_i0	PRJNA556992	16176	836	8.491481	70.98878116	Ripistiq virus	3131082	Viruses	Viruses	80.1	9.35e-13	NR	WZH60828.1	3131082	g14380	i0	27.1	1.03349282296651	288	183	97.6	10	830	15	571	847	WZH60828.1 MAG: RNA-dependent RNA polymerase, partial [Ripistiq virus]	diamond	864	80.1	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Ripistiq virus
31722071	31722071	PRJNA556992_P_NODE_61457_length_475_cov_2.124378_g59288_i0	PRJNA556992	61457	475	2.124378	10.0907955	Whatley partiti-like virus	2716668	Viruses	Viruses	204	1.32e-60	NR	QIJ70094.1	2716668	g59288	i0	61.8	0.991578947368421	157	60	99.2	0	473	3	20	176	QIJ70094.1 RNA-dependent RNA polymerase [Whatley partiti-like virus]	diamond	471	204	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Whatley partiti-like virus
31753490	31753490	PRJNA556992_P_NODE_202677_length_325_cov_16.071429_g200489_i0	PRJNA556992	202677	325	16.071429	52.23214425	Ripistiq virus	3131082	Viruses	Viruses	118	2.46e-28	NR	WZH60828.1	3131082	g200489	i0	47.6	0.969230769230769	105	55	96.9	0	315	1	882	986	WZH60828.1 MAG: RNA-dependent RNA polymerase, partial [Ripistiq virus]	diamond	315	118	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Ripistiq virus
32070025	32070025	PRJNA556992_P_NODE_454958_length_271_cov_2.242424_g452769_i0	PRJNA556992	454958	271	2.242424	6.07696904	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	77.8	2.46e-14	NR	XHA87929.1	3347367	g452769	i0	64	0.553505535055351	50	18	55.4	0	120	269	1501	1550	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	150	77.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
32165348	32165348	PRJNA556992_P_NODE_8358_length_1140_cov_11.931584_g7074_i0	PRJNA556992	8358	1140	11.931584	136.0200576	Exobasidium gracile zybavirus 1-3	2977601	Viruses	Viruses	138	9.52e-32	NR	UWL52195.1	2977601	g7074	i0	36.3	1.36315789473684	259	143	65.8	6	1	750	388	633	UWL52195.1 RNA-dependent RNA polymerase [Exobasidium gracile zybavirus 1-3]	diamond	1554	138	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Amalgaviridae	Zybavirus	Exobasidium gracile zybavirus 1-3
32228329	32228329	PRJNA556992_P_NODE_268898_length_297_cov_1.375000_g266709_i0	PRJNA556992	268898	297	1.375	4.08375	Lysoka partiti-like virus	2169481	Viruses	Viruses	119	5.85e-29	NR	AWV66996.1	2169481	g266709	i0	55.7	2.87878787878788	97	43	98	0	5	295	154	250	AWV66996.1 RdRp, partial [Lysoka partiti-like virus]	diamond	855	119	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae		Lysoka partiti-like 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);;