metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
1999312	1999312	PRJNA744060_P_NODE_31742_length_291_cov_2.527523_g31413_i0	PRJNA744060	31742	291	2.527523	7.35509193	Ripathuj virus	3131458	Viruses	Viruses	396	1.08e-105	NTclustered	gi\|2717322573\|gb\|PP173760.1\|	3131458	g31413	i0	91.409	166.951890034364	291	21	99	4	3	291	60	348	MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence	blastn	48583	396	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripathuj virus
4551840	4551840	PRJNA744060_P_NODE_32884_length_287_cov_1.219626_g32555_i0	PRJNA744060	32884	287	1.219626	3.50032662	Euphorbia ebracteolata waikavirus	3115786	Viruses	Viruses	52.8	0.027	NTclustered	gi\|2752247976\|tpg\|BK065142.1\|	3115786	g32555	i0	100	0.0975609756097561	28	0	10	0	247	274	8042	8015	TPA_asm: Euphorbia ebracteolata waikavirus polyprotein (ORF1) and hypothetical protein (ORFX) genes, complete cds	blastn	28	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Waikavirus	Euphorbia ebracteolata waikavirus
8377056	8377056	PRJNA744060_P_NODE_7_length_4525_cov_17.478661_g4_i0	PRJNA744060	7	4525	17.478661	790.90941025	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	1905	0	NTclustered	gi\|2512878147\|emb\|OX637976.1\|	3048756	g4	i0	81.641	0.964861878453039	2304	415	51	8	2174	4473	1	2300	Malassezia globosa associated totivirus 1 RdRp gene for RNA-dependent RNA polymerase	blastn	4366	1905	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
14751808	14751808	PRJNA744060_P_NODE_11652_length_469_cov_3.138889_g11324_i0	PRJNA744060	11652	469	3.138889	14.72138941	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	534	3.71e-147	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g11324	i0	87.234	1.00213219616205	470	58	100	2	1	469	3971	4439	Malassezia restricta virus MrV40L, complete genome	blastn	470	534	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
14751819	14751819	PRJNA744060_P_NODE_1212_length_1275_cov_32.251248_g1063_i0	PRJNA744060	1212	1275	32.251248	411.203412	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	333	4.16e-86	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g1063	i0	73.741	0.794509803921569	1013	197	77	57	113	1090	109	1087	Malassezia restricta virus MrV40S, complete genome	blastn	1013	333	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S
17301581	17301581	PRJNA744060_P_NODE_4194_length_766_cov_4.163059_g3906_i0	PRJNA744060	4194	766	4.163059	31.88903194	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	893	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g3906	i0	87.811	0.996083550913838	763	91	99	2	1	762	3191	3952	Malassezia restricta virus MrV40L, complete genome	blastn	763	893	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
22401186	22401186	PRJNA744060_P_NODE_78_length_2715_cov_8.898940_g55_i0	PRJNA744060	78	2715	8.89894	241.606221	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	2675	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g55	i0	84.604	1	2715	392	99	20	12	2713	2716	15	Malassezia restricta virus MrV40L, complete genome	blastn	2715	2675	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
24949419	24949419	PRJNA744060_P_NODE_1300_length_1237_cov_33.687285_g1063_i1	PRJNA744060	1300	1237	33.687285	416.71171545	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	255	8.97e-63	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g1063	i1	73.064	0.720291026677445	891	175	69	53	113	970	109	967	Malassezia restricta virus MrV40S, complete genome	blastn	891	255	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S

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