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

5 rows where bioproject = "PRJNA812715" and tax_phylum = "Duplornaviricota"

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
23767089	23767089	PRJNA812715_P_NODE_84959_length_276_cov_2.502463_g83158_i0	PRJNA812715	84959	276	2.502463	6.90679788	Henan cystovirus 3	2824305	Viruses	Viruses	361	3.7099999999999996e-95	NTclustered	gi\|2075443683\|gb\|MW897002.1\|	2824305	g83158	i0	90.217	1	276	27	100	0	1	276	583	308	MAG: Henan cystovirus 3 isolate 265-k141_5132 hypothetical protein 1, putative RNA-dependent RNA polymerase, and hypothetical protein 2 genes, complete cds; and hypothetical protein 3 gene, partial cds	blastn	276	361	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Cystovirus	Henan cystovirus 3
27370697	27370697	PRJNA812715_P_NODE_100783_length_252_cov_1.435754_g98982_i0	PRJNA812715	100783	252	1.435754	3.61810008	Pseudomonas phage phiYY	1852644	Viruses	Viruses	57.4	4.79e-8	NR	YP_009618396.1	1852644	g98982	i0	44.3	0.94047619047619	79	42	91.7	1	241	11	61	139	YP_009618396.1 nucleocapsid shell protein [Pseudomonas phage phiYY]	diamond	237	57.4	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Gammacystovirus	Gammacystovirus phiYY
29643398	29643398	PRJNA812715_P_NODE_47750_length_394_cov_4.467290_g45953_i0	PRJNA812715	47750	394	4.46729	17.6011226	Henan cystovirus 3	2824305	Viruses	Viruses	289	6.18e-92	NR	QYF49797.1	2824305	g45953	i0	99.2	0.99746192893401	131	1	99.7	0	2	394	344	474	QYF49797.1 MAG: putative RNA-dependent RNA polymerase [Henan cystovirus 3]	diamond	393	289	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Cystovirus	Henan cystovirus 3
29801517	29801517	PRJNA812715_P_NODE_75731_length_291_cov_2.825688_g73931_i0	PRJNA812715	75731	291	2.825688	8.22275208	Pseudomonas phage phiYY	1852644	Viruses	Viruses	122	3.78e-32	NR	YP_009618392.1	1852644	g73931	i0	65.5	1.79381443298969	87	30	89.7	0	5	265	144	230	YP_009618392.1 putative muramidase [Pseudomonas phage phiYY]	diamond	522	122	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Gammacystovirus	Gammacystovirus phiYY
32709479	32709479	PRJNA812715_P_NODE_81860_length_281_cov_1.913462_g80060_i0	PRJNA812715	81860	281	1.913462	5.37682822	Pseudomonas phage phi13	134554	Viruses	Viruses	75.1	1.08e-14	NR	NP_690807.1	134554	g80060	i0	54.7	0.800711743772242	75	30	75.8	1	225	13	3	77	NP_690807.1 P8 nucleocapsid shell protein [Pseudomonas phage phi13]	diamond	225	75.1	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Gammacystovirus	Gammacystovirus phi13

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