metadata: contig_metadata: 5 rows where bioproject = "PRJNA1118794", tax_kingdom = "Pararnavirae" and tax

5 rows where bioproject = "PRJNA1118794", tax_kingdom = "Pararnavirae" 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
10434559	10434559	PRJNA1118794_P_NODE_70989_length_242_cov_0.911243_g70239_i0	PRJNA1118794	70989	242	0.911243	2.20520806	Lentivirus humimdef1	3418650	Viruses	Viruses	52.8	0.022	NTclustered	gi\|1811096122\|gb\|MN616644.1\|	11676	g70239	i0	100	0.115702479338843	28	0	12	0	172	199	375	348	HIV-1 isolate NU4P_052715G10 pol protein (pol) and gag protein (gag) genes, partial cds	blastn	28	52.8	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Lentivirus	Lentivirus humimdef1
14259707	14259707	PRJNA1118794_P_NODE_40372_length_268_cov_1.374359_g39622_i0	PRJNA1118794	40372	268	1.374359	3.68328212	Alpharetrovirus avileu	3426267	Viruses	Viruses	481	2.64e-131	NTclustered	gi\|1778014156\|gb\|MK951780.1\|	11864	g39622	i0	98.889	100.75	270	1	100	1	1	268	1615	1346	Avian leukosis virus isolate S0322C, complete genome	blastn	27001	481	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
19356648	19356648	PRJNA1118794_P_NODE_43496_length_261_cov_1.611702_g42746_i0	PRJNA1118794	43496	261	1.611702	4.20654222	Alpharetrovirus avileu	3426267	Viruses	Viruses	431	2.62e-116	NTclustered	gi\|1851142711\|gb\|MN735307.1\|	11864	g42746	i0	97.244	97.3218390804598	254	7	97	0	1	254	2861	3114	Avian leukosis virus isolate SH18JY02, complete genome	blastn	25401	431	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Alpharetrovirus	Alpharetrovirus avileu
27415956	27415956	PRJNA1118794_P_NODE_27823_length_301_cov_1.350877_g27073_i0	PRJNA1118794	27823	301	1.350877	4.06613977	Banana streak MY virus	1476909	Viruses	Viruses	47	0.00252	NR	QVG60622.1	1476909	g27073	i0	31	0.578073089700997	58	38	57.8	1	180	7	853	908	QVG60622.1 ORFIII polyprotein [Banana streak MY virus]	diamond	174	47	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Badnavirus	Badnavirus gammavirgamusae
27952515	27952515	PRJNA1118794_P_NODE_31285_length_289_cov_1.134259_g30535_i0	PRJNA1118794	31285	289	1.134259	3.27800851	Bovine leukemia virus	11901	Viruses	Viruses	44.3	0.019	NR	BDY33775.1	11901	g30535	i0	66.7	0.249134948096886	24	8	24.9	0	72	1	343	366	BDY33775.1 gag-pro-pol polyprotein [Bovine leukemia virus]	diamond	72	44.3	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Deltaretrovirus	Deltaretrovirus bovleu

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