metadata: contig_metadata: 5 rows where bioproject = "PRJNA520845", tax_kingdom = "Pararnavirae" and tax

5 rows where bioproject = "PRJNA520845", tax_kingdom = "Pararnavirae" 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
5595841	5595841	PRJNA520845_P_NODE_39365_length_602_cov_1.733459_g37895_i0	PRJNA520845	39365	602	1.733459	10.43542318	Gammaretrovirus murleu	3428959	Viruses	Viruses	1079	0	NTclustered	gi\|996270272\|gb\|KU324802.1\|	458105	g37895	i0	99.003	100.014950166113	602	6	100	0	1	602	6213	6814	Murine leukemia virus CasE#1, complete genome	blastn	60209	1079	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
6868121	6868121	PRJNA520845_P_NODE_219326_length_250_cov_0.870056_g217827_i0	PRJNA520845	219326	250	0.870056	2.17514	Paper mulberry vein-banding virus	2810460	Viruses	Viruses	322	1.56e-83	NTclustered	gi\|1983384635\|gb\|MW052244.1\|	2810460	g217827	i0	91.632	1.08	239	11	92	3	21	250	7559	7321	Paper mulberry vein-banding virus, complete genome	blastn	270	322	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Paper mulberry vein-banding virus
26728657	26728657	PRJNA520845_P_NODE_215141_length_251_cov_0.865169_g213642_i0	PRJNA520845	215141	251	0.865169	2.17157419	Paper mulberry vein-banding virus	2810460	Viruses	Viruses	97.4	2.42e-21	NR	QRN45547.1	2810460	g213642	i0	66.3	0.956175298804781	80	25	95.6	2	245	6	503	580	QRN45547.1 P3 [Paper mulberry vein-banding virus]	diamond	240	97.4	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Paper mulberry vein-banding virus
28119503	28119503	PRJNA520845_P_NODE_216645_length_251_cov_0.865169_g215146_i0	PRJNA520845	216645	251	0.865169	2.17157419	Paper mulberry vein-banding virus	2810460	Viruses	Viruses	161	9.46e-44	NR	QRN45547.1	2810460	g215146	i0	89.2	0.99203187250996006	83	9	99.2	0	249	1	204	286	QRN45547.1 P3 [Paper mulberry vein-banding virus]	diamond	249	161	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Paper mulberry vein-banding virus
28466967	28466967	PRJNA520845_P_NODE_169466_length_286_cov_1.309859_g167967_i0	PRJNA520845	169466	286	1.309859	3.74619674	Retroviridae sp.	2681591	Viruses	Viruses	62.4	7.38e-9	NR	XNT20556.1	2681591	g167967	i0	43.9	0.86013986013986	82	45	85	1	284	42	449	530	XNT20556.1 MAG: hypothetical protein, partial [Retroviridae sp.]	diamond	246	62.4	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae		Retroviridae 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);;