metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB83101" 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
4826391	4826391	PRJEB83101_P_NODE_91464_length_203_cov_25.446154_g91159_i0	PRJEB83101	91464	203	25.446154	51.65569262	root	1	Root_unresolved	Root_unresolved	268	1.6099999999999998e-67	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g91159	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
13751722	13751722	PRJEB83101_P_NODE_84691_length_243_cov_0.917647_g84386_i0	PRJEB83101	84691	243	0.917647	2.22988221	Mastadenovirus	10509	Viruses	Viruses	444	3.09e-120	NTclustered	gi\|2620236271\|gb\|OR777225.1\|	10533	g84386	i0	99.588	100	243	1	100	0	1	243	640	882	Human adenovirus 1 isolate HAdV-C1/USA/14A1/2017, complete genome	blastn	24300	444	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
15445338	15445338	PRJEB83101_P_NODE_71173_length_250_cov_0.881356_g70868_i0	PRJEB83101	71173	250	0.881356	2.20339	Alphaorpheovirus massiliense	3426221	Viruses	Viruses	52.8	0.023	NTclustered	gi\|1315688781\|emb\|LT906555.1\|	2023057	g70868	i0	100	0.112	28	0	11	0	171	198	1039549	1039522	Orpheovirus IHUMI-LCC2 genome assembly, complete genome: monopartite	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Orpheoviridae	Alphaorpheovirus	Alphaorpheovirus massiliense
20124845	20124845	PRJEB83101_P_NODE_91396_length_206_cov_4.037594_g91091_i0	PRJEB83101	91396	206	4.037594	8.31744364	root	1	Root_unresolved	Root_unresolved	187	4.7299999999999984e-43	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g91091	i0	100	97.5679611650485	101	0	98	0	106	206	18402	18302	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	20099	187	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
21818738	21818738	PRJEB83101_P_NODE_44638_length_285_cov_5.377358_g44333_i0	PRJEB83101	44638	285	5.377358	15.3254703	Mastadenovirus caesari	3241411	Viruses	Viruses	518	2.16e-142	NTclustered	gi\|406678969\|gb\|JX173079.1\|	129951	g44333	i0	100	98.2456140350877	280	0	98	0	1	280	11439	11160	Human adenovirus C strain human/ARG/A15932/2002/2[P2H2F2], complete genome	blastn	28000	518	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);;