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

7 rows where analysis = "blastn", bioproject = "PRJNA287283" 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
6749886	6749886	PRJNA287283_P_NODE_646_length_910_cov_1.495916_g491_i0	PRJNA287283	646	910	1.495916	13.6128356	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	1026	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g491	i0	95.755	0.698901098901099	636	27	70	0	134	769	639	4	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	636	1026	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
6749888	6749888	PRJNA287283_P_NODE_726_length_857_cov_2.381841_g562_i0	PRJNA287283	726	857	2.381841	20.41237737	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	396	3.46e-105	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g562	i0	92.143	0.568261376896149	280	22	57	0	346	625	5194	4915	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	487	396	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
8025465	8025465	PRJNA287283_P_NODE_3927_length_319_cov_2.710526_g3703_i0	PRJNA287283	3927	319	2.710526	8.64657794	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	398	3.3299999999999993e-106	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g3703	i0	94.882	0.796238244514107	254	13	80	0	66	319	2543	2290	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	254	398	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
9300257	9300257	PRJNA287283_P_NODE_6348_length_226_cov_1.913295_g6124_i0	PRJNA287283	6348	226	1.913295	4.3240467	Biavirus raunefjordenense	3059777	Viruses	Viruses	143	1.16e-29	NTclustered	gi\|2500387999\|ref\|NC_077221.1\|	1499987	g6124	i0	79.227	5.3141592920354	207	41	91	2	21	226	944132	943927	Prymnesium kappa virus genome assembly, chromosome: 1	blastn	1201	143	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Biavirus	Biavirus raunefjordenense
9300260	9300260	PRJNA287283_P_NODE_708_length_867_cov_3.098280_g545_i0	PRJNA287283	708	867	3.09828	26.8620876	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	1206	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g545	i0	91.705	1.00115340253749	868	70	100	2	1	867	5951	6817	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	868	1206	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
13126019	13126019	PRJNA287283_P_NODE_1731_length_523_cov_3.670213_g1514_i0	PRJNA287283	1731	523	3.670213	19.19521399	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	315	5.92e-81	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g1514	i0	90.987	0.445506692160612	233	21	45	0	288	520	4195	4427	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	233	315	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15674910	15674910	PRJNA287283_P_NODE_4693_length_283_cov_2.256522_g4469_i0	PRJNA287283	4693	283	2.256522	6.38595726	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	424	4.8e-114	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g4469	i0	93.64	1	283	18	100	0	1	283	5537	5819	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	283	424	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2

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