metadata: contig_metadata: 26 rows where bioproject = "PRJNA939370" and tax

26 rows where bioproject = "PRJNA939370" and tax_phylum = "Pisuviricota"

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
914620	914620	PRJNA939370_S_NODE_1_length_9257_cov_85.534644_g0_i0	PRJNA939370	1	9257	85.534644	7917.94199508	Cripavirus drosophilae	3047809	Viruses	Viruses	15978	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g0	i0	97.889	20.4181700334882	9238	194	99	1	21	9257	9258	21	Drosophila C virus isolate Davidson2006, complete genome	blastn	189011	15978	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
914624	914624	PRJNA939370_S_NODE_2301_length_180_cov_2.923664_g2249_i0	PRJNA939370	2301	180	2.923664	5.2625952	Orthonoravirus melanogastri	3060507	Viruses	Viruses	322	1.05e-83	NTclustered	gi\|822478507\|gb\|KP970094.1\|	3071212	g2249	i0	98.889	36.5944444444444	180	2	100	0	1	180	6870	7049	Nora virus isolate K02 gp1 (gp1) gene, partial cds; replication polyprotein (gp2) and gp3 (gp3) genes, complete cds; and capsid protein (gp4) gene, partial cds	blastn	6587	322	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
2190069	2190069	PRJNA939370_S_NODE_442_length_441_cov_1.864796_g390_i0	PRJNA939370	442	441	1.864796	8.22375036	Orthonoravirus melanogastri	3060507	Viruses	Viruses	760	0	NTclustered	gi\|822478403\|gb\|KP970076.1\|	3071212	g390	i0	97.945	34.4716553287982	438	9	99	0	4	441	9582	9145	Nora virus isolate ATH56 gp1 (gp1) and replication polyprotein (gp2) genes, partial cds; and gp3 (gp3) and capsid protein (gp4) genes, complete cds	blastn	15202	760	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
3465502	3465502	PRJNA939370_S_NODE_963_length_291_cov_1.623967_g911_i0	PRJNA939370	963	291	1.623967	4.72574397	Orthonoravirus melanogastri	3060507	Viruses	Viruses	477	3.75e-130	NTclustered	gi\|157325505\|gb\|DQ321720.2\|	3071212	g911	i0	96.22	38.6941580756014	291	11	100	0	1	291	5153	4863	Nora virus, complete genome	blastn	11260	477	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
4743016	4743016	PRJNA939370_S_NODE_2064_length_190_cov_2.645390_g2012_i0	PRJNA939370	2064	190	2.64539	5.026241	Orthonoravirus melanogastri	3060507	Viruses	Viruses	329	6.730000000000001e-86	NTclustered	gi\|822478403\|gb\|KP970076.1\|	3071212	g2012	i0	97.895	41	190	4	100	0	1	190	11621	11432	Nora virus isolate ATH56 gp1 (gp1) and replication polyprotein (gp2) genes, partial cds; and gp3 (gp3) and capsid protein (gp4) genes, complete cds	blastn	7790	329	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
7292788	7292788	PRJNA939370_S_NODE_1526_length_222_cov_0.913295_g1474_i0	PRJNA939370	1526	222	0.913295	2.0275149	Orthonoravirus melanogastri	3060507	Viruses	Viruses	388	1.32e-103	NTclustered	gi\|402295620\|gb\|JX220408.1\|	3071212	g1474	i0	98.198	39.0495495495495	222	4	100	0	1	222	1371	1150	Nora virus isolate FR1, complete genome	blastn	8669	388	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
8567602	8567602	PRJNA939370_S_NODE_1367_length_236_cov_1.294118_g1315_i0	PRJNA939370	1367	236	1.294118	3.05411848	Orthonoravirus melanogastri	3060507	Viruses	Viruses	403	5.07e-108	NTclustered	gi\|822478445\|gb\|KP970083.1\|	3071212	g1315	i0	97.458	40.6016949152542	236	6	100	0	1	236	772	1007	Nora virus isolate SAF04 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, partial cds	blastn	9582	403	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
9842681	9842681	PRJNA939370_S_NODE_488_length_415_cov_1.352459_g436_i0	PRJNA939370	488	415	1.352459	5.61270485	Orthonoravirus melanogastri	3060507	Viruses	Viruses	706	0	NTclustered	gi\|822478417\|gb\|KP970078.1\|	3071212	g436	i0	97.349	37.9397590361446	415	11	100	0	1	415	2009	2423	Nora virus isolate D167 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	15745	706	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
11118320	11118320	PRJNA939370_S_NODE_2089_length_189_cov_1.892857_g2037_i0	PRJNA939370	2089	189	1.892857	3.57749973	Orthonoravirus melanogastri	3060507	Viruses	Viruses	339	1.11e-88	NTclustered	gi\|2322367320\|gb\|OK188768.1\|	3071212	g2037	i0	98.942	39	189	2	100	0	1	189	3763	3951	Nora virus isolate SMN, complete genome	blastn	7371	339	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
11118325	11118325	PRJNA939370_S_NODE_2769_length_167_cov_1.322034_g2717_i0	PRJNA939370	2769	167	1.322034	2.20779678	Orthonoravirus melanogastri	3060507	Viruses	Viruses	303	3.5e-78	NTclustered	gi\|822478417\|gb\|KP970078.1\|	3071212	g2717	i0	99.401	38.6167664670659	167	1	100	0	1	167	10548	10714	Nora virus isolate D167 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	6449	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
11118332	11118332	PRJNA939370_S_NODE_609_length_370_cov_156.299065_g557_i0	PRJNA939370	609	370	156.299065	578.3065405	Betacoronavirus pandemicum	3418604	Viruses	Viruses	106	2.66e-18	NTclustered	gi\|2156866290\|gb\|OL674078.1\|	694009	g557	i0	98.333	17.2621621621622	60	1	46	0	53	112	29704	29645	Severe acute respiratory syndrome-related coronavirus isolate Rs7921, complete genome	blastn	6387	106	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
12393820	12393820	PRJNA939370_S_NODE_1070_length_271_cov_1.346847_g1018_i0	PRJNA939370	1070	271	1.346847	3.64995537	Orthonoravirus melanogastri	3060507	Viruses	Viruses	451	2.0999999999999997e-122	NTclustered	gi\|822478440\|gb\|KP970082.1\|	3071212	g1018	i0	96.679	36.8376383763838	271	9	100	0	1	271	3369	3099	Nora virus isolate RAKMEL12 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	9983	451	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
13668270	13668270	PRJNA939370_S_NODE_1031_length_278_cov_1.305677_g979_i0	PRJNA939370	1031	278	1.305677	3.62978206	Orthonoravirus melanogastri	3060507	Viruses	Viruses	497	2.73e-136	NTclustered	gi\|822478403\|gb\|KP970076.1\|	3071212	g979	i0	98.921	40.3453237410072	278	3	100	0	1	278	6630	6353	Nora virus isolate ATH56 gp1 (gp1) and replication polyprotein (gp2) genes, partial cds; and gp3 (gp3) and capsid protein (gp4) genes, complete cds	blastn	11216	497	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
13668271	13668271	PRJNA939370_S_NODE_1071_length_271_cov_1.328829_g1019_i0	PRJNA939370	1071	271	1.328829	3.60112659	Orthonoravirus melanogastri	3060507	Viruses	Viruses	475	1.2399999999999999e-129	NTclustered	gi\|822478527\|gb\|KP970098.1\|	3071212	g1019	i0	99.24	36.7047970479705	263	2	97	0	1	263	2819	3081	Nora virus isolate AM04 gp1 (gp1) gene, partial cds; and replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	9947	475	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
13668282	13668282	PRJNA939370_S_NODE_1571_length_218_cov_1.881657_g1519_i0	PRJNA939370	1571	218	1.881657	4.10201226	Orthonoravirus melanogastri	3060507	Viruses	Viruses	387	4.649999999999998e-103	NTclustered	gi\|822478417\|gb\|KP970078.1\|	3071212	g1519	i0	98.624	37.6697247706422	218	3	100	0	1	218	2598	2381	Nora virus isolate D167 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	8212	387	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
13668284	13668284	PRJNA939370_S_NODE_1791_length_204_cov_1.380645_g1739_i0	PRJNA939370	1791	204	1.380645	2.8165158	Orthonoravirus melanogastri	3060507	Viruses	Viruses	350	5.64e-92	NTclustered	gi\|822478537\|gb\|KP970100.1\|	3071212	g1739	i0	97.549	35.1813725490196	204	5	100	0	1	204	11129	11332	Nora virus isolate GEO58 gp1 (gp1) gene, partial cds; and replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	7177	350	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
13668302	13668302	PRJNA939370_S_NODE_551_length_390_cov_1.387097_g499_i0	PRJNA939370	551	390	1.387097	5.4096783	Orthonoravirus melanogastri	3060507	Viruses	Viruses	688	0	NTclustered	gi\|822478572\|gb\|KP970107.1\|	3071212	g499	i0	98.462	40.4923076923077	390	6	100	0	1	390	1108	719	Nora virus isolate YYPLUS capsid protein (gp4) gene, partial cds	blastn	15792	688	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
14942576	14942576	PRJNA939370_S_NODE_2212_length_184_cov_2.251852_g2160_i0	PRJNA939370	2212	184	2.251852	4.14340768	Orthonoravirus melanogastri	3060507	Viruses	Viruses	324	3.01e-84	NTclustered	gi\|402295609\|gb\|JQ288020.1\|	3071212	g2160	i0	98.37	29.2771739130435	184	3	100	0	1	184	268	85	Nora virus isolate NL2 VP1 gene, complete cds	blastn	5387	324	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
17492966	17492966	PRJNA939370_S_NODE_1114_length_264_cov_1.409302_g1062_i0	PRJNA939370	1114	264	1.409302	3.72055728	Orthonoravirus melanogastri	3060507	Viruses	Viruses	444	3.41e-120	NTclustered	gi\|822478497\|gb\|KP970092.1\|	3071212	g1062	i0	96.97	36.7424242424242	264	8	100	0	1	264	8392	8129	Nora virus isolate delta11 gp1 (gp1) gene, partial cds; replication polyprotein (gp2) and gp3 (gp3) genes, complete cds; and capsid protein (gp4) gene, partial cds	blastn	9700	444	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
17492970	17492970	PRJNA939370_S_NODE_1434_length_230_cov_1.044199_g1382_i0	PRJNA939370	1434	230	1.044199	2.4016577	Orthonoravirus melanogastri	3060507	Viruses	Viruses	374	3.859999999999998e-99	NTclustered	gi\|1417910463\|gb\|MH384279.1\|	3071212	g1382	i0	97.696	14.8	217	5	94	0	1	217	11964	12180	Drosophila melanogaster Nora virus strain HUNminus2825 orf1, putative replicase, orf3, and putative capsid protein genes, complete cds	blastn	3404	374	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
17492983	17492983	PRJNA939370_S_NODE_2674_length_169_cov_1.408333_g2622_i0	PRJNA939370	2674	169	1.408333	2.38008277	Orthonoravirus melanogastri	3060507	Viruses	Viruses	296	5.9e-76	NTclustered	gi\|822478512\|gb\|KP970095.1\|	3071212	g2622	i0	98.225	36.905325443787	169	3	100	0	1	169	2401	2233	Nora virus isolate RAK11 gp1 (gp1) and replication polyprotein (gp2) genes, partial cds; and gp3 (gp3) and capsid protein (gp4) genes, complete cds	blastn	6237	296	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
18766400	18766400	PRJNA939370_S_NODE_1115_length_264_cov_1.269767_g1063_i0	PRJNA939370	1115	264	1.269767	3.35218488	Orthonoravirus melanogastri	3060507	Viruses	Viruses	466	7.27e-127	NTclustered	gi\|822478482\|gb\|KP970089.1\|	3071212	g1063	i0	98.485	37.1969696969697	264	4	100	0	1	264	1124	1387	Nora virus isolate IM13 gp1 (gp1) gene, partial cds; replication polyprotein (gp2) and gp3 (gp3) genes, complete cds; and capsid protein (gp4) gene, partial cds	blastn	9820	466	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
18766408	18766408	PRJNA939370_S_NODE_1775_length_205_cov_1.775641_g1723_i0	PRJNA939370	1775	205	1.775641	3.64006405	Orthonoravirus melanogastri	3060507	Viruses	Viruses	303	4.48e-78	NTclustered	gi\|822478417\|gb\|KP970078.1\|	3071212	g1723	i0	97.727	28.0634146341463	176	4	86	0	30	205	9793	9618	Nora virus isolate D167 gp1 (gp1), replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	5753	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
21316743	21316743	PRJNA939370_S_NODE_2137_length_187_cov_1.862319_g2085_i0	PRJNA939370	2137	187	1.862319	3.48253653	Orthonoravirus melanogastri	3060507	Viruses	Viruses	307	3.09e-79	NTclustered	gi\|822478537\|gb\|KP970100.1\|	3071212	g2085	i0	96.257	38.9572192513369	187	7	100	0	1	187	7896	7710	Nora virus isolate GEO58 gp1 (gp1) gene, partial cds; and replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	7285	307	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
23867065	23867065	PRJNA939370_S_NODE_2179_length_186_cov_1.094891_g2127_i0	PRJNA939370	2179	186	1.094891	2.03649726	Orthonoravirus melanogastri	3060507	Viruses	Viruses	316	5.11e-82	NTclustered	gi\|822478537\|gb\|KP970100.1\|	3071212	g2127	i0	97.814	40.3387096774194	183	4	98	0	1	183	1158	976	Nora virus isolate GEO58 gp1 (gp1) gene, partial cds; and replication polyprotein (gp2), gp3 (gp3), and capsid protein (gp4) genes, complete cds	blastn	7503	316	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri
23867083	23867083	PRJNA939370_S_NODE_659_length_360_cov_1.694534_g607_i0	PRJNA939370	659	360	1.694534	6.1003224	Orthonoravirus melanogastri	3060507	Viruses	Viruses	588	2.0999999999999994e-163	NTclustered	gi\|2322367320\|gb\|OK188768.1\|	3071212	g607	i0	96.111	38.6	360	14	100	0	1	360	3940	4299	Nora virus isolate SMN, complete genome	blastn	13896	588	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Noraviridae	Orthonoravirus	Orthonoravirus melanogastri

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