metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA217180" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA217180" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4194167	4194167	PRJNA217180_P_NODE_12564_length_167_cov_0.864407_g12464_i0	PRJNA217180	12564	167	0.864407	1.44355969	Caudoviricetes sp.	2832643	Viruses	Viruses	209	7.85e-50	NTclustered	gi\|2906149211\|gb\|PQ646444.1\|	2832643	g12464	i0	89.222	1	167	18	100	0	1	167	11558	11724	MAG: Caudoviricetes sp. isolate k127_3058080 genomic sequence	blastn	167	209	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
6744717	6744717	PRJNA217180_P_NODE_12626_length_167_cov_0.864407_g12526_i0	PRJNA217180	12626	167	0.864407	1.44355969	Maltschvirus maltsch	2956182	Viruses	Viruses	130	6.29e-26	NTclustered	gi\|1839221816\|emb\|LR797096.1\|	2100421	g12526	i0	90	2.9940119760479	100	10	60	0	66	165	37340	37241	uncultured Caudovirales phage genome assembly	blastn	500	130	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
7433951	7433951	PRJNA217180_P_NODE_806_length_671_cov_106.699357_g714_i0	PRJNA217180	806	671	106.699357	715.95268547	root	1	Root_unresolved	Root_unresolved	793	0	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g714	i0	95.565	78.1698956780924	496	20	85	2	173	667	15223	14729	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	52452	793	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
8708739	8708739	PRJNA217180_P_NODE_3447_length_305_cov_6.628906_g3347_i0	PRJNA217180	3447	305	6.628906	20.2181633	root	1	Root_unresolved	Root_unresolved	555	1.7799999999999996e-153	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g3347	i0	100	98.3606557377049	300	0	98	0	6	305	14427	14726	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	30000	555	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
11845665	11845665	PRJNA217180_P_NODE_14110_length_164_cov_0.886957_g14010_i0	PRJNA217180	14110	164	0.886957	1.45460948	Maltschvirus maltsch	2956182	Viruses	Viruses	291	2.67e-74	NTclustered	gi\|1839227244\|emb\|LR797178.1\|	2100421	g14010	i0	98.773	0.99390243902439	163	2	99	0	1	163	12116	11954	uncultured Caudovirales phage genome assembly	blastn	163	291	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
15083615	15083615	PRJNA217180_P_NODE_2072_length_404_cov_5.340845_g1972_i0	PRJNA217180	2072	404	5.340845	21.5770138	root	1	Root_unresolved	Root_unresolved	719	0	NTclustered	gi\|2079660852\|emb\|OU501478.1\|	10515	g1972	i0	100	96.2871287128713	389	0	96	0	12	400	15378	15766	Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE	blastn	38900	719	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
15669884	15669884	PRJNA217180_P_NODE_13073_length_166_cov_0.871795_g12973_i0	PRJNA217180	13073	166	0.871795	1.4471797	Maltschvirus maltsch	2956182	Viruses	Viruses	265	1.64e-66	NTclustered	gi\|1839141244\|emb\|LR796211.1\|	2100421	g12973	i0	95.732	0.987951807228916	164	7	99	0	1	164	12670	12507	uncultured Caudovirales phage genome assembly	blastn	164	265	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
20768586	20768586	PRJNA217180_P_NODE_10197_length_185_cov_1.338235_g10097_i0	PRJNA217180	10197	185	1.338235	2.47573475	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.016	NTclustered	gi\|2058128472\|tpg\|BK034062.1\|	2832643	g10097	i0	100	0.151351351351351	28	0	15	0	1	28	24678	24651	MAG TPA_asm: Caudoviricetes sp. isolate ctw8r9, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24007994	24007994	PRJNA217180_P_NODE_14359_length_163_cov_0.894737_g14259_i0	PRJNA217180	14359	163	0.894737	1.45842131	Pandoravirus	2060084	Viruses	Viruses	56.5	0.001	NTclustered	gi\|1408259612\|ref\|NC_037667.1\|	2107709	g14259	i0	100	0.368098159509202	30	0	18	0	14	43	1458670	1458699	Pandoravirus quercus, complete genome	blastn	60	56.5	1	Viruses						Pandoravirus	Pandoravirus quercus
24593373	24593373	PRJNA217180_P_NODE_9780_length_188_cov_1.467626_g9680_i0	PRJNA217180	9780	188	1.467626	2.75913688	Caudoviricetes sp.	2832643	Viruses	Viruses	196	7.029999999999999e-46	NTclustered	gi\|2054791465\|tpg\|BK049930.1\|	2832643	g9680	i0	92.701	3.8936170212766	137	9	73	1	3	139	3251	3116	MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome	blastn	732	196	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.

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