metadata: contig_metadata: 10 rows where bioproject = "PRJDB9741" and tax

10 rows where bioproject = "PRJDB9741" 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_genus	tax_species
2560695	2560695	PRJDB9741_P_NODE_16743_length_183_cov_2.619403_g16426_i0	PRJDB9741	16743	183	2.619403	4.79350749	Skokie dicistro-like virus	2789443	Viruses	Viruses	316	5.009999999999999e-82	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g16426	i0	97.814	1.98907103825137	183	4	100	0	1	183	4366	4548	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	364	316	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
11488871	11488871	PRJDB9741_P_NODE_2570_length_457_cov_1.186275_g2256_i0	PRJDB9741	2570	457	1.186275	5.42127675	Skokie dicistro-like virus	2789443	Viruses	Viruses	828	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g2256	i0	99.344	1.99124726477024	457	3	100	0	1	457	4656	5112	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	910	828	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
11489034	11489034	PRJDB9741_P_NODE_7530_length_229_cov_1.133333_g7213_i0	PRJDB9741	7530	229	1.133333	2.59533257	Sopamon virus	3131721	Viruses	Viruses	246	8.73e-61	NTclustered	gi\|2717323235\|gb\|PP174022.1\|	3131721	g7213	i0	86.667	233.161572052402	225	26	97	4	7	229	420	198	MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence	blastn	53394	246	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopamon virus
12461106	12461106	PRJDB9741_P_NODE_9710_length_210_cov_2.354037_g9393_i0	PRJDB9741	9710	210	2.354037	4.9434777	Viruses	10239	Viruses	Viruses	158	3.8e-34	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g9393	i0	96.809	4.06190476190476	94	3	92	0	111	204	1931	1838	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	853	158	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
14039125	14039125	PRJDB9741_P_NODE_5312_length_274_cov_1.395556_g4996_i0	PRJDB9741	5312	274	1.395556	3.82382344	Skokie dicistro-like virus	2789443	Viruses	Viruses	479	9.74e-131	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g4996	i0	98.175	2	274	5	100	0	1	274	4313	4040	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	548	479	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
21687510	21687510	PRJDB9741_P_NODE_28538_length_167_cov_0.864407_g28221_i0	PRJDB9741	28538	167	0.864407	1.44355969	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	303	3.5e-78	NTclustered	gi\|2754692226\|gb\|PP872826.1\|	3003959	g28221	i0	100	0.982035928143713	164	0	98	0	4	167	3947	3784	MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence	blastn	164	303	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
21687631	21687631	PRJDB9741_P_NODE_42618_length_154_cov_2.342857_g42301_i0	PRJDB9741	42618	154	2.342857	3.60799978	Norway luteo-like virus 4	2034334	Viruses	Viruses	279	5.33e-71	NTclustered	gi\|1240393781\|gb\|MF141070.1\|	2034334	g42301	i0	99.351	2	154	1	100	0	1	154	1212	1365	Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds	blastn	308	279	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Norway luteo-like virus 4
22962701	22962701	PRJDB9741_P_NODE_11239_length_199_cov_1.906667_g10922_i0	PRJDB9741	11239	199	1.906667	3.79426733	Tolivirales sp.	2809914	Viruses	Viruses	324	3.31e-84	NTclustered	gi\|2647549457\|gb\|OR843652.1\|	2809914	g10922	i0	95.98	1.22110552763819	199	8	100	0	1	199	1892	2090	Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds	blastn	243	324	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp.
28043296	28043296	PRJDB9741_P_NODE_6985_length_237_cov_1.994681_g6668_i0	PRJDB9741	6985	237	1.994681	4.72739397	ssRNA phage Gerhypos.1_36	2786219	Viruses	Viruses	51.6	4.6e-6	NR	YP_010770575.1	2786219	g6668	i0	43.9	1.67088607594937	66	36	83.5	1	13	210	1	65	YP_010770575.1 coat protein [ssRNA phage Gerhypos.1_36]	diamond	396	51.6	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae	Hodnevirus	Hodnevirus neopedovicinum
28864119	28864119	PRJDB9741_P_NODE_1168_length_786_cov_1.875170_g909_i0	PRJDB9741	1168	786	1.87517	14.7388362	ssRNA phage SRR5467	2844986	Viruses	Viruses	69.3	2.27e-9	NR	YP_010770771.1	2786460	g909	i0	28.1	1.1412213740458	299	165	98.5	10	6	779	89	378	YP_010770771.1 maturation protein [ssRNA phage SRR5467091_10]	diamond	897	69.3	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Timlovirales	Steitzviridae	Huylevirus	Huylevirus limihabitans

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