metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA764222" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA764222" 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
1205783	1205783	PRJNA764222_S_NODE_6981_length_287_cov_7.887500_g6823_i0	PRJNA764222	6981	287	7.8875	22.637125	Copiparvovirus	1511888	Viruses	Viruses	520	6.049999999999999e-143	NTclustered	gi\|1725344901\|ref\|NC_031959.2\|	1917013	g6823	i0	99.303	4.56445993031359	287	2	100	0	1	287	5306	5020	Bosavirus MS-2016a, complete genome	blastn	1310	520	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Copiparvovirus	Copiparvovirus ungulate5
2020708	2020708	PRJNA764222_S_NODE_2342_length_387_cov_5.723529_g2184_i0	PRJNA764222	2342	387	5.723529	22.15005723	Zebrafish picornavirus 1	2304617	Viruses	Viruses	682	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g2184	i0	98.45	3	387	6	100	0	1	387	5715	6101	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	1161	682	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
2020869	2020869	PRJNA764222_S_NODE_642_length_789_cov_115.111860_g525_i0	PRJNA764222	642	789	115.11186	908.2325754	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1380	0	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g525	i0	98.228	3.51584283903676	790	12	100	2	1	789	7449	8237	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	2774	1380	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
4573178	4573178	PRJNA764222_S_NODE_684_length_755_cov_11.381356_g562_i0	PRJNA764222	684	755	11.381356	85.9292378	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1297	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g562	i0	97.742	2.99205298013245	753	17	99	0	1	753	5046	4294	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2259	1297	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
7123302	7123302	PRJNA764222_S_NODE_14146_length_238_cov_1.078534_g13988_i0	PRJNA764222	14146	238	1.078534	2.56691092	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.006	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g13988	i0	100	0.592436974789916	29	0	12	0	210	238	41	13	Carnation latent virus isolate KL, complete genome	blastn	141	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
8398084	8398084	PRJNA764222_S_NODE_7987_length_278_cov_3.142857_g7829_i0	PRJNA764222	7987	278	3.142857	8.73714246	Zebrafish picornavirus 1	2304617	Viruses	Viruses	486	5.919999999999998e-133	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g7829	i0	98.201	2.99640287769784	278	5	100	0	1	278	6158	6435	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	833	486	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
13498579	13498579	PRJNA764222_S_NODE_51_length_3420_cov_29.450341_g42_i0	PRJNA764222	51	3420	29.450341	1007.2016622	Zebrafish picornavirus 1	2304617	Viruses	Viruses	5541	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g42	i0	95.912	3.00438596491228	3425	131	100	7	1	3420	96	3516	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	10275	5541	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
14773744	14773744	PRJNA764222_S_NODE_52_length_3420_cov_27.912541_g42_i1	PRJNA764222	52	3420	27.912541	954.6089022	Zebrafish picornavirus 1	2304617	Viruses	Viruses	5546	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g42	i1	95.942	3.00438596491228	3425	130	100	8	1	3420	3503	83	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	10275	5546	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
17323079	17323079	PRJNA764222_S_NODE_28654_length_174_cov_1.622047_g28496_i0	PRJNA764222	28654	174	1.622047	2.82236178	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	230	6.299999999999999e-56	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g28496	i0	94.04	0.867816091954023	151	9	87	0	21	171	1442	1592	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	151	230	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
17323208	17323208	PRJNA764222_S_NODE_9014_length_270_cov_1.650224_g8856_i0	PRJNA764222	9014	270	1.650224	4.4556048	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	416	7.619999999999998e-112	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g8856	i0	94.444	1	270	15	100	0	1	270	2417	2148	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	270	416	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
18596583	18596583	PRJNA764222_S_NODE_9175_length_269_cov_1.193694_g9017_i0	PRJNA764222	9175	269	1.193694	3.21103686	Carlavirus latensdianthi	3427766	Viruses	Viruses	52.8	0.025	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g9017	i0	100	0.104089219330855	28	0	10	0	1	28	14	41	Carnation latent virus isolate KL, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
19871332	19871332	PRJNA764222_S_NODE_1236_length_527_cov_61.160417_g1084_i0	PRJNA764222	1236	527	61.160417	322.31539759	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	723	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1084	i0	91.412	0.994307400379507	524	45	99	0	1	524	6586	7109	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	524	723	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
21147416	21147416	PRJNA764222_S_NODE_757_length_709_cov_7.564955_g629_i0	PRJNA764222	757	709	7.564955	53.63553095	Zebrafish picornavirus 1	2304617	Viruses	Viruses	1205	0	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g629	i0	97.32	3	709	19	100	0	1	709	3505	4213	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	2127	1205	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
22421933	22421933	PRJNA764222_S_NODE_20718_length_206_cov_1.660377_g20560_i0	PRJNA764222	20718	206	1.660377	3.42037662	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	381	2.0199999999999994e-101	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g20560	i0	100	8.97087378640777	206	0	100	0	1	206	3319	3524	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	1848	381	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
23697545	23697545	PRJNA764222_S_NODE_16739_length_224_cov_2.909605_g16581_i0	PRJNA764222	16739	224	2.909605	6.5175152	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.02	NTclustered	gi\|2058103431\|tpg\|BK033609.1\|	2832643	g16581	i0	100	0.125	28	0	13	0	193	220	40394	40367	MAG TPA_asm: Caudoviricetes sp. isolate ctq0U24, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24971169	24971169	PRJNA764222_S_NODE_13500_length_241_cov_2.427835_g13342_i0	PRJNA764222	13500	241	2.427835	5.85108235	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	440	3.959999999999999e-119	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g13342	i0	99.585	9.00829875518672	241	1	100	0	1	241	1963	2203	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	2171	440	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1

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