metadata: contig_metadata: 24 rows where bioproject = "PRJNA982106" and tax

24 rows where bioproject = "PRJNA982106" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
963636	963636	PRJNA982106_P_NODE_12081_length_307_cov_0.803419_g11841_i0	PRJNA982106	12081	307	0.803419	2.46649633	Spring viraemia of carp virus	696863	Viruses	Viruses	307	5.540000000000001e-79	NTclustered	gi\|1418589526\|gb\|MG663512.1\|	696863	g11841	i0	84.691	1	307	47	100	0	1	307	420	726	Sprivivirus cyprinus isolate ADC-SVC2016-5, complete genome	blastn	307	307	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
963763	963763	PRJNA982106_P_NODE_1_length_11072_cov_6838.070097_g0_i0	PRJNA982106	1	11072	6838.070097	757111.12113984	Spring viraemia of carp virus	696863	Viruses	Viruses	17668	0	NTclustered	gi\|698945648\|gb\|KJ513477.1\|	696863	g0	i0	95.584	29.8548591040462	11029	485	99	2	17	11044	11029	2	Spring viraemia of carp virus isolate SVCV-265, complete genome	blastn	330553	17668	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
964056	964056	PRJNA982106_P_NODE_6661_length_372_cov_1.334448_g6421_i0	PRJNA982106	6661	372	1.334448	4.96414656	Zebrafish picornavirus 1	2304617	Viruses	Viruses	568	2.839999999999999e-157	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g6421	i0	94.324	2.99462365591398	370	21	99	0	1	370	2651	3020	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1114	568	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2238894	2238894	PRJNA982106_P_NODE_10242_length_324_cov_1.521912_g10002_i0	PRJNA982106	10242	324	1.521912	4.93099488	Zebrafish picornavirus 1	2304617	Viruses	Viruses	549	8.849999999999997e-152	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10002	i0	97.222	3	324	9	100	0	1	324	7073	6750	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	972	549	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2239290	2239290	PRJNA982106_P_NODE_2_length_10938_cov_6616.600184_g0_i1	PRJNA982106	2	10938	6616.600184	723723.72812592	Spring viraemia of carp virus	696863	Viruses	Viruses	14654	0	NTclustered	gi\|93280035\|gb\|DQ491000.1\|	696863	g0	i1	95.708	29.6337538855367	9110	387	99	4	17	9123	10990	1882	Spring viremia of carp virus isolate A2, complete genome	blastn	324134	14654	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
3514590	3514590	PRJNA982106_P_NODE_3_length_9714_cov_3642.659164_g0_i2	PRJNA982106	3	9714	3642.659164	353847.91119096	Spring viraemia of carp virus	696863	Viruses	Viruses	13236	0	NTclustered	gi\|93280035\|gb\|DQ491000.1\|	696863	g0	i2	95.859	30.3640107061972	8186	336	98	3	1515	9698	2806	10990	Spring viremia of carp virus isolate A2, complete genome	blastn	294956	13236	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
3514601	3514601	PRJNA982106_P_NODE_463_length_1362_cov_26879.271528_g0_i5	PRJNA982106	463	1362	26879.271528	366095.67821136	Spring viraemia of carp virus	696863	Viruses	Viruses	2204	0	NTclustered	gi\|89280756\|gb\|DQ097384.2\|	696863	g0	i5	96.477	25.0337738619677	1334	47	98	0	1	1334	1335	2	Spring viraemia of carp virus isolate A1, complete genome	blastn	34096	2204	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
4792122	4792122	PRJNA982106_P_NODE_4_length_9164_cov_18.789792_g1_i0	PRJNA982106	4	9164	18.789792	1721.89653888	Picornaviridae sp.	1530251	Viruses	Viruses	1885	0	NR	WWV86902.1	1530251	g1	i0	72	0.42099519860323	1286	348	41.8	7	1801	5628	2	1285	WWV86902.1 MAG: hypothetical protein, partial [Picornaviridae sp.]	diamond	3858	1885	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
6066975	6066975	PRJNA982106_P_NODE_14105_length_290_cov_1.410138_g13865_i0	PRJNA982106	14105	290	1.410138	4.0894002	Zebrafish picornavirus 1	2304617	Viruses	Viruses	492	1.3399999999999996e-134	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g13865	i0	97.561	2.95862068965517	287	7	99	0	4	290	2576	2290	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	858	492	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
6067368	6067368	PRJNA982106_P_NODE_5_length_7162_cov_11.490760_g2_i0	PRJNA982106	5	7162	11.49076	822.9682312	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2844	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g2	i0	96.205	0.665875453783859	1739	61	67	5	5426	7162	5329	7064	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4769	2844	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
7341462	7341462	PRJNA982106_P_NODE_146_length_2090_cov_20437.693109_g0_i3	PRJNA982106	146	2090	20437.693109	427147.7859781	Spring viraemia of carp virus	696863	Viruses	Viruses	2761	0	NTclustered	gi\|89280756\|gb\|DQ097384.2\|	696863	g0	i3	94.417	31.7363636363636	1809	80	99	9	257	2062	1792	2	Spring viraemia of carp virus isolate A1, complete genome	blastn	66329	2761	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
7649001	7649001	PRJNA982106_P_NODE_16846_length_272_cov_1.683417_g16606_i0	PRJNA982106	16846	272	1.683417	4.57889424	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	222	1.8e-53	NTclustered	gi\|1808629704\|gb\|MT049059.1\|	RQ01	g16606	i0	82.129	96.8014705882353	263	44	96	3	7	268	344	604	Influenza B virus (B/California/78/2019) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds	blastn	26330	222	1	Viruses		Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
8616891	8616891	PRJNA982106_P_NODE_26427_length_246_cov_0.890173_g26187_i0	PRJNA982106	26427	246	0.890173	2.18982558	Mogiana tick virus	1172985	Viruses	Viruses	399	6.889999999999999e-107	NTclustered	gi\|2163187833\|gb\|MW721982.1\|	1491393	g26187	i0	95.935	82.9146341463415	246	10	100	0	1	246	832	1077	Jingmen tick virus strain JTV/HAHH3 segment 2, complete sequence	blastn	20397	399	1	Viruses	Riboviria	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Mogiana tick virus
12442769	12442769	PRJNA982106_P_NODE_1190_length_820_cov_14578.069612_g0_i6	PRJNA982106	1190	820	14578.069612	119540.1708184	Spring viraemia of carp virus	696863	Viruses	Viruses	1131	0	NTclustered	gi\|1418589526\|gb\|MG663512.1\|	696863	g0	i6	96.623	19.8451219512195	681	23	96	0	112	792	682	2	Sprivivirus cyprinus isolate ADC-SVC2016-5, complete genome	blastn	16273	1131	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
20090180	20090180	PRJNA982106_P_NODE_156_length_2038_cov_20723.741476_g0_i4	PRJNA982106	156	2038	20723.741476	422349.85128088	Spring viraemia of carp virus	696863	Viruses	Viruses	3053	0	NTclustered	gi\|698945648\|gb\|KJ513477.1\|	696863	g0	i4	94.229	34.3022571148185	2010	98	99	6	29	2038	2	1993	Spring viraemia of carp virus isolate SVCV-265, complete genome	blastn	69908	3053	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
23916563	23916563	PRJNA982106_P_NODE_28299_length_244_cov_1.614035_g28059_i0	PRJNA982106	28299	244	1.614035	3.9382454	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	324	4.22e-84	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g28059	i0	90.612	1.00409836065574	245	21	100	2	1	244	5862	6105	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	245	324	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
26715377	26715377	PRJNA982106_P_NODE_2961_length_508_cov_1.482759_g2722_i0	PRJNA982106	2961	508	1.482759	7.53241572	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	291	2.4099999999999998e-95	NR	AXG64379.1	RQ01	g2722	i0	87.6	6.98622047244094	169	21	99.8	0	2	508	18	186	AXG64379.1 nucleoprotein, partial [Influenza B virus]	diamond	3549	291	1	Viruses		Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
28194745	28194745	PRJNA982106_P_NODE_28406_length_244_cov_0.900585_g28166_i0	PRJNA982106	28406	244	0.900585	2.1974274	Spring viraemia of carp virus	696863	Viruses	Viruses	118	2.19e-29	NR	NP_116744.1	696863	g28166	i0	71.6	2.98770491803279	81	23	99.6	0	2	244	222	302	NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus]	diamond	729	118	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
29205483	29205483	PRJNA982106_P_NODE_24009_length_248_cov_0.880000_g23769_i0	PRJNA982106	24009	248	0.88	2.1824	Spring viraemia of carp virus	696863	Viruses	Viruses	123	1.52e-30	NR	NP_116748.1	696863	g23769	i0	80.5	0.991935483870968	82	16	99.2	0	1	246	1748	1829	NP_116748.1 polymerase [Sprivivirus cyprinus]	diamond	246	123	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
29495453	29495453	PRJNA982106_P_NODE_16850_length_272_cov_1.547739_g16610_i0	PRJNA982106	16850	272	1.547739	4.20985008	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	173	2.7799999999999995e-48	NR	NP_056659.1	RQ01	g16610	i0	92.2	18.8602941176471	90	7	99.3	0	3	272	570	659	NP_056659.1 polymerase PA [Influenza B virus (B/Lee/1940)]	diamond	5130	173	1	Viruses		Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae	Betainfluenzavirus	Zebrafish influenza B-like virus
29552387	29552387	PRJNA982106_P_NODE_26190_length_246_cov_0.890173_g25950_i0	PRJNA982106	26190	246	0.890173	2.18982558	Spring viraemia of carp virus	696863	Viruses	Viruses	102	2.86e-23	NR	NP_116748.1	696863	g25950	i0	65.4	0.98780487804878	81	28	98.8	0	3	245	1828	1908	NP_116748.1 polymerase [Sprivivirus cyprinus]	diamond	243	102	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
30184263	30184263	PRJNA982106_P_NODE_32272_length_241_cov_0.916667_g32032_i0	PRJNA982106	32272	241	0.916667	2.20916747	Spring viraemia of carp virus	696863	Viruses	Viruses	118	7.6e-29	NR	NP_116748.1	696863	g32032	i0	72.2	0.983402489626556	79	22	98.3	0	3	239	1825	1903	NP_116748.1 polymerase [Sprivivirus cyprinus]	diamond	237	118	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
31131879	31131879	PRJNA982106_P_NODE_31195_length_242_cov_0.911243_g30955_i0	PRJNA982106	31195	242	0.911243	2.20520806	Spring viraemia of carp virus	696863	Viruses	Viruses	118	1.4999999999999996e-29	NR	NP_116744.1	696863	g30955	i0	78.2	1.93388429752066	78	17	96.7	0	2	235	3	80	NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus]	diamond	468	118	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
31638062	31638062	PRJNA982106_P_NODE_2476_length_552_cov_1.202505_g2238_i0	PRJNA982106	2476	552	1.202505	6.6378276	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	217	7.87e-66	NR	7XVR_A	RQ01	g2238	i0	61.7	1.98913043478261	183	70	99.5	0	550	2	172	354	7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus]	diamond	1098	217	1	Viruses		Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus

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