metadata: contig_metadata: 14 rows where bioproject = "PRJNA867519" and tax

14 rows where bioproject = "PRJNA867519" 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
5951356	5951356	PRJNA867519_P_NODE_17305_length_287_cov_3.836449_g17151_i0	PRJNA867519	17305	287	3.836449	11.01060863	Skokie tombus-like virus	2789423	Viruses	Viruses	497	2.84e-136	NTclustered	gi\|1933757594\|gb\|MW177751.1\|	2789423	g17151	i0	97.909	1	287	6	100	0	1	287	16	302	Skokie tombus-like virus strain USAdp coat protein gene, partial cds	blastn	287	497	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Skokie tombus-like virus
7226371	7226371	PRJNA867519_P_NODE_2926_length_600_cov_1.413662_g2775_i0	PRJNA867519	2926	600	1.413662	8.481972	Carpotroche-associated picornavirus	2975512	Viruses	Viruses	948	0	NTclustered	gi\|2292905076\|gb\|OL964097.1\|	2975512	g2775	i0	95.167	3	600	29	100	0	1	600	5181	4582	Carpotroche-associated picornavirus polyprotein gene, complete cds	blastn	1800	948	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Carpotroche-associated picornavirus
18699425	18699425	PRJNA867519_P_NODE_2095_length_689_cov_1.383117_g1947_i0	PRJNA867519	2095	689	1.383117	9.52967613	Skokie tombus-like virus	2789423	Viruses	Viruses	322	4.75e-83	NTclustered	gi\|1933757594\|gb\|MW177751.1\|	2789423	g1947	i0	95.522	0.291727140783745	201	9	29	0	1	201	1069	1269	Skokie tombus-like virus strain USAdp coat protein gene, partial cds	blastn	201	322	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Skokie tombus-like virus
22524724	22524724	PRJNA867519_P_NODE_11018_length_346_cov_0.846154_g10864_i0	PRJNA867519	11018	346	0.846154	2.92769284	Carpotroche-associated picornavirus	2975512	Viruses	Viruses	568	2.6299999999999995e-157	NTclustered	gi\|2292905076\|gb\|OL964097.1\|	2975512	g10864	i0	96.243	2.99132947976879	346	13	100	0	1	346	3770	4115	Carpotroche-associated picornavirus polyprotein gene, complete cds	blastn	1035	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Carpotroche-associated picornavirus
26928619	26928619	PRJNA867519_P_NODE_322_length_1412_cov_1.462285_g245_i0	PRJNA867519	322	1412	1.462285	20.6474642	Sanya narna-like virus 1	2970204	Viruses	Viruses	303	8.020000000000001e-91	NR	UUW20996.1	2970204	g245	i0	40	0.902974504249292	425	245	89.7	4	1	1266	325	742	UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1]	diamond	1275	303	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Sanya narna-like virus 1
27189580	27189580	PRJNA867519_P_NODE_802_length_1015_cov_4.159236_g686_i0	PRJNA867519	802	1015	4.159236	42.2162454	Wolframvirales	2732502	Viruses	Viruses	131	9.16e-30	NR	QJT73724.1	2802527	g686	i0	31.6	1.84137931034483	320	197	91.3	11	931	5	5	313	QJT73724.1 RNA-dependent RNA polymerase [Botrytis cinerea binarnavirus 1]	diamond	1869	131	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus cinereae
28413233	28413233	PRJNA867519_P_NODE_1066_length_907_cov_3.513189_g937_i0	PRJNA867519	1066	907	3.513189	31.86462423	Rhabdoviridae sp.	1955137	Viruses	Viruses	75.9	2.76e-11	NR	XKB76561.1	1955137	g937	i0	30.3	0.588754134509372	178	116	57.6	4	146	667	255	428	XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.]	diamond	534	75.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Rhabdoviridae sp.
28791898	28791898	PRJNA867519_P_NODE_707_length_1058_cov_11.203046_g599_i0	PRJNA867519	707	1058	11.203046	118.52822668	Downy mildew lesion associated splipalmivirus 3	2719514	Viruses	Viruses	90.5	5.07e-17	NR	WNA22210.1	2719514	g599	i0	31	0.521739130434783	184	111	51.9	3	185	733	51	219	WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3]	diamond	552	90.5	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus ibericum
29171071	29171071	PRJNA867519_P_NODE_1669_length_754_cov_6.324523_g1523_i0	PRJNA867519	1669	754	6.324523	47.68690342	Wuhan Fly Virus 1	1608101	Viruses	Viruses	72.4	5.96e-11	NR	YP_009304999.1	1608101	g1523	i0	29.2	1.10610079575597	168	109	63.7	4	158	637	31	196	YP_009304999.1 nucleocapsid protein [Wuhan Fly Virus 1]	diamond	834	72.4	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Phasivirus	Phasivirus wuhanense
29242258	29242258	PRJNA867519_P_NODE_69_length_2344_cov_6.050638_g50_i0	PRJNA867519	69	2344	6.050638	141.82695472	Narnavirus	186767	Viruses	Viruses	238	7.38e-65	NR	QIR30285.1	2719531	g50	i0	28.8	3.24957337883959	638	383	78.1	18	201	2030	4	598	QIR30285.1 RNA-dependent RNA polymerase [Downy mildew lesion associated splipalmivirus 6]	diamond	7617	238	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 6
29360456	29360456	PRJNA867519_P_NODE_329_length_1396_cov_2.281935_g249_i0	PRJNA867519	329	1396	2.281935	31.8558126	Sjack associated narna-like virus 18	3067049	Viruses	Viruses	253	2.4e-72	NR	WPR17385.1	3067049	g249	i0	35.7	2.82808022922636	434	274	92.6	5	1293	1	36	467	WPR17385.1 MAG: RNA-dependent RNA polymerase, partial [Sjack associated narna-like virus 18]	diamond	3948	253	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Sjack associated narna-like virus 18
29526486	29526486	PRJNA867519_P_NODE_90_length_2101_cov_9.178994_g61_i0	PRJNA867519	90	2101	9.178994	192.85066394	Narnavirus	186767	Viruses	Viruses	174	3.389999999999999e-42	NR	UYL94525.1	2985682	g61	i0	28.4	2.06615897191813	483	302	65.5	16	301	1677	69	531	UYL94525.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 7]	diamond	4341	174	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Leptosphaeria biglobosa narnavirus 7
30000206	30000206	PRJNA867519_P_NODE_19471_length_278_cov_1.385366_g19317_i0	PRJNA867519	19471	278	1.385366	3.85131748	Chuvivirus	2842604	Viruses	Viruses	121	4.88e-30	NR	WET19887.1	2842604	g19317	i0	64.1	1.98561151079137	92	33	99.3	0	3	278	267	358	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	552	121	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
32204905	32204905	PRJNA867519_P_NODE_238_length_1524_cov_14.020675_g173_i0	PRJNA867519	238	1524	14.020675	213.675087	Durnavirales sp.	2809355	Viruses	Viruses	426	2.08e-141	NR	WRQ64726.1	2809355	g173	i0	47.9	0.96259842519685	489	239	94.7	6	50	1492	1	481	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1467	426	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales 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);;