metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
275366	275366	PRJNA1120203_P_NODE_78421_length_251_cov_0.865169_g77405_i0	PRJNA1120203	78421	251	0.865169	2.17157419	Micromonas commoda virus	3057169	Viruses	Viruses	152	2.18e-32	NTclustered	gi\|2747347731\|gb\|PP911589.1\|	3057169	g77405	i0	83.636	0.657370517928287	165	24	66	1	86	250	187247	187086	Micromonas commoda virus isolate McV-KB2 genomic sequence	blastn	165	152	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Micromonas commoda virus
15055894	15055894	PRJNA1120203_P_NODE_89732_length_247_cov_0.885057_g88716_i0	PRJNA1120203	89732	247	0.885057	2.18609079	Prasinovirus	181084	Viruses	Viruses	418	1.9099999999999998e-112	NTclustered	gi\|937663016\|gb\|KP874736.1\|	1663208	g88716	i0	97.166	12.1174089068826	247	7	100	0	1	247	40428	40674	Ostreococcus lucimarinus virus 2 isolate Olv2, complete genome	blastn	2993	418	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus lucimarinus virus 2
16330459	16330459	PRJNA1120203_P_NODE_64793_length_280_cov_1.024155_g63777_i0	PRJNA1120203	64793	280	1.024155	2.867634	Prasinovirus	181084	Viruses	Viruses	346	1.0599999999999999e-90	NTclustered	gi\|312599355\|gb\|HM004431.1\|	880162	g63777	i0	89.17	22.9571428571429	277	30	99	0	4	280	178880	178604	Ostreococcus lucimarinus virus OlV1, complete genome	blastn	6428	346	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus lucimarinus virus 1
16852960	16852960	PRJNA1120203_P_NODE_99454_length_243_cov_0.905882_g98438_i0	PRJNA1120203	99454	243	0.905882	2.20129326	Micromonas commoda virus	3057169	Viruses	Viruses	375	1.14e-99	NTclustered	gi\|2747347731\|gb\|PP911589.1\|	3057169	g98438	i0	94.628	0.995884773662551	242	13	99	0	1	242	50835	50594	Micromonas commoda virus isolate McV-KB2 genomic sequence	blastn	242	375	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Micromonas commoda virus
20676399	20676399	PRJNA1120203_P_NODE_51457_length_315_cov_1.272727_g50441_i0	PRJNA1120203	51457	315	1.272727	4.00909005	Micromonas commoda virus	3057169	Viruses	Viruses	479	1.1399999999999996e-130	NTclustered	gi\|2747347731\|gb\|PP911589.1\|	3057169	g50441	i0	94.249	0.993650793650794	313	18	99	0	1	313	108101	107789	Micromonas commoda virus isolate McV-KB2 genomic sequence	blastn	313	479	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Micromonas commoda virus
20676592	20676592	PRJNA1120203_P_NODE_65817_length_277_cov_1.509804_g64801_i0	PRJNA1120203	65817	277	1.509804	4.18215708	Micromonas commoda virus	3057169	Viruses	Viruses	407	4.72e-109	NTclustered	gi\|2528222004\|gb\|OQ440139.1\|	3057169	g64801	i0	93.141	3	277	19	100	0	1	277	489	213	Micromonas commoda virus isolate McV-KB2 DNA polymerase gene, partial cds	blastn	831	407	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Micromonas commoda virus
20676949	20676949	PRJNA1120203_P_NODE_89937_length_247_cov_0.885057_g88921_i0	PRJNA1120203	89937	247	0.885057	2.18609079	Ostreococcus tauri virus RT-2011	1120767	Viruses	Viruses	180	9.82e-41	NTclustered	gi\|378706107\|gb\|JN225873.1\|	1120767	g88921	i0	80.426	0.951417004048583	235	46	95	0	1	235	74576	74810	Ostreococcus tauri virus RT-2011, complete genome	blastn	235	180	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus tauri virus RT-2011

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