metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB10140" 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
1287492	1287492	PRJEB10140_P_NODE_5842_length_2900_cov_16.327955_g3239_i0	PRJEB10140	5842	2900	16.327955	473.510695	Hokovirus HKV1	1977638	Viruses	Viruses	69.4	2.99e-6	NTclustered	gi\|1174571316\|gb\|KY684103.1\|	1977638	g3239	i0	79.798	0.0741379310344828	99	16	3	4	2272	2368	291912	292008	Hokovirus HKV1 isolate HKV1 clone Hokovirus_1, sequence	blastn	215	69.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
2563182	2563182	PRJEB10140_P_NODE_6703_length_2729_cov_15.950746_g3239_i1	PRJEB10140	6703	2729	15.950746	435.29585834	Hokovirus HKV1	1977638	Viruses	Viruses	69.4	2.81e-6	NTclustered	gi\|1174571316\|gb\|KY684103.1\|	1977638	g3239	i1	79.798	0.0787834371564676	99	16	4	4	533	629	292008	291912	Hokovirus HKV1 isolate HKV1 clone Hokovirus_1, sequence	blastn	215	69.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Hokovirus	Hokovirus HKV1
8940257	8940257	PRJEB10140_P_NODE_63968_length_573_cov_9.875954_g47058_i0	PRJEB10140	63968	573	9.875954	56.58921642	Mimivirus U306	1932880	Viruses	Viruses	58.4	0.001	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g47058	i0	97.059	0.383944153577661	34	1	6	0	197	230	882471	882438	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	220	58.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
12766944	12766944	PRJEB10140_P_NODE_791_length_6288_cov_583.893733_g350_i1	PRJEB10140	791	6288	583.893733	36715.23793104	Catovirus CTV1	1977631	Viruses	Viruses	67.6	2.35e-5	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g350	i1	75.94	0.0613867684478372	133	30	2	2	3036	3167	770734	770603	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	386	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
16588410	16588410	PRJEB10140_P_NODE_121554_length_301_cov_1.730159_g104247_i0	PRJEB10140	121554	301	1.730159	5.20777859	Mimivirus sp.	2742700	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2770799496\|gb\|PQ010613.1\|	2742700	g104247	i0	100	0.0930232558139535	28	0	9	0	127	154	117944	117917	Mimivirus sp. isolate 2401, partial genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus sp.
16588751	16588751	PRJEB10140_P_NODE_175174_length_217_cov_1.916667_g157865_i0	PRJEB10140	175174	217	1.916667	4.15916739	Megavirus chilense	3060301	Viruses	Viruses	54.7	0.005	NTclustered	gi\|444236153\|gb\|JX885207.1\|	1235314	g157865	i0	88.889	0.207373271889401	45	3	20	2	80	123	991502	991545	Megavirus lba isolate LBA111, complete genome	blastn	45	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
17864993	17864993	PRJEB10140_P_NODE_57655_length_636_cov_4.260647_g41118_i0	PRJEB10140	57655	636	4.260647	27.09771492	Mimivirus U306	1932880	Viruses	Viruses	54.7	0.018	NTclustered	gi\|1572561086\|emb\|LT717347.1\|	1932880	g41118	i0	96.97	0.0518867924528302	33	0	5	1	586	618	769201	769170	Mimivirus U306 genome assembly, complete genome: monopartite	blastn	33	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Mimivirus	Mimivirus U306
19138881	19138881	PRJEB10140_P_NODE_81576_length_449_cov_2.790000_g64318_i0	PRJEB10140	81576	449	2.79	12.5271	Siadenovirus ranae	3241308	Viruses	Viruses	52.8	0.043	NTclustered	gi\|9635795\|ref\|NC_002501.1\|	114102	g64318	i0	100	0.0623608017817372	28	0	6	0	419	446	11698	11671	Frog adenovirus 1, complete genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Siadenovirus	Siadenovirus ranae
20413878	20413878	PRJEB10140_P_NODE_617_length_6825_cov_532.022875_g350_i0	PRJEB10140	617	6825	532.022875	36310.56121875	Catovirus CTV1	1977631	Viruses	Viruses	67.6	2.55e-5	NTclustered	gi\|1174569070\|gb\|KY684083.1\|	1977631	g350	i0	75.94	0.0565567765567766	133	30	2	2	3659	3790	770603	770734	Catovirus CTV1 isolate CTV1 clone Catovirus_1, sequence	blastn	386	67.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus CTV1
24239310	24239310	PRJEB10140_P_NODE_820_length_6204_cov_463.671487_g464_i0	PRJEB10140	820	6204	463.671487	28766.17905348	Edafosvirus sp.	2487765	Viruses	Viruses	95.3	1.06e-13	NTclustered	gi\|1512472962\|gb\|MK072066.1\|	2487765	g464	i0	89.333	0.26611863313991	75	8	1	0	175	249	15274	15200	MAG: Edafosvirus sp. clone Edafosvirus_1 genomic sequence	blastn	1651	95.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus 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);;