metadata: contig_metadata: 29 rows where bioproject = "PRJEB83711" and tax

29 rows where bioproject = "PRJEB83711" 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
1418208	1418208	PRJEB83711_P_NODE_23902_length_363_cov_4.917241_g23636_i0	PRJEB83711	23902	363	4.917241	17.84958483	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	433	1.05e-116	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g23636	i0	91.456	0.870523415977961	316	25	87	2	49	363	5329	5643	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	316	433	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
1419246	1419246	PRJEB83711_P_NODE_6922_length_688_cov_2.908943_g6674_i0	PRJEB83711	6922	688	2.908943	20.01352784	Rocky Mountain birnavirus	3077841	Viruses	Viruses	1177	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g6674	i0	97.529	1	688	17	100	0	1	688	1595	908	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	688	1177	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
1419431	1419431	PRJEB83711_P_NODE_77802_length_242_cov_1.846154_g77536_i0	PRJEB83711	77802	242	1.846154	4.46769268	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	294	3.28e-75	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g77536	i0	94.271	0.793388429752066	192	11	79	0	51	242	639	448	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	192	294	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
1419501	1419501	PRJEB83711_P_NODE_81222_length_231_cov_3.803797_g80956_i0	PRJEB83711	81222	231	3.803797	8.78677107	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	344	3.04e-90	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g80956	i0	93.506	1	231	15	100	0	1	231	6387	6617	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	231	344	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
2693941	2693941	PRJEB83711_P_NODE_35483_length_303_cov_2.291304_g35217_i0	PRJEB83711	35483	303	2.291304	6.94265112	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	339	1.93e-88	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g35217	i0	93.074	0.762376237623762	231	16	76	0	73	303	2548	2318	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	231	339	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
5246713	5246713	PRJEB83711_P_NODE_43905_length_280_cov_1.014493_g43639_i0	PRJEB83711	43905	280	1.014493	2.8405804	brine shrimp yue-like virus 7	2900459	Viruses	Viruses	512	9.85e-141	NTclustered	gi\|2209095278\|gb\|OL472843.1\|	2900459	g43639	i0	99.643	5	280	1	100	0	1	280	849	570	MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds	blastn	1400	512	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		brine shrimp yue-like virus 7
7797072	7797072	PRJEB83711_P_NODE_71527_length_246_cov_0.901734_g71261_i0	PRJEB83711	71527	246	0.901734	2.21826564	Totivirus ichi	3432942	Viruses	Viruses	449	6.74e-122	NTclustered	gi\|558066\|gb\|J04692.1\|SCSCOATRNA	11008	g71261	i0	99.593	3.39837398373984	246	1	100	0	1	246	15	260	Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds	blastn	836	449	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus ichi
9070914	9070914	PRJEB83711_P_NODE_22988_length_370_cov_4.700337_g22722_i0	PRJEB83711	22988	370	4.700337	17.3912469	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	568	2.819999999999999e-157	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g22722	i0	97.033	0.910810810810811	337	10	91	0	34	370	3703	4039	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	337	568	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
9071269	9071269	PRJEB83711_P_NODE_39388_length_290_cov_3.294931_g39122_i0	PRJEB83711	39388	290	3.294931	9.5552999	Rocky Mountain birnavirus	3077841	Viruses	Viruses	508	1.33e-139	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g39122	i0	98.276	1.2	290	5	100	0	1	290	420	131	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	348	508	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
9071428	9071428	PRJEB83711_P_NODE_45628_length_276_cov_1.157635_g45362_i0	PRJEB83711	45628	276	1.157635	3.1950726	Sesamum betacytorhabdovirus 1_Cat	3078362	Viruses	Viruses	501	2.1e-137	NTclustered	gi\|2618835764\|tpg\|BK064337.1\|	3078362	g45362	i0	99.635	1.98550724637681	274	1	99	0	3	276	2650	2377	TPA_asm: Sesamum betacytorhabdovirus 1_Cat cRNA sequence	blastn	548	501	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae		Sesamum betacytorhabdovirus 1_Cat
10347937	10347937	PRJEB83711_P_NODE_9169_length_597_cov_4.391221_g8907_i0	PRJEB83711	9169	597	4.391221	26.21558937	Rocky Mountain birnavirus	3077841	Viruses	Viruses	1059	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g8907	i0	98.66	1	597	8	100	0	1	597	927	331	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	597	1059	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
12897007	12897007	PRJEB83711_P_NODE_19351_length_402_cov_3.419453_g19085_i0	PRJEB83711	19351	402	3.419453	13.74620106	Rocky Mountain birnavirus	3077841	Viruses	Viruses	715	0	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g19085	i0	98.756	1	402	5	100	0	1	402	1326	925	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	402	715	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
12897527	12897527	PRJEB83711_P_NODE_41431_length_285_cov_2.169811_g41165_i0	PRJEB83711	41431	285	2.169811	6.18396135	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	248	3.13e-61	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g41165	i0	96.053	0.533333333333333	152	6	53	0	2	153	5066	4915	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	152	248	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
14171856	14171856	PRJEB83711_P_NODE_14172_length_472_cov_5.037594_g13908_i0	PRJEB83711	14172	472	5.037594	23.77744368	Rocky Mountain birnavirus	3077841	Viruses	Viruses	828	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g13908	i0	98.305	1	472	8	100	0	1	472	2877	2406	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	472	828	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
14172844	14172844	PRJEB83711_P_NODE_5552_length_769_cov_2.027299_g5321_i0	PRJEB83711	5552	769	2.027299	15.58992931	Rocky Mountain birnavirus	3077841	Viruses	Viruses	1304	0	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g5321	i0	97.269	1	769	21	100	0	1	769	2182	1414	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	769	1304	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
15446351	15446351	PRJEB83711_P_NODE_28773_length_333_cov_2.380769_g28507_i0	PRJEB83711	28773	333	2.380769	7.92796077	Rocky Mountain birnavirus	3077841	Viruses	Viruses	593	4.159999999999999e-165	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g28507	i0	98.799	1	333	4	100	0	1	333	2626	2294	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	333	593	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
15446771	15446771	PRJEB83711_P_NODE_45713_length_276_cov_0.768473_g45447_i0	PRJEB83711	45713	276	0.768473	2.12098548	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	449	7.699999999999998e-122	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g45447	i0	96.014	1	276	11	100	0	1	276	5519	5794	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	276	449	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
15447436	15447436	PRJEB83711_P_NODE_77373_length_243_cov_0.917647_g77107_i0	PRJEB83711	77373	243	0.917647	2.22988221	Poacevirus sacchari	3431714	Viruses	Viruses	399	6.789999999999999e-107	NTclustered	gi\|294795277\|ref\|NC_014037.1\|	53954	g77107	i0	96.296	5	243	9	100	0	1	243	5266	5024	Sugarcane streak mosaic virus, complete genome	blastn	1215	399	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Poacevirus	Poacevirus sacchari
16720020	16720020	PRJEB83711_P_NODE_11654_length_525_cov_3.918142_g11390_i0	PRJEB83711	11654	525	3.918142	20.5702455	Rocky Mountain birnavirus	3077841	Viruses	Viruses	931	0	NTclustered	gi\|2582975581\|gb\|OR427290.1\|	3077841	g11390	i0	98.667	1	525	7	100	0	1	525	931	407	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment B, complete sequence	blastn	525	931	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
16720035	16720035	PRJEB83711_P_NODE_12354_length_509_cov_5.103211_g12090_i0	PRJEB83711	12354	509	5.103211	25.97534399	Rocky Mountain birnavirus	3077841	Viruses	Viruses	915	0	NTclustered	gi\|2583625428\|gb\|OR427289.1\|	3077841	g12090	i0	99.211	0.996070726915521	507	4	99	0	3	509	2388	1882	Rocky Mountain birnavirus isolate RMBV/2020/Utah/USA segment A, complete sequence	blastn	507	915	1	Viruses	Orthornavirae				Birnaviridae		Rocky Mountain birnavirus
17994913	17994913	PRJEB83711_P_NODE_11835_length_521_cov_2.024554_g11571_i0	PRJEB83711	11835	521	2.024554	10.54792634	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	368	4.46e-97	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g11571	i0	92.578	0.491362763915547	256	19	49	0	261	516	1703	1448	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	256	368	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
17995043	17995043	PRJEB83711_P_NODE_17275_length_426_cov_1.671388_g17009_i0	PRJEB83711	17275	426	1.671388	7.12011288	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	601	3.2499999999999995e-167	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g17009	i0	95.251	0.889671361502347	379	18	89	0	1	379	4573	4195	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	379	601	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
19269564	19269564	PRJEB83711_P_NODE_45376_length_276_cov_1.901478_g45110_i0	PRJEB83711	45376	276	1.901478	5.24807928	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	370	6.17e-98	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g45110	i0	92.913	0.920289855072464	254	18	92	0	22	275	772	1025	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	254	370	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
21821270	21821270	PRJEB83711_P_NODE_64018_length_250_cov_0.881356_g63752_i0	PRJEB83711	64018	250	0.881356	2.20339	Betascleroulivirus alphaplasmoparae	2955477	Viruses	Viruses	383	7.07e-102	NTclustered	gi\|2500381293\|ref\|NC_076764.1\|	2686503	g63752	i0	94.378	0.996	249	14	99	0	2	250	2055	1807	Plasmopara viticola lesion associated ourmia-like virus 34 isolate DMG-A_34896 RNA dependent RNA polymerase (QKR39_gp1) gene, complete cds	blastn	249	383	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Betascleroulivirus	Betascleroulivirus alphaplasmoparae
24369896	24369896	PRJEB83711_P_NODE_46340_length_274_cov_1.791045_g46074_i0	PRJEB83711	46340	274	1.791045	4.9074633	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	409	1.3e-109	NTclustered	gi\|2551699335\|gb\|OK619588.1\|	3063761	g46074	i0	94.361	0.970802919708029	266	15	97	0	1	266	5986	6251	Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds	blastn	266	409	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Danio blood picornavirus/Zebrafish picornavirus 2
28763829	28763829	PRJEB83711_P_NODE_50507_length_266_cov_1.357513_g50241_i0	PRJEB83711	50507	266	1.357513	3.6109845800000002	Ilarvirus	12316	Viruses	Viruses	84.3	1.36e-17	NR	NP_620774.1	12317	g50241	i0	63.2	3.24812030075188	57	21	64.3	0	1	171	177	233	NP_620774.1 coat protein [Tobacco streak virus]	diamond	864	84.3	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Ilarvirus	Ilarvirus TSV
29971135	29971135	PRJEB83711_P_NODE_35711_length_302_cov_3.030568_g35445_i0	PRJEB83711	35711	302	3.030568	9.15231536	Morogoro maize-associated virus	2497337	Viruses	Viruses	204	2.03e-64	NR	YP_010087199.1	2497337	g35445	i0	95	0.993377483443709	100	5	99.3	0	2	301	99	198	YP_010087199.1 matrix protein [Morogoro maize-associated virus]	diamond	300	204	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Alphanucleorhabdovirus	Alphanucleorhabdovirus morogoromaydis
31481007	31481007	PRJEB83711_P_NODE_81696_length_229_cov_2.006410_g81430_i0	PRJEB83711	81696	229	2.00641	4.5946789	Ilarvirus	12316	Viruses	Viruses	99	1.47e-23	NR	YP_009551517.1	2116599	g81430	i0	61	2.0174672489083	77	29	99.6	1	1	228	86	162	YP_009551517.1 coat protein [Cape gooseberry ilarvirus 1]	diamond	462	99	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Ilarvirus	Cape gooseberry ilarvirus 1
32405586	32405586	PRJEB83711_P_NODE_16099_length_442_cov_1.249322_g15833_i0	PRJEB83711	16099	442	1.249322	5.52200324	Tobacco streak virus	12317	Viruses	Viruses	184	7.459999999999998e-55	NR	NP_620773.1	12317	g15833	i0	78.9	1.54751131221719	114	24	77.4	0	345	4	1	114	NP_620773.1 movement protein [Tobacco streak virus]	diamond	684	184	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Ilarvirus	Ilarvirus TSV

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