metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1034995" 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
2282812	2282812	PRJNA1034995_S_NODE_10242_length_1837_cov_107.579153_g9479_i1	PRJNA1034995	10242	1837	107.579153	1976.22904061	Moloney murine leukemia virus	11801	Viruses	Viruses	1057	0	NR	NP_057933.2	11801	g9479	i1	97.8	2.63091997822537	537	12	87.7	0	162	1772	799	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	4833	1057	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
25233943	25233943	PRJNA1034995_S_NODE_9480_length_2463_cov_92.640083_g9479_i0	PRJNA1034995	9480	2463	92.640083	2281.72524429	Moloney murine leukemia virus	11801	Viruses	Viruses	1294	0	NR	NP_057933.2	11801	g9479	i0	97.6	2.40803897685749	659	16	80.3	0	422	2398	677	1335	NP_057933.2 Pr180 [Moloney murine leukemia virus]	diamond	5931	1294	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
26845496	26845496	PRJNA1034995_S_NODE_20521_length_376_cov_5.393393_g20365_i0	PRJNA1034995	20521	376	5.393393	20.27915768	Adintovirus anguilla10665	3115889	Viruses	Viruses	116	2.42e-29	NR	DBA49780.1	3115889	g20365	i0	60.5	0.686170212765957	86	34	68.6	0	35	292	154	239	DBA49780.1 MAG TPA_asm: Penton [Adintovirus anguilla10665]	diamond	258	116	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguilla10665
27035135	27035135	PRJNA1034995_S_NODE_26882_length_298_cov_11.552941_g26726_i0	PRJNA1034995	26882	298	11.552941	34.42776418	Erythrocytic necrosis virus	1543320	Viruses	Viruses	86.7	2.37e-19	NR	QCF47480.1	1543320	g26726	i0	55.2	0.875838926174497	87	36	87.6	2	265	5	35	118	QCF47480.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	261	86.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
27193057	27193057	PRJNA1034995_S_NODE_12562_length_616_cov_22.815009_g12451_i0	PRJNA1034995	12562	616	22.815009	140.54045544	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	54.7	1.35e-5	NR	DAC81251.1	2609866	g12451	i0	24.3	0.701298701298701	144	105	70.1	3	538	107	1	140	DAC81251.1 TPA_asm: Bcl2 [Astyanax tetra cavefish adintovirus]	diamond	432	54.7	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Astyanax tetra cavefish adintovirus
27477555	27477555	PRJNA1034995_S_NODE_18603_length_409_cov_23.456284_g18448_i0	PRJNA1034995	18603	409	23.456284	95.93620156	Adintovirus anguilla10665	3115889	Viruses	Viruses	52.8	1.59e-5	NR	DAC81254.1	3115889	g18448	i0	75	0.205378973105134	28	7	20.5	0	201	284	15	42	DAC81254.1 TPA_asm: cupiennin [Astyanax tetra cavefish adintovirus]	diamond	84	52.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Adintovirus anguilla10665
27951233	27951233	PRJNA1034995_S_NODE_22485_length_348_cov_9.098361_g22329_i0	PRJNA1034995	22485	348	9.098361	31.66229628	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	119	7.519999999999999e-31	NR	DAC81259.1	2609866	g22329	i0	68.4	1.36206896551724	79	25	68.1	0	347	111	142	220	DAC81259.1 TPA_asm: FtsK [Astyanax tetra cavefish adintovirus]	diamond	474	119	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Astyanax tetra cavefish adintovirus
28645936	28645936	PRJNA1034995_S_NODE_20007_length_384_cov_4.334311_g19852_i0	PRJNA1034995	20007	384	4.334311	16.64375424	Erythrocytic necrosis virus	1543320	Viruses	Viruses	66.2	1.61e-10	NR	QCF47464.1	1543320	g19852	i0	97.1	0.265625	34	1	26.6	0	211	110	40	73	QCF47464.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	102	66.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
28921833	28921833	PRJNA1034995_S_NODE_44188_length_185_cov_14.971831_g44032_i0	PRJNA1034995	44188	185	14.971831	27.69788735	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	44.3	0.00503	NR	YP_010840939.1	2951531	g44032	i0	55.3	1.65405405405405	47	20	74.6	1	24	161	14	60	YP_010840939.1 L protein [Hardyhead chuvirus]	diamond	306	44.7	0.991051454138702	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus
29119638	29119638	PRJNA1034995_S_NODE_19529_length_392_cov_12.249284_g19374_i0	PRJNA1034995	19529	392	12.249284	48.01719328	Erythrocytic necrosis virus	1543320	Viruses	Viruses	144	4.69e-40	NR	QCF47454.1	1543320	g19374	i0	88.1	0.642857142857143	84	10	64.3	0	260	9	2	85	QCF47454.1 hypothetical protein, partial [Erythrocytic necrosis virus]	diamond	252	144	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
29877333	29877333	PRJNA1034995_S_NODE_14491_length_511_cov_33.794872_g14342_i0	PRJNA1034995	14491	511	33.794872	172.69179592	Erythrocytic necrosis virus	1543320	Viruses	Viruses	68.6	5.29e-12	NR	QCF47522.1	1543320	g14342	i0	82.9	0.434442270058708	35	6	20.5	0	310	206	2	36	QCF47522.1 hypothetical protein, partial [Erythrocytic necrosis virus]	diamond	222	68.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
30320077	30320077	PRJNA1034995_S_NODE_26112_length_305_cov_22.641221_g25956_i0	PRJNA1034995	26112	305	22.641221	69.05572405	Erythrocytic necrosis virus	1543320	Viruses	Viruses	86.7	3.23e-19	NR	QCF47477.1	1543320	g25956	i0	60.8	0.727868852459016	74	27	70.8	1	302	87	35	108	QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	222	86.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
30383132	30383132	PRJNA1034995_S_NODE_20053_length_383_cov_11.708824_g19898_i0	PRJNA1034995	20053	383	11.708824	44.84479592	Erythrocytic necrosis virus	1543320	Viruses	Viruses	65.1	1.98e-10	NR	QCF47477.1	1543320	g19898	i0	59.3	0.462140992167102	59	20	43.1	1	247	83	6	64	QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	177	65.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
32627340	32627340	PRJNA1034995_S_NODE_13340_length_559_cov_23.831395_g13201_i0	PRJNA1034995	13340	559	23.831395	133.21749805	Astyanax tetra cavefish adintovirus	2609866	Viruses	Viruses	50.1	4.87e-4	NR	DAC81251.1	2609866	g13201	i0	31.4	0.547406082289803	102	67	54.7	2	532	227	26	124	DAC81251.1 TPA_asm: Bcl2 [Astyanax tetra cavefish adintovirus]	diamond	306	50.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Astyanax tetra cavefish adintovirus
32658654	32658654	PRJNA1034995_S_NODE_19340_length_395_cov_29.125000_g19185_i0	PRJNA1034995	19340	395	29.125	115.04375	Erythrocytic necrosis virus	1543320	Viruses	Viruses	128	9.29e-36	NR	QCF47491.1	1543320	g19185	i0	74.4	1.28354430379747	86	21	65.3	1	284	27	14	98	QCF47491.1 RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	507	128	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus

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