metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA1145276" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA1145276" 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
288421	288421	PRJNA1145276_P_NODE_2461_length_615_cov_1.904059_g2405_i0	PRJNA1145276	2461	615	1.904059	11.70996285	Carlavirus jasmini	3427761	Viruses	Viruses	560	8.19e-155	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g2405	i0	83.089	1	615	104	100	0	1	615	4842	4228	Jasmine virus C isolate Bari, complete genome	blastn	615	560	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
1563096	1563096	PRJNA1145276_P_NODE_2_length_7820_cov_5.493094_g1_i0	PRJNA1145276	2	7820	5.493094	429.5599508	Carlavirus jasmini	3427761	Viruses	Viruses	6985	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g1	i0	82.81	7.75153452685422	7830	1327	100	19	1	7820	605	8425	Jasmine virus C isolate Bari, complete genome	blastn	60617	6985	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
1563200	1563200	PRJNA1145276_P_NODE_782_length_1038_cov_1.280829_g744_i0	PRJNA1145276	782	1038	1.280829	13.29500502	Carlavirus jasmini	3427761	Viruses	Viruses	1352	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g744	i0	90.173	2.00481695568401	1038	102	100	0	1	1038	3762	4799	Jasmine virus C isolate Bari, complete genome	blastn	2081	1352	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
2839259	2839259	PRJNA1145276_P_NODE_23_length_3117_cov_3.895861_g19_i0	PRJNA1145276	23	3117	3.895861	121.43398737	Carlavirus jasmini	3427761	Viruses	Viruses	2988	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g19	i0	84.003	9.77446262431826	3113	496	99	2	1	3112	4954	8065	Jasmine virus C isolate Bari, complete genome	blastn	30467	2988	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
2839261	2839261	PRJNA1145276_P_NODE_243_length_1627_cov_1.288932_g227_i0	PRJNA1145276	243	1627	1.288932	20.97092364	Carlavirus jasmini	3427761	Viruses	Viruses	1753	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g227	i0	86.335	3.96558082360172	1610	218	99	2	18	1625	3957	5566	Jasmine virus C isolate Bari, complete genome	blastn	6452	1753	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
2839289	2839289	PRJNA1145276_P_NODE_3_length_7496_cov_4.633975_g1_i1	PRJNA1145276	3	7496	4.633975	347.362766	Carlavirus jasmini	3427761	Viruses	Viruses	6481	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g1	i1	82.294	7.44410352187834	7506	1309	100	20	1	7496	605	8100	Jasmine virus C isolate Bari, complete genome	blastn	55801	6481	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
5391488	5391488	PRJNA1145276_P_NODE_1405_length_798_cov_1.314483_g1356_i0	PRJNA1145276	1405	798	1.314483	10.48957434	Carlavirus jasmini	3427761	Viruses	Viruses	946	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g1356	i0	88.08	1.3546365914787	797	95	99	0	2	798	5589	6385	Jasmine virus C isolate Bari, complete genome	blastn	1081	946	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
5391663	5391663	PRJNA1145276_P_NODE_3285_length_536_cov_1.680346_g3228_i0	PRJNA1145276	3285	536	1.680346	9.00665456	Carlavirus jasmini	3427761	Viruses	Viruses	743	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g3228	i0	91.76	13.0149253731343	534	44	99	0	1	534	8194	7661	Jasmine virus C isolate Bari, complete genome	blastn	6976	743	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
6666397	6666397	PRJNA1145276_P_NODE_586_length_1183_cov_1.690991_g553_i0	PRJNA1145276	586	1183	1.690991	20.00442353	Carlavirus jasmini	3427761	Viruses	Viruses	1240	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g553	i0	86.201	1.19611158072697	1145	158	97	0	1	1145	870	2014	Jasmine virus C isolate Bari, complete genome	blastn	1415	1240	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
6666455	6666455	PRJNA1145276_P_NODE_8286_length_353_cov_1.342857_g8229_i0	PRJNA1145276	8286	353	1.342857	4.74028521	Carlavirus jasmini	3427761	Viruses	Viruses	494	4.61e-135	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g8229	i0	92.241	8.70254957507082	348	27	99	0	1	348	32	379	Jasmine virus C isolate Bari, complete genome	blastn	3072	494	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
7941522	7941522	PRJNA1145276_P_NODE_4247_length_475_cov_1.189055_g4190_i0	PRJNA1145276	4247	475	1.189055	5.64801125	Carlavirus jasmini	3427761	Viruses	Viruses	529	1.7499999999999993e-145	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g4190	i0	86.765	1.00210526315789	476	61	100	2	1	475	2687	2213	Jasmine virus C isolate Bari, complete genome	blastn	476	529	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
9216490	9216490	PRJNA1145276_P_NODE_3248_length_540_cov_1.473233_g3191_i0	PRJNA1145276	3248	540	1.473233	7.9554582	Carlavirus jasmini	3427761	Viruses	Viruses	676	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g3191	i0	89.259	6.90555555555556	540	58	100	0	1	540	558	19	Jasmine virus C isolate Bari, complete genome	blastn	3729	676	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
10492130	10492130	PRJNA1145276_P_NODE_4929_length_445_cov_2.026882_g4872_i0	PRJNA1145276	4929	445	2.026882	9.0196249	Carlavirus jasmini	3427761	Viruses	Viruses	590	7.38e-164	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g4872	i0	90.562	1	445	42	100	0	1	445	7614	7170	Jasmine virus C isolate Bari, complete genome	blastn	445	590	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
14317357	14317357	PRJNA1145276_P_NODE_2712_length_590_cov_1.303675_g2656_i0	PRJNA1145276	2712	590	1.303675	7.6916825	Carlavirus jasmini	3427761	Viruses	Viruses	427	8.3e-115	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g2656	i0	81.871	0.869491525423729	513	88	87	5	1	511	2561	2052	Jasmine virus C isolate Bari, complete genome	blastn	513	427	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
15591360	15591360	PRJNA1145276_P_NODE_33_length_2903_cov_3.026148_g29_i0	PRJNA1145276	33	2903	3.026148	87.84907644	Carlavirus jasmini	3427761	Viruses	Viruses	3927	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g29	i0	91.078	12.1350327247675	2903	259	100	0	1	2903	5393	8295	Jasmine virus C isolate Bari, complete genome	blastn	35228	3927	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
15591484	15591484	PRJNA1145276_P_NODE_9413_length_332_cov_1.258687_g9356_i0	PRJNA1145276	9413	332	1.258687	4.17884084	Carlavirus jasmini	3427761	Viruses	Viruses	470	7.289999999999999e-128	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g9356	i0	92.169	1	332	26	100	0	1	332	640	309	Jasmine virus C isolate Bari, complete genome	blastn	332	470	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
16865717	16865717	PRJNA1145276_P_NODE_94_length_2178_cov_2.917815_g86_i0	PRJNA1145276	94	2178	2.917815	63.5500107	Carlavirus jasmini	3427761	Viruses	Viruses	2196	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g86	i0	84.881	7.28787878787879	2176	329	99	0	1	2176	5928	8103	Jasmine virus C isolate Bari, complete genome	blastn	15873	2196	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
18140133	18140133	PRJNA1145276_P_NODE_19375_length_241_cov_1.369048_g19318_i0	PRJNA1145276	19375	241	1.369048	3.29940568	Sarawak virus	2109380	Viruses	Viruses	351	1.91e-92	NTclustered	gi\|1571830969\|ref\|NC_040540.1\|	2109380	g19318	i0	92.946	2	241	17	100	0	1	241	4944	5184	Sarawak virus strain SWK-M26, complete genome	blastn	482	351	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Alphatetraviridae		Sarawak virus
19414543	19414543	PRJNA1145276_P_NODE_496_length_1282_cov_2.500414_g467_i0	PRJNA1145276	496	1282	2.500414	32.05530748	Carlavirus jasmini	3427761	Viruses	Viruses	1517	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g467	i0	88.097	13.0148205928237	1277	152	99	0	6	1282	7000	8276	Jasmine virus C isolate Bari, complete genome	blastn	16685	1517	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
19414555	19414555	PRJNA1145276_P_NODE_556_length_1217_cov_1.606643_g524_i0	PRJNA1145276	556	1217	1.606643	19.55284531	Carlavirus jasmini	3427761	Viruses	Viruses	1157	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g524	i0	83.813	4.02958093672966	1217	197	100	0	1	1217	5313	4097	Jasmine virus C isolate Bari, complete genome	blastn	4904	1157	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
21965224	21965224	PRJNA1145276_P_NODE_18_length_3283_cov_2.296262_g14_i0	PRJNA1145276	18	3283	2.296262	75.38628146	Carlavirus jasmini	3427761	Viruses	Viruses	4095	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g14	i0	89.269	5.87876941821505	3271	349	99	2	11	3280	2588	5857	Jasmine virus C isolate Bari, complete genome	blastn	19300	4095	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini
21965255	21965255	PRJNA1145276_P_NODE_3098_length_552_cov_2.112735_g3041_i0	PRJNA1145276	3098	552	2.112735	11.6622972	Carlavirus jasmini	3427761	Viruses	Viruses	741	0	NTclustered	gi\|2198353193\|gb\|OL828237.1\|	1853762	g3041	i0	90.926	0.998188405797101	551	50	99	0	1	551	6337	6887	Jasmine virus C isolate Bari, complete genome	blastn	551	741	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus jasmini

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