metadata: contig_metadata: 9 rows where bioproject = "PRJNA1046144", tax_phylum = "Negarnaviricota" and tax

9 rows where bioproject = "PRJNA1046144", tax_phylum = "Negarnaviricota" 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
22686215	22686215	PRJNA1046144_P_NODE_60218_length_232_cov_0.883436_g59923_i0	PRJNA1046144	60218	232	0.883436	2.04957152	Paramyxoviridae	11158	Viruses	Viruses	429	8.2e-116	NTclustered	gi\|2721617856\|gb\|PP711545.1\|	251774	g59923	i0	100	68.8189655172414	232	0	100	0	1	232	2855	3086	Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome	blastn	15966	429	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Rubulavirus	Porcine parainfluenza virus
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
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
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);;