metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax_kingdom = "Bamfordvirae"

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
26884294	26884294	PRJNA222400_P_NODE_4761_length_204_cov_1.303226_g4728_i0	PRJNA222400	4761	204	1.303226	2.65858104	Tupanvirus soda lake	2126985	Viruses	Viruses	57.4	1.34e-7	NR	YP_010782452.1	2126985	g4728	i0	37.9	0.970588235294118	66	40	95.6	1	199	5	233	298	YP_010782452.1 hypothetical protein QJ857_gp0255 [Tupanvirus soda lake]	diamond	198	57.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27263756	27263756	PRJNA222400_P_NODE_8643_length_164_cov_1.217391_g8610_i0	PRJNA222400	8643	164	1.217391	1.99652124	Gaeavirus sp.	2487767	Viruses	Viruses	63.5	5.8e-10	NR	AYV79987.1	2487767	g8610	i0	56.4	1.00609756097561	55	23	98.8	1	1	162	977	1031	AYV79987.1 MAG: mRNA capping enzyme [Gaeavirus sp.]	diamond	165	63.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
27706185	27706185	PRJNA222400_P_NODE_5804_length_186_cov_1.897810_g5771_i0	PRJNA222400	5804	186	1.89781	3.5299266	Edafosvirus sp.	2487765	Viruses	Viruses	50.1	4.57e-5	NR	AYV78427.1	2487765	g5771	i0	51.2	0.661290322580645	41	19	64.5	1	156	37	324	364	AYV78427.1 MAG: hypothetical protein Edafosvirus12_26 [Edafosvirus sp.]	diamond	123	50.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
28653052	28653052	PRJNA222400_P_NODE_6467_length_176_cov_1.637795_g6434_i0	PRJNA222400	6467	176	1.637795	2.8825192	Mimiviridae sp. ChoanoV1	2596887	Viruses	Viruses	69.7	3.55e-12	NR	QDY51649.1	2596887	g6434	i0	68.8	0.818181818181818	48	15	81.8	0	17	160	287	334	QDY51649.1 SIS domain protein [Mimiviridae sp. ChoanoV1]	diamond	144	69.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae		Mimiviridae sp. ChoanoV1
29063588	29063588	PRJNA222400_P_NODE_2768_length_287_cov_9.831933_g2735_i0	PRJNA222400	2768	287	9.831933	28.21764771	Gaeavirus sp.	2487767	Viruses	Viruses	67.4	2.07e-12	NR	AYV80119.1	2487767	g2735	i0	45.9	0.773519163763066	74	37	77.4	1	5	226	1	71	AYV80119.1 MAG: hypothetical protein Gaeavirus10_15 [Gaeavirus sp.]	diamond	222	67.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
29095181	29095181	PRJNA222400_P_NODE_6208_length_180_cov_1.206107_g6175_i0	PRJNA222400	6208	180	1.206107	2.1709926	Cotonvirus japonicus	2811091	Viruses	Viruses	49.7	5.61e-5	NR	YP_010841753.1	2811091	g6175	i0	35.1	2.88333333333333	57	37	95	0	2	172	422	478	YP_010841753.1 putative core protein [Cotonvirus japonicus]	diamond	519	49.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Cotonvirus	Cotonvirus japonicum
29126889	29126889	PRJNA222400_P_NODE_5549_length_190_cov_1.475177_g5516_i0	PRJNA222400	5549	190	1.475177	2.8028363	Tupanvirus soda lake	2126985	Viruses	Viruses	66.6	5.04e-11	NR	YP_010782452.1	2126985	g5516	i0	40.3	0.978947368421053	62	37	97.9	0	188	3	70	131	YP_010782452.1 hypothetical protein QJ857_gp0255 [Tupanvirus soda lake]	diamond	186	66.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
29158384	29158384	PRJNA222400_P_NODE_1189_length_473_cov_3.044811_g1156_i0	PRJNA222400	1189	473	3.044811	14.40195603	Indivirus ILV1	1977633	Viruses	Viruses	171	3.63e-47	NR	ARF09845.1	1977633	g1156	i0	62.6	0.830866807610994	131	41	81.8	2	83	469	469	593	ARF09845.1 NCLDV major capsid protein [Indivirus ILV1]	diamond	393	171	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
29379238	29379238	PRJNA222400_P_NODE_4609_length_207_cov_1.316456_g4576_i0	PRJNA222400	4609	207	1.316456	2.72506392	Gaeavirus sp.	2487767	Viruses	Viruses	74.3	1.03e-13	NR	AYV80256.1	2487767	g4576	i0	51.6	0.927536231884058	64	30	91.3	1	190	2	235	298	AYV80256.1 MAG: hypothetical protein Gaeavirus22_4 [Gaeavirus sp.]	diamond	192	74.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
30105464	30105464	PRJNA222400_P_NODE_3992_length_224_cov_0.891429_g3959_i0	PRJNA222400	3992	224	0.891429	1.99680096	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	43.5	0.0109	NR	CAK7597173.1	3072188	g3959	i0	43.4	0.709821428571429	53	26	65.6	1	148	2	28	80	CAK7597173.1 hypothetical protein IMIMIMCATVN1_00811 [Catovirus sp. 'naegleriensis']	diamond	159	43.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
30168576	30168576	PRJNA222400_P_NODE_6232_length_180_cov_1.038168_g6199_i0	PRJNA222400	6232	180	1.038168	1.8687024	Aureococcus anophagefferens virus	1474867	Viruses	Viruses	42	0.0289	NR	YP_009052085.1	1474867	g6199	i0	79.2	0.4	24	5	40	0	5	76	54	77	YP_009052085.1 hypothetical protein JO84_gp007 [Aureococcus anophagefferens virus]	diamond	72	42	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae	Kratosvirus	Kratosvirus quantuckense
31242976	31242976	PRJNA222400_P_NODE_5395_length_193_cov_1.083333_g5362_i0	PRJNA222400	5395	193	1.083333	2.09083269	Gaeavirus sp.	2487767	Viruses	Viruses	59.3	3.57e-9	NR	AYV79985.1	2487767	g5362	i0	44.3	0.948186528497409	61	34	94.8	0	11	193	3	63	AYV79985.1 MAG: hypothetical protein Gaeavirus4_8 [Gaeavirus sp.]	diamond	183	59.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
32558164	32558164	PRJNA222400_P_NODE_4039_length_222_cov_1.196532_g4006_i0	PRJNA222400	4039	222	1.196532	2.65630104	Mimiviridae	549779	Viruses	Viruses	92	7.34e-22	NR	ARF09403.1	1977633	g4006	i0	52.8	1.94594594594595	72	34	97.3	0	1	216	14	85	ARF09403.1 hypothetical protein Indivirus_1_26 [Indivirus ILV1]	diamond	432	92.8	0.991379310344828	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1

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