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

10 rows where analysis = "diamond", bioproject = "PRJNA330616" 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
28211420	28211420	PRJNA330616_P_NODE_6746_length_322_cov_1.164835_g6337_i0	PRJNA330616	6746	322	1.164835	3.7507687	Narnaviridae sp.	2583949	Viruses	Viruses	116	9.23e-28	NR	URG16935.1	2583949	g6337	i0	57.3	2.76708074534162	103	42	96	1	6	314	228	328	URG16935.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.]	diamond	891	116	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Narnaviridae sp.
28527568	28527568	PRJNA330616_P_NODE_8367_length_287_cov_1.226891_g7958_i0	PRJNA330616	8367	287	1.226891	3.52117717	Narnaviridae sp.	2583949	Viruses	Viruses	67	1.81e-10	NR	URG16933.1	2583949	g7958	i0	39.8	3.13588850174216	98	56	99.3	1	1	285	459	556	URG16933.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.]	diamond	900	67	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Narnaviridae sp.
29506044	29506044	PRJNA330616_P_NODE_6230_length_336_cov_1.212544_g5821_i0	PRJNA330616	6230	336	1.212544	4.07414784	Fusarium culmorum yue-like virus 1	3233859	Viruses	Viruses	66.2	6.51e-10	NR	XCO56027.1	3233859	g5821	i0	34.5	0.982142857142857	110	66	92.9	1	333	22	495	604	XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1]	diamond	330	66.2	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Fusarium culmorum yue-like virus 1
29663641	29663641	PRJNA330616_P_NODE_29010_length_164_cov_0.886957_g28601_i0	PRJNA330616	29010	164	0.886957	1.45460948	brine shrimp arlivirus 9	2900384	Viruses	Viruses	99	9.19e-23	NR	UNI74140.1	2900384	g28601	i0	87	0.98780487804878	54	7	98.8	0	162	1	330	383	UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9]	diamond	162	99	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Arlivirus	brine shrimp arlivirus 9
30106114	30106114	PRJNA330616_P_NODE_32_length_3692_cov_4.356849_g21_i0	PRJNA330616	32	3692	4.356849	160.85486508	Red mite associated cystovirus	2936548	Viruses	Viruses	224	1.16e-57	NR	UQT02512.1	2936548	g21	i0	26.2	0.58261105092091	717	474	55.5	19	1514	3562	8	703	UQT02512.1 P1 [Red mite associated cystovirus]	diamond	2151	224	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Cystovirus	Red mite associated cystovirus
31022544	31022544	PRJNA330616_P_NODE_26655_length_166_cov_0.871795_g26246_i0	PRJNA330616	26655	166	0.871795	1.4471797	Macrobrachium rosenbergii narna-like virus 1	3132536	Viruses	Viruses	48.1	1.67e-4	NR	WWZ85587.1	3132536	g26246	i0	43.6	0.993975903614458	55	31	99.4	0	166	2	280	334	WWZ85587.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii narna-like virus 1]	diamond	165	48.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Macrobrachium rosenbergii narna-like virus 1
31465313	31465313	PRJNA330616_P_NODE_2776_length_530_cov_4.781705_g2372_i0	PRJNA330616	2776	530	4.781705	25.3430365	Yunnan sediment cysto-like virus 1	2824333	Viruses	Viruses	96.3	5.1e-20	NR	QYF49669.1	2824333	g2372	i0	35.9	0.866037735849057	153	92	86.6	3	501	43	205	351	QYF49669.1 MAG: putative RNA-dependent RNA polymerase, partial [Yunnan sediment cysto-like virus 1]	diamond	459	96.3	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Yunnan sediment cysto-like virus 1
31718143	31718143	PRJNA330616_P_NODE_37_length_3164_cov_8.417657_g25_i0	PRJNA330616	37	3164	8.417657	266.33466748	Sichuan farmland cysto-like virus	2824592	Viruses	Viruses	329	3.3e-96	NR	QYF49781.1	2824592	g25	i0	36.3	0.441845764854614	466	276	43.6	5	1380	1	11	461	QYF49781.1 MAG: putative RNA-dependent RNA polymerase [Sichuan farmland cysto-like virus]	diamond	1398	329	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Sichuan farmland cysto-like virus
31749608	31749608	PRJNA330616_P_NODE_27717_length_165_cov_0.879310_g27308_i0	PRJNA330616	27717	165	0.87931	1.4508615	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	81.6	2.58e-16	NR	XCM67837.1	3003959	g27308	i0	69.1	1	55	17	100	0	165	1	1019	1073	XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	165	81.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
31939412	31939412	PRJNA330616_P_NODE_15697_length_211_cov_1.259259_g15288_i0	PRJNA330616	15697	211	1.259259	2.65703649	Ripaglac virus	3130411	Viruses	Viruses	67.4	4.79e-11	NR	WZH59599.1	3130411	g15288	i0	65.8	0.540284360189573	38	13	54	0	96	209	9	46	WZH59599.1 MAG: RNA-dependent RNA polymerase [Ripaglac virus]	diamond	114	67.4	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripaglac 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);;