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

10 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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
27388308	27388308	PRJNA1164198_P_NODE_31423_length_234_cov_2.670807_g31154_i0	PRJNA1164198	31423	234	2.670807	6.24968838	Giant panda Iflaviridae	2903093	Viruses	Viruses	111	2.69e-26	NR	UGV21557.1	2903093	g31154	i0	68	0.961538461538462	75	24	96.2	0	231	7	965	1039	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	225	111	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
27609259	27609259	PRJNA1164198_P_NODE_22244_length_263_cov_1.884211_g21975_i0	PRJNA1164198	22244	263	1.884211	4.95547493	Giant panda Iflaviridae	2903093	Viruses	Viruses	135	1.68e-34	NR	UGV21557.1	2903093	g21975	i0	74.7	0.992395437262357	87	22	99.2	0	2	262	1144	1230	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	261	135	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
28808640	28808640	PRJNA1164198_P_NODE_28708_length_245_cov_1.523256_g28439_i0	PRJNA1164198	28708	245	1.523256	3.7319772	Giant panda Iflaviridae	2903093	Viruses	Viruses	116	5.36e-28	NR	UGV21557.1	2903093	g28439	i0	69.5	1.00408163265306	82	24	99.2	1	3	245	697	778	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	246	116	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
28872004	28872004	PRJNA1164198_P_NODE_10908_length_376_cov_2.435644_g10640_i0	PRJNA1164198	10908	376	2.435644	9.15802144	Giant panda Iflaviridae	2903093	Viruses	Viruses	218	4.45e-63	NR	UGV21557.1	2903093	g10640	i0	87.9	0.98936170212766	124	15	98.9	0	374	3	170	293	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	372	218	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
29819117	29819117	PRJNA1164198_P_NODE_12531_length_350_cov_1.891697_g12262_i0	PRJNA1164198	12531	350	1.891697	6.6209395	Giant panda Iflaviridae	2903093	Viruses	Viruses	164	3.16e-44	NR	UGV21557.1	2903093	g12262	i0	66.1	0.985714285714286	115	39	98.6	0	5	349	1228	1342	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	345	164	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
30609055	30609055	PRJNA1164198_P_NODE_4633_length_584_cov_1.921722_g4385_i0	PRJNA1164198	4633	584	1.921722	11.22285648	Giant panda Iflaviridae	2903093	Viruses	Viruses	226	1.1e-64	NR	UGV21557.1	2903093	g4385	i0	57.9	0.976027397260274	190	80	97.6	0	581	12	1772	1961	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	570	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
30925352	30925352	PRJNA1164198_P_NODE_21934_length_265_cov_2.135417_g21665_i0	PRJNA1164198	21934	265	2.135417	5.65885505	Crogonang virus 178	3063382	Viruses	Viruses	86.3	5.01e-18	NR	WPR18581.1	3063382	g21665	i0	53.6	0.950943396226415	84	36	95.1	1	264	13	23	103	WPR18581.1 MAG: RNA-dependent RNA polymerase, partial [Crogonang virus 178]	diamond	252	86.3	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Crogonang virus 178
31145840	31145840	PRJNA1164198_P_NODE_21375_length_269_cov_0.979592_g21106_i0	PRJNA1164198	21375	269	0.979592	2.63510248	Giant panda Iflaviridae	2903093	Viruses	Viruses	171	2.8e-47	NR	UGV21557.1	2903093	g21106	i0	93.3	0.992565055762082	89	6	99.3	0	268	2	284	372	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	267	171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae
32664082	32664082	PRJNA1164198_P_NODE_29880_length_243_cov_1.835294_g29611_i0	PRJNA1164198	29880	243	1.835294	4.45976442	Saccharomyces 2	3431059	Viruses	Viruses	120	1.64e-29	NR	NP_660178.1	186772	g29611	i0	76.3	0.987654320987654	80	19	98.8	0	3	242	21	100	NP_660178.1 RNA-dependent RNA polymerase [Saccharomyces 20S RNA narnavirus]	diamond	240	120	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus saccharominor
32758732	32758732	PRJNA1164198_P_NODE_5700_length_527_cov_2.603524_g5445_i0	PRJNA1164198	5700	527	2.603524	13.72057148	Giant panda Iflaviridae	2903093	Viruses	Viruses	226	9.71e-65	NR	UGV21557.1	2903093	g5445	i0	62.6	0.973434535104364	171	63	97.3	1	513	1	2060	2229	UGV21557.1 MAG: polyprotein [Giant panda Iflaviridae]	diamond	513	226	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Iflaviridae		Giant panda Iflaviridae

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