metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA606583" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA606583" 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
583524	583524	PRJNA606583_P_NODE_28001_length_204_cov_2.520958_g27572_i0	PRJNA606583	28001	204	2.520958	5.14275432	Chrocorelt virus	3129514	Viruses	Viruses	289	1.2499999999999998e-73	NTclustered	gi\|2717317772\|gb\|PP171962.1\|	3129514	g27572	i0	92.574	152.563725490196	202	14	99	1	4	204	2733	2532	MAG: Chrocorelt virus isolate CC1B_k141_7916 genomic sequence	blastn	31123	289	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Chrocorelt virus
1859456	1859456	PRJNA606583_P_NODE_26622_length_213_cov_1.261364_g26193_i0	PRJNA606583	26622	213	1.261364	2.68670532	Zebrafish picornavirus 1	2304617	Viruses	Viruses	377	2.72e-100	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g26193	i0	98.592	3	213	3	100	0	1	213	3850	3638	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	639	377	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
1859528	1859528	PRJNA606583_P_NODE_36302_length_168_cov_1.091603_g35873_i0	PRJNA606583	36302	168	1.091603	1.83389304	Zebrafish picornavirus 1	2304617	Viruses	Viruses	250	4.66e-62	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g35873	i0	93.452	3	168	11	100	0	1	168	7293	7460	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	504	250	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
5687243	5687243	PRJNA606583_P_NODE_23165_length_238_cov_1.701493_g22736_i0	PRJNA606583	23165	238	1.701493	4.04955334	Zebrafish picornavirus 1	2304617	Viruses	Viruses	401	1.8399999999999994e-107	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g22736	i0	97.059	3.01260504201681	238	7	100	0	1	238	3141	3378	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	717	401	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
8236763	8236763	PRJNA606583_P_NODE_39107_length_159_cov_2.032787_g38678_i0	PRJNA606583	39107	159	2.032787	3.23213133	Zebrafish picornavirus 1	2304617	Viruses	Viruses	263	5.59e-66	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g38678	i0	96.815	2.9874213836478	157	5	99	0	1	157	4819	4975	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	475	263	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
10787897	10787897	PRJNA606583_P_NODE_32769_length_181_cov_1.083333_g32340_i0	PRJNA606583	32769	181	1.083333	1.96083273	Mitovirus sp.	2587224	Viruses	Viruses	289	1.08e-73	NTclustered	gi\|1698233349\|gb\|MN033122.1\|	2587224	g32340	i0	95.556	0.994475138121547	180	8	99	0	1	180	1173	994	MAG: Mitovirus sp. isolate H4_Bulk_48_scaffold_6274 sequence	blastn	180	289	1	Viruses	Orthornavirae	Lenarviricota	Howeltoviricetes	Cryppavirales	Mitoviridae	Mitovirus	Mitovirus sp.
14612482	14612482	PRJNA606583_P_NODE_12832_length_364_cov_1095.085627_g12404_i0	PRJNA606583	12832	364	1095.085627	3986.11168228	Lycium betacytorhabdovirus 1	3078349	Viruses	Viruses	130	1.55e-25	NTclustered	gi\|2618835662\|tpg\|BK064324.1\|	3078349	g12404	i0	100	2.01373626373626	70	0	35	0	177	246	70	1	TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence	blastn	733	130	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Lycium betacytorhabdovirus 1
15886639	15886639	PRJNA606583_P_NODE_7713_length_488_cov_1.694013_g7294_i0	PRJNA606583	7713	488	1.694013	8.26678344	Zebrafish picornavirus 1	2304617	Viruses	Viruses	874	0	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g7294	i0	98.975	3.00204918032787	488	5	100	0	1	488	275	762	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1465	874	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
23536030	23536030	PRJNA606583_P_NODE_28819_length_200_cov_1.030675_g28390_i0	PRJNA606583	28819	200	1.030675	2.06135	Zebrafish picornavirus 1	2304617	Viruses	Viruses	337	4.28e-88	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g28390	i0	97	2.99	200	6	100	0	1	200	1314	1513	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	598	337	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 1
24809921	24809921	PRJNA606583_P_NODE_34580_length_174_cov_1.087591_g34151_i0	PRJNA606583	34580	174	1.087591	1.89240834	Zebrafish picornavirus 1	2304617	Viruses	Viruses	305	1.02e-78	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g34151	i0	98.276	3	174	3	100	0	1	174	6658	6831	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	522	305	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);;