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

15 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax_kingdom = "Orthornavirae"

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
28150927	28150927	PRJNA494251_P_NODE_18485_length_328_cov_1.219608_g18171_i0	PRJNA494251	18485	328	1.219608	4.00031424	Sclerotinia sclerotiorum narnavirus 1	2822897	Viruses	Viruses	58.9	1.12e-7	NR	QZE12035.1	2822897	g18171	i0	38.6	0.640243902439024	70	43	64	0	248	39	35	104	QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1]	diamond	210	58.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Sclerotinia sclerotiorum narnavirus 1
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
30424915	30424915	PRJNA494251_P_NODE_27193_length_282_cov_1.473684_g26879_i0	PRJNA494251	27193	282	1.473684	4.15578888	Hepelivirales sp.	2809460	Viruses	Viruses	72	3.08e-12	NR	WAY16437.1	2809460	g26879	i0	46.4	0.893617021276596	84	44	88.3	1	2	250	2019	2102	WAY16437.1 nonstructural polyprotein [Hepelivirales sp.]	diamond	252	72	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales			Hepelivirales sp.
30456426	30456426	PRJNA494251_P_NODE_25793_length_287_cov_2.728972_g25479_i0	PRJNA494251	25793	287	2.728972	7.83214964	brine shrimp yue-like virus 9	2900461	Viruses	Viruses	57.4	4.66e-7	NR	UNI74195.1	2900461	g25479	i0	65.2	0.480836236933798	46	14	48.1	1	267	130	2347	2390	UNI74195.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 9]	diamond	138	57.4	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 9
30629459	30629459	PRJNA494251_P_NODE_24053_length_295_cov_1.963964_g23739_i0	PRJNA494251	24053	295	1.963964	5.7936938	Chuvivirus	2842604	Viruses	Viruses	135	3.0799999999999996e-35	NR	WET19887.1	2842604	g23739	i0	63.3	1.99322033898305	98	36	99.7	0	2	295	298	395	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	588	135	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
30835152	30835152	PRJNA494251_P_NODE_15594_length_352_cov_1.100358_g15281_i0	PRJNA494251	15594	352	1.100358	3.87326016	brine shrimp arlivirus 5	2900380	Viruses	Viruses	102	4.309999999999999e-23	NR	UNI74090.1	2900380	g15281	i0	70	0.596590909090909	70	21	59.7	0	351	142	337	406	UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5]	diamond	210	102	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
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);;