metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA658591" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA658591" 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
625468	625468	PRJNA658591_S_NODE_1241_length_367_cov_134.295597_g1178_i0	PRJNA658591	1241	367	134.295597	492.86484099	Betacoronavirus pandemicum	3418604	Viruses	Viruses	71.3	9.62e-8	NTclustered	gi\|2565353280\|emb\|OY626164.1\|	2697049	g1178	i0	89.655	0.517711171662125	58	3	15	3	28	82	26558	26501	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	190	71.3	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
1901673	1901673	PRJNA658591_S_NODE_9482_length_165_cov_36.896552_g9419_i0	PRJNA658591	9482	165	36.896552	60.8793108	Orthoavulavirus javaense	3051375	Viruses	Viruses	63.9	6.37e-6	NTclustered	gi\|1810954291\|gb\|MN727300.2\|	2560319	g9419	i0	100	0.206060606060606	34	0	21	0	1	34	15286	15253	Avian paramyxovirus 1 isolate chicken/Indonesia/ITA/012WJ, complete genome	blastn	34	63.9	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthoavulavirus	Orthoavulavirus javaense
5728916	5728916	PRJNA658591_S_NODE_1445_length_342_cov_44.262799_g1382_i0	PRJNA658591	1445	342	44.262799	151.37877258	Betacoronavirus pandemicum	3418604	Viruses	Viruses	119	3.14e-22	NTclustered	gi\|2165835426\|emb\|OV196492.1\|	2697049	g1382	i0	94.872	6.5672514619883	78	1	22	2	1	75	61	138	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	2246	119	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
21028021	21028021	PRJNA658591_S_NODE_297_length_660_cov_210.075286_g158_i1	PRJNA658591	297	660	210.075286	1386.4968876	Betacoronavirus pandemicum	3418604	Viruses	Viruses	115	8.26e-21	NTclustered	gi\|2165836832\|emb\|OV197136.1\|	2697049	g158	i1	94.737	0.284848484848485	76	1	11	2	1	73	41	116	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	188	115	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
21028032	21028032	PRJNA658591_S_NODE_7337_length_180_cov_2.145038_g7274_i0	PRJNA658591	7337	180	2.145038	3.8610684	Ampelovirus tetravitis	3426346	Viruses	Viruses	62.1	2.54e-5	NTclustered	gi\|2452977696\|gb\|OP752675.1\|	70177	g7274	i0	100	0.338888888888889	33	0	18	0	148	180	13822	13854	Grapevine leafroll-associated virus 4 isolate LC9_N5, complete genome	blastn	61	62.1	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae	Ampelovirus	Ampelovirus tetravitis

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