metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA690234" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA690234" 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
669969	669969	PRJNA690234_P_NODE_13061_length_351_cov_1.122302_g12694_i0	PRJNA690234	13061	351	1.122302	3.93928002	Amalgavirus lycopersici	3048320	Viruses	Viruses	641	1.5499999999999998e-179	NTclustered	gi\|2595963093\|gb\|OR596868.1\|	591166	g12694	i0	100	96.3589743589744	347	0	99	0	5	351	2195	2541	Southern tomato virus isolate T15 fusion protein p122 and coat protein p42 genes, complete cds	blastn	33822	641	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Amalgaviridae	Amalgavirus	Amalgavirus lycopersici
670107	670107	PRJNA690234_P_NODE_1_length_7216_cov_133.050819_g0_i0	PRJNA690234	1	7216	133.050819	9600.94709904	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2913	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g0	i0	96.184	0.666712860310421	1782	63	67	5	5	1783	7108	5329	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	4811	2913	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
3221265	3221265	PRJNA690234_P_NODE_3_length_6313_cov_53.996635_g2_i0	PRJNA690234	3	6313	53.996635	3408.80756755	Spring viraemia of carp virus	696863	Viruses	Viruses	11293	0	NTclustered	gi\|89280756\|gb\|DQ097384.2\|	696863	g2	i0	98.955	21.8602882939965	6314	64	100	2	1	6313	11080	4768	Spring viraemia of carp virus isolate A1, complete genome	blastn	138004	11293	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
4498188	4498188	PRJNA690234_P_NODE_21964_length_271_cov_1.181818_g21597_i0	PRJNA690234	21964	271	1.181818	3.20272678	Zebrafish picornavirus 1	2304617	Viruses	Viruses	462	9.69e-126	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g21597	i0	97.417	3	271	7	100	0	1	271	5946	6216	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	813	462	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4498260	4498260	PRJNA690234_P_NODE_25604_length_252_cov_0.871508_g25237_i0	PRJNA690234	25604	252	0.871508	2.19620016	Bacteriophage sp.	38018	Viruses	Viruses	411	3.269999999999999e-110	NTclustered	gi\|2057080768\|tpg\|BK037912.1\|	38018	g25237	i0	96.032	1	252	10	100	0	1	252	24326	24075	MAG TPA_asm: Bacteriophage sp. isolate ctu5M1, partial genome	blastn	252	411	1	Viruses							Bacteriophage sp.
5774027	5774027	PRJNA690234_P_NODE_5_length_5428_cov_1272.131653_g4_i0	PRJNA690234	5	5428	1272.131653	69051.30612484	Spring viraemia of carp virus	696863	Viruses	Viruses	4505	0	NTclustered	gi\|89280756\|gb\|DQ097384.2\|	696863	g4	i0	97.925	38.6226971260133	2603	50	100	4	2709	5307	2761	159	Spring viraemia of carp virus isolate A1, complete genome	blastn	209644	4505	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
5774101	5774101	PRJNA690234_P_NODE_9865_length_406_cov_2.489489_g9499_i0	PRJNA690234	9865	406	2.489489	10.10732534	Zebrafish picornavirus 1	2304617	Viruses	Viruses	684	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g9499	i0	97.044	3	406	12	100	0	1	406	6710	6305	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1218	684	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7048999	7048999	PRJNA690234_P_NODE_4466_length_620_cov_1.893967_g4107_i0	PRJNA690234	4466	620	1.893967	11.7425954	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	872	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4107	i0	91.935	1	620	50	100	0	1	620	6366	6985	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	620	872	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
9598617	9598617	PRJNA690234_P_NODE_20108_length_283_cov_1.442857_g19741_i0	PRJNA690234	20108	283	1.442857	4.08328531	Zebrafish picornavirus 1	2304617	Viruses	Viruses	499	7.76e-137	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g19741	i0	98.582	2.98939929328622	282	4	99	0	2	283	7932	7651	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	846	499	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
9599008	9599008	PRJNA690234_P_NODE_8_length_4727_cov_944.341427_g4_i1	PRJNA690234	8	4727	944.341427	44639.01925429	Spring viraemia of carp virus	696863	Viruses	Viruses	7978	0	NTclustered	gi\|89280756\|gb\|DQ097384.2\|	696863	g4	i1	97.922	42.3289612862281	4620	72	100	6	122	4727	159	4768	Spring viraemia of carp virus isolate A1, complete genome	blastn	200089	7978	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
10873929	10873929	PRJNA690234_P_NODE_11129_length_381_cov_1.772727_g10763_i0	PRJNA690234	11129	381	1.772727	6.75408987	Zebrafish picornavirus 1	2304617	Viruses	Viruses	627	4.7499999999999997e-175	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g10763	i0	96.325	3	381	14	100	0	1	381	5258	5638	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1143	627	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13423933	13423933	PRJNA690234_P_NODE_19851_length_285_cov_1.103774_g19484_i0	PRJNA690234	19851	285	1.103774	3.1457559	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	353	6.44e-93	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g19484	i0	96.279	0.754385964912281	215	8	75	0	71	285	4704	4490	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	215	353	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13423962	13423962	PRJNA690234_P_NODE_21451_length_274_cov_1.417910_g21084_i0	PRJNA690234	21451	274	1.41791	3.8850734	Zebrafish picornavirus 1	2304617	Viruses	Viruses	462	9.81e-126	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g21084	i0	97.08	3	274	8	100	0	1	274	6947	7220	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	822	462	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13424159	13424159	PRJNA690234_P_NODE_30271_length_244_cov_1.304094_g29904_i0	PRJNA690234	30271	244	1.304094	3.18198936	Zebrafish picornavirus 1	2304617	Viruses	Viruses	412	8.759999999999998e-111	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g29904	i0	97.131	2.99180327868852	244	7	100	0	1	244	1261	1018	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	730	412	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
18522159	18522159	PRJNA690234_P_NODE_22415_length_268_cov_1.343590_g22048_i0	PRJNA690234	22415	268	1.34359	3.6008212	Spring viraemia of carp virus	696863	Viruses	Viruses	368	2.15e-97	NTclustered	gi\|1063892400\|gb\|KU230365.1\|	696863	g22048	i0	91.418	18	268	23	100	0	1	268	10614	10347	Sprivivirus cyprinus strain 202238 nucleoprotein (NP), phosoprotein (P), matrix protein (M), glycoprotein (G), and polymerase protein (L) genes, complete cds	blastn	4824	368	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Sprivivirus	Spring viraemia of carp virus
19797108	19797108	PRJNA690234_P_NODE_23476_length_262_cov_1.084656_g23109_i0	PRJNA690234	23476	262	1.084656	2.84179872	Ripachij virus	3130407	Viruses	Viruses	401	2.0599999999999992e-107	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g23109	i0	94.275	164.156488549618	262	15	100	0	1	262	490	751	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	43009	401	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
21072715	21072715	PRJNA690234_P_NODE_28117_length_248_cov_0.891429_g27750_i0	PRJNA690234	28117	248	0.891429	2.21074392	Amalgavirus lycopersici	3048320	Viruses	Viruses	455	1.4600000000000002e-123	NTclustered	gi\|2595963093\|gb\|OR596868.1\|	591166	g27750	i0	100	93.2701612903226	246	0	99	0	1	246	1863	2108	Southern tomato virus isolate T15 fusion protein p122 and coat protein p42 genes, complete cds	blastn	23131	455	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Amalgaviridae	Amalgavirus	Amalgavirus lycopersici
21072902	21072902	PRJNA690234_P_NODE_7457_length_471_cov_2.193467_g7091_i0	PRJNA690234	7457	471	2.193467	10.33122957	Indivirus ILV1	1977633	Viruses	Viruses	54.7	0.013	NTclustered	gi\|1174571037\|gb\|KY684089.1\|	1977633	g7091	i0	100	0.0615711252653928	29	0	6	0	302	330	55599	55571	Indivirus ILV1 isolate ILV1 clone Indivirus_5, sequence	blastn	29	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
22347619	22347619	PRJNA690234_P_NODE_27358_length_249_cov_1.147727_g26991_i0	PRJNA690234	27358	249	1.147727	2.85784023	Zebrafish picornavirus 1	2304617	Viruses	Viruses	438	1.4799999999999996e-118	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g26991	i0	98.394	3.01204819277108	249	4	100	0	1	249	5597	5845	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	750	438	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22347708	22347708	PRJNA690234_P_NODE_31238_length_243_cov_0.917647_g30871_i0	PRJNA690234	31238	243	0.917647	2.22988221	Carlavirus betachrysanthemi	3427741	Viruses	Viruses	207	4.42e-49	NTclustered	gi\|1515255842\|gb\|MH678701.1\|	12165	g30871	i0	83.26	9.60082304526749	227	36	93	2	18	243	281	56	Chrysanthemum virus B isolate Demurral Lilac coat protein gene, complete cds	blastn	2333	207	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus betachrysanthemi
22347731	22347731	PRJNA690234_P_NODE_32078_length_241_cov_2.511905_g31711_i0	PRJNA690234	32078	241	2.511905	6.05369105	Zebrafish picornavirus 1	2304617	Viruses	Viruses	424	3.99e-114	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g31711	i0	98.34	3	241	4	100	0	1	241	6679	6919	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	723	424	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22347803	22347803	PRJNA690234_P_NODE_6698_length_499_cov_1.389671_g6332_i0	PRJNA690234	6698	499	1.389671	6.93445829	Zebrafish picornavirus 1	2304617	Viruses	Viruses	845	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g6332	i0	97.194	3	499	14	100	0	1	499	4627	5125	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1497	845	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23622862	23622862	PRJNA690234_P_NODE_17559_length_303_cov_1.256522_g17192_i0	PRJNA690234	17559	303	1.256522	3.80726166	Zebrafish picornavirus 1	2304617	Viruses	Viruses	499	8.389999999999998e-137	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g17192	i0	96.37	3	303	11	100	0	1	303	7511	7209	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	909	499	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);;