metadata: contig_metadata: 7 rows where bioproject = "PRJNA1025141" and tax

7 rows where bioproject = "PRJNA1025141" 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
9090424	9090424	PRJNA1025141_P_NODE_6388_length_317_cov_0.946721_g6327_i0	PRJNA1025141	6388	317	0.946721	3.00110557	Japanese yam mosaic virus	79917	Viruses	Viruses	188	6.47e-53	NR	AIT13016.1	79917	g6327	i0	81	1.98738170347003	105	20	99.4	0	2	316	2056	2160	AIT13016.1 polyprotein [Japanese yam mosaic virus]	diamond	630	188	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nippodioscoreae
11641447	11641447	PRJNA1025141_P_NODE_7010_length_300_cov_1.647577_g6949_i0	PRJNA1025141	7010	300	1.647577	4.942731	Potyvirus nippodioscoreae	3240571	Viruses	Viruses	241	5.55e-59	NTclustered	gi\|745788249\|gb\|KJ789138.1\|	79917	g6949	i0	93.252	2.55666666666667	163	11	54	0	138	300	3164	3002	Japanese yam mosaic virus isolate WX1, complete genome	blastn	767	241	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nippodioscoreae
12916534	12916534	PRJNA1025141_P_NODE_4551_length_381_cov_1.025974_g4490_i0	PRJNA1025141	4551	381	1.025974	3.90896094	Cryphonectria naterciae splipalmivirus 1	2841740	Viruses	Viruses	142	2.1899999999999998e-40	NR	BCX55511.1	2841740	g4490	i0	58.7	0.992125984251969	126	51	99.2	1	2	379	26	150	BCX55511.1 hypothetical protein 1 [Cryphonectria naterciae splipalmivirus 1]	diamond	378	142	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus cryphonectriae
28866636	28866636	PRJNA1025141_P_NODE_12308_length_243_cov_0.905882_g12247_i0	PRJNA1025141	12308	243	0.905882	2.20129326	Yam chlorotic necrosis virus	2175329	Viruses	Viruses	145	2.83e-38	NR	YP_010086840.1	2175329	g12247	i0	87.3	0.975308641975309	79	10	97.5	0	242	6	1630	1708	YP_010086840.1 polyprotein [Yam chlorotic necrosis virus]	diamond	237	145	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Macluravirus	Macluravirus dioscoreaflavinecrosis
29371928	29371928	PRJNA1025141_P_NODE_7129_length_297_cov_1.491071_g7068_i0	PRJNA1025141	7129	297	1.491071	4.42848087	Japanese yam mosaic virus	79917	Viruses	Viruses	187	1.6699999999999999e-52	NR	AJD23395.1	79917	g7068	i0	91.8	1.97979797979798	98	8	99	0	2	295	1770	1867	AJD23395.1 polyprotein [Japanese yam mosaic virus]	diamond	588	187	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus nippodioscoreae
30793217	30793217	PRJNA1025141_P_NODE_3594_length_430_cov_1.299720_g3533_i0	PRJNA1025141	3594	430	1.29972	5.588796	Grapevine wood holobiome associated narna-like virus 18	3398654	Viruses	Viruses	81.3	2.57e-16	NR	XOD45390.1	3398654	g3533	i0	39	0.948837209302326	136	76	90	5	389	3	6	141	XOD45390.1 HP2 [Grapevine wood holobiome associated narna-like virus 18]	diamond	408	81.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 18
32311550	32311550	PRJNA1025141_P_NODE_11979_length_244_cov_0.900585_g11918_i0	PRJNA1025141	11979	244	0.900585	2.1974274	Pseudomonas phage ER16	2917704	Viruses	Viruses	68.2	3.73e-11	NR	UNI73393.1	2917704	g11918	i0	43.2	1.99180327868852	81	42	94.7	2	3	233	206	286	UNI73393.1 RNA dependent RNA polymerase [Pseudomonas phage ER16]	diamond	486	68.2	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Pseudomonas phage ER16

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