metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA474911" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA474911" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2372570	2372570	PRJNA474911_P_NODE_6522_length_217_cov_2.429487_g6395_i0	PRJNA474911	6522	217	2.429487	5.27198679	Viruses	10239	Viruses	Viruses	390	3.579999999999999e-104	NTclustered	gi\|822478147\|gb\|KP969949.1\|	595895	g6395	i0	99.078	23.5391705069124	217	2	100	0	1	217	872	1088	Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	5108	390	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
2998355	2998355	PRJNA474911_P_NODE_3323_length_329_cov_1.194030_g3197_i0	PRJNA474911	3323	329	1.19403	3.9283587	Shahe picorna-like virus 13	1923443	Viruses	Viruses	608	1.4599999999999995e-169	NTclustered	gi\|1110864981\|gb\|KX883657.1\|	1923443	g3197	i0	100	7.7629179331307	329	0	100	0	1	329	7417	7089	Shahe picorna-like virus 13 strain SHWC13556 hypothetical protein gene, complete cds	blastn	2554	608	1	Viruses								Shahe picorna-like virus 13
2998363	2998363	PRJNA474911_P_NODE_6823_length_211_cov_1.706667_g6696_i0	PRJNA474911	6823	211	1.706667	3.60106737	Drosophila A virus	595895	Viruses	Viruses	379	7.489999999999999e-101	NTclustered	gi\|822478135\|gb\|KP969945.1\|	595895	g6696	i0	99.052	40.7440758293839	211	2	100	0	1	211	215	5	Drosophila A virus isolate XID_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds	blastn	8597	379	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
5551278	5551278	PRJNA474911_P_NODE_2045_length_435_cov_1.695187_g1920_i0	PRJNA474911	2045	435	1.695187	7.37406345	Drosophila A virus	595895	Viruses	Viruses	787	0	NTclustered	gi\|822478132\|gb\|KP969944.1\|	595895	g1920	i0	99.31	37.8275862068966	435	3	100	0	1	435	266	700	Drosophila A virus isolate wipe_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	16455	787	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
6825206	6825206	PRJNA474911_P_NODE_2066_length_433_cov_1.537634_g1941_i0	PRJNA474911	2066	433	1.537634	6.65795522	Drosophila A virus	595895	Viruses	Viruses	784	0	NTclustered	gi\|822478147\|gb\|KP969949.1\|	595895	g1941	i0	99.307	31.4133949191686	433	3	100	0	1	433	3040	2608	Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	13602	784	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
6825211	6825211	PRJNA474911_P_NODE_5746_length_235_cov_1.839080_g5619_i0	PRJNA474911	5746	235	1.83908	4.321838	Cripavirus drosophilae	3047809	Viruses	Viruses	429	8.33e-116	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g5619	i0	99.574	20.0893617021277	235	1	100	0	1	235	6598	6364	Drosophila C virus isolate SMN, complete genome	blastn	4721	429	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
6825212	6825212	PRJNA474911_P_NODE_5986_length_229_cov_2.619048_g5859_i0	PRJNA474911	5986	229	2.619048	5.99761992	Cripavirus drosophilae	3047809	Viruses	Viruses	412	8.13e-111	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g5859	i0	99.127	10.1834061135371	229	2	100	0	1	229	7106	6878	Drosophila C virus isolate SMN, complete genome	blastn	2332	412	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
6825216	6825216	PRJNA474911_P_NODE_7366_length_207_cov_0.876712_g7239_i0	PRJNA474911	7366	207	0.876712	1.81479384	Caudoviricetes sp.	2832643	Viruses	Viruses	361	2.65e-95	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g7239	i0	98.068	355.95652173913	207	4	100	0	1	207	18145	17939	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	73683	361	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
6825223	6825223	PRJNA474911_P_NODE_866_length_689_cov_2.452229_g752_i0	PRJNA474911	866	689	2.452229	16.89585781	Cripavirus drosophilae	3047809	Viruses	Viruses	1234	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g752	i0	98.984	8.99564586357039	689	7	100	0	1	689	3377	4065	Drosophila C virus isolate SMN, complete genome	blastn	6198	1234	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
8100710	8100710	PRJNA474911_P_NODE_1287_length_561_cov_1.814000_g1165_i0	PRJNA474911	1287	561	1.814	10.17654	Cripavirus drosophilae	3047809	Viruses	Viruses	970	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1165	i0	97.861	8.99286987522282	561	12	100	0	1	561	2770	3330	Drosophila C virus isolate CYG, complete genome	blastn	5045	970	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
9375441	9375441	PRJNA474911_P_NODE_3588_length_314_cov_3.114625_g3462_i0	PRJNA474911	3588	314	3.114625	9.7799225	Cripavirus drosophilae	3047809	Viruses	Viruses	544	3.98e-150	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g3462	i0	98.077	7.94585987261147	312	6	99	0	3	314	1701	2012	Drosophila C virus isolate CYG, complete genome	blastn	2495	544	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
9375445	9375445	PRJNA474911_P_NODE_7028_length_209_cov_0.864865_g6901_i0	PRJNA474911	7028	209	0.864865	1.80756785	Eriocheir sinensis alphatetra-like virus	3022104	Viruses	Viruses	274	3.59e-69	NTclustered	gi\|2430285571\|gb\|OP019089.1\|	3022104	g6901	i0	90.385	0.995215311004785	208	20	99	0	1	208	9785	9578	MAG: Eriocheir sinensis alphatetra-like virus isolate Tangshan, Hebei genomic sequence	blastn	208	274	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Alphatetraviridae		Eriocheir sinensis alphatetra-like virus
10651312	10651312	PRJNA474911_P_NODE_2829_length_364_cov_1.452145_g2703_i0	PRJNA474911	2829	364	1.452145	5.2858078	Drosophila A virus	595895	Viruses	Viruses	623	5.839999999999999e-174	NTclustered	gi\|822478144\|gb\|KP969948.1\|	595895	g2703	i0	97.527	41.6730769230769	364	9	100	0	1	364	3598	3235	Drosophila A virus isolate XIB_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds	blastn	15169	623	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
10651315	10651315	PRJNA474911_P_NODE_4309_length_280_cov_1.598174_g4182_i0	PRJNA474911	4309	280	1.598174	4.4748872	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	433	7.89e-117	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4182	i0	94.624	0.996428571428571	279	15	99	0	1	279	4419	4697	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	279	433	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
11926282	11926282	PRJNA474911_P_NODE_3590_length_314_cov_2.996047_g3464_i0	PRJNA474911	3590	314	2.996047	9.40758758	Cripavirus drosophilae	3047809	Viruses	Viruses	568	2.3599999999999998e-157	NTclustered	gi\|1743646610\|gb\|MK645239.1\|	64279	g3464	i0	99.361	8.97133757961783	313	2	99	0	2	314	6823	6511	Drosophila C virus isolate EB, complete genome	blastn	2817	568	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
11926285	11926285	PRJNA474911_P_NODE_4010_length_293_cov_2.943966_g3883_i0	PRJNA474911	4010	293	2.943966	8.62582038	Drosophila A virus	595895	Viruses	Viruses	525	1.3299999999999994e-144	NTclustered	gi\|822478147\|gb\|KP969949.1\|	595895	g3883	i0	98.976	29.8361774744027	293	3	100	0	1	293	1921	1629	Drosophila A virus isolate delta11_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	8742	525	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
13201276	13201276	PRJNA474911_P_NODE_8131_length_202_cov_0.907801_g8004_i0	PRJNA474911	8131	202	0.907801	1.83375802	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	124	3.669999999999999e-24	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8004	i0	92.045	0.435643564356436	88	7	44	0	2	89	1529	1442	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	88	124	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14476188	14476188	PRJNA474911_P_NODE_2132_length_427_cov_1.822404_g2007_i0	PRJNA474911	2132	427	1.822404	7.78166508	Cripavirus drosophilae	3047809	Viruses	Viruses	619	8.999999999999999e-173	NTclustered	gi\|300871977\|gb\|GU983899.2\|	64279	g2007	i0	98.3	24.8524590163934	353	6	83	0	75	427	99	451	Drosophila C virus isolate AkGB1 polyprotein gene, partial cds	blastn	10612	619	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
14476193	14476193	PRJNA474911_P_NODE_5612_length_238_cov_1.418079_g5485_i0	PRJNA474911	5612	238	1.418079	3.37502802	Drosophila A virus	595895	Viruses	Viruses	418	1.8299999999999998e-112	NTclustered	gi\|822478135\|gb\|KP969945.1\|	595895	g5485	i0	98.319	21.7941176470588	238	4	100	0	1	238	2440	2203	Drosophila A virus isolate XID_DrosophilaA RNA-dependent RNA polymerase gene, complete cds; and capsid precursor, gene, partial cds	blastn	5187	418	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
15750266	15750266	PRJNA474911_P_NODE_1093_length_613_cov_3.798913_g975_i0	PRJNA474911	1093	613	3.798913	23.28733669	Cripavirus drosophilae	3047809	Viruses	Viruses	1088	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g975	i0	98.695	12.8238172920065	613	8	100	0	1	613	7030	7642	Drosophila C virus isolate CYG, complete genome	blastn	7861	1088	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
15750267	15750267	PRJNA474911_P_NODE_173_length_1424_cov_2.596478_g129_i0	PRJNA474911	173	1424	2.596478	36.97384672	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2025	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g129	i0	92.281	1.00070224719101	1425	108	100	2	1	1424	5512	6935	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	1425	2025	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15750273	15750273	PRJNA474911_P_NODE_4153_length_286_cov_1.466667_g4026_i0	PRJNA474911	4153	286	1.466667	4.19466762	Caudoviricetes sp.	2832643	Viruses	Viruses	479	1.02e-130	NTclustered	gi\|2054434277\|tpg\|BK035998.1\|	2832643	g4026	i0	96.864	429.164335664336	287	8	100	1	1	286	18106	18392	MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome	blastn	122741	479	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
15750277	15750277	PRJNA474911_P_NODE_553_length_871_cov_2.664198_g459_i0	PRJNA474911	553	871	2.664198	23.20516458	Cripavirus drosophilae	3047809	Viruses	Viruses	1554	0	NTclustered	gi\|2322367289\|gb\|OK188767.1\|	64279	g459	i0	98.852	21.5430539609644	871	10	100	0	1	871	6367	5497	Drosophila C virus isolate SMN, complete genome	blastn	18764	1554	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
17024902	17024902	PRJNA474911_P_NODE_6054_length_228_cov_1.149701_g5927_i0	PRJNA474911	6054	228	1.149701	2.62131828	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	399	6.299999999999999e-107	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g5927	i0	98.246	1	228	4	100	0	1	228	258	485	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	228	399	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
18299185	18299185	PRJNA474911_P_NODE_1775_length_475_cov_2.777778_g1651_i0	PRJNA474911	1775	475	2.777778	13.1944455	Cripavirus drosophilae	3047809	Viruses	Viruses	813	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g1651	i0	97.674	12.0947368421053	473	11	99	0	1	473	9098	8626	Drosophila C virus isolate Davidson2006, complete genome	blastn	5745	813	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
20849251	20849251	PRJNA474911_P_NODE_1237_length_577_cov_3.465116_g1115_i0	PRJNA474911	1237	577	3.465116	19.99371932	Cripavirus drosophilae	3047809	Viruses	Viruses	521	3.609999999999999e-143	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1115	i0	97.69	9.59965337954939	303	7	100	0	1	303	8397	8095	Drosophila C virus isolate CYG, complete genome	blastn	5539	521	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
20849256	20849256	PRJNA474911_P_NODE_3397_length_325_cov_2.140152_g3271_i0	PRJNA474911	3397	325	2.140152	6.955494	Drosophila A virus	595895	Viruses	Viruses	556	5.31e-154	NTclustered	gi\|822478132\|gb\|KP969944.1\|	595895	g3271	i0	97.538	24	325	8	100	0	1	325	4319	3995	Drosophila A virus isolate wipe_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	7800	556	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
22124078	22124078	PRJNA474911_P_NODE_2038_length_436_cov_2.445333_g1913_i0	PRJNA474911	2038	436	2.445333	10.66165188	Cripavirus drosophilae	3047809	Viruses	Viruses	752	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g1913	i0	97.706	8.54128440366972	436	10	100	0	1	436	2228	2663	Drosophila C virus isolate CYG, complete genome	blastn	3724	752	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
22124100	22124100	PRJNA474911_P_NODE_8238_length_201_cov_1.371429_g8111_i0	PRJNA474911	8238	201	1.371429	2.75657229	Drosophila A virus	595895	Viruses	Viruses	366	5.5e-97	NTclustered	gi\|822478150\|gb\|KP969950.1\|	595895	g8111	i0	99.502	31.3582089552239	201	1	100	0	1	201	1201	1401	Drosophila A virus isolate Qdelta_DrosophilaA RNA-dependent RNA polymerase and capsid precursor, genes, partial cds	blastn	6303	366	1	Viruses	unclassified ssRNA positive-strand viruses							Drosophila A virus
24673744	24673744	PRJNA474911_P_NODE_760_length_738_cov_1.666174_g650_i0	PRJNA474911	760	738	1.666174	12.29636412	Cripavirus drosophilae	3047809	Viruses	Viruses	1284	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g650	i0	98.1	11.0460704607046	737	14	99	0	1	737	4563	5299	Drosophila C virus isolate Davidson2006, complete genome	blastn	8152	1284	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae

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