metadata: contig_metadata: 19 rows where bioproject = "PRJEB25583", tax_phylum = "Kitrinoviricota" and tax

19 rows where bioproject = "PRJEB25583", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

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
2572855	2572855	PRJEB25583_P_NODE_1643_length_333_cov_11.557432_g1466_i0	PRJEB25583	1643	333	11.557432	38.48624856	Luteoviridae sp.	1955165	Viruses	Viruses	281	3.68e-71	NTclustered	gi\|2836327433\|gb\|PQ161556.1\|	1955165	g1466	i0	82.857	7.04204204204204	315	52	94	2	20	333	1301	1614	MAG: Luteoviridae sp. isolate CS06 RNA-dependent RNA polymerase, coat protein VP1, and capsid protein genes, complete cds	blastn	2345	281	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
2572874	2572874	PRJEB25583_P_NODE_4383_length_195_cov_1.740506_g4206_i0	PRJEB25583	4383	195	1.740506	3.3939867	Tolivirales sp. gcode 6	3108923	Viruses	Viruses	285	1.5300000000000001e-72	NTclustered	gi\|2647550025\|gb\|OR843800.1\|	3108923	g4206	i0	97.041	0.866666666666667	169	5	87	0	13	181	1414	1246	Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds	blastn	169	285	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp. gcode 6
14051092	14051092	PRJEB25583_P_NODE_1332_length_382_cov_5.478261_g1156_i0	PRJEB25583	1332	382	5.478261	20.92695702	Orthornavirae	2732396	Viruses	Viruses	155	5.96e-41	NR	XII42506.1	1955165	g1156	i0	86.4	2.54450261780105	81	11	63.6	0	381	139	1021	1101	XII42506.1 MAG: RNA-dependent RNA polymerase [Luteoviridae sp.]	diamond	972	155	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
14051128	14051128	PRJEB25583_P_NODE_4952_length_184_cov_3.238095_g4775_i0	PRJEB25583	4952	184	3.238095	5.9580948	Tolivirales sp. gcode 6	3108923	Viruses	Viruses	261	2.39e-65	NTclustered	gi\|2647550025\|gb\|OR843800.1\|	3108923	g4775	i0	94.706	0.923913043478261	170	6	91	1	18	184	1765	1934	Tolivirales sp. gcode 6 strain MR233-17E/7345 hypothetical protein gene, partial cds; RNA-dependent RNA polymerase gene, complete cds; and structural protein gene, partial cds	blastn	170	261	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp. gcode 6
17874607	17874607	PRJEB25583_P_NODE_6515_length_164_cov_1.858268_g6338_i0	PRJEB25583	6515	164	1.858268	3.04755952	Lolavirus latenslolii	3430466	Viruses	Viruses	213	5.94e-51	NTclustered	gi\|169803200\|ref\|NC_010434.1\|	365150	g6338	i0	93.662	1.73170731707317	142	9	87	0	3	144	7642	7501	Lolium latent virus, complete genome	blastn	284	213	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Lolavirus	Lolavirus latenslolii
24248812	24248812	PRJEB25583_P_NODE_3020_length_233_cov_5.505102_g2843_i0	PRJEB25583	3020	233	5.505102	12.82688766	Luteoviridae sp.	1955165	Viruses	Viruses	213	9.04e-51	NTclustered	gi\|2171145475\|gb\|MZ218407.1\|	1955165	g2843	i0	84.834	2.05579399141631	211	32	91	0	21	231	3446	3656	MAG: Luteoviridae sp. isolate s48-k141_1520260 genomic sequence	blastn	479	213	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
27033117	27033117	PRJEB25583_P_NODE_1582_length_341_cov_15.259868_g1405_i0	PRJEB25583	1582	341	15.259868	52.03614988	Jasmine mosaic-associated virus 1	2293880	Viruses	Viruses	134	8.09e-34	NR	AXN91182.1	2293880	g1405	i0	55.6	1.87390029325513	108	48	95	0	330	7	338	445	AXN91182.1 RNA-dependent RNA polymerase [Jasmine mosaic-associated virus 1]	diamond	639	134	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Pelarspovirus	Pelarspovirus rosae
27096328	27096328	PRJEB25583_P_NODE_4322_length_196_cov_2.207547_g4145_i0	PRJEB25583	4322	196	2.207547	4.32679212	Luteoviridae sp.	1955165	Viruses	Viruses	50.8	2.77e-5	NR	UHS71977.1	1955165	g4145	i0	65.7	0.535714285714286	35	12	53.6	0	25	129	367	401	UHS71977.1 MAG: hypothetical protein 3 [Luteoviridae sp.]	diamond	105	50.8	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
27216143	27216143	PRJEB25583_P_NODE_1882_length_307_cov_10.922222_g1705_i0	PRJEB25583	1882	307	10.922222	33.53122154	Orthornavirae	2732396	Viruses	Viruses	136	1.19e-34	NR	UHS71978.1	1955165	g1705	i0	78.3	4.86644951140065	83	18	81.1	0	37	285	486	568	UHS71978.1 MAG: RNA-dependent RNA polymerase, partial [Luteoviridae sp.]	diamond	1494	136	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
27317815	27317815	PRJEB25583_P_NODE_3243_length_225_cov_0.994681_g3066_i0	PRJEB25583	3243	225	0.994681	2.23803225	Qianjiang tombus-like virus 183	3347850	Viruses	Viruses	94.4	1.77e-20	NR	XHA86821.1	3347850	g3066	i0	57.3	6	75	32	100	0	1	225	273	347	XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183]	diamond	1350	94.4	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Qianjiang tombus-like virus 183
27980817	27980817	PRJEB25583_P_NODE_8025_length_152_cov_3.721739_g7848_i0	PRJEB25583	8025	152	3.721739	5.65704328	Ginkgo biloba tombusvirus	2739248	Viruses	Viruses	82	1.4e-16	NR	QKI28841.1	2739248	g7848	i0	84.1	0.868421052631579	44	7	86.8	0	132	1	418	461	QKI28841.1 hypothetical protein 2 [Ginkgo biloba tombusvirus]	diamond	132	82	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Tombusvirus	Ginkgo biloba tombusvirus
28517608	28517608	PRJEB25583_P_NODE_3727_length_209_cov_5.029070_g3550_i0	PRJEB25583	3727	209	5.02907	10.5107563	Luteoviridae sp.	1955165	Viruses	Viruses	115	5.93e-28	NR	UHS71969.1	1955165	g3550	i0	84.1	3.61722488038277	63	10	90.4	0	21	209	753	815	UHS71969.1 MAG: hypothetical protein 1 [Luteoviridae sp.]	diamond	756	115	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
28984986	28984986	PRJEB25583_P_NODE_3428_length_218_cov_5.077348_g3251_i0	PRJEB25583	3428	218	5.077348	11.06861864	Pelarspovirus	1911602	Viruses	Viruses	51.6	2.01e-5	NR	AXN91182.1	2293880	g3251	i0	61	1.72018348623853	41	15	56.4	1	123	1	358	397	AXN91182.1 RNA-dependent RNA polymerase [Jasmine mosaic-associated virus 1]	diamond	375	52	0.992307692307692	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Pelarspovirus	Pelarspovirus rosae
30033293	30033293	PRJEB25583_P_NODE_6111_length_168_cov_4.061069_g5934_i0	PRJEB25583	6111	168	4.061069	6.82259592	Luteoviridae sp.	1955165	Viruses	Viruses	96.3	1.85e-21	NR	UHS71969.1	1955165	g5934	i0	89.8	3.5	49	5	87.5	0	21	167	306	354	UHS71969.1 MAG: hypothetical protein 1 [Luteoviridae sp.]	diamond	588	96.3	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
30254640	30254640	PRJEB25583_P_NODE_2212_length_277_cov_13.641667_g2035_i0	PRJEB25583	2212	277	13.641667	37.78741759	Luteoviridae sp.	1955165	Viruses	Viruses	92.4	1.98e-19	NR	UHS71948.1	1955165	g2035	i0	57.3	0.963898916967509	89	37	96.4	1	10	276	224	311	UHS71948.1 MAG: hypothetical protein 1 [Luteoviridae sp.]	diamond	267	92.4	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
30381133	30381133	PRJEB25583_P_NODE_2633_length_251_cov_4.191589_g2456_i0	PRJEB25583	2633	251	4.191589	10.52088839	Luteoviridae sp.	1955165	Viruses	Viruses	58.5	1.12e-7	NR	UHS71953.1	1955165	g2456	i0	48.7	0.908366533864542	76	35	90.8	1	24	251	314	385	UHS71953.1 MAG: hypothetical protein 1, partial [Luteoviridae sp.]	diamond	228	58.5	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
30759944	30759944	PRJEB25583_P_NODE_3394_length_219_cov_14.730769_g3217_i0	PRJEB25583	3394	219	14.730769	32.26038411	Qianjiang tombus-like virus 183	3347850	Viruses	Viruses	70.1	6.03e-12	NR	XHA86821.1	3347850	g3217	i0	47.1	1.91780821917808	70	37	95.9	0	211	2	3	72	XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183]	diamond	420	70.1	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Qianjiang tombus-like virus 183
31512283	31512283	PRJEB25583_P_NODE_2816_length_241_cov_7.500000_g2639_i0	PRJEB25583	2816	241	7.5	18.075	Orthornavirae	2732396	Viruses	Viruses	52	1.93e-5	NR	UHS71987.1	1955165	g2639	i0	51	1.19502074688797	49	23	59.8	1	4	147	333	381	UHS71987.1 MAG: hypothetical protein 3 [Luteoviridae sp.]	diamond	288	52.4	0.99236641221374	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.
31898082	31898082	PRJEB25583_P_NODE_7457_length_156_cov_2.764706_g7280_i0	PRJEB25583	7457	156	2.764706	4.31294136	Luteoviridae sp.	1955165	Viruses	Viruses	75.5	2.59e-14	NR	UHS71971.1	1955165	g7280	i0	76.6	0.903846153846154	47	11	90.4	0	2	142	206	252	UHS71971.1 MAG: hypothetical protein 3 [Luteoviridae sp.]	diamond	141	75.5	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Luteoviridae sp.

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