metadata: contig_metadata: 8 rows where bioproject = "PRJNA293022", tax_phylum = "Lenarviricota" and tax

8 rows where bioproject = "PRJNA293022", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

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
9301333	9301333	PRJNA293022_P_NODE_33928_length_240_cov_1.816754_g33191_i0	PRJNA293022	33928	240	1.816754	4.3602096	Sopawol virus	3131668	Viruses	Viruses	206	1.57e-48	NTclustered	gi\|2717323098\|gb\|PP173969.1\|	3131668	g33191	i0	89.157	150.783333333333	166	16	69	2	3	167	216	380	MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence	blastn	36188	206	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopawol virus
18225087	18225087	PRJNA293022_P_NODE_67635_length_169_cov_0.866667_g66898_i0	PRJNA293022	67635	169	0.866667	1.46466723	Ripachij virus	3130407	Viruses	Viruses	213	6.12e-51	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g66898	i0	90.361	12.1420118343195	166	11	96	5	1	163	480	643	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	2052	213	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
18225103	18225103	PRJNA293022_P_NODE_69595_length_168_cov_0.873950_g68858_i0	PRJNA293022	69595	168	0.87395	1.468236	Chrocagosk virus	3129397	Viruses	Viruses	87.9	3.87e-13	NTclustered	gi\|2717317479\|gb\|PP171845.1\|	3129397	g68858	i0	80.87	0.68452380952381	115	18	67	3	3	114	582	469	MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence	blastn	115	87.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagosk virus
27263971	27263971	PRJNA293022_P_NODE_48883_length_199_cov_2.666667_g48146_i0	PRJNA293022	48883	199	2.666667	5.30666733	Halia narna-like virus	2912703	Viruses	Viruses	49.7	7.56e-5	NR	DAZ87253.1	2912703	g48146	i0	46.4	0.844221105527638	56	30	84.4	0	199	32	293	348	DAZ87253.1 TPA_asm: RNA-dependent polymerase [Halia narna-like virus]	diamond	168	49.7	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Halia narna-like virus
27390429	27390429	PRJNA293022_P_NODE_18263_length_334_cov_1.726316_g17526_i0	PRJNA293022	18263	334	1.726316	5.76589544	Sanya mito-like virus 1	2970201	Viruses	Viruses	155	1.36e-41	NR	UUW21442.1	2970201	g17526	i0	69.4	2.80239520958084	108	31	97	1	9	332	246	351	UUW21442.1 MAG: RNA-dependent RNA polymerase [Sanya mito-like virus 1]	diamond	936	155	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Sanya mito-like virus 1
27832246	27832246	PRJNA293022_P_NODE_50124_length_197_cov_1.054054_g49387_i0	PRJNA293022	50124	197	1.054054	2.07648638	Erysiphales associated mitovirus 1	2719863	Viruses	Viruses	53.5	3.17e-6	NR	QIP68035.1	2719863	g49387	i0	41.9	0.944162436548223	62	36	94.4	0	7	192	274	335	QIP68035.1 RNA-dependent RNA polymerase [Erysiphales associated mitovirus 1]	diamond	186	53.5	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Erysiphales associated mitovirus 1
30958963	30958963	PRJNA293022_P_NODE_82874_length_153_cov_2.961538_g82137_i0	PRJNA293022	82874	153	2.961538	4.53115314	wugcerasp narna-like virus 1	3116852	Viruses	Viruses	74.7	4.67e-14	NR	WVD52812.1	3116852	g82137	i0	63.3	0.96078431372549	49	18	96.1	0	3	149	305	353	WVD52812.1 RdRp [wugcerasp narna-like virus 1]	diamond	147	74.7	1	Viruses	Orthornavirae	Lenarviricota					wugcerasp narna-like virus 1
31970740	31970740	PRJNA293022_P_NODE_44478_length_209_cov_1.937500_g43741_i0	PRJNA293022	44478	209	1.9375	4.049375	Mitoviridae sp.	2809572	Viruses	Viruses	78.6	5.65e-15	NR	WAK72376.1	2809572	g43741	i0	49.2	1.83732057416268	65	33	93.3	0	208	14	476	540	WAK72376.1 MAG: RNA-dependent RNA polymerases [Mitoviridae sp.]	diamond	384	78.6	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Mitoviridae sp.

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