metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB28062" 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
6402931	6402931	PRJEB28062_P_NODE_4286_length_1946_cov_15.023492_g3295_i0	PRJEB28062	4286	1946	15.023492	292.35715432	Viruses	10239	Viruses	Viruses	788	9.45e-280	NR	WWV86528.1	1955170	g3295	i0	62.2	2.7934224049332	603	227	92.8	1	1856	51	2	604	WWV86528.1 MAG: reverse transcriptase-like protein [Partitiviridae sp.]	diamond	5436	795	0.991194968553459	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
21700299	21700299	PRJEB28062_P_NODE_1078_length_4484_cov_331.484697_g511_i0	PRJEB28062	1078	4484	331.484697	14863.77381348	Picornavirales	464095	Viruses	Viruses	506	8.079999999999998e-156	NR	NP_044946.1	64279	g511	i0	35.7	4.57560214094558	978	492	62.8	25	3083	267	16	895	NP_044946.1 capsid polyprotein, partial [Drosophila C virus]	diamond	20517	509	0.994106090373281	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
26716246	26716246	PRJEB28062_P_NODE_4101_length_1990_cov_251.032864_g3132_i0	PRJEB28062	4101	1990	251.032864	4995.5539936	Cripavirus sp.	1955141	Viruses	Viruses	100	9.91e-18	NR	ULF99876.1	1955141	g3132	i0	33.9	0.382914572864322	127	84	19.1	0	1581	1961	405	531	ULF99876.1 MAG: hypothetical protein 1 [Cripavirus sp.]	diamond	762	100	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus sp.
27665235	27665235	PRJEB28062_P_NODE_23024_length_779_cov_1.797450_g20848_i0	PRJEB28062	23024	779	1.79745	14.0021355	Cripavirus sp.	1955141	Viruses	Viruses	53.5	5.34e-4	NR	ULF99863.1	1955141	g20848	i0	27	1.82156611039795	237	160	87	4	697	20	754	988	ULF99863.1 MAG: putative replicase polyprotein [Cripavirus sp.]	diamond	1419	53.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus sp.
28138903	28138903	PRJEB28062_P_NODE_12365_length_1092_cov_517.991168_g10631_i0	PRJEB28062	12365	1092	517.991168	5656.46355456	Dicistroviridae sp.	1955144	Viruses	Viruses	152	2.27e-36	NR	XCO48968.1	1955144	g10631	i0	30.4	1.5989010989011	309	201	83	4	1060	155	445	746	XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.]	diamond	1746	152	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
28517645	28517645	PRJEB28062_P_NODE_5147_length_1765_cov_24.368794_g4063_i0	PRJEB28062	5147	1765	24.368794	430.1092141	Xiaogan partiti-like virus 1	2970246	Viruses	Viruses	429	4.27e-141	NR	UUW20933.1	2970246	g4063	i0	44	0.892351274787535	525	289	89.2	3	1675	101	4	523	UUW20933.1 MAG: coat protein [Xiaogan partiti-like virus 1]	diamond	1575	429	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Xiaogan partiti-like virus 1
30121384	30121384	PRJEB28062_P_NODE_59632_length_454_cov_1.501312_g57273_i0	PRJEB28062	59632	454	1.501312	6.81595648	Danio blood picornavirus/Zebrafish picornavirus 2	3063761	Viruses	Viruses	115	2.06e-26	NR	YP_009104360.1	3063761	g57273	i0	47.7	4.44052863436123	132	66	85.2	3	431	45	765	896	YP_009104360.1 polyprotein [Crohivirus A]	diamond	2016	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Crohivirus	Danio blood picornavirus/Zebrafish picornavirus 2
31518641	31518641	PRJEB28062_P_NODE_113776_length_276_cov_3.133005_g111413_i0	PRJEB28062	113776	276	3.133005	8.6470938	Dicistroviridae sp.	1955144	Viruses	Viruses	118	1.23e-28	NR	XCO48987.1	1955144	g111413	i0	76.1	0.771739130434783	71	17	77.2	0	253	41	308	378	XCO48987.1 MAG: putative ORF2 protein [Dicistroviridae sp.]	diamond	213	118	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
32366454	32366454	PRJEB28062_P_NODE_93619_length_334_cov_1.973180_g91257_i0	PRJEB28062	93619	334	1.97318	6.5904212	Viruses	10239	Viruses	Viruses	110	1.33e-25	NR	XCO49233.1	1955144	g91257	i0	48.6	6.8622754491018	109	56	97.9	0	1	327	226	334	XCO49233.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.]	diamond	2292	110	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae 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);;