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

5 rows where analysis = "blastn", bioproject = "PRJNA937226" 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
11459533	11459533	PRJNA937226_S_NODE_17269_length_197_cov_2.459459_g17142_i0	PRJNA937226	17269	197	2.459459	4.84513423	root	1	Root_unresolved	Root_unresolved	364	1.929999999999999e-96	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g17142	i0	100	100	197	0	100	0	1	197	4029	3833	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	19700	364	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
11459549	11459549	PRJNA937226_S_NODE_22749_length_176_cov_1.637795_g22622_i0	PRJNA937226	22749	176	1.637795	2.8825192	root	1	Root_unresolved	Root_unresolved	124	3.0999999999999997e-24	NTclustered	gi\|1841985160\|gb\|MT277585.1\|	10515	g22622	i0	93.902	45.6818181818182	82	5	47	0	95	176	31130	31049	Mutant Human adenovirus 2 isolate HAdV-C2-dE3B-CMV-GFP, complete sequence	blastn	8040	124	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
12735183	12735183	PRJNA937226_S_NODE_3730_length_338_cov_2.508651_g3603_i0	PRJNA937226	3730	338	2.508651	8.47924038	root	1	Root_unresolved	Root_unresolved	625	1.4999999999999999e-174	NTclustered	gi\|2288721861\|gb\|OP218818.1\|	10535	g3603	i0	100	100.647928994083	338	0	100	0	1	338	2117	2454	Unidentified adenovirus strain CHOP Ad5	blastn	34019	625	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	unidentified adenovirus
14939854	14939854	PRJNA937226_S_NODE_3532_length_345_cov_31.334459_g3405_i0	PRJNA937226	3532	345	31.334459	108.10388355	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.033	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g3405	i0	94.286	0.101449275362319	35	1	10	1	107	140	153475	153509	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
17490168	17490168	PRJNA937226_S_NODE_16154_length_202_cov_5.725490_g16027_i0	PRJNA937226	16154	202	5.72549	11.5654898	Orthopoxvirus monkeypox	3431483	Viruses	Viruses	54.7	0.005	NTclustered	gi\|2309594316\|gb\|OP536747.1\|	10244	g16027	i0	100	14.3564356435644	29	0	14	0	68	96	119302	119274	Monkeypox virus isolate 9000365, partial genome	blastn	2900	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox

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