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

9 rows where analysis = "blastn", bioproject = "PRJNA727760" and tax_superkingdom = "Viruses"

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
1194778	1194778	PRJNA727760_S_NODE_21_length_1897_cov_6.392544_g20_i0	PRJNA727760	21	1897	6.392544	121.26655968	root	1	Root_unresolved	Root_unresolved	3439	0	NTclustered	gi\|61006\|emb\|X56131.1\|	12730	g20	i0	99.576	46.6009488666315	1886	8	99	0	1	1886	1886	1	Sendai virus HN gene for Haemagglutinin/Neuraminidase	blastn	88402	3472	0.990495391705069	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
4541066	4541066	PRJNA727760_S_NODE_24_length_1880_cov_8.637521_g23_i0	PRJNA727760	24	1880	8.637521	162.3853948	Respirovirus muris	3052731	Viruses	Viruses	3356	0	NTclustered	gi\|546225817\|dbj\|AB855654.1\|	3052731	g23	i0	99.945	73.0893617021277	1820	1	97	0	61	1880	4813	6632	Respirovirus muris genomic RNA, complete genome, strain: Cantell, clone: cCdi	blastn	137408	3356	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus muris
5023066	5023066	PRJNA727760_S_NODE_2724_length_277_cov_1.642157_g2696_i0	PRJNA727760	2724	277	1.642157	4.54877489	Alphapapillomavirus	333750	Viruses	Viruses	388	1.7099999999999998e-103	NTclustered	gi\|1162227033\|gb\|KY501965.1\|	10566	g2696	i0	100	76.057761732852	210	0	76	0	49	258	1261	1052	Human papillomavirus isolate HPV18 P1 replication protein E1 (E1) gene, partial cds	blastn	21068	390	0.994871794871795	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
19046593	19046593	PRJNA727760_S_NODE_1035_length_464_cov_1.982097_g1007_i0	PRJNA727760	1035	464	1.982097	9.19693008	Alphapapillomavirus	333750	Viruses	Viruses	798	0	NTclustered	gi\|1162227035\|gb\|KY501966.1\|	10566	g1007	i0	99.321	95.2650862068966	442	2	95	1	1	442	727	287	Human papillomavirus isolate HPV18 P1-10 replication protein E1 (E1) gene, partial cds	blastn	44203	804	0.992537313432836	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
19046594	19046594	PRJNA727760_S_NODE_2315_length_298_cov_0.906667_g2287_i0	PRJNA727760	2315	298	0.906667	2.70186766	Alphapapillomavirus	333750	Viruses	Viruses	496	1.06e-135	NTclustered	gi\|1390389019\|gb\|MF446038.1\|	10566	g2287	i0	99.273	92.2818791946309	275	1	92	1	24	298	311	38	Human papillomavirus isolate Patient V0486 E6 protein (E6) gene, partial cds; and E7 protein (E7) gene, complete cds	blastn	27500	501	0.99001996007984	Viruses	Human papillomavirus types	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae		Human papillomavirus
19839633	19839633	PRJNA727760_S_NODE_1816_length_338_cov_9.818868_g1788_i0	PRJNA727760	1816	338	9.818868	33.18777384	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.032	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g1788	i0	94.286	0.103550295857988	35	1	10	1	198	231	153509	153475	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
19839636	19839636	PRJNA727760_S_NODE_3656_length_245_cov_1.779070_g3628_i0	PRJNA727760	3656	245	1.77907	4.3587215	Alphapapillomavirus 7	337042	Viruses	Viruses	364	2.5e-96	NTclustered	gi\|1258167396\|gb\|MF288663.1\|	333761	g3628	i0	100	80.4081632653061	197	0	80	0	1	197	1704	1900	Human papillomavirus 18 isolate C415154_R1_1138896_N-P, complete genome	blastn	19700	364	1	Viruses		Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Alphapapillomavirus	Alphapapillomavirus 7
21596993	21596993	PRJNA727760_S_NODE_117_length_1222_cov_22.433420_g107_i0	PRJNA727760	117	1222	22.43342	274.1363924	root	1	Root_unresolved	Root_unresolved	2146	0	NTclustered	gi\|62017\|emb\|X53056.1\|	12730	g107	i0	99.914	63.4959083469722	1165	1	95	0	50	1214	1165	1	Sendai virus mRNA for matrix protein	blastn	77592	2152	0.997211895910781	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
22872313	22872313	PRJNA727760_S_NODE_18_length_1926_cov_11.681597_g17_i0	PRJNA727760	18	1926	11.681597	224.98755822	Respirovirus	186938	Viruses	Viruses	3450	0	NTclustered	gi\|62011\|emb\|X17008.1\|	12730	g17	i0	99.629	62.48753894081	1889	7	98	0	28	1916	1889	1	Sendai virus polymerase (P) gene (strain fushimi)	blastn	120351	3483	0.99052540913006	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis

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