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

5 rows where bioproject = "PRJNA543299" and tax_kingdom = "Shotokuvirae"

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
1784945	1784945	PRJNA543299_P_NODE_15642_length_190_cov_0.957447_g15485_i0	PRJNA543299	15642	190	0.957447	1.8191493	Cressdnaviricota sp.	2748378	Viruses	Viruses	68.2	3.42e-12	NR	XNT20742.1	2748378	g15485	i0	65.4	0.821052631578947	52	17	80.5	1	153	1	76	127	XNT20742.1 MAG: Rep protein [Cressdnaviricota sp.]	diamond	156	68.2	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.
6222259	6222259	PRJNA543299_P_NODE_24205_length_163_cov_0.894737_g24048_i0	PRJNA543299	24205	163	0.894737	1.45842131	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	257	2.68e-64	NTclustered	gi\|530787446\|ref\|NC_022089.1\|	3003968	g24048	i0	95.122	14.3251533742331	164	6	100	2	1	163	3180	3342	Parvovirus NIH-CQV putative 15-kDa protein, putative replication associated protein (rep), and putative capsid protein (cap) genes, complete cds	blastn	2335	257	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
9437760	9437760	PRJNA543299_P_NODE_14668_length_196_cov_1.040816_g14511_i0	PRJNA543299	14668	196	1.040816	2.03999936	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	289	1.1899999999999998e-73	NTclustered	gi\|541138038\|gb\|KF214644.1\|	3003968	g14511	i0	93.367	15.3979591836735	196	12	100	1	1	196	738	544	Parvo-like hybrid virus UC5, partial genome	blastn	3018	289	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
26871621	26871621	PRJNA543299_P_NODE_25301_length_162_cov_0.902655_g25144_i0	PRJNA543299	25301	162	0.902655	1.4623011	Galvornvirus	2948715	Viruses	Viruses	96.7	4.2e-24	NR	XOE96529.1	1954248	g25144	i0	74.1	8.87037037037037	54	14	100	0	1	162	2	55	XOE96529.1 MAG: hypothetical protein [Circoviridae sp.]	diamond	1437	96.7	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Rohanvirales	Nenyaviridae	Galvornvirus	Galvornvirus isengard
28720163	28720163	PRJNA543299_P_NODE_25087_length_162_cov_0.902655_g24930_i0	PRJNA543299	25087	162	0.902655	1.4623011	Cressdnaviricota sp.	2748378	Viruses	Viruses	78.2	1.43e-15	NR	WAE42678.1	2748378	g24930	i0	62.3	0.981481481481482	53	20	98.1	0	160	2	176	228	WAE42678.1 MAG: capsid protein [Cressdnaviricota sp.]	diamond	159	78.2	1	Viruses	Shotokuvirae	Cressdnaviricota					Cressdnaviricota sp.

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