metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_kingdom = "Pararnavirae"

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
3477818	3477818	PRJNA946307_P_NODE_31483_length_232_cov_6.453552_g30609_i0	PRJNA946307	31483	232	6.453552	14.97224064	Pinus nigra virus 1	2267679	Viruses	Viruses	158	4.27e-34	NTclustered	gi\|1421686372\|gb\|MH551473.1\|	2267679	g30609	i0	94.175	2.625	103	6	88	0	116	218	3831	3729	Pinus nigra virus 1 isolate S1, complete genome	blastn	609	158	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
4754810	4754810	PRJNA946307_P_NODE_151804_length_164_cov_2.260870_g150930_i0	PRJNA946307	151804	164	2.26087	3.7078268	Pinus nigra virus 1	2267679	Viruses	Viruses	174	2.8e-39	NTclustered	gi\|1421686372\|gb\|MH551473.1\|	2267679	g150930	i0	87.582	2.79878048780488	153	16	91	2	15	164	137	289	Pinus nigra virus 1 isolate S1, complete genome	blastn	459	174	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
8912597	8912597	PRJNA946307_P_NODE_111887_length_179_cov_1.307692_g111013_i0	PRJNA946307	111887	179	1.307692	2.34076868	Gammaretrovirus	153135	Viruses	Viruses	268	1.3799999999999999e-67	NTclustered	gi\|331934\|gb\|J02255.1\|MLMCG	11786	g111013	i0	98.675	2.53072625698324	151	2	84	0	15	165	4593	4443	Moloney murine leukemia virus, complete genome	blastn	453	268	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Retroviridae	Gammaretrovirus	Gammaretrovirus murleu
12405327	12405327	PRJNA946307_P_NODE_139230_length_167_cov_2.432203_g138356_i0	PRJNA946307	139230	167	2.432203	4.06177901	Pinus nigra virus 1	2267679	Viruses	Viruses	158	2.89e-34	NTclustered	gi\|1421686372\|gb\|MH551473.1\|	2267679	g138356	i0	88.976	2.2814371257485	127	14	76	0	37	163	830	956	Pinus nigra virus 1 isolate S1, complete genome	blastn	381	158	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
20054182	20054182	PRJNA946307_P_NODE_57316_length_210_cov_2.720497_g56442_i0	PRJNA946307	57316	210	2.720497	5.7130437	Pinus nigra virus 1	2267679	Viruses	Viruses	67.6	6.58e-7	NTclustered	gi\|1421686372\|gb\|MH551473.1\|	2267679	g56442	i0	97.436	0.557142857142857	39	1	19	0	172	210	6880	6918	Pinus nigra virus 1 isolate S1, complete genome	blastn	117	67.6	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
21328628	21328628	PRJNA946307_P_NODE_159977_length_162_cov_2.530973_g159103_i0	PRJNA946307	159977	162	2.530973	4.10017626	Pinus nigra virus 1	2267679	Viruses	Viruses	207	2.72e-49	NTclustered	gi\|1571847622\|ref\|NC_040841.1\|	2267679	g159103	i0	91.892	2.7283950617284	148	12	91	0	15	162	577	724	Pinus nigra virus 1 isolate B2, complete genome	blastn	442	207	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
22603391	22603391	PRJNA946307_P_NODE_145958_length_166_cov_0.871795_g145084_i0	PRJNA946307	145958	166	0.871795	1.4471797	Pinus nigra virus 1	2267679	Viruses	Viruses	187	3.65e-43	NTclustered	gi\|1421686370\|gb\|MH551472.1\|	2267679	g145084	i0	89.404	2.70481927710843	151	12	90	3	4	152	6060	5912	Pinus nigra virus 1 isolate BM, complete genome	blastn	449	187	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
23880411	23880411	PRJNA946307_P_NODE_77059_length_196_cov_3.217687_g76185_i0	PRJNA946307	77059	196	3.217687	6.30666652	Pinus nigra virus 1	2267679	Viruses	Viruses	121	4.579999999999999e-23	NTclustered	gi\|1421686372\|gb\|MH551473.1\|	2267679	g76185	i0	88.119	1.54591836734694	101	12	52	0	96	196	2320	2420	Pinus nigra virus 1 isolate S1, complete genome	blastn	303	121	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1
25153242	25153242	PRJNA946307_P_NODE_33800_length_225_cov_8.727273_g32926_i0	PRJNA946307	33800	225	8.727273	19.63636425	Pinus nigra virus 1	2267679	Viruses	Viruses	222	1.44e-53	NTclustered	gi\|1571847622\|ref\|NC_040841.1\|	2267679	g32926	i0	91.358	2.16	162	14	72	0	19	180	6530	6369	Pinus nigra virus 1 isolate B2, complete genome	blastn	486	222	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae		Pinus nigra virus 1

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