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

5 rows where bioproject = "PRJNA352850" 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
2347175	2347175	PRJNA352850_P_NODE_8222_length_1269_cov_1.872951_g6124_i0	PRJNA352850	8222	1269	1.872951	23.76774819	root	1	Root_unresolved	Root_unresolved	1991	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g6124	i0	95.032	87.9259259259259	1268	54	99	6	1	1259	2322	1055	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	111578	2004	0.993512974051896	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
3622052	3622052	PRJNA352850_P_NODE_51123_length_336_cov_1.700348_g48290_i0	PRJNA352850	51123	336	1.700348	5.71316928	root	1	Root_unresolved	Root_unresolved	616	8.96e-172	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g48290	i0	99.702	68.7827380952381	336	1	100	0	1	336	6675	6340	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	23111	616	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
6173874	6173874	PRJNA352850_P_NODE_23525_length_579_cov_1.356604_g20715_i0	PRJNA352850	23525	579	1.356604	7.85473716	root	1	Root_unresolved	Root_unresolved	1048	0	NTclustered	gi\|57547621\|tpd\|BR000030.1\|	10654	g20715	i0	99.309	116.851468048359	579	4	100	0	1	579	5364	5942	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-B	blastn	67657	1048	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
16373703	16373703	PRJNA352850_P_NODE_37393_length_419_cov_1.391892_g34561_i0	PRJNA352850	37393	419	1.391892	5.83202748	root	1	Root_unresolved	Root_unresolved	765	0	NTclustered	gi\|57547625\|tpd\|BR000031.1\|	10654	g34561	i0	99.523	100.701670644391	419	2	100	0	1	419	4100	3682	TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C	blastn	42194	765	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Tungrovirus	Tungrovirus oryzae
18248034	18248034	PRJNA352850_P_NODE_6555_length_1503_cov_2.174691_g4687_i0	PRJNA352850	6555	1503	2.174691	32.68560573	Gammaretrovirus murleu	3428959	Viruses	Viruses	2726	0	NTclustered	gi\|336462523\|gb\|JF908817.1\|	11837	g4687	i0	99.401	104.091151031271	1503	9	100	0	1	1503	6460	7962	Xenotropic murine leukemia virus isolate EKVX, partial genome	blastn	156449	2726	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);;