metadata: contig_metadata: 5 rows where bioproject = "PRJNA680334", tax_phylum = "Duplornaviricota" and tax

5 rows where bioproject = "PRJNA680334", tax_phylum = "Duplornaviricota" 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
3200761	3200761	PRJNA680334_S_NODE_50563_length_191_cov_3.436709_g50077_i0	PRJNA680334	50563	191	3.436709	6.56411419	Totiviridae sp.	1955172	Viruses	Viruses	316	5.28e-82	NTclustered	gi\|2396039066\|gb\|ON812734.1\|	1955172	g50077	i0	96.825	2.98952879581152	189	6	99	0	3	191	2289	2477	MAG: Totiviridae sp. isolate TIGMIC_6 genomic sequence	blastn	571	316	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
8302744	8302744	PRJNA680334_S_NODE_23747_length_241_cov_4.908654_g23261_i0	PRJNA680334	23747	241	4.908654	11.82985614	Skokie reo-like virus	2789444	Viruses	Viruses	126	1.26e-24	NTclustered	gi\|1933757587\|gb\|MW177748.1\|	2789444	g23261	i0	92.135	0.369294605809129	89	7	37	0	153	241	1	89	Skokie reo-like virus strain USAdf hypothetical protein 2 gene, complete cds	blastn	89	126	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Skokie reo-like virus
17228102	17228102	PRJNA680334_S_NODE_59874_length_181_cov_3.290541_g59388_i0	PRJNA680334	59874	181	3.290541	5.95587921	Alphachrysovirus perseae	2955248	Viruses	Viruses	313	6.39e-81	NTclustered	gi\|1694999067\|ref\|NC_043508.1\|	1587509	g59388	i0	98.857	0.966850828729282	175	2	97	0	1	175	1848	1674	Persea americana chrysovirus segment RNA2, complete sequence	blastn	175	313	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus perseae
17228690	17228690	PRJNA680334_S_NODE_94914_length_156_cov_2.723577_g94428_i0	PRJNA680334	94914	156	2.723577	4.24878012	Coltivirus dermacentoris	3428066	Viruses	Viruses	209	7.2e-50	NTclustered	gi\|2758887253\|gb\|PP473574.1\|	46839	g94428	i0	90.968	4.75	155	14	99	0	2	156	4697	4543	MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence	blastn	741	209	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Spinareoviridae	Coltivirus	Coltivirus dermacentoris
27966282	27966282	PRJNA680334_S_NODE_22045_length_247_cov_2.883178_g21559_i0	PRJNA680334	22045	247	2.883178	7.12144966	Skokie reo-like virus	2789444	Viruses	Viruses	65.1	5.35e-10	NR	QPF16728.1	2789444	g21559	i0	40.5	0.898785425101215	74	42	89.9	1	26	247	686	757	QPF16728.1 hypothetical protein 2 [Skokie reo-like virus]	diamond	222	65.1	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Skokie reo-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);;