metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
7832282	7832282	PRJNA1063685_S_NODE_45607_length_339_cov_6.334586_g45064_i0	PRJNA1063685	45607	339	6.334586	21.47424654	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	627	4.1799999999999996e-175	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g45064	i0	100	98.3893805309735	339	0	100	0	1	339	740993	740655	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	33354	627	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
11215627	11215627	PRJNA1063685_S_NODE_9789_length_632_cov_3.652952_g9277_i0	PRJNA1063685	9789	632	3.652952	23.08665664	Halalkalicoccus	332246	Archaea	Archaea	1092	0	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g9277	i0	99.015	177.92246835443	609	6	96	0	24	632	631	1239	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	112447	1092	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
11657963	11657963	PRJNA1063685_S_NODE_1970_length_909_cov_12.052632_g1640_i0	PRJNA1063685	1970	909	12.052632	109.55842488	Halococcus qingdaonensis	224402	Archaea	Archaea	1513	0	NTclustered	gi\|2281256326\|gb\|CP101943.1\|	224402	g1640	i0	97.216	133.832783278328	898	18	98	5	17	909	2644652	2645547	Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome	blastn	121654	1513	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus qingdaonensis
12933362	12933362	PRJNA1063685_S_NODE_40271_length_367_cov_2.054422_g39728_i0	PRJNA1063685	40271	367	2.054422	7.53972874	uncultured archaeon	115547	Archaea	Archaea	303	8.71e-78	NTclustered	gi\|1032564008\|gb\|KX029804.1\|	115547	g39728	i0	99.401	79.2179836512262	167	1	46	0	201	367	250	84	Uncultured archaeon clone A_OTU_328 16S ribosomal RNA gene, partial sequence	blastn	29073	303	1	Archaea								uncultured archaeon
14208136	14208136	PRJNA1063685_S_NODE_24652_length_468_cov_29.486076_g24112_i0	PRJNA1063685	24652	468	29.486076	137.99483568	Halococcus qingdaonensis	224402	Archaea	Archaea	797	0	NTclustered	gi\|2281256326\|gb\|CP101943.1\|	224402	g24112	i0	98.879	138.655982905983	446	5	95	0	1	446	2647109	2646664	Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome	blastn	64891	797	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus qingdaonensis
18031490	18031490	PRJNA1063685_S_NODE_62595_length_271_cov_4.242424_g62052_i0	PRJNA1063685	62595	271	4.242424	11.49696904	Methanobrevibacter arboriphilus	39441	Archaea	Archaea	52.8	0.025	NTclustered	gi\|2047640843\|dbj\|AP019779.1\|	39441	g62052	i0	100	0.103321033210332	28	0	10	0	166	193	1215031	1215058	Methanobrevibacter arboriphilus SA DNA, complete genome	blastn	28	52.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter arboriphilus
18863304	18863304	PRJNA1063685_S_NODE_12675_length_591_cov_3.249035_g12157_i0	PRJNA1063685	12675	591	3.249035	19.20179685	root	1	Root_unresolved	Root_unresolved	63.9	2.7e-5	NTclustered	gi\|969874815\|gb\|CP013695.1\|	2285	g12157	i0	100	19.3502538071066	34	0	6	0	558	591	41	8	Sulfolobus acidocaldarius strain NG05B_CO5_07 chromosome	blastn	11436	63.9	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus acidocaldarius
21413968	21413968	PRJNA1063685_S_NODE_33677_length_404_cov_6.117825_g33135_i0	PRJNA1063685	33677	404	6.117825	24.716013	Halalkalicoccus	332246	Archaea	Archaea	638	2.3399999999999996e-178	NTclustered	gi\|507148368\|ref\|NR_103171.1\|	413810	g33135	i0	96.85	134.920792079208	381	12	94	0	1	381	383	3	Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence	blastn	54508	641	0.995319812792512	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus jeotgali
22689008	22689008	PRJNA1063685_S_NODE_75158_length_238_cov_4.096970_g74615_i0	PRJNA1063685	75158	238	4.09697	9.7507886	Halococcus	2249	Archaea	Archaea	440	3.899999999999999e-119	NTclustered	gi\|43626\|emb\|X05481.1\|	2250	g74615	i0	100	161.852941176471	238	0	100	0	1	238	2859	2622	Halococcus morrhuae 23S ribosomal RNA	blastn	38521	440	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halococcus	Halococcus morrhuae
24405773	24405773	PRJNA1063685_S_NODE_66860_length_259_cov_1.086022_g66317_i0	PRJNA1063685	66860	259	1.086022	2.81279698	Candidatus Nitrosotenuis aquarius	1846278	Archaea	Archaea	292	1.28e-74	NTclustered	gi\|1279207014\|gb\|CP024808.1\|	1846278	g66317	i0	87.903	0.957528957528958	248	30	96	0	12	259	1534194	1534441	Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome	blastn	248	292	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis aquarius

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