metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA724039" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA724039" and tax_kingdom = "Orthornavirae"

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_species
5814811	5814811	PRJNA724039_S_NODE_5465_length_297_cov_6.730769_g5258_i0	PRJNA724039	5465	297	6.730769	19.99038393	Ripaflec virus	3130560	Viruses	Viruses	364	3.119999999999999e-96	NTclustered	gi\|2717320098\|gb\|PP172862.1\|	3130560	g5258	i0	89.037	165.037037037037	301	24	100	8	1	297	5529	5234	MAG: Ripaflec virus isolate KCAP2_k141_128097 genomic sequence	blastn	49016	364	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Ripaflec virus
8364541	8364541	PRJNA724039_S_NODE_5927_length_283_cov_1.825203_g5720_i0	PRJNA724039	5927	283	1.825203	5.16532449	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	191	5.3e-44	NTclustered	gi\|1698236883\|gb\|MN034603.1\|	3003959	g5720	i0	83.744	19.5017667844523	203	31	71	2	7	208	10506	10305	MAG: Picornavirales sp. isolate H1_Bulk_Litter_5_scaffold_57 RNA-dependent RNA polymerase (H1BulkLitter557_000001) gene, complete cds; and hypothetical protein (H1BulkLitter557_000002) gene, partial cds	blastn	5519	191	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales		Fish-associated picorna-like virus 3
14740168	14740168	PRJNA724039_S_NODE_15032_length_164_cov_7.370079_g14825_i0	PRJNA724039	15032	164	7.370079	12.08692956	Sopidub virus	3131684	Viruses	Viruses	135	1.32e-27	NTclustered	gi\|2717323145\|gb\|PP173985.1\|	3131684	g14825	i0	89.091	6.54878048780488	110	11	66	1	53	161	2140	2249	MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence	blastn	1074	135	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Sopidub virus
22388432	22388432	PRJNA724039_S_NODE_10018_length_205_cov_6.309524_g9811_i0	PRJNA724039	10018	205	6.309524	12.9345242	Ripaglys virus	3130696	Viruses	Viruses	150	6.17e-32	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g9811	i0	80.583	73.7268292682927	206	30	99	7	2	203	1653	1852	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	15114	150	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Ripaglys virus
23664260	23664260	PRJNA724039_S_NODE_5339_length_301_cov_3.715909_g5132_i0	PRJNA724039	5339	301	3.715909	11.18488609	Ripaglys virus	3130696	Viruses	Viruses	285	2.54e-72	NTclustered	gi\|2717320496\|gb\|PP172998.1\|	3130696	g5132	i0	84.158	512.016611295681	303	39	99	6	3	301	1010	1307	MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence	blastn	154117	285	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes			Ripaglys 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);;