metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax_kingdom = "Orthornavirae"

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
28926431	28926431	PRJNA870096_S_NODE_91748_length_184_cov_1.021277_g90084_i0	PRJNA870096	91748	184	1.021277	1.87914968	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	43.5	0.00391	NR	NP_859022.1	RQ13	g90084	i0	36.4	3.45652173913043	55	34	89.7	1	183	19	51	104	NP_859022.1 2A [Kobuvirus bejaponia]	diamond	636	43.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
29360484	29360484	PRJNA870096_S_NODE_137529_length_153_cov_0.872727_g135865_i0	PRJNA870096	137529	153	0.872727	1.33527231	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	61.2	3.33e-9	NR	WAB24476.1	RQ13	g135865	i0	60	0.980392156862745	50	20	98	0	1	150	2561	2610	WAB24476.1 polyprotein [Avian megrivirus]	diamond	150	61.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Megrivirus	Zebrafish jaw picornavirus
29739044	29739044	PRJNA870096_S_NODE_136970_length_153_cov_0.872727_g135306_i0	PRJNA870096	136970	153	0.872727	1.33527231	Spring viraemia of carp virus	696863	Viruses	Viruses	70.9	2.62e-13	NR	QHX41416.1	696863	g135306	i0	60	3.92156862745098	50	20	98	0	3	152	104	153	QHX41416.1 glycoprotein, partial [Sprivivirus cyprinus]	diamond	600	70.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
29936976	29936976	PRJNA870096_S_NODE_35491_length_299_cov_3.023438_g33827_i0	PRJNA870096	35491	299	3.023438	9.04007962	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	74.3	6.01e-13	NR	QJX58422.1	RQ13	g33827	i0	44.3	4.69565217391304	97	52	95.3	2	299	15	2256	2352	QJX58422.1 polyprotein [Salivirus A]	diamond	1404	74.7	0.994645247657296	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Salivirus	Zebrafish jaw picornavirus
30876661	30876661	PRJNA870096_S_NODE_108974_length_170_cov_1.133858_g107310_i0	PRJNA870096	108974	170	1.133858	1.9275586	Rocky Mountain birnavirus	3077841	Viruses	Viruses	99.4	1.6000000000000002e-22	NR	WNN64190.1	3077841	g107310	i0	92.9	0.988235294117647	56	4	98.8	0	168	1	761	816	WNN64190.1 VP1 [Rocky Mountain birnavirus]	diamond	168	99.4	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
31414069	31414069	PRJNA870096_S_NODE_64036_length_219_cov_1.363636_g62372_i0	PRJNA870096	64036	219	1.363636	2.98636284	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	52	1.56e-5	NR	QMI57975.1	RQ13	g62372	i0	52.3	2.83561643835616	44	21	60.3	0	85	216	1029	1072	QMI57975.1 polyprotein, partial [Pacific black duck sicinivirus-like virus]	diamond	621	52	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Sicinivirus	Zebrafish jaw picornavirus
31951696	31951696	PRJNA870096_S_NODE_126097_length_159_cov_1.017241_g124433_i0	PRJNA870096	126097	159	1.017241	1.61741319	Spring viraemia of carp virus	696863	Viruses	Viruses	52.8	2.51e-6	NR	AMR72046.1	696863	g124433	i0	49	3.84905660377358	51	26	96.2	0	3	155	126	176	AMR72046.1 glycoprotein, partial [Sprivivirus cyprinus]	diamond	612	52.8	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
32300181	32300181	PRJNA870096_S_NODE_55079_length_237_cov_0.953608_g53415_i0	PRJNA870096	55079	237	0.953608	2.26005096	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	104	2.33e-24	NR	ADI48258.1	RQ13	g53415	i0	57.1	0.974683544303797	77	32	97.5	1	2	232	121	196	ADI48258.1 3D, partial [Bat kobuvirus TM003k]	diamond	231	104	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Kobuvirus	Zebrafish jaw picornavirus
32394822	32394822	PRJNA870096_S_NODE_115399_length_165_cov_2.459016_g113735_i0	PRJNA870096	115399	165	2.459016	4.0573764	Spring viraemia of carp virus	696863	Viruses	Viruses	72.4	4.3e-13	NR	NP_116744.1	696863	g113735	i0	64.8	0.981818181818182	54	19	98.2	0	4	165	335	388	NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus]	diamond	162	72.4	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
32647099	32647099	PRJNA870096_S_NODE_63520_length_220_cov_1.237288_g61856_i0	PRJNA870096	63520	220	1.237288	2.7220336	Spring viraemia of carp virus	696863	Viruses	Viruses	94.7	1.41e-20	NR	NP_116748.1	696863	g61856	i0	64.4	0.995454545454545	73	26	99.5	0	1	219	1802	1874	NP_116748.1 polymerase [Sprivivirus cyprinus]	diamond	219	94.7	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus

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