metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_kingdom = "Pararnavirae"

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
27674071	27674071	PRJNA1249042_S_NODE_104204_length_158_cov_2.286957_g103990_i0	PRJNA1249042	104204	158	2.286957	3.61339206	Gammaretrovirus murleu	3428959	Viruses	Viruses	109	2.49e-26	NR	8WUS_E	11801	g103990	i0	98.1	0.987341772151899	52	1	98.7	0	3	158	280	331	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	156	109	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
28684428	28684428	PRJNA1249042_S_NODE_38127_length_227_cov_1.788043_g37913_i0	PRJNA1249042	38127	227	1.788043	4.05885761	Feline endogenous virus ECE1	11766	Viruses	Viruses	65.9	2.17e-10	NR	P31792.1	11766	g37913	i0	44.7	2.00881057268722	76	37	93.8	1	4	216	205	280	P31792.1 RecName: Full=Pol polyprotein; Contains: RecName: Full=Reverse transcriptase/ribonuclease H; Short=RT; Contains: RecName: Full=Integrase; Short=IN [Feline endogenous virus ECE1]	diamond	456	65.9	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Feline endogenous virus
31116060	31116060	PRJNA1249042_S_NODE_5295_length_380_cov_7.913947_g5081_i0	PRJNA1249042	5295	380	7.913947	30.0729986	Gammaretrovirus murleu	3428959	Viruses	Viruses	262	2.45e-83	NR	8WUS_E	11801	g5081	i0	100	8.81052631578947	124	0	97.9	0	3	374	141	264	8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus]	diamond	3348	262	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
31577175	31577175	PRJNA1249042_S_NODE_3596_length_466_cov_3.713948_g3385_i0	PRJNA1249042	3596	466	3.713948	17.30699768	Gammaretrovirus	153135	Viruses	Viruses	295	2.41e-89	NR	NP_057933.2	11801	g3385	i0	98.1	1.98283261802575	154	3	99.1	0	464	3	1174	1327	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	924	295	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu

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