metadata: contig_metadata: 5 rows where bioproject = "PRJNA753112" and tax

5 rows where bioproject = "PRJNA753112" 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
23681701	23681701	PRJNA753112_P_NODE_10859_length_412_cov_1.097345_g10517_i0	PRJNA753112	10859	412	1.097345	4.5210614	Ophiovirus mirafioriense	2170048	Viruses	Viruses	750	0	NTclustered	gi\|28626244\|gb\|AF532872.1\|	200255	g10517	i0	99.515	52.5946601941748	412	2	100	0	1	412	14	425	Mirafiori lettuce virus coat protein (cp) gene, complete cds	blastn	21669	750	1	Viruses	Orthornavirae	Negarnaviricota	Milneviricetes	Naedrevirales	Aspiviridae	Ophiovirus	Ophiovirus mirafioriense
27157211	27157211	PRJNA753112_P_NODE_382_length_2235_cov_4.640148_g286_i0	PRJNA753112	382	2235	4.640148	103.7073078	Cystovirus	10878	Viruses	Viruses	126	4.47e-26	NR	QYF49781.1	2824592	g286	i0	37.9	0.479194630872483	177	103	23.8	2	540	10	9	178	QYF49781.1 MAG: putative RNA-dependent RNA polymerase [Sichuan farmland cysto-like virus]	diamond	1071	127	0.992125984251969	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Sichuan farmland cysto-like virus
29705036	29705036	PRJNA753112_P_NODE_8710_length_461_cov_2.095361_g8368_i0	PRJNA753112	8710	461	2.095361	9.65961421	Red mite associated cystovirus	2936548	Viruses	Viruses	156	3.15e-41	NR	UQT02510.1	2936548	g8368	i0	49.7	0.995661605206074	153	72	98.9	2	3	458	210	358	UQT02510.1 P2 [Red mite associated cystovirus]	diamond	459	156	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Cystovirus	Red mite associated cystovirus
30811177	30811177	PRJNA753112_P_NODE_4194_length_665_cov_3.905405_g3861_i0	PRJNA753112	4194	665	3.905405	25.97094325	Pseudomonas phage phi12	161736	Viruses	Viruses	91.7	1.83e-18	NR	NP_690829.1	161736	g3861	i0	36.9	0.793984962406015	176	100	75.3	6	110	610	70	243	NP_690829.1 muramidase [Pseudomonas phage phi12]	diamond	528	91.7	1	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae	Betacystovirus	Betacystovirus phi12
31485047	31485047	PRJNA753112_P_NODE_3256_length_758_cov_3.210219_g2940_i0	PRJNA753112	3256	758	3.210219	24.33346002	Cystovirus	10878	Viruses	Viruses	148	2.32e-38	NR	UNI73393.1	2917704	g2940	i0	35.6	1.70976253298153	216	134	85.5	3	13	660	191	401	UNI73393.1 RNA dependent RNA polymerase [Pseudomonas phage ER16]	diamond	1296	149	0.993288590604027	Viruses	Orthornavirae	Duplornaviricota	Vidaverviricetes	Mindivirales	Cystoviridae		Pseudomonas phage ER16

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