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

10 rows where analysis = "diamond", bioproject = "PRJNA494251" 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
26950198	26950198	PRJNA494251_P_NODE_17242_length_337_cov_2.166667_g16928_i0	PRJNA494251	17242	337	2.166667	7.30166779	PNG bee virus 12	2746871	Viruses	Viruses	94.4	8.26e-20	NR	QKW94216.1	2746871	g16928	i0	43.8	1.99406528189911	112	62	98.8	1	2	334	102	213	QKW94216.1 calicivirus coat protein [PNG bee virus 12]	diamond	672	94.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		PNG bee virus 12
27519292	27519292	PRJNA494251_P_NODE_2003_length_842_cov_4.130039_g1766_i0	PRJNA494251	2003	842	4.130039	34.77492838	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	247	2.06e-70	NR	XHA87929.1	3347367	g1766	i0	65.3	0.676959619952494	190	65	67.3	1	570	4	412	601	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	570	247	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
27519310	27519310	PRJNA494251_P_NODE_303_length_1736_cov_3.536380_g240_i0	PRJNA494251	303	1736	3.53638	61.3915568	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	485	7.84e-149	NR	XHA87929.1	3347367	g240	i0	44.8	1.06451612903226	616	292	98.8	8	3	1718	888	1499	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	1848	485	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
27550730	27550730	PRJNA494251_P_NODE_44_length_2834_cov_4.365085_g37_i0	PRJNA494251	44	2834	4.365085	123.7065089	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	89.4	8.05e-14	NR	XEQ84337.1	RQ13	g37	i0	25.4	0.374735356386733	354	222	34.1	9	1618	2583	112	455	XEQ84337.1 polyprotein, partial [Mink kobuvirus]	diamond	1062	89.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
28340248	28340248	PRJNA494251_P_NODE_6_length_5682_cov_7.299519_g4_i0	PRJNA494251	6	5682	7.299519	414.75866958	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	516	1.59e-146	NR	XBH24011.1	RQ13	g4	i0	32.8	0.670010559662091	1269	680	65.2	36	3983	282	1256	2385	XBH24011.1 MAG: polyprotein [Coleura bat picornavirus]	diamond	3807	516	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Zebrafish jaw picornavirus
30898504	30898504	PRJNA494251_P_NODE_1014_length_1128_cov_4.636967_g848_i0	PRJNA494251	1014	1128	4.636967	52.30498776	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	84.3	2.05e-13	NR	XHA87929.1	3347367	g848	i0	32.1	0.422872340425532	159	98	42	4	474	1	752	901	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	477	84.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
32384814	32384814	PRJNA494251_P_NODE_10099_length_421_cov_3.120690_g9793_i0	PRJNA494251	10099	421	3.12069	13.1381049	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	50.4	5.33e-4	NR	XHA87929.1	3347367	g9793	i0	34	0.755344418052256	106	66	73.4	3	27	335	576	680	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	318	50.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
32543257	32543257	PRJNA494251_P_NODE_339_length_1672_cov_4.799250_g268_i0	PRJNA494251	339	1672	4.79925	80.24346	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	370	5.5699999999999995e-109	NR	XHA87929.1	3347367	g268	i0	46	0.889952153110048	496	230	88.5	10	4	1482	2012	2472	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	1488	370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
32606159	32606159	PRJNA494251_P_NODE_520_length_1450_cov_5.137255_g414_i0	PRJNA494251	520	1450	5.137255	74.4901975	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	331	1.09e-96	NR	XHA87929.1	3347367	g414	i0	53	0.717931034482759	347	152	70.8	5	425	1450	1673	2013	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	1041	331	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113
32700483	32700483	PRJNA494251_P_NODE_880_length_1201_cov_4.361702_g728_i0	PRJNA494251	880	1201	4.361702	52.38404102	Qianjiang dicistro-like virus 113	3347367	Viruses	Viruses	55.5	4.57e-4	NR	XHA87929.1	3347367	g728	i0	22	0.601998334721066	241	166	56.5	5	678	1	47	280	XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113]	diamond	723	55.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 113

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