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

9 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
2385881	2385881	PRJNA505329_P_NODE_37302_length_176_cov_1.629921_g36831_i0	PRJNA505329	37302	176	1.629921	2.86866096	Tobamovirus	12234	Viruses	Viruses	307	2.87e-79	NTclustered	gi\|139866184\|dbj\|AB276030.1\|	12239	g36831	i0	98.844	92.5909090909091	173	1	98	1	4	175	4990	5162	Pepper mild mottle virus genomic RNA, complete genome, strain: L4BV	blastn	16296	307	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus capsici
3034725	3034725	PRJNA505329_P_NODE_52663_length_151_cov_5.480392_g52192_i0	PRJNA505329	52663	151	5.480392	8.27539192	Alphanodavirus flockense	3426214	Viruses	Viruses	279	5.19e-71	NTclustered	gi\|2775959247\|dbj\|LC831259.1\|	12287	g52192	i0	100	4.98675496688742	151	0	100	0	1	151	891	741	Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds	blastn	753	279	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
7488434	7488434	PRJNA505329_P_NODE_34586_length_180_cov_2.343511_g34115_i0	PRJNA505329	34586	180	2.343511	4.2183198	Wolframvirales	2732502	Viruses	Viruses	248	1.81e-61	NTclustered	gi\|2577295406\|gb\|OQ980198.1\|	2719503	g34115	i0	92.045	1.95	176	14	98	0	4	179	409	234	MAG: Downy mildew lesion associated splipalmivirus 2 isolate DMG-E segment RNA3, partial sequence	blastn	351	248	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Downy mildew lesion associated splipalmivirus 2
8136487	8136487	PRJNA505329_P_NODE_28867_length_189_cov_1.464286_g28396_i0	PRJNA505329	28867	189	1.464286	2.76750054	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	315	1.8699999999999998e-81	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g28396	i0	97.297	1.35449735449735	185	5	98	0	2	186	2844	3028	Malassezia restricta virus MrV40L, complete genome	blastn	256	315	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
9411756	9411756	PRJNA505329_P_NODE_7548_length_265_cov_3.606481_g7077_i0	PRJNA505329	7548	265	3.606481	9.55717465	Chemarfal virus 260	3063286	Viruses	Viruses	224	4.8499999999999997e-54	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g7077	i0	94.483	0.916981132075472	145	8	92	0	3	147	7	151	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	243	224	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
13237000	13237000	PRJNA505329_P_NODE_111_length_3140_cov_101.013911_g87_i0	PRJNA505329	111	3140	101.013911	3171.8368054	Alphanodavirus flockense	3426214	Viruses	Viruses	5655	0	NTclustered	gi\|2775959219\|dbj\|LC831249.1\|	12287	g87	i0	99.518	45.5630573248408	3109	12	99	3	5	3112	1	3107	Flock House virus TNCL gene for Protein A and Protein B2, segment RNA1, complete cds	blastn	143068	5655	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
13237454	13237454	PRJNA505329_P_NODE_46091_length_165_cov_1.784483_g45620_i0	PRJNA505329	46091	165	1.784483	2.94439695	Chemarfal virus 260	3063286	Viruses	Viruses	300	4.46e-77	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g45620	i0	99.398	1.00606060606061	166	0	100	1	1	165	779	944	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	166	300	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
15786336	15786336	PRJNA505329_P_NODE_5273_length_334_cov_3.210526_g4803_i0	PRJNA505329	5273	334	3.210526	10.72315684	Alphanodavirus flockense	3426214	Viruses	Viruses	603	6.929999999999998e-168	NTclustered	gi\|2775959247\|dbj\|LC831259.1\|	12287	g4803	i0	100	6.82035928143713	326	0	98	0	3	328	887	1212	Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds	blastn	2278	603	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
19609378	19609378	PRJNA505329_P_NODE_2996_length_524_cov_48.745263_g2559_i0	PRJNA505329	2996	524	48.745263	255.42517812	Alphanodavirus flockense	3426214	Viruses	Viruses	387	1.24e-102	NTclustered	gi\|152143030\|gb\|EF690538.1\|	12287	g2559	i0	99.528	6.66221374045802	212	1	94	0	4	215	42	253	Flock house virus isolate TNCL segment RNA2 protein alpha mRNA, complete cds	blastn	3491	387	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense

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