metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA849646" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA849646" 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
2508854	2508854	PRJNA849646_P_NODE_32122_length_248_cov_0.880000_g32004_i0	PRJNA849646	32122	248	0.88	2.1824	Methanocaldococcus	196118	Archaea	Archaea	65.8	2.88e-6	NTclustered	gi\|470491724\|ref\|NR_077055.1\|	2190	g32004	i0	97.368	3.67741935483871	38	1	15	0	1	38	1177	1140	Methanocaldococcus jannaschii strain JAL-1 23S ribosomal RNA gene, complete sequence	blastn	912	65.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus jannaschii
10161684	10161684	PRJNA849646_P_NODE_10888_length_286_cov_1.446009_g10770_i0	PRJNA849646	10888	286	1.446009	4.13558574	Halomarina	871740	Archaea	Archaea	250	8.73e-62	NTclustered	gi\|2270268912\|gb\|CP100448.1\|	2961595	g10770	i0	83.212	31.1468531468531	274	44	95	2	1	273	439947	440219	Halomarina litorea strain BCD28 chromosome, complete genome	blastn	8908	250	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina litorea
12317390	12317390	PRJNA849646_P_NODE_28030_length_253_cov_1.711111_g27912_i0	PRJNA849646	28030	253	1.711111	4.32911083	Halocatena marina	2934937	Archaea	Archaea	71.3	6.34e-8	NTclustered	gi\|2324023557\|gb\|CP109979.1\|	2934937	g27912	i0	82.022	1.05533596837945	89	11	35	4	51	138	617862	617946	Halocatena marina strain QDMS1 chromosome, complete genome	blastn	267	71.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halocatena	Halocatena marina
12713031	12713031	PRJNA849646_P_NODE_810_length_545_cov_2.355932_g694_i0	PRJNA849646	810	545	2.355932	12.8398294	root	1	Root_unresolved	Root_unresolved	1007	0	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g694	i0	100	7.40550458715596	545	0	100	0	1	545	829	285	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	4036	1007	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
15261394	15261394	PRJNA849646_P_NODE_42912_length_212_cov_4.100719_g42794_i0	PRJNA849646	42912	212	4.100719	8.69352428	root	1	Root_unresolved	Root_unresolved	387	4.5e-103	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g42794	i0	99.528	6.87264150943396	212	1	100	0	1	212	2156	1945	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	1457	387	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
17416468	17416468	PRJNA849646_P_NODE_28414_length_252_cov_2.279330_g28296_i0	PRJNA849646	28414	252	2.27933	5.7439116	Halovalidus salilacus	3075124	Archaea	Archaea	58.4	4.91e-4	NTclustered	gi\|2581323319\|gb\|CP134700.1\|	3075124	g28296	i0	92.683	0.273809523809524	41	1	16	2	50	89	1689335	1689374	Halovalidus salilacus strain CCL63 chromosome, complete genome	blastn	69	58.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Halovalidus	Halovalidus salilacus
19084962	19084962	PRJNA849646_P_NODE_6515_length_309_cov_3.334746_g6397_i0	PRJNA849646	6515	309	3.334746	10.30436514	Halobacteriales	2235	Archaea	Archaea	475	1.4399999999999997e-129	NTclustered	gi\|1678236646\|gb\|MN022518.1\|	44099	g6397	i0	94.498	98.9935275080906	309	10	100	1	1	309	490	189	Halobacteriaceae gen. sp. strain DYA01 16S ribosomal RNA gene, partial sequence	blastn	30589	475	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae		Halobacteriaceae gen. sp.
20359649	20359649	PRJNA849646_P_NODE_2136_length_374_cov_3.142857_g2018_i0	PRJNA849646	2136	374	3.142857	11.75428518	root	1	Root_unresolved	Root_unresolved	691	0	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g2018	i0	100	8	374	0	100	0	1	374	1570	1943	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	2992	691	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
23790583	23790583	PRJNA849646_P_NODE_36819_length_243_cov_0.905882_g36701_i0	PRJNA849646	36819	243	0.905882	2.20129326	Methanocaldococcus jannaschii	2190	Archaea	Archaea	71.3	6.05e-8	NTclustered	gi\|6626255\|gb\|L77117.1\|	243232	g36701	i0	100	0.625514403292181	38	0	16	0	206	243	149221	149184	Methanocaldococcus jannaschii DSM 2661, complete genome	blastn	152	71.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus jannaschii

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