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

25 rows where bioproject = "PRJNA1016321" 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
2277846	2277846	PRJNA1016321_P_NODE_102_length_3038_cov_8.709612_g90_i0	PRJNA1016321	102	3038	8.709612	264.59801256	Respirovirus	186938	Viruses	Viruses	5566	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g90	i0	99.737	45.7314022383147	3039	6	100	2	1	3038	3315	278	Sendai virus (strain Z) genome RNA 5'end	blastn	138932	5566	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
2709487	2709487	PRJNA1016321_P_NODE_11343_length_594_cov_4.606526_g11120_i0	PRJNA1016321	11343	594	4.606526	27.36276444	Botourmiaviridae sp.	2808997	Viruses	Viruses	701	0	NTclustered	gi\|2396039586\|gb\|ON812872.1\|	2808997	g11120	i0	89.317	1.91919191919192	571	44	95	13	1	562	563	1	MAG: Botourmiaviridae sp. isolate TIGMIC_4, complete genome	blastn	1140	701	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
2709656	2709656	PRJNA1016321_P_NODE_20283_length_423_cov_29.865714_g20052_i0	PRJNA1016321	20283	423	29.865714	126.33197022	Penoulivirus aspergilli	3431565	Viruses	Viruses	102	3.99e-17	NTclustered	gi\|2500378724\|ref\|NC_076348.1\|	2501288	g20052	i0	78.659	0.387706855791962	164	28	38	5	176	337	209	51	Aspergillus neoniger ourmia-like virus 1 strain AnOlv1CBS 115656, complete genome	blastn	164	102	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Penoulivirus	Penoulivirus aspergilli
7380415	7380415	PRJNA1016321_P_NODE_6_length_7441_cov_9.979370_g4_i0	PRJNA1016321	6	7441	9.97937	742.5649217	Venezuelan equine encephalitis virus	11036	Viruses	Viruses	4739	0	NR	NP_040822.1	11036	g4	i0	98.5	0.995833893293912	2470	36	99.6	0	7439	30	24	2493	NP_040822.1 non-structural polyprotein precursor P1234 [Venezuelan equine encephalitis virus]	diamond	7410	4739	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus venezuelan
9087654	9087654	PRJNA1016321_P_NODE_8_length_6986_cov_38.244756_g6_i0	PRJNA1016321	8	6986	38.244756	2671.77865416	Respirovirus muris	3052731	Viruses	Viruses	8661	0	NTclustered	gi\|546225824\|dbj\|AB855655.1\|	3052731	g6	i0	99.725	50.150014314343	4730	12	99	1	2207	6936	4842	114	Respirovirus muris genomic RNA, complete genome, strain: Z	blastn	350348	8661	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus muris
10362452	10362452	PRJNA1016321_P_NODE_17309_length_466_cov_1.997455_g17079_i0	PRJNA1016321	17309	466	1.997455	9.3081403	Respirovirus muris	3052731	Viruses	Viruses	850	0	NTclustered	gi\|546225824\|dbj\|AB855655.1\|	3052731	g17079	i0	99.571	40.8669527896996	466	2	100	0	1	466	10375	9910	Respirovirus muris genomic RNA, complete genome, strain: Z	blastn	19044	850	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus muris
13756102	13756102	PRJNA1016321_P_NODE_171_length_2662_cov_7.118965_g156_i0	PRJNA1016321	171	2662	7.118965	189.5068483	Apis mellifera associated ourmia-like virus 2	3373667	Viruses	Viruses	776	3.45e-269	NR	XII93055.1	3373667	g156	i0	59.4	0.793388429752066	704	263	77.3	8	86	2143	43	741	XII93055.1 RNA-dependent RNA polymerase [Apis mellifera associated ourmia-like virus 2]	diamond	2112	776	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Apis mellifera associated ourmia-like virus 2
22679521	22679521	PRJNA1016321_P_NODE_23438_length_386_cov_2.920128_g23207_i0	PRJNA1016321	23438	386	2.920128	11.27169408	Respirovirus	186938	Viruses	Viruses	713	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g23207	i0	100	37.7512953367876	386	0	100	0	1	386	6177	5792	Sendai virus (strain Z) genome RNA 5'end	blastn	14572	713	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
23955056	23955056	PRJNA1016321_P_NODE_34919_length_303_cov_4.765217_g34688_i0	PRJNA1016321	34919	303	4.765217	14.43860751	Respirovirus	186938	Viruses	Viruses	560	3.79e-155	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g34688	i0	100	35.2376237623762	303	0	100	0	1	303	17	319	Sendai virus (strain Z) genome RNA 5'end	blastn	10677	560	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
26781783	26781783	PRJNA1016321_P_NODE_12661_length_557_cov_2.000000_g12438_i0	PRJNA1016321	12661	557	2	11.14	Leptosphaeria biglobosa deltaflexivirus 1	2921231	Viruses	Viruses	138	5.18e-36	NR	UNI72638.1	2921231	g12438	i0	46.6	0.958707360861759	178	86	91.6	2	547	38	79	255	UNI72638.1 MAG: hypothetical protein [Leptosphaeria biglobosa deltaflexivirus 1]	diamond	534	138	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 1
27698664	27698664	PRJNA1016321_P_NODE_57324_length_230_cov_5.968153_g57093_i0	PRJNA1016321	57324	230	5.968153	13.7267519	Skokie reo-like virus	2789444	Viruses	Viruses	43.1	0.0234	NR	QPF16728.1	2789444	g57093	i0	74.1	0.352173913043478	27	7	35.2	0	83	3	21	47	QPF16728.1 hypothetical protein 2 [Skokie reo-like virus]	diamond	81	43.1	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Skokie reo-like virus
27730210	27730210	PRJNA1016321_P_NODE_30064_length_332_cov_1.189189_g29833_i0	PRJNA1016321	30064	332	1.189189	3.94810748	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	233	1.71e-70	NR	CAI9858974.1	3048756	g29833	i0	99.1	0.993975903614458	110	1	99.4	0	2	331	166	275	CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1]	diamond	330	233	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
28045566	28045566	PRJNA1016321_P_NODE_24525_length_376_cov_1.016502_g24294_i0	PRJNA1016321	24525	376	1.016502	3.82204752	Suillus luteus botourmiavirus 1	3067802	Viruses	Viruses	88.2	2.03e-17	NR	WLK77426.1	3067802	g24294	i0	42.7	0.933510638297872	117	61	90.2	3	351	13	469	583	WLK77426.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 1]	diamond	351	88.2	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Suillus luteus botourmiavirus 1
28171865	28171865	PRJNA1016321_P_NODE_17966_length_456_cov_1.746736_g17736_i0	PRJNA1016321	17966	456	1.746736	7.96511616	Grapevine wood holobiome associated mononegaambi virus 1	3385175	Viruses	Viruses	63.5	9.58e-9	NR	XLV09863.1	3385175	g17736	i0	38.3	1.06578947368421	81	50	53.3	0	442	200	180	260	XLV09863.1 hypothetical protein [Grapevine wood holobiome associated mononegaambi virus 1]	diamond	486	63.5	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales			Grapevine wood holobiome associated mononegaambi virus 1
28574512	28574512	PRJNA1016321_P_NODE_33907_length_309_cov_1.144068_g33676_i0	PRJNA1016321	33907	309	1.144068	3.53517012	Narnavirus	186767	Viruses	Viruses	55.8	1.23e-6	NR	WNA22205.1	2719492	g33676	i0	35.6	1.45631067961165	104	61	99	4	3	308	54	153	WNA22205.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 1]	diamond	450	55.8	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 1
28582511	28582511	PRJNA1016321_P_NODE_17907_length_457_cov_1.690104_g17677_i0	PRJNA1016321	17907	457	1.690104	7.72377528	Leptosphaeria biglobosa deltaflexivirus 2	2985705	Viruses	Viruses	156	8.79e-41	NR	UYL94495.1	2985705	g17677	i0	51.3	0.99781181619256	152	74	99.8	0	2	457	574	725	UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2]	diamond	456	156	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 2
29119379	29119379	PRJNA1016321_P_NODE_32949_length_314_cov_1.477178_g32718_i0	PRJNA1016321	32949	314	1.477178	4.63833892	Botourmiaviridae sp.	2808997	Viruses	Viruses	121	2.32e-29	NR	WAK77813.1	2808997	g32718	i0	58.7	0.993630573248408	104	40	99.4	1	2	313	99	199	WAK77813.1 MAG: RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	312	121	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
29371787	29371787	PRJNA1016321_P_NODE_29029_length_339_cov_1.157895_g28798_i0	PRJNA1016321	29029	339	1.157895	3.92526405	Lichen partiti-like RNA virus 1	2726936	Viruses	Viruses	91.7	7.47e-19	NR	BCD56382.1	2726936	g28798	i0	56.2	0.646017699115044	73	32	64.6	0	336	118	462	534	BCD56382.1 putative coat protein [Lichen partiti-like RNA virus 1]	diamond	219	91.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Lichen partiti-like RNA virus 1
29908681	29908681	PRJNA1016321_P_NODE_4431_length_966_cov_2.893617_g4260_i0	PRJNA1016321	4431	966	2.893617	27.95234022	Plasmopara viticola lesion associated mononegaambi virus 9	2692021	Viruses	Viruses	130	1.8799999999999998e-32	NR	WKE35292.1	2692021	g4260	i0	42.1	0.493788819875776	159	92	49.4	0	785	309	4	162	WKE35292.1 hypothetical protein [Plasmopara viticola lesion associated mononegaambi virus 9]	diamond	477	130	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Mymonaviridae	Penicillimonavirus	Penicillimonavirus etaplasmoparae
30508825	30508825	PRJNA1016321_P_NODE_56713_length_238_cov_2.600000_g56482_i0	PRJNA1016321	56713	238	2.6	6.188	Leptosphaeria biglobosa deltaflexivirus 2	2985705	Viruses	Viruses	142	3.2499999999999996e-37	NR	UYL94495.1	2985705	g56482	i0	87.3	0.995798319327731	79	10	99.6	0	1	237	1704	1782	UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2]	diamond	237	142	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 2
30824719	30824719	PRJNA1016321_P_NODE_17894_length_457_cov_2.088542_g17664_i0	PRJNA1016321	17894	457	2.088542	9.54463694	Leptosphaeria biglobosa deltaflexivirus 2	2985705	Viruses	Viruses	252	2.69e-74	NR	UYL94495.1	2985705	g17664	i0	80.9	0.99781181619256	152	29	99.8	0	1	456	387	538	UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2]	diamond	456	252	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 2
30824729	30824729	PRJNA1016321_P_NODE_7574_length_739_cov_2.163664_g7373_i0	PRJNA1016321	7574	739	2.163664	15.98947696	Leptosphaeria biglobosa deltaflexivirus 2	2985705	Viruses	Viruses	391	2.58e-121	NR	UYL94495.1	2985705	g7373	i0	77.2	0.962110960757781	237	54	96.2	0	1	711	159	395	UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2]	diamond	711	391	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 2
31362230	31362230	PRJNA1016321_P_NODE_12096_length_572_cov_4.843687_g11873_i0	PRJNA1016321	12096	572	4.843687	27.70588964	Tongren Botou tick virus 1	2972060	Viruses	Viruses	310	2.78e-98	NR	UYL95439.1	2972060	g11873	i0	79.9	0.965034965034965	184	37	96.5	0	3	554	454	637	UYL95439.1 MAG: RNA-dependent RNA polymerase [Tongren Botou tick virus 1]	diamond	552	310	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Tongren Botou tick virus 1
32501181	32501181	PRJNA1016321_P_NODE_14719_length_512_cov_1.772210_g14490_i0	PRJNA1016321	14719	512	1.77221	9.0737152	Leptosphaeria biglobosa deltaflexivirus 2	2985705	Viruses	Viruses	87.4	1.92e-16	NR	UYL94495.1	2985705	g14490	i0	39	0.931640625	159	85	88.5	4	455	3	1	155	UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2]	diamond	477	87.4	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Leptosphaeria biglobosa deltaflexivirus 2
32532830	32532830	PRJNA1016321_P_NODE_32119_length_319_cov_1.252033_g31888_i0	PRJNA1016321	32119	319	1.252033	3.99398527	Suillus luteus botourmiavirus 1	3067802	Viruses	Viruses	104	2.1099999999999998e-23	NR	WLK77426.1	3067802	g31888	i0	49	1.89028213166144	100	51	94	0	301	2	52	151	WLK77426.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 1]	diamond	603	104	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Suillus luteus botourmiavirus 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);;