metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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
27856451	27856451	PRJNA1046144_P_NODE_16325_length_399_cov_5.639394_g16030_i0	PRJNA1046144	16325	399	5.639394	22.50118206	Sinu virus	1927799	Viruses	Viruses	184	6.13e-53	NR	YP_010840496.1	1927799	g16030	i0	60.8	0.977443609022556	130	51	97.7	0	3	392	360	489	YP_010840496.1 glycoprotein [Sinu virus]	diamond	390	184	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
28172220	28172220	PRJNA1046144_P_NODE_65126_length_229_cov_0.900000_g64831_i0	PRJNA1046144	65126	229	0.9	2.061	Sinu virus	1927799	Viruses	Viruses	114	1.4700000000000002e-27	NR	YP_010840497.1	1927799	g64831	i0	72.4	0.995633187772926	76	21	99.6	0	228	1	263	338	YP_010840497.1 PB2 polymerase subunit [Sinu virus]	diamond	228	114	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
28835332	28835332	PRJNA1046144_P_NODE_54268_length_238_cov_1.704142_g53973_i0	PRJNA1046144	54268	238	1.704142	4.05585796	Reoviridae sp.	2585267	Viruses	Viruses	118	1.02e-28	NR	WWV87256.1	2585267	g53973	i0	68.4	0.995798319327731	79	25	99.6	0	238	2	810	888	WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.]	diamond	237	118	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Reoviridae sp.
29119739	29119739	PRJNA1046144_P_NODE_70489_length_223_cov_2.266234_g70194_i0	PRJNA1046144	70489	223	2.266234	5.05370182	Reoviridae sp.	2585267	Viruses	Viruses	91.3	2.4e-19	NR	WWV87256.1	2585267	g70194	i0	59.5	1.97757847533632	74	30	99.6	0	1	222	638	711	WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.]	diamond	441	91.3	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Reoviridae sp.
29214471	29214471	PRJNA1046144_P_NODE_289_length_2131_cov_3.489816_g266_i0	PRJNA1046144	289	2131	3.489816	74.36797896	Guiyang narnavirus 1	2905332	Viruses	Viruses	479	4.16e-156	NR	UHR49782.1	2905332	g266	i0	39.9	1.0361332707649	736	378	98.7	16	2106	4	3	709	UHR49782.1 MAG: RNA-dependent RNA polymerase, partial [Guiyang narnavirus 1]	diamond	2208	479	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Guiyang narnavirus 1
29498341	29498341	PRJNA1046144_P_NODE_39630_length_272_cov_2.128079_g39335_i0	PRJNA1046144	39630	272	2.128079	5.78837488	Sinu virus	1927799	Viruses	Viruses	155	3.0299999999999996e-42	NR	YP_010840494.1	1927799	g39335	i0	75.6	0.992647058823529	90	22	99.3	0	271	2	543	632	YP_010840494.1 PA polymerase subunit [Sinu virus]	diamond	270	155	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
29561376	29561376	PRJNA1046144_P_NODE_2710_length_929_cov_10.017442_g2501_i0	PRJNA1046144	2710	929	10.017442	93.06203618	Sinu virus	1927799	Viruses	Viruses	297	5.59e-97	NR	YP_010840498.1	1927799	g2501	i0	53.9	0.8751345532831	271	123	86.9	1	901	95	1	271	YP_010840498.1 ML [Sinu virus]	diamond	813	297	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
29782533	29782533	PRJNA1046144_P_NODE_22951_length_343_cov_1.576642_g22656_i0	PRJNA1046144	22951	343	1.576642	5.40788206	Sinu virus	1927799	Viruses	Viruses	175	8.86e-49	NR	YP_010840499.1	1927799	g22656	i0	76.1	0.988338192419825	113	27	98.8	0	3	341	125	237	YP_010840499.1 PB1 protein [Sinu virus]	diamond	339	175	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
31520733	31520733	PRJNA1046144_P_NODE_55616_length_235_cov_2.572289_g55321_i0	PRJNA1046144	55616	235	2.572289	6.04487915	Sinu virus	1927799	Viruses	Viruses	58.9	6.66e-8	NR	YP_010840494.1	1927799	g55321	i0	47.1	0.868085106382979	68	34	85.5	2	34	234	109	175	YP_010840494.1 PA polymerase subunit [Sinu virus]	diamond	204	58.9	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
31520735	31520735	PRJNA1046144_P_NODE_57096_length_234_cov_2.048485_g56801_i0	PRJNA1046144	57096	234	2.048485	4.7934549	Reoviridae sp.	2585267	Viruses	Viruses	103	9.379999999999999e-24	NR	WWV87256.1	2585267	g56801	i0	64.9	0.987179487179487	77	27	98.7	0	232	2	734	810	WWV87256.1 MAG: RNA-dependent RNA polymerase [Reoviridae sp.]	diamond	231	103	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Reoviridae sp.
31836675	31836675	PRJNA1046144_P_NODE_44777_length_259_cov_3.989474_g44482_i0	PRJNA1046144	44777	259	3.989474	10.33273766	Sinu virus	1927799	Viruses	Viruses	74.3	3.38e-13	NR	YP_010840496.1	1927799	g44482	i0	50	0.833976833976834	72	32	81.1	2	211	2	7	76	YP_010840496.1 glycoprotein [Sinu virus]	diamond	216	74.3	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense
31836686	31836686	PRJNA1046144_P_NODE_7777_length_565_cov_2.322581_g7485_i0	PRJNA1046144	7777	565	2.322581	13.12258265	Sinu virus	1927799	Viruses	Viruses	150	1.9e-39	NR	YP_010840496.1	1927799	g7485	i0	41.1	2.03362831858407	185	105	96.6	2	20	565	203	386	YP_010840496.1 glycoprotein [Sinu virus]	diamond	1149	150	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Thogotovirus	Thogotovirus sinuense

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