metadata: contig_metadata: 25 rows where bioproject = "PRJNA380660" and tax

25 rows where bioproject = "PRJNA380660" 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
2349565	2349565	PRJNA380660_P_NODE_7182_length_271_cov_2.900826_g6782_i0	PRJNA380660	7182	271	2.900826	7.86123846	Viruses	10239	Viruses	Viruses	298	2.89e-76	NTclustered	gi\|2214231626\|gb\|OM622299.1\|	1955153	g6782	i0	98.802	2.03690036900369	167	2	100	0	105	271	5531	5697	MAG: Picornavirales sp. isolate HPLV-44 genomic sequence	blastn	552	298	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Picornavirales sp.
7452205	7452205	PRJNA380660_P_NODE_7406_length_265_cov_1.766949_g7006_i0	PRJNA380660	7406	265	1.766949	4.68241485	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|1720276672\|gb\|MK959613.1\|	10493	g7006	i0	96.97	5.8377358490566	33	0	12	1	180	212	51119	51088	Frog virus 3 strain Z920	blastn	1547	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae	Ranavirus	Ranavirus rana1
10606005	10606005	PRJNA380660_P_NODE_6809_length_283_cov_1587.318898_g6409_i0	PRJNA380660	6809	283	1587.318898	4492.11248134	Betacoronavirus pandemicum	3418604	Viruses	Viruses	54.7	0.007	NTclustered	gi\|2046846597\|emb\|OU077603.1\|	2697049	g6409	i0	100	0.102473498233216	29	0	10	0	255	283	30001	30029	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	29	54.7	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
13156006	13156006	PRJNA380660_P_NODE_8751_length_230_cov_2.034826_g8351_i0	PRJNA380660	8751	230	2.034826	4.6800998	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	265	2.42e-66	NTclustered	gi\|2214231626\|gb\|OM622299.1\|	3003959	g8351	i0	97.419	1.34782608695652	155	4	67	0	1	155	3807	3653	MAG: Picornavirales sp. isolate HPLV-44 genomic sequence	blastn	310	265	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
16979566	16979566	PRJNA380660_P_NODE_12774_length_153_cov_1.943548_g12374_i0	PRJNA380660	12774	153	1.943548	2.97362844	Totivirus sp.	2776824	Viruses	Viruses	272	8.84e-69	NTclustered	gi\|1918615616\|gb\|MT949667.1\|	2776824	g12374	i0	98.693	1.99346405228758	153	2	100	0	1	153	1259	1107	Totivirus sp. isolate sequence_5835 genomic sequence	blastn	305	272	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
19528063	19528063	PRJNA380660_P_NODE_11976_length_169_cov_2.300000_g11576_i0	PRJNA380660	11976	169	2.3	3.887	Caudoviricetes sp.	2832643	Viruses	Viruses	207	2.85e-49	NTclustered	gi\|2059905452\|tpg\|BK041391.1\|	2832643	g11576	i0	88.757	1	169	19	100	0	1	169	13542	13710	MAG TPA_asm: Caudoviricetes sp. isolate ct2M34, partial genome	blastn	169	207	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27169596	27169596	PRJNA380660_P_NODE_12562_length_157_cov_2.062500_g12162_i0	PRJNA380660	12562	157	2.0625	3.238125	Rosellinia necatrix partitivirus 21	2699389	Viruses	Viruses	72.8	2.94e-13	NR	BBU59850.1	2699389	g12162	i0	64.2	1.01273885350318	53	17	99.4	2	1	156	168	219	BBU59850.1 RNA dependent RNA polymerase [Rosellinia necatrix partitivirus 21]	diamond	159	72.8	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Rosellinia necatrix partitivirus 21
27233056	27233056	PRJNA380660_P_NODE_2563_length_527_cov_2.078313_g2201_i0	PRJNA380660	2563	527	2.078313	10.95270951	Macrophomina phaseolina single-stranded RNA virus 1	1708488	Viruses	Viruses	86.7	4.1e-16	NR	YP_010799203.1	1708488	g2201	i0	32.3	0.916508538899431	161	107	91.7	1	526	44	1337	1495	YP_010799203.1 RNA-dependent RNA polymerase [Macrophomina phaseolina single-stranded RNA virus 1]	diamond	483	86.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae	Alphafusarivirus	Alphafusarivirus macrophominae
27264734	27264734	PRJNA380660_P_NODE_2603_length_521_cov_6.250000_g2241_i0	PRJNA380660	2603	521	6.25	32.5625	Sanya totivirus 3	2905262	Viruses	Viruses	117	4.990000000000001e-27	NR	UHK03125.1	2905262	g2241	i0	39.4	0.978886756238004	170	99	96.2	3	506	6	281	449	UHK03125.1 MAG: RNA-dependent RNA polymerase [Sanya totivirus 3]	diamond	510	117	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Sanya totivirus 3
27296281	27296281	PRJNA380660_P_NODE_5403_length_336_cov_1.775244_g5004_i0	PRJNA380660	5403	336	1.775244	5.96481984	Aspergillus chevalieri partitivirus 1	3238293	Viruses	Viruses	87	3.08e-17	NR	BFP29929.1	3238293	g5004	i0	50	0.732142857142857	82	41	73.2	0	333	88	451	532	BFP29929.1 MAG: coat protein [Aspergillus chevalieri partitivirus 1]	diamond	246	87	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Aspergillus chevalieri partitivirus 1
27485849	27485849	PRJNA380660_P_NODE_2523_length_532_cov_3.467197_g2163_i0	PRJNA380660	2523	532	3.467197	18.44548804	Emiliania huxleyi virus 86	181082	Viruses	Viruses	77.8	4.41e-13	NR	YP_293932.1	181082	g2163	i0	36.7	0.721804511278195	128	74	72.2	2	532	149	367	487	YP_293932.1 Major Facilitator Superfamily protein [Emiliania huxleyi virus 86]	diamond	384	77.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Coccolithovirus huxleyi
27643906	27643906	PRJNA380660_P_NODE_11144_length_187_cov_1.316456_g10744_i0	PRJNA380660	11144	187	1.316456	2.46177272	Prasiola crispa toti-like virus	2933125	Viruses	Viruses	44.7	0.0038	NR	CAI5383883.1	2933125	g10744	i0	42	0.802139037433155	50	29	80.2	0	154	5	112	161	CAI5383883.1 RNA-dependent RNA polymerase [Prasiola crispa toti-like virus]	diamond	150	44.7	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Prasiola crispa toti-like virus
28369821	28369821	PRJNA380660_P_NODE_1426_length_716_cov_5.687045_g1126_i0	PRJNA380660	1426	716	5.687045	40.7192422	Emiliania huxleyi virus 86	181082	Viruses	Viruses	104	1.3e-21	NR	YP_293932.1	181082	g1126	i0	37	1.29050279329609	154	90	64.5	2	716	255	326	472	YP_293932.1 Major Facilitator Superfamily protein [Emiliania huxleyi virus 86]	diamond	924	104	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Coccolithovirus huxleyi
28906447	28906447	PRJNA380660_P_NODE_368_length_1412_cov_5.903109_g256_i0	PRJNA380660	368	1412	5.903109	83.35189908	Cryptolin alternavirus 1	3081027	Viruses	Viruses	163	4.92e-39	NR	WOC29231.1	3081027	g256	i0	29.9	1.95679886685552	428	281	87.1	5	1373	144	1977	2403	WOC29231.1 hypothetical protein [Cryptolin alternavirus 1]	diamond	2763	163	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Alternaviridae	Alternavirus	Cryptolin alternavirus 1
29190916	29190916	PRJNA380660_P_NODE_1189_length_795_cov_4.468668_g918_i0	PRJNA380660	1189	795	4.468668	35.5259106	Trichoderma citrinoviride partitivirus 1	2501046	Viruses	Viruses	210	1.72e-59	NR	AZT88593.1	2501046	g918	i0	47.7	0.886792452830189	235	117	86.4	1	687	1	1	235	AZT88593.1 coat protein [Trichoderma citrinoviride partitivirus 1]	diamond	705	210	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Trichoderma citrinoviride partitivirus 1
29790515	29790515	PRJNA380660_P_NODE_8431_length_237_cov_4.394231_g8031_i0	PRJNA380660	8431	237	4.3942310000000004	10.41432747	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	137	1.26e-35	NR	XCM67829.1	3003959	g8031	i0	78.2	0.987341772151899	78	17	98.7	0	3	236	415	492	XCM67829.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	234	137	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
30422975	30422975	PRJNA380660_P_NODE_11933_length_170_cov_2.482270_g11533_i0	PRJNA380660	11933	170	2.48227	4.219859	Sanxia picorna-like virus 7	1923376	Viruses	Viruses	80.9	5.03e-16	NR	APG77477.1	1923376	g11533	i0	70.2	1.00588235294118	57	16	98.8	1	3	170	327	383	APG77477.1 hypothetical protein, partial [Sanxia picorna-like virus 7]	diamond	171	80.9	1	Viruses							Sanxia picorna-like virus 7
30485809	30485809	PRJNA380660_P_NODE_12893_length_151_cov_1.754098_g12493_i0	PRJNA380660	12893	151	1.754098	2.64868798	Ripaglac virus	3130411	Viruses	Viruses	57	9.46e-8	NR	WZH59599.1	3130411	g12493	i0	61.1	0.71523178807947	36	14	71.5	0	110	3	27	62	WZH59599.1 MAG: RNA-dependent RNA polymerase [Ripaglac virus]	diamond	108	57	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae		Ripaglac virus
30706852	30706852	PRJNA380660_P_NODE_14_length_4015_cov_7.299047_g11_i0	PRJNA380660	14	4015	7.299047	293.05673705	Prasiola crispa toti-like virus	2933125	Viruses	Viruses	70.9	5.09e-8	NR	CAI5383882.1	2933125	g11	i0	25.9	0.153175591531756	205	119	13.5	6	1146	1688	464	659	CAI5383882.1 putative capsid protein [Prasiola crispa toti-like virus]	diamond	615	70.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Prasiola crispa toti-like virus
31402421	31402421	PRJNA380660_P_NODE_5156_length_346_cov_3.539432_g4758_i0	PRJNA380660	5156	346	3.539432	12.24643472	Sclerotinia sclerotiorum partitivirus 1	1232468	Viruses	Viruses	131	7.06e-33	NR	AFR78160.1	1232468	g4758	i0	56.6	0.979768786127168	113	49	98	0	340	2	18	130	AFR78160.1 RNA-dependent RNA polymerase [Sclerotinia sclerotiorum partitivirus 1]	diamond	339	131	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Sclerotinia sclerotiorum partitivirus 1
31497283	31497283	PRJNA380660_P_NODE_4696_length_368_cov_4.938053_g4299_i0	PRJNA380660	4696	368	4.938053	18.17203504	Leptosphaeria biglobosa partitivirus 3	3062775	Viruses	Viruses	89.4	7.05e-18	NR	WKR37728.1	3062775	g4299	i0	53.8	0.758152173913043	93	42	75	1	78	353	4	96	WKR37728.1 putative RNA-dependent RNA polymerase, partial [Leptosphaeria biglobosa partitivirus 3]	diamond	279	89.4	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Leptosphaeria biglobosa partitivirus 3
31798606	31798606	PRJNA380660_P_NODE_8477_length_236_cov_4.748792_g8077_i0	PRJNA380660	8477	236	4.748792	11.20714912	Viruses	10239	Viruses	Viruses	144	2.95e-39	NR	WAK75580.1	1955170	g8077	i0	87.2	2.97457627118644	78	10	99.2	0	3	236	191	268	WAK75580.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.]	diamond	702	144	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
32034905	32034905	PRJNA380660_P_NODE_7258_length_269_cov_2.554167_g6858_i0	PRJNA380660	7258	269	2.554167	6.87070923	Betapolyomavirus macacae	1891767	Viruses	Viruses	62.8	4.44e-9	NR	AAK29054.1	1891767	g6858	i0	70.5	0.490706319702602	44	13	49.1	0	96	227	494	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	132	62.8	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
32256735	32256735	PRJNA380660_P_NODE_5638_length_326_cov_3.444444_g5239_i0	PRJNA380660	5638	326	3.444444	11.22888744	Betapolyomavirus macacae	1891767	Viruses	Viruses	48.1	0.00121	NR	AAK29054.1	1891767	g5239	i0	74.2	0.680981595092024	31	8	28.5	0	144	52	507	537	AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae]	diamond	222	48.5	0.991752577319588	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
32382905	32382905	PRJNA380660_P_NODE_6719_length_287_cov_1.934109_g6319_i0	PRJNA380660	6719	287	1.934109	5.5508928299999996	Pterostylis sanguinea virus A	1964430	Viruses	Viruses	55.5	2.18e-6	NR	AOX47548.1	1964430	g6319	i0	57.8	0.470383275261324	45	19	47	0	149	15	910	954	AOX47548.1 RNA-dependent RNA polymerase, partial [Pterostylis sanguinea virus A]	diamond	135	55.5	1	Viruses							Pterostylis sanguinea virus A

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