metadata: contig_metadata: 4 rows where bioproject = "PRJNA1237347", tax_kingdom = "Orthornavirae" and tax

4 rows where bioproject = "PRJNA1237347", tax_kingdom = "Orthornavirae" 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
29378250	29378250	PRJNA1237347_P_NODE_255929_length_369_cov_1.756757_g249356_i0	PRJNA1237347	255929	369	1.756757	6.48243333	Wenzhou Shrimp Virus 1	1608095	Viruses	Viruses	48.9	7.56e-4	NR	YP_009304992.1	1608095	g249356	i0	30	1.95934959349593	120	76	96.7	3	358	2	7	119	YP_009304992.1 nucleocapsid protein [Wenzhou Shrimp Virus 1]	diamond	723	48.9	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Wenrivirus	Wenrivirus penaei
32665019	32665019	PRJNA1237347_P_NODE_263600_length_362_cov_2.114187_g257027_i0	PRJNA1237347	263600	362	2.114187	7.65335694	Enontekio phenui-like virus 1	2980601	Viruses	Viruses	96.3	2.65e-20	NR	UYE93877.1	2980601	g257027	i0	41.7	0.994475138121547	120	70	99.4	0	3	362	6	125	UYE93877.1 MAG: RNA-dependent RNA polymerase, partial [Enontekio phenui-like virus 1]	diamond	360	96.3	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae		Enontekio phenui-like virus 1
32822939	32822939	PRJNA1237347_P_NODE_504920_length_247_cov_0.885057_g498347_i0	PRJNA1237347	504920	247	0.885057	2.18609079	Tulip streak virus	2761348	Viruses	Viruses	51.6	2.95e-5	NR	BCK51609.1	2761348	g498347	i0	37.9	1.7246963562753	66	38	76.5	1	9	197	1498	1563	BCK51609.1 replicase [Tulip streak virus]	diamond	426	51.6	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Konkoviridae	Olpivirus	Olpivirus tulipae
32885864	32885864	PRJNA1237347_P_NODE_98760_length_687_cov_1.754072_g92386_i0	PRJNA1237347	98760	687	1.754072	12.05047464	African cichlid piscichuvirus	3065075	Viruses	Viruses	130	1.29e-30	NR	WLN26256.1	3065075	g92386	i0	46.4	0.602620087336245	138	74	60.3	0	665	252	97	234	WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus]	diamond	414	130	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	African cichlid 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);;