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

9 rows where bioproject = "PRJNA1005695" and tax_phylum = "Kitrinoviricota"

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_species
24379601	24379601	PRJNA1005695_P_NODE_32620_length_261_cov_1.585106_g31768_i0	PRJNA1005695	32620	261	1.585106	4.13712666	Beijing sediment noda-like virus 3	2824385	Viruses	Viruses	272	1.68e-68	NTclustered	gi\|2802838360\|gb\|PP054172.1\|	2824385	g31768	i0	85.551	6.54406130268199	263	34	100	4	1	261	2635	2895	Beijing sediment noda-like virus 3 isolate BjSNV3/01/JS/202008 RNA-dependent RNA polymerase gene, complete cds	blastn	1708	272	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Beijing sediment noda-like virus 3
27761345	27761345	PRJNA1005695_P_NODE_29124_length_277_cov_1.441176_g28272_i0	PRJNA1005695	29124	277	1.441176	3.99205752	Qianjiang hepeli-like virus 13	3348975	Viruses	Viruses	63.9	2.06e-9	NR	XHA85828.1	3348975	g28272	i0	50	1.65703971119134	54	27	58.5	0	86	247	156	209	XHA85828.1 MAG: polyprotein [Qianjiang hepeli-like virus 13]	diamond	459	63.9	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 13
28424242	28424242	PRJNA1005695_P_NODE_23826_length_308_cov_1.327660_g22974_i0	PRJNA1005695	23826	308	1.32766	4.0891928	Qianjiang hepeli-like virus 2	3348982	Viruses	Viruses	98.6	2.03e-21	NR	XHA85843.1	3348983	g22974	i0	45.1	0.993506493506494	102	55	99.4	1	307	2	878	978	XHA85843.1 MAG: polyprotein [Qianjiang hepeli-like virus 20]	diamond	306	98.6	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 20
28645250	28645250	PRJNA1005695_P_NODE_5547_length_673_cov_1.743333_g4731_i0	PRJNA1005695	5547	673	1.743333	11.73263109	Qianjiang hepeli-like virus 2	3348982	Viruses	Viruses	170	1.1999999999999998e-44	NR	XHA85843.1	3348983	g4731	i0	43.9	0.913818722139673	205	112	91.4	2	3	617	580	781	XHA85843.1 MAG: polyprotein [Qianjiang hepeli-like virus 20]	diamond	615	170	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 20
28961122	28961122	PRJNA1005695_P_NODE_14668_length_398_cov_1.440000_g13816_i0	PRJNA1005695	14668	398	1.44	5.7312	Hepelivirales sp.	2809460	Viruses	Viruses	72.4	9.36e-12	NR	WAY16373.1	2809460	g13816	i0	33.6	2.68341708542714	134	78	95.7	5	3	383	207	336	WAY16373.1 nonstructural polyprotein [Hepelivirales sp.]	diamond	1068	72.4	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Hepelivirales sp.
29655097	29655097	PRJNA1005695_P_NODE_7650_length_567_cov_1.795547_g6817_i0	PRJNA1005695	7650	567	1.795547	10.18075149	Hepelivirales sp.	2809460	Viruses	Viruses	78.2	4.72e-13	NR	WAY16538.1	2809460	g6817	i0	30.5	0.798941798941799	151	98	76.2	1	121	552	1	151	WAY16538.1 hypothetical protein [Hepelivirales sp.]	diamond	453	78.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Hepelivirales sp.
30571358	30571358	PRJNA1005695_P_NODE_133_length_3190_cov_15.626564_g82_i0	PRJNA1005695	133	3190	15.626564	498.4873916	Qianjiang tombus-like virus 392	3348083	Viruses	Viruses	543	7.509999999999998e-182	NR	XHA87252.1	3348083	g82	i0	71.3	0.340438871473354	362	103	34	1	1501	416	1	361	XHA87252.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 392]	diamond	1086	543	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Qianjiang tombus-like virus 392
32311028	32311028	PRJNA1005695_P_NODE_2939_length_934_cov_1.761905_g2347_i0	PRJNA1005695	2939	934	1.761905	16.4561927	Qianjiang hepeli-like virus 2	3348982	Viruses	Viruses	147	2.59e-35	NR	XHA85843.1	3348983	g2347	i0	46.1	0.488222698072805	152	81	48.8	1	6	461	998	1148	XHA85843.1 MAG: polyprotein [Qianjiang hepeli-like virus 20]	diamond	456	147	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 20
32437528	32437528	PRJNA1005695_P_NODE_13719_length_413_cov_1.273529_g12867_i0	PRJNA1005695	13719	413	1.273529	5.25967477	Qianjiang hepeli-like virus 2	3348982	Viruses	Viruses	66.6	1.13e-9	NR	XHA85843.1	3348983	g12867	i0	36.7	0.929782082324455	128	76	89.3	2	412	44	184	311	XHA85843.1 MAG: polyprotein [Qianjiang hepeli-like virus 20]	diamond	384	66.6	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales		Qianjiang hepeli-like virus 20

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