metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA891846" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA891846" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28287102	28287102	PRJNA891846_P_NODE_10246_length_466_cov_1.664122_g10029_i0	PRJNA891846	10246	466	1.664122	7.75480852	Marnaviridae sp.	2715102	Viruses	Viruses	286	4.31e-86	NR	ULG00027.1	2715102	g10029	i0	83.9	0.997854077253219	155	25	99.8	0	465	1	1114	1268	ULG00027.1 MAG: hypothetical protein 1 [Marnaviridae sp.]	diamond	465	286	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
29557912	29557912	PRJNA891846_P_NODE_5330_length_628_cov_2.001802_g5120_i0	PRJNA891846	5330	628	2.001802	12.57131656	Picornavirales	464095	Viruses	Viruses	406	1.11e-140	NR	URG14683.1	1530251	g5120	i0	94.2	1.98726114649682	208	12	99.4	0	626	3	119	326	URG14683.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.]	diamond	1248	406	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Picornaviridae sp.
29897721	29897721	PRJNA891846_P_NODE_11_length_5453_cov_7.552788_g7_i0	PRJNA891846	11	5453	7.552788	411.85352964	Kelp fly virus	340921	Viruses	Viruses	160	6.91e-35	NR	YP_415507.1	340921	g7	i0	28.4	0.234366403814414	426	277	23.1	12	305	1561	2909	3313	YP_415507.1 polyprotein [Kelp fly virus]	diamond	1278	160	1	Viruses	unclassified ssRNA positive-strand viruses							Kelp fly virus
30348243	30348243	PRJNA891846_P_NODE_42612_length_245_cov_1.790698_g42392_i0	PRJNA891846	42612	245	1.790698	4.3872101	Prunevirus	1914295	Viruses	Viruses	164	7.24e-45	NR	YP_010799543.1	2606569	g42392	i0	91.4	2.97551020408163	81	7	99.2	0	245	3	1710	1790	YP_010799543.1 replicase [Camellia ringspot associated virus 1]	diamond	729	165	0.993939393939394	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Prunevirus	Prunevirus unicamelliae
30371948	30371948	PRJNA891846_P_NODE_2072_length_957_cov_3.574661_g1925_i0	PRJNA891846	2072	957	3.574661	34.20950577	Riboviria sp.	2585031	Viruses	Viruses	55.8	1.91e-4	NR	QKN89011.1	2585031	g1925	i0	29.6	0.529780564263323	169	97	46.1	6	411	851	981	1149	QKN89011.1 MAG: hypothetical protein, partial [Riboviria sp.]	diamond	507	55.8	1	Viruses								Riboviria sp.
30718999	30718999	PRJNA891846_P_NODE_3814_length_734_cov_2.273828_g3621_i0	PRJNA891846	3814	734	2.273828	16.68989752	Marnaviridae sp.	2715102	Viruses	Viruses	479	2.999999999999999e-154	NR	ULG00027.1	2715102	g3621	i0	95.1	0.997275204359673	244	12	99.7	0	734	3	362	605	ULG00027.1 MAG: hypothetical protein 1 [Marnaviridae sp.]	diamond	732	479	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.
31667366	31667366	PRJNA891846_P_NODE_5457_length_622_cov_1.360656_g5247_i0	PRJNA891846	5457	622	1.360656	8.46328032	Camellia japonica associated betaflexivirus 1	2686011	Viruses	Viruses	317	5.049999999999999e-104	NR	QGY72523.1	2686011	g5247	i0	98.2	0.795819935691318	165	3	79.6	0	127	621	1	165	QGY72523.1 movement protein [Camellia japonica associated betaflexivirus 1]	diamond	495	317	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae		Camellia japonica associated betaflexivirus 1
31675115	31675115	PRJNA891846_P_NODE_45237_length_243_cov_0.905882_g45017_i0	PRJNA891846	45237	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	71.6	2.54e-12	NR	AGQ49469.1	213888	g45017	i0	47.3	11.283950617284	74	36	87.7	1	1	213	658	731	AGQ49469.1 reverse transcriptase [Dahlia mosaic virus]	diamond	2742	71.6	1	Viruses		Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Caulimovirus	Caulimovirus tessellodahliae
32205331	32205331	PRJNA891846_P_NODE_2878_length_831_cov_1.638522_g2704_i0	PRJNA891846	2878	831	1.638522	13.61611782	Marnaviridae sp.	2715102	Viruses	Viruses	463	1.08e-147	NR	ULG00027.1	2715102	g2704	i0	80.4	0.996389891696751	276	54	99.6	0	2	829	820	1095	ULG00027.1 MAG: hypothetical protein 1 [Marnaviridae sp.]	diamond	828	463	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Marnaviridae sp.

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