metadata: contig_metadata: 9 rows where bioproject = "PRJNA841653" and tax

9 rows where bioproject = "PRJNA841653" and tax_phylum = "Negarnaviricota"

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
27023044	27023044	PRJNA841653_P_NODE_19862_length_366_cov_1.750853_g19190_i0	PRJNA841653	19862	366	1.750853	6.40812198	Ripegast virus	3130561	Viruses	Viruses	65.5	4.56e-10	NR	WZH59875.1	3130561	g19190	i0	34.5	2.77868852459016	119	74	94.3	2	364	20	22	140	WZH59875.1 MAG: RNA-dependent RNA polymerase, partial [Ripegast virus]	diamond	1017	65.5	1	Viruses	Orthornavirae	Negarnaviricota	Ellioviricetes	Bunyavirales			Ripegast virus
27371071	27371071	PRJNA841653_P_NODE_4143_length_849_cov_2.975515_g3570_i0	PRJNA841653	4143	849	2.975515	25.26212235	Leptosphaeria biglobosa negative single-stranded RNA virus 9	2985704	Viruses	Viruses	67.4	9.85e-9	NR	UYL94510.1	2985704	g3570	i0	29.7	0.583038869257951	165	99	53.7	3	84	539	155	315	UYL94510.1 MAG: nucleocapsid protein [Leptosphaeria biglobosa negative single-stranded RNA virus 9]	diamond	495	67.4	1	Viruses	Orthornavirae	Negarnaviricota					Leptosphaeria biglobosa negative single-stranded RNA virus 9
27497159	27497159	PRJNA841653_P_NODE_17183_length_395_cov_0.795031_g16511_i0	PRJNA841653	17183	395	0.795031	3.14037245	Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2	3038610	Viruses	Viruses	46.6	0.00919	NR	WNK16441.1	3038610	g16511	i0	28.2	1.73924050632911	110	77	82.8	2	345	19	702	810	WNK16441.1 MAG: RNA-dependent RNA polymerase [Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2]	diamond	687	46.6	1	Viruses	Orthornavirae	Negarnaviricota					Fusarium oxysporum f. sp. cubense negative-stranded RNA virus 2
29517702	29517702	PRJNA841653_P_NODE_16850_length_399_cov_1.604294_g16178_i0	PRJNA841653	16850	399	1.604294	6.40113306	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	69.7	8.56e-11	NR	UVF58767.1	2951531	g16178	i0	45.6	0.593984962406015	79	42	58.6	1	297	64	1	79	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	diamond	237	69.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
29936867	29936867	PRJNA841653_P_NODE_14791_length_427_cov_2.192090_g14120_i0	PRJNA841653	14791	427	2.19209	9.3602243	Negarnaviricota	2497569	Viruses	Viruses	93.2	6.44e-20	NR	YP_010840287.1	2185132	g14120	i0	61	1.08196721311475	77	30	54.1	0	427	197	189	265	YP_010840287.1 Nucleocapsid [Penicillium discovirus]	diamond	462	93.6	0.995726495726496	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Discoviridae	Orthodiscovirus	Orthodiscovirus missouriense
30252939	30252939	PRJNA841653_P_NODE_52572_length_246_cov_0.890173_g51898_i0	PRJNA841653	52572	246	0.890173	2.18982558	Orthodiscovirus	2948850	Viruses	Viruses	114	1.93e-27	NR	YP_010840285.1	2185132	g51898	i0	66.7	1.90243902439024	78	26	95.1	0	10	243	743	820	YP_010840285.1 RNA-dependent RNA polymerase [Penicillium discovirus]	diamond	468	115	0.991304347826087	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Discoviridae	Orthodiscovirus	Orthodiscovirus missouriense
30402688	30402688	PRJNA841653_P_NODE_40273_length_260_cov_1.229947_g39599_i0	PRJNA841653	40273	260	1.229947	3.1978622	Peribunyaviridae sp.	2683622	Viruses	Viruses	102	6.559999999999999e-23	NR	WAK75611.1	2683622	g39599	i0	61.6	0.992307692307692	86	33	99.2	0	3	260	99	184	WAK75611.1 MAG: RNA-dependent RNA polymerase [Peribunyaviridae sp.]	diamond	258	102	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae		Peribunyaviridae sp.
30654866	30654866	PRJNA841653_P_NODE_27133_length_313_cov_1.283333_g26459_i0	PRJNA841653	27133	313	1.283333	4.01683229	Cercospora beticola negative-stranded virus 1	2973209	Viruses	Viruses	130	1.92e-32	NR	UVB78665.1	2973209	g26459	i0	57.1	0.939297124600639	98	42	93.9	0	301	8	280	377	UVB78665.1 RdRp [Cercospora beticola negative-stranded virus 1]	diamond	294	130	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales			Cercospora beticola negative-stranded virus 1
30812948	30812948	PRJNA841653_P_NODE_38514_length_266_cov_0.839378_g37840_i0	PRJNA841653	38514	266	0.839378	2.23274548	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	79.3	6.77e-15	NR	WLN26256.1	2951531	g37840	i0	43.5	0.958646616541353	85	48	95.9	0	255	1	129	213	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	255	79.3	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus 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);;