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

9 rows where analysis = "blastn", bioproject = "PRJNA473641" 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
445028	445028	PRJNA473641_P_NODE_1941_length_597_cov_3.654580_g1859_i0	PRJNA473641	1941	597	3.65458	21.8178426	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	1048	0	NTclustered	gi\|2754692633\|gb\|PP872994.1\|	3003959	g1859	i0	98.325	1	597	10	100	0	1	597	4756	4160	MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence	blastn	597	1048	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
1719638	1719638	PRJNA473641_P_NODE_11782_length_297_cov_2.642857_g11699_i0	PRJNA473641	11782	297	2.642857	7.84928529	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	516	8.14e-142	NTclustered	gi\|2754692633\|gb\|PP872994.1\|	3003959	g11699	i0	97.98	1	297	6	100	0	1	297	3775	4071	MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence	blastn	297	516	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
5548912	5548912	PRJNA473641_P_NODE_685_length_911_cov_1.852029_g622_i0	PRJNA473641	685	911	1.852029	16.87198419	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	1037	0	NTclustered	gi\|2754692633\|gb\|PP872994.1\|	3003959	g622	i0	88.101	2.52140504939627	874	102	96	2	1	873	3624	2752	MAG: Picornavirales sp. isolate TC-PLV-438 MR233-17E/4129 genomic sequence	blastn	2297	1037	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
5548952	5548952	PRJNA473641_P_NODE_8525_length_334_cov_1.084291_g8442_i0	PRJNA473641	8525	334	1.084291	3.62153194	Betacoronavirus pandemicum	3418604	Viruses	Viruses	113	1.42e-20	NTclustered	gi\|2165832678\|emb\|OV195277.1\|	2697049	g8442	i0	93.59	47.997005988024	78	1	22	3	1	74	29930	30007	Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1	blastn	16031	113	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
6822908	6822908	PRJNA473641_P_NODE_6_length_3647_cov_8.905428_g4_i0	PRJNA473641	6	3647	8.905428	324.78095916	Arma chinensis virus 1	2974718	Viruses	Viruses	2344	0	NTclustered	gi\|2289441063\|gb\|MW846634.1\|	2974718	g4	i0	78.488	26.8390457910611	3677	722	100	61	1	3647	5545	9182	Arma chinensis virus 1 isolate GZ1, complete genome	blastn	97882	2344	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Arma chinensis virus 1
14473753	14473753	PRJNA473641_P_NODE_24932_length_242_cov_0.911243_g24849_i0	PRJNA473641	24932	242	0.911243	2.20520806	Gylbovirus aagae	2955967	Viruses	Viruses	403	5.22e-108	NTclustered	gi\|1407526736\|gb\|MH430649.1\|	2230910	g24849	i0	97.083	28.5537190082645	240	5	99	1	3	242	6031	5794	Aedes anphevirus isolate Bora Bora nucleoprotein and small TMD protein genes, complete cds; nonfunctional putative glycoprotein genes, complete sequence; putative ZnF protein and putative TMD protein genes, complete cds; and nonfunctional RdRP protein gene, complete sequence	blastn	6910	403	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Xinmoviridae	Gylbovirus	Gylbovirus aagae
14473858	14473858	PRJNA473641_P_NODE_572_length_965_cov_3.014574_g512_i0	PRJNA473641	572	965	3.014574	29.0906391	Dicistroviridae sp.	1955144	Viruses	Viruses	538	6.149999999999998e-148	NTclustered	gi\|2756423296\|gb\|PP745438.1\|	1955144	g512	i0	76.899	1.00932642487047	974	209	100	14	1	965	4860	3894	MAG: Dicistroviridae sp. isolate 087_50073 genomic sequence	blastn	974	538	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Dicistroviridae sp.
14473911	14473911	PRJNA473641_P_NODE_7872_length_343_cov_3.425926_g7789_i0	PRJNA473641	7872	343	3.425926	11.75092618	brine shrimp dicistrovirus 1	2900466	Viruses	Viruses	82.4	4.14e-11	NTclustered	gi\|2209094695\|gb\|OL472420.1\|	2900466	g7789	i0	86.842	1.06705539358601	76	6	22	3	232	307	9460	9531	MAG: Brine shrimp dicistrovirus 1 isolate KAZ/15-16 RNA-dependent RNA polymerase and capsid protein genes, complete cds	blastn	366	82.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		brine shrimp dicistrovirus 1
20846766	20846766	PRJNA473641_P_NODE_25377_length_241_cov_1.589286_g25294_i0	PRJNA473641	25377	241	1.589286	3.83017926	Zebrafish picornavirus 1	2304617	Viruses	Viruses	418	1.8599999999999995e-112	NTclustered	gi\|1812398529\|gb\|MN524064.1\|	2304617	g25294	i0	97.925	3	241	5	100	0	1	241	5886	6126	Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome	blastn	723	418	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae		Zebrafish picornavirus 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);;