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

9 rows where analysis = "blastn", bioproject = "PRJEB65099" 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
3544403	3544403	PRJEB65099_P_NODE_4243_length_272_cov_1.130653_g4138_i0	PRJEB65099	4243	272	1.130653	3.07537616	root	1	Root_unresolved	Root_unresolved	497	2.67e-136	NTclustered	gi\|1956765275\|gb\|MW161386.1\|	37124	g4138	i0	99.632	100	272	1	100	0	1	272	3230	2959	Chikungunya virus strain CHIKV/Sudan154/2018 non-structural polyprotein and structural polyprotein genes, partial cds	blastn	27200	497	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
5232479	5232479	PRJEB65099_P_NODE_4745_length_257_cov_1.103261_g4640_i0	PRJEB65099	4745	257	1.103261	2.83538077	Alphavirus chikungunya	3426298	Viruses	Viruses	475	1.1699999999999999e-129	NTclustered	gi\|2669656132\|gb\|PP236109.1\|	37124	g4640	i0	100	100	257	0	100	0	1	257	1171	915	Chikungunya virus strain IMR45-21 non-structural polyprotein and structural polyprotein genes, complete cds	blastn	25700	475	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
6097032	6097032	PRJEB65099_P_NODE_1765_length_453_cov_1.013158_g1660_i0	PRJEB65099	1765	453	1.013158	4.58960574	root	1	Root_unresolved	Root_unresolved	837	0	NTclustered	gi\|549823107\|gb\|KF283987.1\|	37124	g1660	i0	100	100.596026490066	453	0	100	0	1	453	7877	7425	Chikungunya virus isolate S7 nonfunctional nonstructural polyprotein gene, partial sequence; and structural polyprotein gene, complete cds	blastn	45570	837	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
7782314	7782314	PRJEB65099_P_NODE_4287_length_270_cov_1.578680_g4182_i0	PRJEB65099	4287	270	1.57868	4.262436	Betacoronavirus pandemicum	3418604	Viruses	Viruses	499	7.349999999999998e-137	NTclustered	gi\|2499447400\|emb\|OX492971.1\|	2697049	g4182	i0	100	100	270	0	100	0	1	270	14410	14679	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	27000	499	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
9057204	9057204	PRJEB65099_P_NODE_3568_length_295_cov_1.270270_g3463_i0	PRJEB65099	3568	295	1.27027	3.7472965	Alphavirus chikungunya	3426298	Viruses	Viruses	401	2.3599999999999993e-107	NTclustered	gi\|2577286133\|gb\|OR283254.1\|	37124	g3463	i0	97.447	98.2135593220339	235	6	90	0	61	295	2547	2313	Chikungunya virus isolate THSTI-CHIKV-6, complete genome	blastn	28973	401	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
13747291	13747291	PRJEB65099_P_NODE_3471_length_300_cov_1.339207_g3366_i0	PRJEB65099	3471	300	1.339207	4.017621	root	1	Root_unresolved	Root_unresolved	555	1.7399999999999995e-153	NTclustered	gi\|1050242897\|gb\|KT324224.1\|	37124	g3366	i0	100	100	300	0	100	0	1	300	1949	1650	Chikungunya virus isolate MY/08/1230, complete genome	blastn	30000	555	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
17571746	17571746	PRJEB65099_P_NODE_2754_length_348_cov_0.825455_g2649_i0	PRJEB65099	2754	348	0.825455	2.8725834	root	1	Root_unresolved	Root_unresolved	627	4.3099999999999996e-175	NTclustered	gi\|334145773\|gb\|HQ456255.1\|	37124	g2649	i0	99.138	100	348	3	100	0	1	348	757	410	Chikungunya virus strain Lamu33, complete genome	blastn	34800	627	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
17981482	17981482	PRJEB65099_P_NODE_3955_length_281_cov_1.745192_g3850_i0	PRJEB65099	3955	281	1.745192	4.90398952	Alphavirus chikungunya	3426298	Viruses	Viruses	497	2.77e-136	NTclustered	gi\|1194463477\|gb\|KY435472.1\|	37124	g3850	i0	99.275	98.3523131672598	276	0	98	2	4	277	297	22	Chikungunya virus isolate 14.02560 non-structural polypeptide and structural polypeptide genes, complete cds	blastn	27637	497	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya
20120433	20120433	PRJEB65099_P_NODE_2896_length_337_cov_1.340909_g2791_i0	PRJEB65099	2896	337	1.340909	4.51886333	root	1	Root_unresolved	Root_unresolved	617	2.4999999999999997e-172	NTclustered	gi\|549823107\|gb\|KF283987.1\|	37124	g2791	i0	99.703	100	337	1	100	0	1	337	5363	5027	Chikungunya virus isolate S7 nonfunctional nonstructural polyprotein gene, partial sequence; and structural polyprotein gene, complete cds	blastn	33700	617	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Togaviridae	Alphavirus	Alphavirus chikungunya

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