metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_clade = "unclassified ssRNA positive-strand viruses"

6 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_clade = "unclassified ssRNA positive-strand 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_clade	tax_species
27873900	27873900	PRJNA743294_P_NODE_58885_length_230_cov_3.191083_g58429_i0	PRJNA743294	58885	230	3.191083	7.3394909	Halastavi arva RNA virus	1088890	Viruses	Viruses	74.7	1.72e-13	NR	YP_004935382.1	1088890	g58429	i0	48.7	0.991304347826087	76	39	99.1	0	3	230	912	987	YP_004935382.1 unnamed protein product [Halastavi arva RNA virus]	diamond	228	74.7	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA virus
29736496	29736496	PRJNA743294_P_NODE_16210_length_400_cov_1.354740_g15754_i0	PRJNA743294	16210	400	1.35474	5.41896	Halastavi arva RNA virus	1088890	Viruses	Viruses	107	3.81e-24	NR	YP_004935382.1	1088890	g15754	i0	43.2	1.0425	139	72	99.8	2	399	1	164	301	YP_004935382.1 unnamed protein product [Halastavi arva RNA virus]	diamond	417	107	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA virus
29989464	29989464	PRJNA743294_P_NODE_32891_length_292_cov_1.324201_g32435_i0	PRJNA743294	32891	292	1.324201	3.86666692	Halastavi arva RNA virus	1088890	Viruses	Viruses	180	2.69e-50	NR	YP_004935382.1	1088890	g32435	i0	84.4	0.986301369863014	96	15	98.6	0	3	290	471	566	YP_004935382.1 unnamed protein product [Halastavi arva RNA virus]	diamond	288	180	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA virus
31158085	31158085	PRJNA743294_P_NODE_23755_length_337_cov_1.109848_g23299_i0	PRJNA743294	23755	337	1.109848	3.74018776	Halastavi arva RNA virus	1088890	Viruses	Viruses	182	8.64e-51	NR	YP_004935381.1	1088890	g23299	i0	75.7	0.98813056379822	111	27	98.8	0	3	335	1658	1768	YP_004935381.1 unnamed protein product [Halastavi arva RNA virus]	diamond	333	182	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA virus
32012516	32012516	PRJNA743294_P_NODE_50518_length_248_cov_1.302857_g50062_i0	PRJNA743294	50518	248	1.302857	3.23108536	Halastavi arva RNA virus	1088890	Viruses	Viruses	97.8	1.7e-21	NR	YP_004935381.1	1088890	g50062	i0	57	1.91129032258065	79	34	95.6	0	5	241	1506	1584	YP_004935381.1 unnamed protein product [Halastavi arva RNA virus]	diamond	474	97.8	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA virus
32075744	32075744	PRJNA743294_P_NODE_47338_length_252_cov_0.871508_g46882_i0	PRJNA743294	47338	252	0.871508	2.19620016	Halastavi arva RNA virus	1088890	Viruses	Viruses	156	3.92e-42	NR	YP_004935381.1	1088890	g46882	i0	91.6	0.988095238095238	83	7	98.8	0	2	250	1196	1278	YP_004935381.1 unnamed protein product [Halastavi arva RNA virus]	diamond	249	156	1	Viruses	unclassified ssRNA positive-strand viruses	Halastavi arva RNA 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);;