metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
589730	589730	PRJNA611476_P_NODE_601_length_2856_cov_7.490478_g341_i0	PRJNA611476	601	2856	7.490478	213.92805168	Cheravirus mali	3047371	Viruses	Viruses	2508	0	NTclustered	gi\|20451026\|ref\|NC_003788.1\|	101688	g341	i0	82.653	1.89040616246499	2865	466	99	27	8	2855	3384	534	Apple latent spherical virus segment 2, complete sequence	blastn	5399	2508	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Cheravirus	Cheravirus mali
1865011	1865011	PRJNA611476_P_NODE_13722_length_530_cov_1.439825_g12932_i0	PRJNA611476	13722	530	1.439825	7.6310725	Cheravirus avii	3047742	Viruses	Viruses	372	3.52e-98	NTclustered	gi\|52093349\|ref\|NC_006271.1\|	202566	g12932	i0	79.922	2.90377358490566	513	97	96	6	4	513	3093	2584	Cherry rasp leaf virus, complete genome	blastn	1539	372	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Cheravirus	Cheravirus avii
3140669	3140669	PRJNA611476_P_NODE_6283_length_771_cov_3.117479_g5532_i0	PRJNA611476	6283	771	3.117479	24.03576309	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	1290	0	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g5532	i0	97.365	1.97665369649805	759	18	98	1	12	770	7789	7033	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	1524	1290	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
4417494	4417494	PRJNA611476_P_NODE_7504_length_708_cov_0.968504_g6735_i0	PRJNA611476	7504	708	0.968504	6.85700832	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	1297	0	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g6735	i0	99.718	1	708	2	100	0	1	708	4963	5670	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	708	1297	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
6967836	6967836	PRJNA611476_P_NODE_42566_length_329_cov_1.203125_g41775_i0	PRJNA611476	42566	329	1.203125	3.95828125	Cheravirus mali	3047371	Viruses	Viruses	409	1.5899999999999998e-109	NTclustered	gi\|20451026\|ref\|NC_003788.1\|	101688	g41775	i0	89.058	1	329	36	100	0	1	329	2566	2894	Apple latent spherical virus segment 2, complete sequence	blastn	329	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Cheravirus	Cheravirus mali
6968022	6968022	PRJNA611476_P_NODE_55406_length_294_cov_1.384615_g54615_i0	PRJNA611476	55406	294	1.384615	4.0707680999999996	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	492	1.36e-134	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g54615	i0	96.928	0.996598639455782	293	9	99	0	2	294	3240	3532	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	293	492	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
9517267	9517267	PRJNA611476_P_NODE_110588_length_243_cov_0.905882_g109797_i0	PRJNA611476	110588	243	0.905882	2.20129326	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	388	1.47e-103	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g109797	i0	95.473	1	243	11	100	0	1	243	2455	2213	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	243	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
9517717	9517717	PRJNA611476_P_NODE_35328_length_353_cov_1.139286_g34537_i0	PRJNA611476	35328	353	1.139286	4.02167958	Potexvirus ecspotati	3433837	Viruses	Viruses	608	1.579999999999999e-169	NTclustered	gi\|2025365924\|gb\|MT752833.1\|	12183	g34537	i0	97.734	99.957507082153	353	8	100	0	1	353	581	933	Potato virus X isolate Jin118-2, complete genome	blastn	35285	608	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus ecspotati
10793339	10793339	PRJNA611476_P_NODE_17689_length_470_cov_1.914358_g16899_i0	PRJNA611476	17689	470	1.914358	8.9974826	Picornaviridae sp.	1530251	Viruses	Viruses	531	4.8099999999999985e-146	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g16899	i0	87.049	1.00212765957447	471	59	100	2	1	470	3726	3257	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	471	531	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
10793354	10793354	PRJNA611476_P_NODE_18509_length_461_cov_1.675258_g17719_i0	PRJNA611476	18509	461	1.675258	7.72293938	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	802	0	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g17719	i0	98.048	1	461	9	100	0	1	461	4736	4276	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	461	802	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
10793427	10793427	PRJNA611476_P_NODE_23109_length_418_cov_1.281159_g22318_i0	PRJNA611476	23109	418	1.281159	5.35524462	Daiswa trichovirus 1	2794435	Viruses	Viruses	407	7.45e-109	NTclustered	gi\|1950492700\|gb\|MW328734.1\|	2794435	g22318	i0	84.211	1	418	66	100	0	1	418	6358	5941	Daiswa trichovirus 1 RdRp, MP, and CP genes, complete cds	blastn	418	407	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Daiswa trichovirus 1
10793645	10793645	PRJNA611476_P_NODE_389_length_4006_cov_5.302059_g201_i0	PRJNA611476	389	4006	5.302059	212.40048354	Cheravirus mali	3047371	Viruses	Viruses	3059	0	NTclustered	gi\|20451024\|ref\|NC_003787.1\|	101688	g201	i0	80.51	1.48077883175237	4038	725	99	48	2	3999	2797	6812	Apple latent spherical virus segment 1, complete sequence	blastn	5932	3059	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Cheravirus	Cheravirus mali
10793739	10793739	PRJNA611476_P_NODE_45669_length_320_cov_0.935223_g44878_i0	PRJNA611476	45669	320	0.935223	2.9927136	Daiswa trichovirus 1	2794435	Viruses	Viruses	331	3.44e-86	NTclustered	gi\|1950492700\|gb\|MW328734.1\|	2794435	g44878	i0	85.312	1	320	47	100	0	1	320	5191	5510	Daiswa trichovirus 1 RdRp, MP, and CP genes, complete cds	blastn	320	331	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Daiswa trichovirus 1
10794353	10794353	PRJNA611476_P_NODE_89409_length_248_cov_1.320000_g88618_i0	PRJNA611476	89409	248	1.32	3.2736	Potexvirus ecspotati	3433837	Viruses	Viruses	453	5.2600000000000005e-123	NTclustered	gi\|2025365630\|gb\|MT752784.1\|	12183	g88618	i0	99.597	99.9798387096774	248	1	100	0	1	248	3099	3346	Potato virus X isolate Ica098-2, complete genome	blastn	24795	453	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus ecspotati
13343472	13343472	PRJNA611476_P_NODE_34311_length_357_cov_1.218310_g33520_i0	PRJNA611476	34311	357	1.21831	4.3493667	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	627	4.4199999999999986e-175	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g33520	i0	98.588	2.87675070028011	354	5	99	0	1	354	6603	6956	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	1027	627	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
14617736	14617736	PRJNA611476_P_NODE_1012_length_1980_cov_2.785527_g645_i0	PRJNA611476	1012	1980	2.785527	55.1534346	Picornaviridae sp.	1530251	Viruses	Viruses	1561	0	NTclustered	gi\|2780183578\|gb\|PP818844.1\|	1530251	g645	i0	80.976	1.00353535353535	1987	362	100	15	1	1980	7739	5762	Picornaviridae sp. polyprotein and capsid protein genes, complete cds	blastn	1987	1561	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
14618127	14618127	PRJNA611476_P_NODE_192_length_7213_cov_49.534594_g95_i0	PRJNA611476	192	7213	49.534594	3572.93026522	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2505	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g95	i0	92.036	0.651046721197837	1783	137	65	5	5426	7206	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4696	2505	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15892219	15892219	PRJNA611476_P_NODE_26033_length_397_cov_56.496914_g25242_i0	PRJNA611476	26033	397	56.496914	224.29274858	Lycium betacytorhabdovirus 1	3078349	Viruses	Viruses	124	7.94e-24	NTclustered	gi\|2618835662\|tpg\|BK064324.1\|	3078349	g25242	i0	98.592	2.93198992443325	71	0	26	1	315	384	1	71	TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence	blastn	1164	124	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Lycium betacytorhabdovirus 1
15893049	15893049	PRJNA611476_P_NODE_85713_length_249_cov_1.147727_g84922_i0	PRJNA611476	85713	249	1.147727	2.85784023	Kummerowia striata picorna-like virus	2739852	Viruses	Viruses	438	1.4799999999999996e-118	NTclustered	gi\|1851269098\|gb\|MN832470.1\|	2739852	g84922	i0	98.394	1	249	4	100	0	1	249	3920	4168	Kummerowia striata picorna-like virus strain pt119-pic-7 genomic sequence, sequence	blastn	249	438	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Kummerowia striata picorna-like virus
17167734	17167734	PRJNA611476_P_NODE_71614_length_263_cov_1.621053_g70823_i0	PRJNA611476	71614	263	1.621053	4.26336939	Potexvirus ecspotati	3433837	Viruses	Viruses	475	1.2e-129	NTclustered	gi\|2025365426\|gb\|MT752750.1\|	12183	g70823	i0	99.24	101.011406844106	263	2	100	0	1	263	6380	6118	Potato virus X isolate Hco062, complete genome	blastn	26566	475	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus ecspotati
18441182	18441182	PRJNA611476_P_NODE_17475_length_473_cov_1.500000_g16685_i0	PRJNA611476	17475	473	1.5	7.095	Cheravirus ribis	3047783	Viruses	Viruses	398	5.13e-106	NTclustered	gi\|2571475827\|gb\|OR096292.1\|	1476584	g16685	i0	82.303	0.99154334038055	469	73	98	8	10	473	799	336	Currant latent virus isolate YWDi segment 1 polyprotein gene, complete cds	blastn	469	398	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Cheravirus	Cheravirus ribis
18441676	18441676	PRJNA611476_P_NODE_52655_length_301_cov_1.219298_g51864_i0	PRJNA611476	52655	301	1.219298	3.67008698	Ripaprog virus	3131032	Viruses	Viruses	148	3.47e-31	NTclustered	gi\|2717321440\|gb\|PP173334.1\|	3131032	g51864	i0	100	68.2890365448505	80	0	27	0	88	167	5076	5155	MAG: Ripaprog virus isolate KCAP3_k141_45667 genomic sequence	blastn	20555	148	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripaprog virus
20991889	20991889	PRJNA611476_P_NODE_46097_length_318_cov_1.893878_g45306_i0	PRJNA611476	46097	318	1.893878	6.02253204	Daiswa trichovirus 1	2794435	Viruses	Viruses	331	3.4200000000000004e-86	NTclustered	gi\|1950492700\|gb\|MW328734.1\|	2794435	g45306	i0	85.852	0.977987421383648	311	44	98	0	8	318	5529	5219	Daiswa trichovirus 1 RdRp, MP, and CP genes, complete cds	blastn	311	331	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Trichovirus	Daiswa trichovirus 1
20992194	20992194	PRJNA611476_P_NODE_72557_length_261_cov_2.037234_g71766_i0	PRJNA611476	72557	261	2.037234	5.31718074	Sopapen virus	3131614	Viruses	Viruses	141	4.9399999999999993e-29	NTclustered	gi\|2717322942\|gb\|PP173915.1\|	3131614	g71766	i0	93.617	9.29885057471264	94	6	36	0	76	169	434	527	MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence	blastn	2427	141	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sopapen virus
21549900	21549900	PRJNA611476_P_NODE_50177_length_307_cov_1.786325_g49386_i0	PRJNA611476	50177	307	1.786325	5.48401775	Cripavirus	144051	Viruses	Viruses	455	1.87e-123	NTclustered	gi\|1847622119\|gb\|MN738553.1\|	2739222	g49386	i0	93.464	5.8599348534202	306	20	99	0	2	307	8459	8764	Bactrocera dorsalis cripavirus, complete genome	blastn	1799	457	0.99562363238512	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Bactrocera dorsalis cripavirus
22266405	22266405	PRJNA611476_P_NODE_26458_length_395_cov_1.369565_g25667_i0	PRJNA611476	26458	395	1.369565	5.40978175	Tobamovirus tabaci	3432891	Viruses	Viruses	719	0	NTclustered	gi\|348605458\|gb\|JF920727.1\|	12242	g25667	i0	99.494	98.7443037974683	395	2	100	0	1	395	6201	5807	Tobacco mosaic virus isolate Shanxi, complete genome	blastn	39004	719	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
23542498	23542498	PRJNA611476_P_NODE_84139_length_250_cov_0.870056_g83348_i0	PRJNA611476	84139	250	0.870056	2.17514	Potyvirus halapensis	3240535	Viruses	Viruses	390	4.22e-104	NTclustered	gi\|2699880115\|gb\|PP480666.1\|	31742	g83348	i0	94.821	14.016	251	12	100	1	1	250	9738	9488	Johnsongrass mosaic virus isolate Santa_Ana-2021-JgM1 polyprotein gene, complete cds	blastn	3504	390	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus halapensis
24815517	24815517	PRJNA611476_P_NODE_25240_length_403_cov_1.042424_g24449_i0	PRJNA611476	25240	403	1.042424	4.20096872	Zebrafish picornavirus 1	2304617	Viruses	Viruses	651	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g24449	i0	95.782	3.00496277915633	403	17	100	0	1	403	5602	5200	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1211	651	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 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);;