metadata: contig_metadata: 5 rows where bioproject = "PRJNA283169", tax_kingdom = "Shotokuvirae" and tax

5 rows where bioproject = "PRJNA283169", tax_kingdom = "Shotokuvirae" and tax_phylum = "Cressdnaviricota"

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
1646620	1646620	PRJNA283169_S_NODE_1562_length_220_cov_0.140351_g1548_i0	PRJNA283169	1562	220	0.140351	0.3087722	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	187	5.12e-43	NTclustered	gi\|2015373061\|gb\|MW046496.1\|	3003968	g1548	i0	82.569	1.96818181818182	218	32	98	6	1	215	877	663	MAG: Grus japonensis parvo-like hybrid virus isolate cra70par052 genomic sequence, sequence	blastn	433	187	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
5475231	5475231	PRJNA283169_S_NODE_2065_length_197_cov_0.108108_g2051_i0	PRJNA283169	2065	197	0.108108	0.21297276	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	239	1.22e-58	NTclustered	gi\|2015373061\|gb\|MW046496.1\|	3003968	g2051	i0	92.262	1.61928934010152	168	13	85	0	2	169	450	617	MAG: Grus japonensis parvo-like hybrid virus isolate cra70par052 genomic sequence, sequence	blastn	319	239	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
28148125	28148125	PRJNA283169_P_NODE_7085_length_166_cov_0.871795_g7022_i0	PRJNA283169	7085	166	0.871795	1.4471797	Genomoviridae sp.	2202565	Viruses	Viruses	65.5	9.08e-11	NR	QJB18634.1	2202565	g7022	i0	59.6	0.849397590361446	47	18	84.9	1	3	143	230	275	QJB18634.1 MAG: replication-associated protein [Genomoviridae sp.]	diamond	141	65.5	1	Viruses	Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Genomoviridae		Genomoviridae sp.
29442249	29442249	PRJNA283169_P_NODE_7450_length_164_cov_1.330435_g7387_i0	PRJNA283169	7450	164	1.330435	2.1819134	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	115	3.74e-29	NR	QTE03928.1	3003968	g7387	i0	92.6	0.98780487804878	54	4	98.8	0	162	1	91	144	QTE03928.1 MAG: replication protein [Grus japonensis parvo-like hybrid virus]	diamond	162	115	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Lineavirales	Oomyviridae	Nicoomyvirus	Fish-associated parvo-like hybrid virus
31464822	31464822	PRJNA283169_P_NODE_5896_length_176_cov_1.598425_g5833_i0	PRJNA283169	5896	176	1.598425	2.813228	Skomarfal virus 49	3063507	Viruses	Viruses	97.8	8.159999999999999e-23	NR	WPR18784.1	3063507	g5833	i0	77.6	1.97727272727273	58	13	98.9	0	2	175	26	83	WPR18784.1 MAG: hypothetical protein [Skomarfal virus 49]	diamond	348	97.8	1	Viruses	Shotokuvirae	Cressdnaviricota					Skomarfal virus 49

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