metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_phylum = "Pisuviricota"

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
926799	926799	PRJNA946307_P_NODE_1_length_8287_cov_76.507162_g0_i0	PRJNA946307	1	8287	76.507162	6340.14851494	Dicistroviridae sp.	1955144	Viruses	Viruses	2486	0	NR	XCO49139.1	1955144	g0	i0	79.1	0.558947749487149	1544	239	53.5	7	1759	6195	1	1525	XCO49139.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	4632	2486	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
26740170	26740170	PRJNA946307_P_NODE_81121_length_193_cov_3.034722_g80247_i0	PRJNA946307	81121	193	3.034722	5.85701346	Dicistroviridae sp.	1955144	Viruses	Viruses	47.4	4.35e-4	NR	XCO49265.1	1955144	g80247	i0	69	1.33678756476684	29	9	45.1	0	9	95	489	517	XCO49265.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	258	47.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
27214825	27214825	PRJNA946307_P_NODE_117842_length_176_cov_1.598425_g116968_i0	PRJNA946307	117842	176	1.598425	2.813228	Scotland dicistro-like virus	2789512	Viruses	Viruses	53.5	2.37e-6	NR	QPN36963.1	2789512	g116968	i0	77.1	0.596590909090909	35	8	59.7	0	162	58	1886	1920	QPN36963.1 polyprotein 1 [Scotland dicistro-like virus]	diamond	105	53.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Scotland dicistro-like virus
27569174	27569174	PRJNA946307_P_NODE_108624_length_180_cov_2.183206_g107750_i0	PRJNA946307	108624	180	2.183206	3.9297708	Orthopicobirnavirus	2948851	Viruses	Viruses	53.5	2.42e-6	NR	USE07769.1	1907787	g107750	i0	58.3	3.46666666666667	36	15	60	0	121	14	339	374	USE07769.1 MAG: putative RNA-dependent RNA polymerase, partial [Picobirnavirus sp.]	diamond	624	53.5	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Picobirnaviridae	Orthopicobirnavirus	Picobirnavirus sp.
28193886	28193886	PRJNA946307_P_NODE_89746_length_189_cov_1.321429_g88872_i0	PRJNA946307	89746	189	1.321429	2.49750081	Panax cryptic virus 4	2809267	Viruses	Viruses	56.6	2.25e-7	NR	QRG29207.1	2809267	g88872	i0	74.2	0.492063492063492	31	8	49.2	0	15	107	225	255	QRG29207.1 putative CP [Panax cryptic virus 4]	diamond	93	56.6	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Panax cryptic virus 4
29299175	29299175	PRJNA946307_P_NODE_28749_length_241_cov_5.958333_g27875_i0	PRJNA946307	28749	241	5.958333	14.35958253	Shenzhen dicistro-like virus	2789378	Viruses	Viruses	66.6	1.45e-10	NR	QPG92982.1	2789378	g27875	i0	45.6	1.96680497925311	79	38	92.1	2	223	2	792	870	QPG92982.1 polyprotein [Shenzhen dicistro-like virus]	diamond	474	66.6	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Shenzhen dicistro-like virus
30657311	30657311	PRJNA946307_P_NODE_35773_length_220_cov_6.198830_g34899_i0	PRJNA946307	35773	220	6.19883	13.637426	Trichoderma citrinoviride partitivirus 1	2501046	Viruses	Viruses	109	7.36e-26	NR	AZT88592.1	2501046	g34899	i0	79.4	0.927272727272727	68	13	91.4	1	216	16	560	627	AZT88592.1 RNA-dependent RNA polymerase [Trichoderma citrinoviride partitivirus 1]	diamond	204	109	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Trichoderma citrinoviride partitivirus 1
31068286	31068286	PRJNA946307_P_NODE_4295_length_705_cov_23.233232_g3654_i0	PRJNA946307	4295	705	23.233232	163.7942856	Dicistroviridae sp.	1955144	Viruses	Viruses	73.9	4.38e-11	NR	QJI52110.1	1955144	g3654	i0	36.1	0.659574468085106	155	83	61.7	5	653	219	689	837	QJI52110.1 MAG: hypothetical protein 2 [Dicistroviridae sp.]	diamond	465	73.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
31795217	31795217	PRJNA946307_P_NODE_46197_length_210_cov_4.596273_g45323_i0	PRJNA946307	46197	210	4.596273	9.6521733	Beet ringspot virus	191547	Viruses	Viruses	59.3	3.45e-8	NR	NP_620113.1	191547	g45323	i0	84.4	3.2	32	5	45.7	0	111	206	465	496	NP_620113.1 polyprotein [Beet ringspot virus]	diamond	672	59.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus betae
32111835	32111835	PRJNA946307_P_NODE_172038_length_154_cov_2.704762_g171164_i0	PRJNA946307	172038	154	2.704762	4.16533348	Periplaneta americana dicistro-like virus	3032225	Viruses	Viruses	87.4	1.92e-18	NR	DBA56413.1	3032225	g171164	i0	95.6	0.876623376623377	45	2	87.7	0	15	149	656	700	DBA56413.1 TPA_asm: hypothetical protein, partial [Periplaneta americana dicistro-like virus]	diamond	135	87.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Periplaneta americana dicistro-like virus
32555154	32555154	PRJNA946307_P_NODE_84999_length_191_cov_1.943662_g84125_i0	PRJNA946307	84999	191	1.943662	3.71239442	Paris mosaic necrosis virus	2058396	Viruses	Viruses	93.6	2.32e-20	NR	WYJ74782.1	2058396	g84125	i0	75.4	0.895287958115183	57	14	89.5	0	16	186	251	307	WYJ74782.1 putative RNA-dependent RNA polymerase [Paris mosaic necrosis virus]	diamond	171	93.6	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus parisnecrosis

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