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

5 rows where bioproject = "PRJNA1245487" 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
1625902	1625902	PRJNA1245487_P_NODE_6702_length_479_cov_1.839901_g6366_i0	PRJNA1245487	6702	479	1.839901	8.81312579	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	494	6.45e-135	NTclustered	gi\|2754804027\|tpg\|BK063169.1\|	3032225	g6366	i0	85.417	1.00208768267223	480	65	99	4	2	479	4482	4006	TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds	blastn	480	494	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus
2901926	2901926	PRJNA1245487_P_NODE_17183_length_269_cov_1.591837_g16845_i0	PRJNA1245487	17183	269	1.591837	4.28204153	Solenopsis invicta virus 8	2547311	Viruses	Viruses	420	5.86e-113	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g16845	i0	94.796	1	269	14	100	0	1	269	4659	4391	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	269	420	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
8004513	8004513	PRJNA1245487_P_NODE_8207_length_427_cov_1.488701_g7869_i0	PRJNA1245487	8207	427	1.488701	6.35675327	Solenopsis invicta virus 8	2547311	Viruses	Viruses	468	3.45e-127	NTclustered	gi\|2213881427\|gb\|MH727525.2\|	2547311	g7869	i0	86.698	0.985948477751756	421	56	99	0	6	426	4418	3998	Solenopsis invicta virus 8 isolate Formosa, complete genome	blastn	421	468	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
27831637	27831637	PRJNA1245487_P_NODE_10344_length_370_cov_1.050505_g10006_i0	PRJNA1245487	10344	370	1.050505	3.8868685	Solenopsis invicta virus 8	2547311	Viruses	Viruses	254	8.099999999999998e-82	NR	QBL75895.1	2547311	g10006	i0	95.9	0.997297297297297	123	5	99.7	0	1	369	69	191	QBL75895.1 putative capsid protein [Solenopsis invicta virus 8]	diamond	369	254	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Solenopsis invicta virus 8
32445024	32445024	PRJNA1245487_P_NODE_20719_length_247_cov_0.896552_g20381_i0	PRJNA1245487	20719	247	0.896552	2.21448344	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	139	4.41e-36	NR	DBA56413.1	3032225	g20381	i0	89	0.995951417004049	82	9	99.6	0	246	1	577	658	DBA56413.1 TPA_asm: hypothetical protein, partial [Periplaneta americana dicistro-like virus]	diamond	246	139	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus

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