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

5 rows where analysis = "blastn", bioproject = "PRJEB39643" 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
989399	989399	PRJEB39643_P_NODE_159981_length_199_cov_29.912698_g159787_i0	PRJEB39643	159981	199	29.912698	59.52626902	root	1	Root_unresolved	Root_unresolved	265	2.04e-66	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g159787	i0	99.32	73.8693467336683	147	0	73	1	1	146	11549	11403	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	14700	265	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
3884073	3884073	PRJEB39643_P_NODE_34684_length_316_cov_2.074074_g34491_i0	PRJEB39643	34684	316	2.074074	6.55407384	Klosneuvirus KNV1	1977640	Viruses	Viruses	54.7	0.008	NTclustered	gi\|1174573444\|gb\|KY684111.1\|	1977640	g34491	i0	96.875	0.10126582278481	32	1	10	0	123	154	98626	98595	Klosneuvirus KNV1 isolate KNV1 clone Klosneuvirus_4, sequence	blastn	32	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
6092524	6092524	PRJEB39643_P_NODE_159525_length_204_cov_7.358779_g159331_i0	PRJEB39643	159525	204	7.358779	15.01190916	root	1	Root_unresolved	Root_unresolved	368	1.56e-97	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g159331	i0	100	97.5490196078431	199	0	98	0	1	199	15025	15223	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	19900	368	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
21391605	21391605	PRJEB39643_P_NODE_45897_length_288_cov_1.572093_g45704_i0	PRJEB39643	45897	288	1.572093	4.52762784	root	1	Root_unresolved	Root_unresolved	58.4	5.73e-4	NTclustered	gi\|2327912943\|gb\|OL897270.1\|	1907210	g45704	i0	100	4.82638888888889	31	0	11	0	41	71	101	131	Human adenovirus sp. strain HAdV/S183/Huzhou/2020/CHN hexon gene, partial cds	blastn	1390	58.4	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Human adenovirus sp.
22666476	22666476	PRJEB39643_P_NODE_91858_length_265_cov_1.604167_g91665_i0	PRJEB39643	91858	265	1.604167	4.25104255	root	1	Root_unresolved	Root_unresolved	484	2.0199999999999998e-132	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g91665	i0	99.623	99.7849056603774	265	1	100	0	1	265	14225	14489	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	26443	484	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);;