metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA627467" 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
599152	599152	PRJNA627467_P_NODE_19241_length_161_cov_1.785714_g19172_i0	PRJNA627467	19241	161	1.785714	2.87499954	Potyvirus citrulli	3240504	Viruses	Viruses	281	1.57e-71	NTclustered	gi\|1821701274\|gb\|MN186551.1\|	146500	g19172	i0	98.734	98.0993788819876	158	2	98	0	1	158	727	884	Watermelon mosaic virus isolate 323-2016 polyprotein, helper component protease region, gene, partial cds	blastn	15794	281	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
1875303	1875303	PRJNA627467_P_NODE_20242_length_157_cov_3.203704_g20173_i0	PRJNA627467	20242	157	3.203704	5.02981528	Sopamon virus	3131721	Viruses	Viruses	147	5.78e-31	NTclustered	gi\|2717323235\|gb\|PP174022.1\|	3131721	g20173	i0	83.974	15.7388535031847	156	21	98	4	1	154	379	226	MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence	blastn	2471	147	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopamon virus
1875383	1875383	PRJNA627467_P_NODE_7422_length_235_cov_3.790323_g7353_i0	PRJNA627467	7422	235	3.790323	8.90725905	Potyvirus citrulli	3240504	Viruses	Viruses	418	1.8e-112	NTclustered	gi\|326468192\|gb\|JF273463.1\|	146500	g7353	i0	100	95.336170212766	226	0	96	0	5	230	4864	5089	Watermelon mosaic virus isolate C06-257, complete genome	blastn	22404	418	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
1875389	1875389	PRJNA627467_P_NODE_7782_length_223_cov_2.977011_g7713_i0	PRJNA627467	7782	223	2.977011	6.63873453	Potyvirus citrulli	3240504	Viruses	Viruses	385	1.72e-102	NTclustered	gi\|726972783\|gb\|KM527486.1\|	146500	g7713	i0	98.182	98.6233183856502	220	4	99	0	4	223	241	460	Watermelon mosaic virus isolate WTLF-1 coat protein mRNA, partial cds	blastn	21993	385	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
3150041	3150041	PRJNA627467_P_NODE_16423_length_167_cov_0.864407_g16354_i0	PRJNA627467	16423	167	0.864407	1.44355969	Potyvirus citrulli	3240504	Viruses	Viruses	259	7.69e-65	NTclustered	gi\|1204712534\|gb\|KX664483.1\|	146500	g16354	i0	95.122	91.562874251497007	164	8	98	0	1	164	742	579	Watermelon mosaic virus isolate WMV-WS, complete genome	blastn	15291	259	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
4426756	4426756	PRJNA627467_P_NODE_1384_length_330_cov_1.672598_g1317_i0	PRJNA627467	1384	330	1.672598	5.5195734	Potyvirus citrulli	3240504	Viruses	Viruses	195	4.88e-45	NTclustered	gi\|326468192\|gb\|JF273463.1\|	146500	g1317	i0	97.368	46.269696969697	114	3	64	0	1	114	5788	5675	Watermelon mosaic virus isolate C06-257, complete genome	blastn	15269	195	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
4426800	4426800	PRJNA627467_P_NODE_17484_length_164_cov_5.652174_g17415_i0	PRJNA627467	17484	164	5.652174	9.26956536	Potyvirus citrulli	3240504	Viruses	Viruses	291	2.67e-74	NTclustered	gi\|1821701274\|gb\|MN186551.1\|	146500	g17415	i0	99.375	97.3963414634146	160	1	98	0	2	161	366	207	Watermelon mosaic virus isolate 323-2016 polyprotein, helper component protease region, gene, partial cds	blastn	15973	291	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
6977642	6977642	PRJNA627467_P_NODE_19026_length_161_cov_3.589286_g18957_i0	PRJNA627467	19026	161	3.589286	5.77875046	Potyvirus citrulli	3240504	Viruses	Viruses	274	2.62e-69	NTclustered	gi\|1789811472\|gb\|MN686524.1\|	146500	g18957	i0	98.701	95.111801242236	154	2	96	0	6	159	1397	1244	Watermelon mosaic virus isolate TX113, complete genome	blastn	15313	274	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
6977737	6977737	PRJNA627467_P_NODE_8386_length_207_cov_2.297468_g8317_i0	PRJNA627467	8386	207	2.297468	4.75575876	Emesvirus zinderi	329852	Viruses	Viruses	56.5	0.001	NTclustered	gi\|2494998033\|dbj\|LC710218.1\|	12022	g8317	i0	96.97	0.294685990338164	33	1	16	0	141	173	23	55	Escherichia phage MS2 GI_B RNA, complete genome	blastn	61	56.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Emesvirus	Emesvirus zinderi
8252254	8252254	PRJNA627467_P_NODE_11267_length_183_cov_2.813433_g11198_i0	PRJNA627467	11267	183	2.813433	5.14858239	Potyvirus citrulli	3240504	Viruses	Viruses	322	1.08e-83	NTclustered	gi\|326468192\|gb\|JF273463.1\|	146500	g11198	i0	98.361	99.9890710382514	183	3	100	0	1	183	6160	6342	Watermelon mosaic virus isolate C06-257, complete genome	blastn	18298	322	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
8252258	8252258	PRJNA627467_P_NODE_11867_length_181_cov_2.848485_g11798_i0	PRJNA627467	11867	181	2.848485	5.15575785	Pestivirus bovis	3052619	Viruses	Viruses	300	4.970000000000001e-77	NTclustered	gi\|642594\|gb\|L35849.1\|BVDP125B	11099	g11798	i0	97.175	98.475138121547	177	5	98	0	5	181	1642	1818	Bovine viral diarrhea virus (strain Draper) p125 gene, partial cds	blastn	17824	300	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
8252427	8252427	PRJNA627467_P_NODE_7327_length_239_cov_2.036842_g7258_i0	PRJNA627467	7327	239	2.036842	4.86805238	Pestivirus bovis	3052619	Viruses	Viruses	326	1.15e-84	NTclustered	gi\|2419860354\|dbj\|LC727648.1\|	11099	g7258	i0	91.845	97.1757322175732	233	19	97	0	4	236	2195	1963	Bovine viral diarrhea virus 1 Tokachi-27 RNA, nearly complete genome	blastn	23225	326	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10079497	10079497	PRJNA627467_P_NODE_9808_length_188_cov_3.100719_g9739_i0	PRJNA627467	9808	188	3.100719	5.82935172	Pestivirus	11095	Viruses	Viruses	315	1.8599999999999999e-81	NTclustered	gi\|1129880133\|gb\|KX170434.1\|	11099	g9739	i0	97.283	97.8510638297872	184	5	98	0	5	188	1423	1606	Bovine viral diarrhea virus 1 isolate V098 NS3 gene, partial cds	blastn	18396	315	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10803267	10803267	PRJNA627467_P_NODE_10189_length_187_cov_1.876812_g10120_i0	PRJNA627467	10189	187	1.876812	3.50963844	Potyvirus citrulli	3240504	Viruses	Viruses	322	1.1e-83	NTclustered	gi\|268628057\|gb\|FJ823122.1\|	146500	g10120	i0	98.361	31.957219251336895	183	3	98	0	5	187	619	801	Watermelon mosaic virus isolate Lecce, complete genome	blastn	5976	322	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
14628071	14628071	PRJNA627467_P_NODE_15252_length_170_cov_1.669421_g15183_i0	PRJNA627467	15252	170	1.669421	2.8380157	Pestivirus bovis	3052619	Viruses	Viruses	276	7.75e-70	NTclustered	gi\|1129879735\|gb\|KX170235.1\|	11099	g15183	i0	96.407	97.5941176470588	167	6	98	0	2	168	530	364	Bovine viral diarrhea virus 1 isolate V087 Erns gene, partial cds	blastn	16591	276	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
17177110	17177110	PRJNA627467_P_NODE_18314_length_163_cov_1.350877_g18245_i0	PRJNA627467	18314	163	1.350877	2.20192951	Pestivirus bovis	3052619	Viruses	Viruses	263	5.77e-66	NTclustered	gi\|1129880205\|gb\|KX170470.1\|	11099	g18245	i0	96.25	98.7546012269939	160	6	98	0	1	160	520	361	Bovine viral diarrhea virus 1 isolate V083 NS3 gene, partial cds	blastn	16097	263	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
19725688	19725688	PRJNA627467_P_NODE_12596_length_179_cov_1.538462_g12527_i0	PRJNA627467	12596	179	1.538462	2.75384698	Pestivirus bovis	3052619	Viruses	Viruses	233	5.0499999999999995e-57	NTclustered	gi\|2127986396\|gb\|MW250798.1\|	11099	g12527	i0	90.805	93.2960893854749	174	16	97	0	5	178	3058	3231	Bovine viral diarrhea virus 1 strain 62-2, complete genome	blastn	16700	233	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
21001582	21001582	PRJNA627467_P_NODE_2677_length_316_cov_2.434457_g2609_i0	PRJNA627467	2677	316	2.434457	7.69288412	Potyvirus citrulli	3240504	Viruses	Viruses	178	4.68e-40	NTclustered	gi\|1864318209\|gb\|MN464245.1\|	146500	g2609	i0	100	55.2626582278481	96	0	30	0	218	313	660	565	Watermelon mosaic virus isolate Ir-W7 cytoplasmic inclusion protein gene, partial cds	blastn	17463	178	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
21001632	21001632	PRJNA627467_P_NODE_7057_length_250_cov_6.378109_g6988_i0	PRJNA627467	7057	250	6.378109	15.9452725	Potyvirus citrulli	3240504	Viruses	Viruses	436	5.349999999999999e-118	NTclustered	gi\|2547379353\|gb\|OQ680560.1\|	146500	g6988	i0	99.174	97.072	242	2	97	0	6	247	7406	7165	Watermelon mosaic virus isolate EM190155, complete genome	blastn	24268	436	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli
21552754	21552754	PRJNA627467_P_NODE_19957_length_158_cov_4.495413_g19888_i0	PRJNA627467	19957	158	4.495413	7.10275254	Pestivirus	11095	Viruses	Viruses	237	3.36e-58	NTclustered	gi\|2731951075\|gb\|PP770551.1\|	11099	g19888	i0	95.302	94.297468354430407	149	7	94	0	5	153	10566	10714	Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome	blastn	14899	237	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
22276306	22276306	PRJNA627467_P_NODE_19618_length_160_cov_2.846847_g19549_i0	PRJNA627467	19618	160	2.846847	4.5549552	Allexivirus deltallii	3433711	Viruses	Viruses	84.2	4.71e-12	NTclustered	gi\|1722561338\|gb\|MN059370.1\|	12430	g19549	i0	79.2	1.5625	125	23	77	3	28	150	1987	1864	Garlic virus D isolate G45-2, complete genome	blastn	250	84.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii
23551745	23551745	PRJNA627467_P_NODE_18899_length_162_cov_0.902655_g18830_i0	PRJNA627467	18899	162	0.902655	1.4623011	Ripachij virus	3130407	Viruses	Viruses	152	1.29e-32	NTclustered	gi\|2717319663\|gb\|PP172709.1\|	3130407	g18830	i0	84.049	119.172839506173	163	20	98	5	1	159	504	664	MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence	blastn	19306	152	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Ripachij virus
24102859	24102859	PRJNA627467_P_NODE_8779_length_198_cov_2.026846_g8710_i0	PRJNA627467	8779	198	2.026846	4.01315508	Viruses	10239	Viruses	Viruses	52.8	0.017	NTclustered	gi\|2565349936\|emb\|OY624021.1\|	2697049	g8710	i0	100	0.282828282828283	28	0	14	0	85	112	21766	21739	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	56	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
24825340	24825340	PRJNA627467_P_NODE_18320_length_163_cov_1.307018_g18251_i0	PRJNA627467	18320	163	1.307018	2.13043934	Allexivirus deltallii	3433711	Viruses	Viruses	263	5.77e-66	NTclustered	gi\|1722561121\|gb\|MN059339.1\|	12430	g18251	i0	95.706	23.6319018404908	163	7	100	0	1	163	413	251	Garlic virus D isolate G102, complete genome	blastn	3852	263	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii
24825443	24825443	PRJNA627467_P_NODE_7540_length_231_cov_3.708791_g7471_i0	PRJNA627467	7540	231	3.708791	8.56730721	Potyvirus citrulli	3240504	Viruses	Viruses	418	1.7699999999999994e-112	NTclustered	gi\|268628057\|gb\|FJ823122.1\|	146500	g7471	i0	99.563	79.1774891774892	229	1	99	0	3	231	869	1097	Watermelon mosaic virus isolate Lecce, complete genome	blastn	18290	418	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus citrulli

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