metadata: contig_metadata: 8 rows where bioproject = "PRJNA879221" and tax

8 rows where bioproject = "PRJNA879221" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3792053	3792053	PRJNA879221_P_NODE_48123_length_250_cov_0.870056_g47983_i0	PRJNA879221	48123	250	0.870056	2.17514	archaeon	1906665	Archaea	Archaea	86.3	1.04e-17	NR	RYG65047.1	1906665	g47983	i0	52.4	0.984	82	38	97.2	1	243	1	24	105	RYG65047.1 MAG: hypothetical protein EON64_12740 [archaeon]	diamond	246	86.3	1	Archaea							archaeon
27907847	27907847	PRJNA879221_P_NODE_56465_length_245_cov_0.895349_g56325_i0	PRJNA879221	56465	245	0.895349	2.19360505	Nitrososphaera sp.	1971748	Archaea	Archaea	63.2	2.38e-9	NR	HZT36206.1	1971748	g56325	i0	40	0.979591836734694	80	45	98	1	4	243	222	298	HZT36206.1 hypothetical protein [Nitrososphaera sp.]	diamond	240	63.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
28065970	28065970	PRJNA879221_P_NODE_40465_length_273_cov_1.370000_g40325_i0	PRJNA879221	40465	273	1.37	3.7401	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	57.8	1.49e-8	NR	AIF11849.1	1456186	g40325	i0	66.7	0.428571428571429	39	13	42.9	0	259	143	44	82	AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08]	diamond	117	57.8	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08
29044952	29044952	PRJNA879221_P_NODE_20788_length_388_cov_1.098413_g20649_i0	PRJNA879221	20788	388	1.098413	4.26184244	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	66.6	1.83e-11	NR	AIF11849.1	1456186	g20649	i0	57.4	0.417525773195876	54	23	41.8	0	163	2	40	93	AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08]	diamond	162	66.6	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08
29960477	29960477	PRJNA879221_P_NODE_37611_length_285_cov_1.377358_g37471_i0	PRJNA879221	37611	285	1.377358	3.9254703	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	57.8	1.71e-8	NR	AIF11849.1	1456186	g37471	i0	57.4	0.494736842105263	47	20	49.5	0	283	143	47	93	AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08]	diamond	141	57.8	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08
30687084	30687084	PRJNA879221_P_NODE_6073_length_763_cov_3.957971_g5946_i0	PRJNA879221	6073	763	3.957971	30.19931873	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	90.9	1.85e-19	NR	AIF11849.1	1456186	g5946	i0	77.8	0.212319790301442	54	12	21.2	0	437	276	40	93	AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08]	diamond	162	90.9	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08
31160769	31160769	PRJNA879221_P_NODE_47095_length_251_cov_0.865169_g46955_i0	PRJNA879221	47095	251	0.865169	2.17157419	archaeon	1906665	Archaea	Archaea	70.5	7.05e-12	NR	RYH31189.1	1906665	g46955	i0	44	1.00398406374502	84	33	99.2	2	251	3	598	668	RYH31189.1 MAG: hypothetical protein EON65_03225 [archaeon]	diamond	252	70.5	1	Archaea							archaeon
32394936	32394936	PRJNA879221_P_NODE_39199_length_278_cov_1.497561_g39059_i0	PRJNA879221	39199	278	1.497561	4.16321958	uncultured marine thaumarchaeote KM3_53_F	1167203	Archaea	Archaea	87.4	3.42e-20	NR	AIF11849.1	1456186	g39059	i0	75.9	0.58273381294964	54	13	58.3	0	72	233	40	93	AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08]	diamond	162	87.4	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote KM3_53_F08

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