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

9 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax_kingdom = "Orthornavirae"

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
4199017	4199017	PRJNA285816_S_NODE_13424_length_208_cov_0.981132_g13322_i0	PRJNA285816	13424	208	0.981132	2.04075456	Betacoronavirus pandemicum	3418604	Viruses	Viruses	76.8	1.08e-9	NTclustered	gi\|2565365187\|emb\|OY637518.1\|	2697049	g13322	i0	100	21.0913461538462	41	0	20	0	1	41	11672	11632	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	4387	76.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
8025231	8025231	PRJNA285816_S_NODE_18207_length_186_cov_5.532847_g18105_i0	PRJNA285816	18207	186	5.532847	10.29109542	Betacoronavirus pandemicum	3418604	Viruses	Viruses	60.2	9.5e-5	NTclustered	gi\|2560517252\|emb\|OY702345.1\|	2697049	g18105	i0	100	4.98924731182796	32	0	17	0	155	186	26488	26519	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	928	60.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
12537624	12537624	PRJNA285816_S_NODE_17610_length_189_cov_1.042857_g17508_i0	PRJNA285816	17610	189	1.042857	1.97099973	Viruses	10239	Viruses	Viruses	71.3	4.48e-8	NTclustered	gi\|2167415105\|tpg\|BK059322.1\|	12271	g17508	i0	100	23.2380952380952	38	0	20	0	152	189	39	2	TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence	blastn	4392	71.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus arabis
13125698	13125698	PRJNA285816_S_NODE_12151_length_215_cov_1.566265_g12049_i0	PRJNA285816	12151	215	1.566265	3.36746975	Sopawol virus	3131668	Viruses	Viruses	274	3.72e-69	NTclustered	gi\|2717323098\|gb\|PP173969.1\|	3131668	g12049	i0	90.431	44.0837209302326	209	18	97	2	1	208	325	118	MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence	blastn	9478	274	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes				Sopawol virus
13125708	13125708	PRJNA285816_S_NODE_12911_length_211_cov_0.962963_g12809_i0	PRJNA285816	12911	211	0.962963	2.03185193	Betacoronavirus pandemicum	3418604	Viruses	Viruses	63.9	8.56e-6	NTclustered	gi\|2557389902\|emb\|OY653400.1\|	2697049	g12809	i0	97.368	17.0758293838863	38	0	18	1	175	211	19642	19679	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	3603	63.9	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
16949512	16949512	PRJNA285816_S_NODE_4914_length_309_cov_23.915385_g4812_i0	PRJNA285816	4914	309	23.915385	73.89853965	Chrocagost virus	3129398	Viruses	Viruses	296	1.21e-75	NTclustered	gi\|2717317482\|gb\|PP171846.1\|	3129398	g4812	i0	88.525	202.236245954693	244	28	79	0	5	248	5619	5862	MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence	blastn	62491	296	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocagost virus
19497843	19497843	PRJNA285816_S_NODE_14416_length_202_cov_36.084967_g14314_i0	PRJNA285816	14416	202	36.084967	72.89163334	Nepovirus arabis	3047374	Viruses	Viruses	75	3.75e-9	NTclustered	gi\|2167415105\|tpg\|BK059322.1\|	12271	g14314	i0	97.674	19.4207920792079	43	1	21	0	1	43	2	44	TPA_asm: Arabis mosaic virus isolate SRR5788585_ArMV segment RNA1, complete sequence	blastn	3923	75	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Secoviridae	Nepovirus	Nepovirus arabis
20773655	20773655	PRJNA285816_S_NODE_8097_length_251_cov_1.514851_g7995_i0	PRJNA285816	8097	251	1.514851	3.80227601	Coguvirus henanense	3059897	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2058277675\|dbj\|LC636074.1\|	2034157	g7995	i0	100	0.231075697211155	30	0	12	0	222	251	31	2	Watermelon crinkle leaf-associated virus 2 Ju-01-WCLaV2 MP gene for putative movement protein, complete cds	blastn	58	56.5	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Coguvirus	Coguvirus henanense
23323897	23323897	PRJNA285816_S_NODE_10839_length_224_cov_1.771429_g10737_i0	PRJNA285816	10839	224	1.771429	3.96800096	Betacoronavirus pandemicum	3418604	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2557646044\|emb\|OY675404.1\|	2697049	g10737	i0	100	9.12053571428571	30	0	13	0	195	224	18438	18467	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	2043	56.5	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum

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