metadata: contig_metadata: 7 rows where bioproject = "PRJNA399711", tax_kingdom = "Methanobacteriati" and tax

7 rows where bioproject = "PRJNA399711", tax_kingdom = "Methanobacteriati" 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
25563276	25563276	PRJNA399711_S_NODE_36937_length_222_cov_2.275676_g36795_i0	PRJNA399711	36937	222	2.275676	5.05200072	Methanosphaera sp. ISO3-F5	1452353	Archaea	Archaea	52.8	0.02	NTclustered	gi\|2695672541\|gb\|CP118754.2\|	1452353	g36795	i0	100	0.126126126126126	28	0	13	0	174	201	141713	141740	Methanosphaera sp. ISO3-F5 plasmid pNP174, complete sequence	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanosphaera	Methanosphaera sp. ISO3-F5
25697956	25697956	PRJNA399711_S_NODE_10458_length_341_cov_2.496711_g10316_i0	PRJNA399711	10458	341	2.496711	8.51378451	Candidatus Poseidoniales archaeon	2163009	Archaea	Archaea	70.5	1.29e-11	NR	MEK9698159.1	2163009	g10316	i0	52.3	1.38123167155425	65	31	57.2	0	337	143	29	93	MEK9698159.1 hypothetical protein [Candidatus Poseidoniales archaeon]	diamond	471	70.5	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
26242509	26242509	PRJNA399711_S_NODE_107126_length_151_cov_2.877193_g106984_i0	PRJNA399711	107126	151	2.877193	4.34456143	Halobaculum limi	3031916	Archaea	Archaea	52.8	0.012	NTclustered	gi\|2471356524\|gb\|CP120468.1\|	3031916	g106984	i0	100	0.185430463576159	28	0	19	0	35	62	499995	499968	Halobaculum limi strain YSMS11 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum limi
32934556	32934556	PRJNA399711_S_NODE_11009_length_335_cov_7.932886_g10867_i0	PRJNA399711	11009	335	7.932886	26.5751681	Methanocaldococcus jannaschii	2190	Archaea	Archaea	75.1	4.52e-15	NR	WP_064496856.1	2190	g10867	i0	76.2	0.564179104477612	63	15	56.4	0	48	236	28	90	WP_064496856.1 hypothetical protein [Methanocaldococcus jannaschii]	diamond	189	75.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus jannaschii
33037457	33037457	PRJNA399711_S_NODE_73372_length_173_cov_3.514706_g73230_i0	PRJNA399711	73372	173	3.514706	6.08044138	Methanobacterium sp.	2164	Archaea	Archaea	45.1	0.00222	NR	MCC7564369.1	2164	g73230	i0	100	0.416184971098266	24	0	41.6	0	100	171	1	24	MCC7564369.1 hypothetical protein [Methanobacterium sp.]	diamond	72	45.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
33060674	33060674	PRJNA399711_S_NODE_50397_length_198_cov_6.931677_g50255_i0	PRJNA399711	50397	198	6.931677	13.72472046	Archaea	2157	Archaea	Archaea	43.1	0.0157	NR	HIO94141.1	2163009	g50255	i0	41.1	2.57575757575758	56	33	84.8	0	4	171	193	248	HIO94141.1 aconitate hydratase AcnA [Candidatus Poseidoniales archaeon]	diamond	510	43.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Candidatus Poseidoniia	Candidatus Poseidoniales			Candidatus Poseidoniales archaeon
33173811	33173811	PRJNA399711_S_NODE_39096_length_217_cov_12.505556_g38954_i0	PRJNA399711	39096	217	12.505556	27.13705652	Methanomethylophilus alvi	1291540	Archaea	Archaea	41.6	0.0344	NR	WP_400256085.1	1291540	g38954	i0	38.2	0.76036866359447	55	25	63.6	2	60	197	79	133	WP_400256085.1 hypothetical protein [Methanomethylophilus alvi]	diamond	165	41.6	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomethylophilaceae	Methanomethylophilus	Methanomethylophilus alvi

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