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

5 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax_superkingdom = "Viruses"

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
14240540	14240540	PRJNA1102048_P_NODE_7852_length_310_cov_1.632911_g7748_i0	PRJNA1102048	7852	310	1.632911	5.0620241	Hokovirus HKV1	1977638	Viruses	Viruses	261	4.42e-65	NTclustered	gi\|1174571674\|gb\|KY684104.1\|	1977638	g7748	i0	83.333	57.8387096774194	282	47	91	0	1	282	163173	163454	Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence	blastn	17930	261	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
18063444	18063444	PRJNA1102048_P_NODE_16335_length_244_cov_0.900585_g16231_i0	PRJNA1102048	16335	244	0.900585	2.1974274	Ripothoz virus	3131336	Viruses	Viruses	191	4.47e-44	NTclustered	gi\|2717322249\|gb\|PP173638.1\|	3131336	g16231	i0	81.452	39.8073770491803	248	32	99	11	2	244	5383	5621	MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence	blastn	9713	191	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Ripothoz virus
20146383	20146383	PRJNA1102048_P_NODE_4496_length_402_cov_3.294833_g4392_i0	PRJNA1102048	4496	402	3.294833	13.24522866	Prasinovirus	181084	Viruses	Viruses	87.9	1.06e-12	NTclustered	gi\|2853279488\|gb\|PQ442268.1\|	3378364	g4392	i0	100	2.25373134328358	47	0	12	0	314	360	128794	128840	Ostreococcus tauri virus 09-565, partial genome	blastn	906	87.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus tauri virus 09-565
21888491	21888491	PRJNA1102048_P_NODE_11118_length_266_cov_1.352332_g11014_i0	PRJNA1102048	11118	266	1.352332	3.59720312	Marine virus AFVG_25M84	2694782	Viruses	Viruses	259	1.34e-64	NTclustered	gi\|1789809213\|gb\|MN693569.1\|	2694782	g11014	i0	84.586	2.45112781954887	266	36	99	5	1	264	26023	25761	MAG: Marine virus AFVG_25M84, complete genome	blastn	652	259	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Marine virus AFVG_25M84
23164006	23164006	PRJNA1102048_P_NODE_14159_length_248_cov_0.880000_g14055_i0	PRJNA1102048	14159	248	0.88	2.1824	uncultured virus	340016	Viruses	Viruses	182	2.74e-41	NTclustered	gi\|2347411005\|gb\|OP589531.1\|	340016	g14055	i0	81.735	0.883064516129032	219	39	88	1	11	229	20233	20016	MAG: Uncultured virus isolate r_vMAG_35_vRhyme_326 clone vRhyme_326_GMC6_367 genomic sequence	blastn	219	182	1	Viruses							uncultured 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);;