metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA520845" 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
14522309	14522309	PRJNA520845_P_NODE_9632_length_1260_cov_2.516428_g8747_i0	PRJNA520845	9632	1260	2.516428	31.7069928	brine shrimp arlivirus 8	2900383	Viruses	Viruses	403	4.95e-135	NR	UNI74120.1	2900383	g8747	i0	52.3	0.873809523809524	367	175	87.4	0	46	1146	1	367	UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8]	diamond	1101	403	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsaeighalis
23444873	23444873	PRJNA520845_P_NODE_59_length_8272_cov_72.906696_g33_i0	PRJNA520845	59	8272	72.906696	6030.84189312	Marnaviridae sp.	2715102	Viruses	Viruses	2099	0	NR	ULF99949.1	2715102	g33	i0	67.7	0.554158607350097	1528	466	55.3	8	800	5371	18	1522	ULF99949.1 MAG: hypothetical protein 1 [Marnaviridae sp.]	diamond	4584	2099	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
27361973	27361973	PRJNA520845_P_NODE_184363_length_274_cov_1.532338_g182864_i0	PRJNA520845	184363	274	1.532338	4.19860612	Striga asiatica dicistro-like virus 1	2943843	Viruses	Viruses	177	8.8e-50	NR	UQR78685.1	2943843	g182864	i0	87.9	0.996350364963504	91	11	99.6	0	274	2	130	220	UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1]	diamond	273	177	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Striga asiatica dicistro-like virus 1
27456659	27456659	PRJNA520845_P_NODE_138883_length_317_cov_1.262295_g137384_i0	PRJNA520845	138883	317	1.262295	4.00147515	Rhizoctonia cerealis bunyavirus	3068840	Viruses	Viruses	46.6	0.00414	NR	WMI40150.1	3068840	g137384	i0	33.3	0.851735015772871	90	58	85.2	2	289	20	1495	1582	WMI40150.1 MAG: RNA-dependent RNA polymerase [Rhizoctonia cerealis bunyavirus]	diamond	270	46.6	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Rhizoctonia cerealis bunyavirus
28024850	28024850	PRJNA520845_P_NODE_10745_length_1195_cov_2.755793_g8747_i1	PRJNA520845	10745	1195	2.755793	32.93172635	brine shrimp arlivirus 8	2900383	Viruses	Viruses	397	5.929999999999999e-133	NR	UNI74120.1	2900383	g8747	i1	52.6	0.901255230125523	359	170	90.1	0	46	1122	1	359	UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8]	diamond	1077	397	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Lispiviridae	Artemvirus	Artemvirus bsaeighalis
29256022	29256022	PRJNA520845_P_NODE_36329_length_629_cov_1.250000_g34869_i0	PRJNA520845	36329	629	1.25	7.8625	brine shrimp toti-like virus 1	2900477	Viruses	Viruses	263	3.5700000000000004e-79	NR	UNI73990.1	2900477	g34869	i0	63.6	0.996820349761526	209	76	99.7	0	627	1	410	618	UNI73990.1 MAG: capsid protein [brine shrimp toti-like virus 1]	diamond	627	263	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		brine shrimp toti-like virus 1
32195427	32195427	PRJNA520845_P_NODE_67018_length_454_cov_1.782152_g65519_i0	PRJNA520845	67018	454	1.782152	8.09097008	brine shrimp toti-like virus 1	2900477	Viruses	Viruses	200	1.14e-56	NR	UNI73990.1	2900477	g65519	i0	66.2	1.99559471365639	151	47	97.1	2	451	11	694	844	UNI73990.1 MAG: capsid protein [brine shrimp toti-like virus 1]	diamond	906	200	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		brine shrimp toti-like virus 1

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