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

9 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax_kingdom = "Methanobacteriati"

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
5777807	5777807	PRJNA694770_P_NODE_36445_length_338_cov_1.452830_g36151_i0	PRJNA694770	36445	338	1.45283	4.9105654	Natrinema sp. J7-2	406552	Archaea	Archaea	562	1.19e-155	NTclustered	gi\|397680883\|gb\|CP003412.1\|	406552	g36151	i0	99.674	57.7011834319527	307	1	91	0	2	308	1830750	1831056	Natrinema sp. J7-2, complete genome	blastn	19503	562	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. J7-2
7558969	7558969	PRJNA694770_P_NODE_73866_length_257_cov_2.092391_g73572_i0	PRJNA694770	73866	257	2.092391	5.37744487	root	1	Root_unresolved	Root_unresolved	464	2.5299999999999998e-126	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g73572	i0	99.222	6.715953307393	257	2	100	0	1	257	2084	1828	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	1726	464	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
8327154	8327154	PRJNA694770_P_NODE_25947_length_383_cov_1.241935_g25653_i0	PRJNA694770	25947	383	1.241935	4.75661105	uncultured Methanoregula sp.	1005933	Archaea	Archaea	549	1.0599999999999999e-151	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g25653	i0	93.496	97.4543080939948	369	24	96	0	1	369	3092089	3091721	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	37325	549	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
8327751	8327751	PRJNA694770_P_NODE_48627_length_301_cov_1.013158_g48333_i0	PRJNA694770	48627	301	1.013158	3.04960558	Halorutilales archaeon Cl-col2-1	3242703	Archaea	Archaea	56.5	0.002	NTclustered	gi\|2801083086\|gb\|CP169074.1\|	3242703	g48333	i0	96.97	0.109634551495017	33	1	11	0	206	238	1816624	1816592	Halorutilales archaeon Cl-col2-1 chromosome, complete genome	blastn	33	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halorutilales			Halorutilales archaeon Cl-col2-1
8833904	8833904	PRJNA694770_P_NODE_6627_length_746_cov_2.731055_g6347_i0	PRJNA694770	6627	746	2.731055	20.3736703	root	1	Root_unresolved	Root_unresolved	1373	0	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g6347	i0	99.866	7.9142091152815	746	1	100	0	1	746	1009	1754	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	5904	1373	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
11384824	11384824	PRJNA694770_P_NODE_85889_length_248_cov_0.880000_g85595_i0	PRJNA694770	85889	248	0.88	2.1824	Methanoculleus	45989	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2323247744\|gb\|CP109831.1\|	204050	g85595	i0	88	0.403225806451613	50	1	20	5	29	77	1398535	1398490	Methanoculleus submarinus strain DSM 15122 chromosome, complete genome	blastn	100	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoculleus	Methanoculleus submarinus
18527262	18527262	PRJNA694770_P_NODE_73755_length_258_cov_1.118919_g73461_i0	PRJNA694770	73755	258	1.118919	2.88681102	Natrinema sp. J7-2	406552	Archaea	Archaea	379	9.479999999999998e-101	NTclustered	gi\|397680883\|gb\|CP003412.1\|	406552	g73461	i0	100	13.8875968992248	205	0	96	0	54	258	1830253	1830457	Natrinema sp. J7-2, complete genome	blastn	3583	379	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. J7-2
21583612	21583612	PRJNA694770_P_NODE_90957_length_245_cov_0.895349_g90663_i0	PRJNA694770	90957	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|436492\|gb\|U00707.1\|PSU00707	33866	g90663	i0	100	11.9102040816327	245	0	100	0	1	245	838	1082	Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds	blastn	2918	453	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus sp.
24131689	24131689	PRJNA694770_P_NODE_100859_length_237_cov_2.347561_g100565_i0	PRJNA694770	100859	237	2.347561	5.56371957	root	1	Root_unresolved	Root_unresolved	438	1.4e-118	NTclustered	gi\|216917\|dbj\|D12983.1\|PYWPOL	2261	g100565	i0	100	6	237	0	100	0	1	237	587	351	Pyrococcus furiosus pol gene for DNA polymerase, complete cds	blastn	1422	438	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus

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