metadata: contig_metadata: 5 rows where bioproject = "PRJNA312899" and tax

5 rows where bioproject = "PRJNA312899" 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_genus	tax_species
14407810	14407810	PRJNA312899_P_NODE_103532_length_158_cov_2.807339_g103090_i0	PRJNA312899	103532	158	2.807339	4.43559562	Varroa picorna-like virus	2873563	Viruses	Viruses	171	3.46e-38	NTclustered	gi\|2111829811\|gb\|MZ822077.1\|	2873563	g103090	i0	93.22	0.746835443037975	118	5	73	3	1	115	7807	7924	MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome	blastn	118	171	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Varroa picorna-like virus
27010926	27010926	PRJNA312899_P_NODE_35622_length_303_cov_13.744094_g35180_i0	PRJNA312899	35622	303	13.744094	41.64460482	Dicistroviridae sp.	1955144	Viruses	Viruses	72.4	2.94e-12	NR	XCO49407.1	1955144	g35180	i0	44.1	0.920792079207921	93	48	91.1	2	290	15	805	894	XCO49407.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	279	72.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
27042673	27042673	PRJNA312899_P_NODE_3162_length_962_cov_41.704272_g2917_i0	PRJNA312899	3162	962	41.704272	401.19509664	Locarnavirus sp.	2809529	Viruses	Viruses	342	8.92e-103	NR	ULG00072.1	2809529	g2917	i0	54.2	1.91476091476091	308	115	92.9	4	55	948	49	340	ULG00072.1 MAG: hypothetical protein, partial [Locarnavirus sp.]	diamond	1842	342	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus sp.
31717803	31717803	PRJNA312899_P_NODE_19917_length_422_cov_11.911528_g19476_i0	PRJNA312899	19917	422	11.911528	50.26664816	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	95.9	7.27e-20	NR	XCM67775.1	3003959	g19476	i0	56	0.533175355450237	75	32	53.3	1	421	197	822	895	XCM67775.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	225	95.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32192451	32192451	PRJNA312899_P_NODE_45738_length_260_cov_4.113744_g45296_i0	PRJNA312899	45738	260	4.113744	10.6957344	Colletotrichum associated partitivirus 2	2979641	Viruses	Viruses	55.1	2.04e-6	NR	UYD21360.1	2979641	g45296	i0	48	0.576923076923077	50	26	57.7	0	255	106	487	536	UYD21360.1 hypothetical protein [Colletotrichum associated partitivirus 2]	diamond	150	55.1	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Colletotrichum associated partitivirus 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);;