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

5 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax_superkingdom = "Archaea"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25908247	25908247	PRJNA816047d_S_NODE_53811_length_303_cov_11295.384000_g51976_i0	PRJNA816047	53811	303	11295.384	34225.01352	root	1	Root_unresolved	Root_unresolved	71.3	7.79e-8	NTclustered	gi\|969874815\|gb\|CP013695.1\|	2285	g51976	i0	100	110.471947194719	38	0	13	0	212	249	40	3	Sulfolobus acidocaldarius strain NG05B_CO5_07 chromosome	blastn	33473	71.3	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus acidocaldarius
26141019	26141019	PRJNA816047a_S_NODE_83973_length_228_cov_3.038710_g81313_i0	PRJNA816047	83973	228	3.03871	6.9282588	uncultured archaeon	115547	Archaea	Archaea	165	2.4999999999999997e-36	NTclustered	gi\|452094308\|gb\|JX672222.1\|	115547	g81313	i0	100	87.8464912280702	89	0	39	0	121	209	341	253	Uncultured archaeon clone 4S_002a_F05 16S ribosomal RNA gene, partial sequence	blastn	20029	165	1	Archaea								uncultured archaeon
26180395	26180395	PRJNA816047d_S_NODE_45541_length_324_cov_1.686347_g43706_i0	PRJNA816047	45541	324	1.686347	5.46376428	Halobaculum	43927	Archaea	Archaea	52.8	0.03	NTclustered	gi\|2090002430\|gb\|CP082284.1\|	2872158	g43706	i0	87.5	0.296296296296296	48	2	14	4	195	240	243487	243532	Halobaculum rubrum strain C46 chromosome, complete genome	blastn	96	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum rubrum
26417916	26417916	PRJNA816047d_S_NODE_131055_length_230_cov_2.209040_g129220_i0	PRJNA816047	131055	230	2.20904	5.080792	Salinirubellus salinus	1364945	Archaea	Archaea	52.8	0.021	NTclustered	gi\|2297614754\|gb\|CP104003.1\|	1364945	g129220	i0	100	0.121739130434783	28	0	12	0	144	171	2542871	2542844	Salinirubellus salinus strain ZS-35-S2 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Salinirubellus	Salinirubellus salinus
26546823	26546823	PRJNA816047a_S_NODE_53704_length_288_cov_2.283721_g51044_i0	PRJNA816047	53704	288	2.283721	6.57711648	Pyrococcus sp. ST	33866	Archaea	Archaea	54.7	0.007	NTclustered	gi\|388248755\|gb\|CP003534.1\|	1183377	g51044	i0	92.105	0.131944444444444	38	3	13	0	169	206	186961	186924	Pyrococcus sp. ST04, complete genome	blastn	38	54.7	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus sp. ST04

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