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

5 rows where bioproject = "PRJNA546018" and tax_phylum = "Kitrinoviricota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1786852	1786852	PRJNA546018_S_NODE_60062_length_191_cov_4.476923_g59737_i0	PRJNA546018	60062	191	4.476923	8.55092293	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.005	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g59737	i0	100	0.151832460732984	29	0	15	0	163	191	44	16	Carnation latent virus isolate KL, complete genome	blastn	29	54.7	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
4338193	4338193	PRJNA546018_S_NODE_47704_length_220_cov_2.018868_g47379_i0	PRJNA546018	47704	220	2.018868	4.4415096	Tobamovirus tabaci	3432891	Viruses	Viruses	348	2.2200000000000005e-91	NTclustered	gi\|2647550519\|gb\|OR843964.1\|	12242	g47379	i0	98.485	89.4181818181818	198	2	90	1	1	197	742	545	Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds	blastn	19672	348	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
5614606	5614606	PRJNA546018_S_NODE_22505_length_338_cov_6.541516_g22180_i0	PRJNA546018	22505	338	6.541516	22.11032408	Wuhan aphid virus 1	1746067	Viruses	Viruses	313	1.33e-80	NTclustered	gi\|943496544\|gb\|KR902723.1\|	1746067	g22180	i0	84.543	1.87573964497041	317	47	93	2	1	316	1507	1192	Wuhan aphid virus 1 strain WHYC-1 segment 3, complete sequence	blastn	634	313	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Wuhan aphid virus 1
11322320	11322320	PRJNA546018_S_NODE_38009_length_250_cov_6.211640_g37684_i0	PRJNA546018	38009	250	6.21164	15.5291	Tobamovirus	12234	Viruses	Viruses	425	1.16e-114	NTclustered	gi\|1821461776\|gb\|MN267897.1\|	12239	g37684	i0	99.571	86.024	233	1	93	0	1	233	3830	3598	Pepper mild mottle virus isolate PMMoV_WW17-E1-Nben-pos, complete genome	blastn	21506	425	1	Viruses		Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus capsici
24736975	24736975	PRJNA546018_S_NODE_35060_length_262_cov_2.099502_g34735_i0	PRJNA546018	35060	262	2.099502	5.50069524	Wuhan aphid virus 1	1746067	Viruses	Viruses	272	1.69e-68	NTclustered	gi\|1817956135\|dbj\|LC516841.1\|	1746067	g34735	i0	87.654	2.75954198473282	243	19	90	8	24	258	2314	2553	Wuhan aphid virus 1 06BaA3 gene for non-structural protein 2, complete cds	blastn	723	272	1	Viruses	Jingmenvirus group	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae		Wuhan aphid 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);;