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

5 rows where bioproject = "PRJNA416866" 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
419610	419610	PRJNA416866_P_NODE_1_length_8517_cov_6.467715_g0_i0	PRJNA416866	1	8517	6.467715	550.85528655	Cripavirus drosophilae	3047809	Viruses	Viruses	12273	0	NTclustered	gi\|1743646607\|gb\|MK645238.1\|	64279	g0	i0	97.938	19.9293178349184	7081	146	100	0	935	8015	8062	982	Drosophila C virus isolate CYG, complete genome	blastn	169738	12273	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
19545512	19545512	PRJNA416866_P_NODE_9496_length_209_cov_0.864865_g9352_i0	PRJNA416866	9496	209	0.864865	1.80756785	Eriocheir sinensis alphatetra-like virus	3022104	Viruses	Viruses	274	3.59e-69	NTclustered	gi\|2430285571\|gb\|OP019089.1\|	3022104	g9352	i0	90.385	0.995215311004785	208	20	99	0	1	208	9785	9578	MAG: Eriocheir sinensis alphatetra-like virus isolate Tangshan, Hebei genomic sequence	blastn	208	274	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Hepelivirales	Alphatetraviridae		Eriocheir sinensis alphatetra-like virus
20821389	20821389	PRJNA416866_P_NODE_3297_length_369_cov_2.571429_g3154_i0	PRJNA416866	3297	369	2.571429	9.48857301	Cripavirus drosophilae	3047809	Viruses	Viruses	632	9.839999999999998e-177	NTclustered	gi\|9629650\|ref\|NC_001834.1\|	64279	g3154	i0	97.568	13.4986449864499	370	8	100	1	1	369	385	16	Drosophila C virus strain EB, complete genome	blastn	4981	632	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
20821404	20821404	PRJNA416866_P_NODE_6757_length_250_cov_1.354497_g6613_i0	PRJNA416866	6757	250	1.354497	3.3862425	Eridge virus	1807812	Viruses	Viruses	429	8.949999999999998e-116	NTclustered	gi\|1003096245\|gb\|KU754528.1\|	1807812	g6613	i0	97.6	1.988	250	6	100	0	1	250	460	211	Eridge virus segment B putative replicase gene, complete cds	blastn	497	429	1	Viruses	Orthornavirae				Birnaviridae		Eridge virus
30392019	30392019	PRJNA416866_P_NODE_9333_length_210_cov_1.543624_g9189_i0	PRJNA416866	9333	210	1.543624	3.2416104	Moss partitivirus 7	3067240	Viruses	Viruses	94.7	1.1e-20	NR	WPR17416.1	3067240	g9189	i0	58	0.985714285714286	69	29	98.6	0	3	209	293	361	WPR17416.1 MAG: RNA-dependent RNA polymerase, partial [Moss partitivirus 7]	diamond	207	94.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Moss partitivirus 7

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