metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJDB4470" and tax

17 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
1284030	1284030	PRJDB4470_P_NODE_73242_length_213_cov_1.268293_g72087_i0	PRJDB4470	73242	213	1.268293	2.70146409	Grapevine wood holobiome associated narna-like virus 6	3398663	Viruses	Viruses	135	1.81e-27	NTclustered	gi\|2905035787\|gb\|PV021973.1\|	3398663	g72087	i0	79.31	1.97652582159624	203	35	94	6	1	201	1309	1506	Grapevine wood holobiome associated narna-like virus 6 isolate grp6 segment RNA3 HP1 and HP2 genes, complete cds	blastn	421	135	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 6
1284164	1284164	PRJDB4470_P_NODE_87962_length_186_cov_1.116788_g86807_i0	PRJDB4470	87962	186	1.116788	2.07722568	Neofusicoccum parvum narnavirus 1	2587532	Viruses	Viruses	204	4.15e-48	NTclustered	gi\|1682807473\|gb\|MK584833.1\|	2587532	g86807	i0	86.631	3.01612903225806	187	21	99	4	1	185	2387	2571	MAG: Neofusicoccum parvum narnavirus 1 isolate CREA-VE-9AS3, complete sequence	blastn	561	204	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Neofusicoccum parvum narnavirus 1
2559428	2559428	PRJDB4470_P_NODE_48023_length_299_cov_1.784000_g46870_i0	PRJDB4470	48023	299	1.784	5.33416	Skokie reo-like virus	2789444	Viruses	Viruses	494	3.84e-135	NTclustered	gi\|1933757587\|gb\|MW177748.1\|	2789444	g46870	i0	97.895	0.953177257525084	285	6	95	0	15	299	193	477	Skokie reo-like virus strain USAdf hypothetical protein 2 gene, complete cds	blastn	285	494	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales			Skokie reo-like virus
3836058	3836058	PRJDB4470_P_NODE_88664_length_185_cov_1.102941_g87509_i0	PRJDB4470	88664	185	1.102941	2.04044085	Pestivirus bovis	3052619	Viruses	Viruses	298	1.84e-76	NTclustered	gi\|575471150\|gb\|KF772785.1\|	11099	g87509	i0	99.394	79.3135135135135	165	0	89	1	1	165	164	1	Bovine viral diarrhea virus 1 isolate CC13B, complete genome	blastn	14673	298	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
6387736	6387736	PRJDB4470_P_NODE_38806_length_351_cov_2.784768_g37654_i0	PRJDB4470	38806	351	2.784768	9.77453568	Carlavirus latensdianthi	3427766	Viruses	Viruses	52.8	0.033	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g37654	i0	100	0.0797720797720798	28	0	8	0	324	351	42	15	Carnation latent virus isolate KL, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
6388034	6388034	PRJDB4470_P_NODE_7446_length_887_cov_49.661098_g6452_i1	PRJDB4470	7446	887	49.661098	440.49393926	Skokie dicistro-like virus	2789443	Viruses	Viruses	1480	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g6452	i1	99.03	1.90529875986471	825	8	93	0	42	866	5323	4499	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1690	1480	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
7661971	7661971	PRJDB4470_P_NODE_58707_length_254_cov_2.429268_g57552_i0	PRJDB4470	58707	254	2.429268	6.17034072	Alphachrysovirus perseae	2955248	Viruses	Viruses	433	7.05e-117	NTclustered	gi\|1694999054\|ref\|NC_043506.1\|	1587509	g57552	i0	100	0.921259842519685	234	0	92	0	1	234	2839	2606	Persea americana chrysovirus segment RNA1, complete sequence	blastn	234	433	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus perseae
8936730	8936730	PRJDB4470_P_NODE_728_length_2103_cov_2.588608_g593_i0	PRJDB4470	728	2103	2.588608	54.43842624	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	693	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g593	i0	94.82	0.300047551117451	444	23	30	0	567	1010	2100	2543	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	631	693	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
11487898	11487898	PRJDB4470_P_NODE_90_length_3437_cov_37.488194_g73_i0	PRJDB4470	90	3437	37.488194	1288.46922778	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	2527	0	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g73	i0	92.256	0.877218504509747	1782	134	88	4	1654	3433	5329	7108	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	3015	2527	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14037565	14037565	PRJDB4470_P_NODE_45172_length_314_cov_1.366038_g44019_i0	PRJDB4470	45172	314	1.366038	4.28935932	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	473	5.29e-129	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g44019	i0	96.82	0.901273885350318	283	9	90	0	32	314	4	286	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	283	473	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15311931	15311931	PRJDB4470_P_NODE_7193_length_901_cov_28.205399_g6452_i0	PRJDB4470	7193	901	28.205399	254.13064499	Skokie dicistro-like virus	2789443	Viruses	Viruses	1365	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g6452	i0	96.062	1.90455049944506	838	33	93	0	42	879	5323	4486	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1716	1365	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
17861689	17861689	PRJDB4470_P_NODE_81875_length_195_cov_3.198630_g80720_i0	PRJDB4470	81875	195	3.19863	6.2373285	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	235	1.56e-57	NTclustered	gi\|1940198121\|gb\|MT757492.1\|	2789378	g80720	i0	87.907	2.2974358974359	215	6	100	7	1	195	9133	8919	Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds	blastn	448	235	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
19135471	19135471	PRJDB4470_P_NODE_94756_length_176_cov_1.606299_g93601_i0	PRJDB4470	94756	176	1.606299	2.82708624	Botourmiaviridae sp.	2808997	Viruses	Viruses	276	8.090000000000001e-70	NTclustered	gi\|2396039523\|gb\|ON812848.1\|	2808997	g93601	i0	94.886	2	176	9	100	0	1	176	1796	1621	MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome	blastn	352	276	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
21383548	21383548	PRJDB4470_P_NODE_6857_length_920_cov_5.510907_g6140_i0	PRJDB4470	6857	920	5.5109069999999996	50.7003444	Pestivirus	11095	Viruses	Viruses	1334	0	NTclustered	gi\|386285713\|gb\|JQ418634.1\|	11099	g6140	i0	93.437	97.2836956521739	899	59	98	0	1	899	9776	8878	Bovine viral diarrhea virus 1 isolate 08GB45-2 polyprotein gene, complete cds	blastn	89501	1345	0.99182156133829	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
22658450	22658450	PRJDB4470_P_NODE_86778_length_187_cov_2.623188_g85623_i0	PRJDB4470	86778	187	2.623188	4.90536156	root	1	Root_unresolved	Root_unresolved	196	6.989999999999999e-46	NTclustered	gi\|2006234009\|gb\|MW741553.1\|	11060	g85623	i0	96.61	96.3903743315508	118	4	97	0	4	121	10595	10478	Dengue virus type 2 isolate DENV-2 Rega Lab strain polyprotein (POLY) gene, complete cds; and sfRNA1 lncRNA gene, partial sequence	blastn	18025	196	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Orthoflavivirus	Orthoflavivirus denguei
22961926	22961926	PRJDB4470_P_NODE_98139_length_172_cov_1.089431_g96984_i0	PRJDB4470	98139	172	1.089431	1.87382132	Sopafab virus	3131770	Viruses	Viruses	185	1.3599999999999999e-42	NTclustered	gi\|2717323354\|gb\|PP174071.1\|	3131770	g96984	i0	90.21	49.6162790697674	143	13	83	1	19	160	20	162	MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence	blastn	8534	185	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sopafab virus
24235326	24235326	PRJDB4470_P_NODE_40480_length_341_cov_1.729452_g39328_i0	PRJDB4470	40480	341	1.729452	5.89743132	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	182	3.94e-41	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g39328	i0	94.872	0.343108504398827	117	5	34	1	225	341	1105	990	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	117	182	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2

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