metadata: contig_metadata: 11 rows where bioproject = "PRJNA690124", tax_phylum = "Kitrinoviricota" and tax

11 rows where bioproject = "PRJNA690124", tax_phylum = "Kitrinoviricota" 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
669279	669279	PRJNA690124_P_NODE_34001_length_285_cov_1.103774_g33635_i0	PRJNA690124	34001	285	1.103774	3.1457559	Capillovirus mali	28347	Viruses	Viruses	427	3.74e-115	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g33635	i0	93.972	1.97894736842105	282	17	99	0	4	285	1734	1453	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	564	427	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
669780	669780	PRJNA690124_P_NODE_55701_length_242_cov_0.923077_g55335_i0	PRJNA690124	55701	242	0.923077	2.23384634	Capillovirus mali	28347	Viruses	Viruses	364	2.4699999999999992e-96	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g55335	i0	93.802	2	242	15	100	0	1	242	1467	1226	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	484	364	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
1945755	1945755	PRJNA690124_P_NODE_52442_length_245_cov_0.906977_g52076_i0	PRJNA690124	52442	245	0.906977	2.22209365	Foveavirus mali	35350	Viruses	Viruses	283	7.2e-72	NTclustered	gi\|1229033421\|gb\|KY081217.1\|	35350	g52076	i0	93.651	9.60816326530612	189	12	77	0	57	245	1	189	Foveavirus mali isolate YSH2 coat protein gene, complete cds	blastn	2354	283	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
10872938	10872938	PRJNA690124_P_NODE_15649_length_408_cov_1.994030_g15283_i0	PRJNA690124	15649	408	1.99403	8.1356424	Capillovirus mali	28347	Viruses	Viruses	682	0	NTclustered	gi\|1824676484\|gb\|MK481972.1\|	28347	g15283	i0	96.814	43.9950980392157	408	13	100	0	1	408	3712	3305	Apple stem grooving virus isolate Tibet-4, complete genome	blastn	17950	682	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
12148747	12148747	PRJNA690124_P_NODE_42130_length_256_cov_0.945355_g41764_i0	PRJNA690124	42130	256	0.945355	2.4201088	Foveavirus mali	35350	Viruses	Viruses	433	7.11e-117	NTclustered	gi\|526132482\|gb\|JX673872.1\|	35350	g41764	i0	97.255	7.921875	255	7	99	0	2	256	514	768	Apple stem pitting virus clone HN-HM-20 TGB1, TGB2, and TGB3 genes, complete cds	blastn	2028	433	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
12148966	12148966	PRJNA690124_P_NODE_52450_length_245_cov_0.906977_g52084_i0	PRJNA690124	52450	245	0.906977	2.22209365	Trichovirus mali	12175	Viruses	Viruses	276	1.21e-69	NTclustered	gi\|1810787445\|gb\|MK368730.1\|	12175	g52084	i0	87.045	5.96326530612245	247	28	100	4	1	245	2850	3094	Apple chlorotic leaf spot virus isolate Shanxi_1, complete genome	blastn	1461	276	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Trichovirus mali
13422909	13422909	PRJNA690124_P_NODE_22911_length_341_cov_1.291045_g22545_i0	PRJNA690124	22911	341	1.291045	4.40246345	Capillovirus mali	28347	Viruses	Viruses	558	1.56e-154	NTclustered	gi\|2219859828\|gb\|OM313335.1\|	28347	g22545	i0	96.188	100.105571847507	341	13	100	0	1	341	353	13	Apple stem grooving virus isolate SD-Pb312-8S coat protein gene, complete cds	blastn	34136	558	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali
13423510	13423510	PRJNA690124_P_NODE_50431_length_247_cov_0.896552_g50065_i0	PRJNA690124	50431	247	0.896552	2.21448344	Foveavirus mali	35350	Viruses	Viruses	416	6.869999999999999e-112	NTclustered	gi\|526132506\|gb\|JX673878.1\|	35350	g50065	i0	99.134	39.9716599190283	231	2	94	0	17	247	1026	796	Apple stem pitting virus clone LN-AP1-1 TGB1, TGB2, and TGB3 genes, complete cds	blastn	9873	416	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
17247674	17247674	PRJNA690124_P_NODE_56074_length_242_cov_0.923077_g55708_i0	PRJNA690124	56074	242	0.923077	2.23384634	Foveavirus mali	35350	Viruses	Viruses	431	2.4e-116	NTclustered	gi\|2111969293\|gb\|MZ148040.1\|	35350	g55708	i0	98.76	8.70661157024793	242	3	100	0	1	242	5316	5075	Foveavirus mali isolate 13TF175D, complete genome	blastn	2107	431	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
21071803	21071803	PRJNA690124_P_NODE_37937_length_270_cov_1.335025_g37571_i0	PRJNA690124	37937	270	1.335025	3.6045675	Foveavirus mali	35350	Viruses	Viruses	438	1.6299999999999993e-118	NTclustered	gi\|285804505\|gb\|FJ970954.1\|	35350	g37571	i0	95.926	99.5666666666667	270	11	100	0	1	270	623	354	Apple stem pitting virus isolate 402ASP coat protein gene, partial cds	blastn	26883	438	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Foveavirus	Foveavirus mali
23622077	23622077	PRJNA690124_P_NODE_32039_length_292_cov_2.429224_g31673_i0	PRJNA690124	32039	292	2.429224	7.09333408	Capillovirus mali	28347	Viruses	Viruses	477	3.77e-130	NTclustered	gi\|1824676451\|gb\|MK481961.1\|	28347	g31673	i0	96.233	8.9486301369863	292	10	100	1	1	292	2921	3211	Apple stem grooving virus isolate Ordos-7, complete genome	blastn	2613	477	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Capillovirus	Capillovirus mali

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