metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA358009" 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
1672991	1672991	PRJNA358009_P_NODE_3762_length_327_cov_2.453237_g3699_i0	PRJNA358009	3762	327	2.453237	8.02208499	Pestivirus bovis	3052619	Viruses	Viruses	156	2.28e-33	NTclustered	gi\|2625903273\|gb\|ON676187.1\|	11099	g3699	i0	96.774	50.2935779816514	93	3	28	0	228	320	8582	8490	Bovine viral diarrhea virus 1 strain Chilgok, complete genome	blastn	16446	156	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
2348448	2348448	PRJNA358009_P_NODE_8302_length_201_cov_3.427632_g8233_i0	PRJNA358009	8302	201	3.427632	6.88954032	Pestivirus	11095	Viruses	Viruses	255	1.24e-63	NTclustered	gi\|2088281168\|dbj\|LC648387.1\|	11099	g8233	i0	92.655	88.0248756218905	177	13	88	0	18	194	467	291	Bovine viral diarrhea virus 1 BVDV/Rikubetsu/1283/14 gene for polyprotein, partial cds	blastn	17693	255	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
4225372	4225372	PRJNA358009_P_NODE_12524_length_169_cov_1.700000_g12455_i0	PRJNA358009	12524	169	1.7	2.873	Pestivirus bovis	3052619	Viruses	Viruses	276	7.69e-70	NTclustered	gi\|1350888790\|gb\|KY852366.1\|	11099	g12455	i0	96.951	96.9230769230769	164	5	97	0	6	169	34	197	Bovine viral diarrhea virus 1 isolate S1118 E2 glycoprotein gene, partial cds	blastn	16380	276	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
8051608	8051608	PRJNA358009_P_NODE_7327_length_253_cov_5.544118_g7259_i0	PRJNA358009	7327	253	5.544118	14.02661854	Pestivirus bovis	3052619	Viruses	Viruses	422	1.52e-113	NTclustered	gi\|1129880375\|gb\|KX170555.1\|	11099	g7259	i0	97.561	97.2094861660079	246	6	97	0	1	246	576	331	Bovine viral diarrhea virus 1 isolate V078 NS4B gene, partial cds	blastn	24594	422	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10602123	10602123	PRJNA358009_P_NODE_9729_length_184_cov_3.059259_g9660_i0	PRJNA358009	9729	184	3.059259	5.62903656	Chemarfal virus 260	3063286	Viruses	Viruses	300	5.08e-77	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g9660	i0	97.191	0.967391304347826	178	4	96	1	8	184	980	803	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	178	300	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
13152066	13152066	PRJNA358009_P_NODE_9511_length_185_cov_6.404412_g9442_i0	PRJNA358009	9511	185	6.404412	11.8481622	Pestivirus bovis	3052619	Viruses	Viruses	298	1.84e-76	NTclustered	gi\|2127986424\|gb\|MW713361.1\|	11099	g9442	i0	96.154	72.8216216216216	182	7	98	0	1	182	7684	7865	Bovine viral diarrhea virus 1 strain BoAEC1190, partial genome	blastn	13472	298	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
13826482	13826482	PRJNA358009_P_NODE_8911_length_189_cov_2.964286_g8842_i0	PRJNA358009	8911	189	2.964286	5.60250054	Pestivirus	11095	Viruses	Viruses	287	4.08e-73	NTclustered	gi\|646290880\|gb\|KJ620017.1\|	11099	g8842	i0	97.605	89.4074074074074	167	4	88	0	21	187	11033	10867	Bovine viral diarrhea virus 1 isolate IBSP4ncp polyprotein gene, complete cds	blastn	16898	287	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
15100868	15100868	PRJNA358009_P_NODE_9592_length_185_cov_2.544118_g9523_i0	PRJNA358009	9592	185	2.544118	4.7066183	Pestivirus	11095	Viruses	Viruses	279	6.66e-71	NTclustered	gi\|1761026086\|gb\|MK675069.1\|	11099	g9523	i0	94.944	95.7891891891892	178	9	96	0	1	178	695	518	Bovine viral diarrhea virus 1 strain 194-TC/17 glycoprotein E2 gene, partial cds	blastn	17721	279	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
16975563	16975563	PRJNA358009_P_NODE_12714_length_168_cov_2.117647_g12645_i0	PRJNA358009	12714	168	2.117647	3.55764696	Chemarfal virus 260	3063286	Viruses	Viruses	243	7.8e-60	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g12645	i0	93.789	0.958333333333333	161	10	96	0	8	168	626	466	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	161	243	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
18924428	18924428	PRJNA358009_P_NODE_1715_length_339_cov_4.793103_g1653_i0	PRJNA358009	1715	339	4.793103	16.24861917	Pestivirus	11095	Viruses	Viruses	191	6.499999999999998e-44	NTclustered	gi\|1129879727\|gb\|KX170231.1\|	11099	g1653	i0	96.522	59.9085545722714	115	4	62	0	218	332	551	665	Bovine viral diarrhea virus 1 isolate V020 Erns gene, partial cds	blastn	20309	191	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
20199089	20199089	PRJNA358009_P_NODE_3656_length_327_cov_2.521583_g3593_i0	PRJNA358009	3656	327	2.521583	8.24557641	Pestivirus	11095	Viruses	Viruses	178	4.86e-40	NTclustered	gi\|800924330\|gb\|KP941590.1\|	11099	g3593	i0	98.99	59.2660550458716	99	1	60	0	227	325	11004	11102	Bovine viral diarrhea virus 1 strain USMARC-55924 polyprotein gene, complete cds	blastn	19380	178	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
20799757	20799757	PRJNA358009_P_NODE_17037_length_158_cov_3.706422_g16968_i0	PRJNA358009	17037	158	3.706422	5.85614676	Pestivirus bovis	3052619	Viruses	Viruses	255	9.27e-64	NTclustered	gi\|2625903273\|gb\|ON676187.1\|	11099	g16968	i0	96.732	96.7025316455696	153	5	97	0	3	155	11299	11451	Bovine viral diarrhea virus 1 strain Chilgok, complete genome	blastn	15279	255	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
20799831	20799831	PRJNA358009_P_NODE_6517_length_326_cov_3.945848_g6454_i0	PRJNA358009	6517	326	3.945848	12.86346448	Pestivirus bovis	3052619	Viruses	Viruses	152	2.94e-32	NTclustered	gi\|2419860348\|dbj\|LC727645.1\|	11099	g6454	i0	94.059	45.0460122699387	101	5	59	1	227	326	1492	1592	Bovine viral diarrhea virus 1 Tokachi-13 RNA, nearly complete genome	blastn	14685	152	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
22074914	22074914	PRJNA358009_P_NODE_8238_length_203_cov_7.746753_g8169_i0	PRJNA358009	8238	203	7.746753	15.72590859	Sopapen virus	3131614	Viruses	Viruses	91.6	3.75e-14	NTclustered	gi\|2717322942\|gb\|PP173915.1\|	3131614	g8169	i0	93.443	1.54187192118227	61	4	30	0	143	203	527	467	MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence	blastn	313	91.6	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Sopapen virus
22749778	22749778	PRJNA358009_P_NODE_13878_length_165_cov_3.000000_g13809_i0	PRJNA358009	13878	165	3	4.95	Pestivirus	11095	Viruses	Viruses	296	5.77e-76	NTclustered	gi\|1151064267\|gb\|KY040393.1\|	11099	g13809	i0	100	96.7515151515152	160	0	97	0	6	165	96	255	Bovine viral diarrhea virus 1 strain 124/11 5' UTR	blastn	15964	296	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
23350354	23350354	PRJNA358009_P_NODE_9139_length_188_cov_1.467626_g9070_i0	PRJNA358009	9139	188	1.467626	2.75913688	Gammacarmovirus melonis	3048200	Viruses	Viruses	318	1.44e-82	NTclustered	gi\|1108560304\|gb\|KY124136.1\|	11987	g9070	i0	98.343	6.73936170212766	181	3	96	0	8	188	3058	3238	Melon necrotic spot virus strain MNSV/USA/MD/2012, complete genome	blastn	1267	318	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Gammacarmovirus	Gammacarmovirus melonis

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