metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB12982" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB12982" and tax_phylum = "Pisuviricota"

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_species
1295220	1295220	PRJEB12982_P_NODE_3582_length_405_cov_1.522472_g3419_i0	PRJEB12982	3582	405	1.522472	6.1660116	Zebrafish picornavirus 1	2304617	Viruses	Viruses	625	1.8299999999999995e-174	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g3419	i0	94.554	2.99259259259259	404	22	99	0	1	404	5149	5552	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1212	625	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
5123264	5123264	PRJEB12982_P_NODE_13185_length_193_cov_1.055556_g13022_i0	PRJEB12982	13185	193	1.055556	2.03722308	Zebrafish picornavirus 1	2304617	Viruses	Viruses	318	1.4899999999999995e-82	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g13022	i0	96.373	3	193	7	100	0	1	193	2662	2470	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	579	318	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
6399221	6399221	PRJEB12982_P_NODE_9266_length_233_cov_1.951087_g9103_i0	PRJEB12982	9266	233	1.951087	4.54603271	Zebrafish picornavirus 1	2304617	Viruses	Viruses	381	2.3399999999999995e-101	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g9103	i0	96.137	3	233	9	100	0	1	233	6005	6237	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	699	381	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
16597802	16597802	PRJEB12982_P_NODE_19914_length_163_cov_0.894737_g19751_i0	PRJEB12982	19914	163	0.894737	1.45842131	Sopidub virus	3131684	Viruses	Viruses	134	4.72e-27	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g19751	i0	84.783	5.17177914110429	138	16	82	4	5	138	2212	2076	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	843	134	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Sopidub virus
16597846	16597846	PRJEB12982_P_NODE_4594_length_352_cov_1.178218_g4431_i0	PRJEB12982	4594	352	1.178218	4.14732736	Zebrafish picornavirus 1	2304617	Viruses	Viruses	595	1.2299999999999994e-165	NTclustered	gi\|2500378199\|ref\|NC_076245.1\|	2304617	g4431	i0	97.159	3	352	10	100	0	1	352	6636	6987	Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome	blastn	1056	595	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
17872647	17872647	PRJEB12982_P_NODE_4315_length_364_cov_1.298413_g4152_i0	PRJEB12982	4315	364	1.298413	4.72622332	Zebrafish picornavirus 1	2304617	Viruses	Viruses	645	1.2499999999999996e-180	NTclustered	gi\|1990739381\|tpg\|BK011179.1\|	2304617	g4152	i0	98.626	3.00824175824176	364	5	100	0	1	364	6060	5697	TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome	blastn	1095	645	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Zebrafish picornavirus 1
22973051	22973051	PRJEB12982_P_NODE_9059_length_237_cov_1.047872_g8896_i0	PRJEB12982	9059	237	1.047872	2.48345664	Zebrafish picornavirus 1	2304617	Viruses	Viruses	372	1.44e-98	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g8896	i0	95.299	2.9789029535865	234	11	99	0	3	236	1890	2123	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	706	372	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);;