metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA255848" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA255848" 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
26598869	26598869	PRJNA255848_P_NODE_5101_length_493_cov_1.551802_g4786_i0	PRJNA255848	5101	493	1.551802	7.65038386	Pestalotiopsis mitovirus 1	2816842	Viruses	Viruses	181	6.05e-50	NR	QTH80198.1	2816842	g4786	i0	64.7	1.6551724137931	136	48	82.8	0	1	408	376	511	QTH80198.1 MAG: RNA-dependent RNA polymerase [Pestalotiopsis mitovirus 1]	diamond	816	181	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Pestalotiopsis mitovirus 1
27028516	27028516	PRJNA255848_P_NODE_30582_length_180_cov_1.007634_g30264_i0	PRJNA255848	30582	180	1.007634	1.8137412	Mitoviridae	2732892	Viruses	Viruses	64.3	3.85e-10	NR	AHX84134.1	1435446	g30264	i0	60	4.16666666666667	50	20	83.3	0	30	179	310	359	AHX84134.1 RNA-dependent RNA polymerase [Sclerotinia sclerotiorum mitovirus 6]	diamond	750	64.3	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Duamitovirus	Duamitovirus scsc6
28053059	28053059	PRJNA255848_P_NODE_47685_length_161_cov_0.910714_g47367_i0	PRJNA255848	47685	161	0.910714	1.46624954	Suillus luteus hypovirus 1	3067807	Viruses	Viruses	102	8.53e-24	NR	WLK77429.1	3067807	g47367	i0	98.1	0.987577639751553	53	1	98.8	0	161	3	1872	1924	WLK77429.1 polyprotein, partial [Suillus luteus hypovirus 1]	diamond	159	102	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae		Suillus luteus hypovirus 1
28148007	28148007	PRJNA255848_P_NODE_16905_length_243_cov_1.051546_g16587_i0	PRJNA255848	16905	243	1.051546	2.55525678	Apis mellifera associated ourmia-like virus 2	3373667	Viruses	Viruses	68.9	2.16e-11	NR	XII93055.1	3373667	g16587	i0	53.7	0.827160493827161	67	29	82.7	2	238	38	487	551	XII93055.1 RNA-dependent RNA polymerase [Apis mellifera associated ourmia-like virus 2]	diamond	201	68.9	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Apis mellifera associated ourmia-like virus 2
28179183	28179183	PRJNA255848_P_NODE_12126_length_292_cov_3.748971_g11808_i0	PRJNA255848	12126	292	3.748971	10.94699532	African cichlid piscichuvirus	3065075	Viruses	Viruses	57.8	3.67e-7	NR	UVF58767.1	3065075	g11808	i0	43.8	1.42808219178082	73	40	74	1	5	220	10	82	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	417	57.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus
28210850	28210850	PRJNA255848_P_NODE_4586_length_523_cov_1.251055_g4274_i0	PRJNA255848	4586	523	1.251055	6.54301765	Aspergillus chevalieri mitovirus 1	3238291	Viruses	Viruses	55.5	2e-5	NR	BFP29922.1	3238291	g4274	i0	33.3	0.619502868068834	108	62	59.7	3	140	451	313	414	BFP29922.1 MAG: RNA-dependent RNA polymerase [Aspergillus chevalieri mitovirus 1]	diamond	324	55.5	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Aspergillus chevalieri mitovirus 1
28810554	28810554	PRJNA255848_P_NODE_43528_length_163_cov_0.894737_g43210_i0	PRJNA255848	43528	163	0.894737	1.45842131	Manglie virus	2562519	Viruses	Viruses	51.6	9.13e-6	NR	QBR99594.1	2562519	g43210	i0	57.5	2.13496932515337	40	17	73.6	0	161	42	1480	1519	QBR99594.1 hypothetical protein [Manglie virus]	diamond	348	51.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales			Manglie virus
29554674	29554674	PRJNA255848_P_NODE_3770_length_581_cov_2.680451_g3468_i0	PRJNA255848	3770	581	2.680451	15.57342031	Mitoviridae	2732892	Viruses	Viruses	100	9.87e-21	NR	NP_660176.1	198597	g3468	i0	56.6	0.867469879518072	83	36	42.9	0	243	491	35	117	NP_660176.1 RNA-dependent RNA polymerase [Ophiostoma mitovirus 3a]	diamond	504	101	0.99009900990099	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Duamitovirus	Duamitovirus opno3a
31559588	31559588	PRJNA255848_P_NODE_2336_length_745_cov_1.952586_g2078_i0	PRJNA255848	2336	745	1.952586	14.5467657	African cichlid piscichuvirus	3065075	Viruses	Viruses	125	1.31e-28	NR	WLN26256.1	3065075	g2078	i0	44.1	0.583892617449664	145	81	58.4	0	723	289	90	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	435	125	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid piscichuvirus

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