metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
15755365	15755365	PRJNA492406_P_NODE_4893_length_541_cov_2.237179_g4598_i0	PRJNA492406	4893	541	2.237179	12.10313839	brine shrimp arlivirus 5	2900380	Viruses	Viruses	340	1.25e-104	NR	UNI74094.1	2900380	g4598	i0	93.3	0.992606284658041	179	12	99.3	0	3	539	663	841	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	537	340	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
26918245	26918245	PRJNA492406_P_NODE_13902_length_336_cov_1.692015_g13603_i0	PRJNA492406	13902	336	1.692015	5.6851704	brine shrimp arlivirus 5	2900380	Viruses	Viruses	211	1.2699999999999999e-60	NR	UNI74094.1	2900380	g13603	i0	95.5	0.991071428571429	111	5	99.1	0	3	335	463	573	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	333	211	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
27044828	27044828	PRJNA492406_P_NODE_7622_length_439_cov_1.642077_g7323_i0	PRJNA492406	7622	439	1.642077	7.20871803	brine shrimp arlivirus 5	2900380	Viruses	Viruses	239	4.28e-70	NR	UNI74094.1	2900380	g7323	i0	76.7	0.997722095671982	146	34	99.8	0	439	2	66	211	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	438	239	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
27518793	27518793	PRJNA492406_P_NODE_14223_length_332_cov_1.779923_g13924_i0	PRJNA492406	14223	332	1.779923	5.90934436	brine shrimp arlivirus 5	2900380	Viruses	Viruses	221	2.81e-64	NR	UNI74094.1	2900380	g13924	i0	90	0.993975903614458	110	11	99.4	0	330	1	1045	1154	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	330	221	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
27865959	27865959	PRJNA492406_P_NODE_22965_length_269_cov_0.943878_g22666_i0	PRJNA492406	22965	269	0.943878	2.53903182	brine shrimp yue-like virus 8	2900460	Viruses	Viruses	172	2.0499999999999998e-47	NR	UNI74191.1	2900460	g22666	i0	91	0.992565055762082	89	8	99.3	0	269	3	1206	1294	UNI74191.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 8]	diamond	267	172	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 8
28466165	28466165	PRJNA492406_P_NODE_21346_length_277_cov_1.352941_g21047_i0	PRJNA492406	21346	277	1.352941	3.74764657	brine shrimp arlivirus 5	2900380	Viruses	Viruses	176	7.650000000000001e-49	NR	UNI74094.1	2900380	g21047	i0	89.1	0.996389891696751	92	10	99.6	0	1	276	1228	1319	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	276	176	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
28560882	28560882	PRJNA492406_P_NODE_6887_length_460_cov_1.591731_g6588_i0	PRJNA492406	6887	460	1.591731	7.3219626	Fusarium culmorum narnavirus 1	3233852	Viruses	Viruses	65.5	4.52e-9	NR	XCO56019.1	3233852	g6588	i0	28.6	0.958695652173913	147	81	80.9	3	56	427	648	793	XCO56019.1 MAG: putative coat protein [Fusarium culmorum narnavirus 1]	diamond	441	65.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales			Fusarium culmorum narnavirus 1
29981638	29981638	PRJNA492406_P_NODE_15231_length_321_cov_1.786290_g14932_i0	PRJNA492406	15231	321	1.78629	5.7339909	brine shrimp arlivirus 5	2900380	Viruses	Viruses	207	2.29e-59	NR	UNI74094.1	2900380	g14932	i0	90.6	0.990654205607477	106	10	99.1	0	319	2	1644	1749	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	318	207	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis
30107912	30107912	PRJNA492406_P_NODE_20352_length_282_cov_1.210526_g20053_i0	PRJNA492406	20352	282	1.210526	3.41368332	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	156	8.539999999999997e-42	NR	AVM87439.1	3063761	g20053	i0	79.6	0.98936170212766	93	19	98.9	0	282	4	1209	1301	AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1]	diamond	279	156	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Danio blood picornavirus/Zebrafish picornavirus 2
31372214	31372214	PRJNA492406_P_NODE_8676_length_414_cov_3.096774_g8377_i0	PRJNA492406	8676	414	3.096774	12.82064436	brine shrimp yue-like virus 3	2900455	Viruses	Viruses	180	2.08e-52	NR	UNI74156.1	2900455	g8377	i0	59.4	4	138	56	100	0	414	1	190	327	UNI74156.1 MAG: hypothetical protein [brine shrimp yue-like virus 3]	diamond	1656	180	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 3
31467047	31467047	PRJNA492406_P_NODE_17476_length_299_cov_0.946903_g17177_i0	PRJNA492406	17476	299	0.946903	2.83123997	Mitoviridae sp.	2809572	Viruses	Viruses	145	6.37e-38	NR	WAK72382.1	2809572	g17177	i0	67	1.94648829431438	97	32	97.3	0	295	5	460	556	WAK72382.1 MAG: RNA-dependent RNA polymerase [Mitoviridae sp.]	diamond	582	145	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.
32067795	32067795	PRJNA492406_P_NODE_11038_length_373_cov_1.216667_g10739_i0	PRJNA492406	11038	373	1.216667	4.53816791	brine shrimp arlivirus 5	2900380	Viruses	Viruses	226	1.22e-65	NR	UNI74094.1	2900380	g10739	i0	91.1	0.997319034852547	124	11	99.7	0	2	373	1757	1880	UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5]	diamond	372	226	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsafivalis

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