metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax_kingdom = "Bamfordvirae"

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
3729988	3729988	PRJNA689790_S_NODE_15863_length_153_cov_19.094828_g15748_i0	PRJNA689790	15863	153	19.094828	29.21508684	root	1	Root_unresolved	Root_unresolved	274	2.4599999999999997e-69	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g15748	i0	100	96.7320261437908	148	0	97	0	6	153	15173	15026	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	14800	274	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
5006469	5006469	PRJNA689790_S_NODE_8324_length_204_cov_14.455090_g8209_i0	PRJNA689790	8324	204	14.45509	29.4883836	root	1	Root_unresolved	Root_unresolved	267	5.839999999999999e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g8209	i0	100	93.5343137254902	144	0	95	0	56	199	11236	11379	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	19081	268	0.996268656716418	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
5772330	5772330	PRJNA689790_S_NODE_3845_length_314_cov_2.108303_g3730_i0	PRJNA689790	3845	314	2.108303	6.62007142	Indivirus ILV1	1977633	Viruses	Viruses	60.2	1.76e-4	NTclustered	gi\|1174571037\|gb\|KY684089.1\|	1977633	g3730	i0	97.143	0.111464968152866	35	1	11	0	149	183	55605	55571	Indivirus ILV1 isolate ILV1 clone Indivirus_5, sequence	blastn	35	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
16480989	16480989	PRJNA689790_S_NODE_8513_length_202_cov_3.781818_g8398_i0	PRJNA689790	8513	202	3.781818	7.63927236	root	1	Root_unresolved	Root_unresolved	348	2e-91	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g8398	i0	98.485	98.0445544554455	198	1	98	2	1	197	15023	14827	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	19805	351	0.991452991452991	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
18520841	18520841	PRJNA689790_S_NODE_9355_length_193_cov_8.500000_g9240_i0	PRJNA689790	9355	193	8.5	16.405	Mastadenovirus caesari	3241411	Viruses	Viruses	147	7.419999999999999e-31	NTclustered	gi\|1706705536\|gb\|MK165453.1\|	129951	g9240	i0	100	66.8652849740933	79	0	67	0	55	133	11239	11161	Human mastadenovirus C isolate SX-2004-327	blastn	12905	147	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
20304546	20304546	PRJNA689790_S_NODE_8416_length_203_cov_20.150602_g8301_i0	PRJNA689790	8416	203	20.150602	40.90572206	root	1	Root_unresolved	Root_unresolved	268	1.6099999999999998e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g8301	i0	99.329	73.3990147783251	149	0	73	1	1	148	11551	11403	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14900	268	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari

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