metadata: contig_metadata: 6 rows where bioproject = "PRJNA744060", tax_phylum = "Lenarviricota" and tax

6 rows where bioproject = "PRJNA744060", 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
1999312	1999312	PRJNA744060_P_NODE_31742_length_291_cov_2.527523_g31413_i0	PRJNA744060	31742	291	2.527523	7.35509193	Ripathuj virus	3131458	Viruses	Viruses	396	1.08e-105	NTclustered	gi\|2717322573\|gb\|PP173760.1\|	3131458	g31413	i0	91.409	166.951890034364	291	21	99	4	3	291	60	348	MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence	blastn	48583	396	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripathuj virus
27273942	27273942	PRJNA744060_P_NODE_1563_length_1168_cov_2.439269_g1387_i0	PRJNA744060	1563	1168	2.439269	28.49066192	Nanning Narna tick virus 3	2972237	Viruses	Viruses	68.9	1.6e-8	NR	UYL95385.1	2972237	g1387	i0	25.2	0.827054794520548	322	209	79.6	8	1152	223	317	618	UYL95385.1 MAG: hypothetical protein [Nanning Narna tick virus 3]	diamond	966	68.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Nanning Narna tick virus 3
27726501	27726501	PRJNA744060_P_NODE_3304_length_854_cov_3.142125_g3036_i0	PRJNA744060	3304	854	3.142125	26.8337475	Viruses	10239	Viruses	Viruses	119	4.52e-26	NR	XOD45381.1	3398652	g3036	i0	31.8	2.38524590163934	233	146	78.3	6	119	787	50	279	XOD45381.1 RdRp [Grapevine wood holobiome associated narna-like virus 16]	diamond	2037	120	0.991666666666667	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 16
28347595	28347595	PRJNA744060_P_NODE_7726_length_572_cov_3.545090_g7402_i0	PRJNA744060	7726	572	3.54509	20.2779148	Penaeus vannamei narna-like virus 2	3132560	Viruses	Viruses	50.8	0.00122	NR	WWZ85650.1	3132560	g7402	i0	41.4	0.456293706293706	87	43	42.5	4	36	278	557	641	WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2]	diamond	261	50.8	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Penaeus vannamei narna-like virus 2
30937508	30937508	PRJNA744060_P_NODE_2894_length_907_cov_2.211031_g2639_i0	PRJNA744060	2894	907	2.211031	20.05405117	Aspergillus flavus narnavirus 1	2871717	Viruses	Viruses	74.3	1.03e-10	NR	UAW09567.1	2871717	g2639	i0	27.4	1.53472987872106	234	152	72.4	5	680	24	51	281	UAW09567.1 MAG: replicase [Aspergillus flavus narnavirus 1]	diamond	1392	74.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus japonicum
32085788	32085788	PRJNA744060_P_NODE_3958_length_787_cov_2.040616_g3674_i0	PRJNA744060	3958	787	2.040616	16.05964792	Narnavirus	186767	Viruses	Viruses	113	2.48e-24	NR	QHD64828.1	2695338	g3674	i0	33.9	7.53621346886912	242	146	90.3	7	716	6	272	504	QHD64828.1 RdRp [Erysiphe necator associated narnavirus 5]	diamond	5931	114	0.991228070175439	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 5

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