metadata: contig_metadata: 12 rows where bioproject = "PRJNA379145" and tax

12 rows where bioproject = "PRJNA379145" and tax_phylum = "Kitrinoviricota"

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
2349358	2349358	PRJNA379145_P_NODE_51162_length_227_cov_1.716495_g49008_i0	PRJNA379145	51162	227	1.716495	3.89644365	Potexvirus	12176	Viruses	Viruses	418	1.7299999999999996e-112	NTclustered	gi\|1839430140\|gb\|MK860513.1\|	112229	g49008	i0	100	99.5594713656388	226	0	99	0	1	226	739	964	Pepino mosaic virus isolate MU14_4.19a_Mo TGB1 protein, TGB2 protein, TGB3 protein, and CP protein genes, complete cds	blastn	22600	418	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
2951321	2951321	PRJNA379145_P_NODE_23343_length_526_cov_1.933063_g21360_i0	PRJNA379145	23343	526	1.933063	10.16791138	Martellivirales sp.	2809552	Viruses	Viruses	54.7	0.014	NTclustered	gi\|2647548574\|gb\|OR843378.1\|	2809552	g21360	i0	100	0.0551330798479087	29	0	6	0	245	273	12322	12294	Martellivirales sp. strain MR233-17E/76 polyprotein gene, partial cds	blastn	29	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales			Martellivirales sp.
6177009	6177009	PRJNA379145_P_NODE_63625_length_177_cov_1.006944_g61471_i0	PRJNA379145	63625	177	1.006944	1.78229088	Potexvirus	12176	Viruses	Viruses	311	2.23e-80	NTclustered	gi\|1805119874\|gb\|MN038406.1\|	112229	g61471	i0	98.305	93.9604519774011	177	3	100	0	1	177	2374	2198	Pepino mosaic virus strain MZ3, complete genome	blastn	16631	311	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
13154683	13154683	PRJNA379145_P_NODE_45811_length_259_cov_1.420354_g43658_i0	PRJNA379145	45811	259	1.420354	3.67871686	Potexvirus pepini	3433856	Viruses	Viruses	468	1.98e-127	NTclustered	gi\|148283741\|gb\|EF408821.3\|	112229	g43658	i0	99.228	96.030888030888	259	2	100	0	1	259	19	277	Pepino mosaic virus isolate PepMV-PK, complete genome	blastn	24872	468	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
15703846	15703846	PRJNA379145_P_NODE_67953_length_165_cov_1.037879_g65799_i0	PRJNA379145	67953	165	1.037879	1.71250035	Tobamovirus tabaci	3432891	Viruses	Viruses	294	2.08e-75	NTclustered	gi\|2813525801\|dbj\|LC846392.1\|	12242	g65799	i0	98.788	100.012121212121	165	2	100	0	1	165	3948	3784	Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome	blastn	16502	294	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
19526992	19526992	PRJNA379145_P_NODE_67916_length_165_cov_1.136364_g65762_i0	PRJNA379145	67916	165	1.136364	1.8750006	Tobamovirus tabaci	3432891	Viruses	Viruses	300	4.46e-77	NTclustered	gi\|388240225\|emb\|HE818435.1\|	12242	g65762	i0	99.394	99.9333333333333	165	1	100	0	1	165	4278	4442	Tobacco mosaic virus isolate Ludian, complete genome	blastn	16489	300	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
20802393	20802393	PRJNA379145_P_NODE_47037_length_251_cov_1.866972_g44884_i0	PRJNA379145	47037	251	1.866972	4.68609972	Ripothoz virus	3131336	Viruses	Viruses	130	1.02e-25	NTclustered	gi\|2717322249\|gb\|PP173638.1\|	3131336	g44884	i0	96.25	1.51792828685259	80	2	31	1	19	97	5631	5552	MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence	blastn	381	130	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripothoz virus
27643789	27643789	PRJNA379145_P_NODE_13924_length_774_cov_1.794872_g12409_i0	PRJNA379145	13924	774	1.794872	13.89230928	Erysiphe necator associated flexivirus 3	2743100	Viruses	Viruses	208	2.34e-57	NR	QKN22675.1	2743100	g12409	i0	52.7	2.18992248062015	203	91	77.5	3	774	175	564	764	QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3]	diamond	1695	208	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 3
28148900	28148900	PRJNA379145_P_NODE_18105_length_642_cov_1.880131_g16327_i0	PRJNA379145	18105	642	1.880131	12.07044102	Erysiphe necator associated flexivirus 2	2743099	Viruses	Viruses	164	9.23e-43	NR	QKN22646.1	2743099	g16327	i0	72	1.14485981308411	118	33	55.1	0	288	641	1157	1274	QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2]	diamond	735	164	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 2
28401414	28401414	PRJNA379145_P_NODE_48446_length_242_cov_2.066986_g46292_i0	PRJNA379145	48446	242	2.066986	5.00210612	Fusarium deltaflexivirus 2	2973081	Viruses	Viruses	114	2.4199999999999998e-27	NR	BDQ13824.1	2973081	g46292	i0	66.3	0.991735537190083	80	27	99.2	0	240	1	364	443	BDQ13824.1 unnamed protein product [Fusarium deltaflexivirus 2]	diamond	240	114	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Fusarium deltaflexivirus 2
30580277	30580277	PRJNA379145_P_NODE_613_length_2772_cov_4.202994_g506_i0	PRJNA379145	613	2772	4.202994	116.50699368	Sclerotinia sclerotiorum deltaflexivirus 1	1788309	Viruses	Viruses	86.7	4.12e-15	NR	YP_009508364.1	1788309	g506	i0	38.3	0.143939393939394	133	80	14.4	2	1031	633	67	197	YP_009508364.1 hypothetical protein [Sclerotinia sclerotiorum deltaflexivirus 1]	diamond	399	86.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae	Deltaflexivirus	Deltaflexivirus sclerotiniae
31939783	31939783	PRJNA379145_P_NODE_43617_length_274_cov_1.601660_g41465_i0	PRJNA379145	43617	274	1.60166	4.3885484	Pestalotiopsis deltaflexivirus 1	2816841	Viruses	Viruses	128	3.88e-32	NR	QTH80200.1	2816841	g41465	i0	58.9	1.98175182481752	90	37	98.5	0	1	270	440	529	QTH80200.1 MAG: RNA-dependent RNA polymerase [Pestalotiopsis deltaflexivirus 1]	diamond	543	128	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Pestalotiopsis deltaflexivirus 1

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