metadata: contig_metadata: 10 rows where bioproject = "PRJNA983848" and tax

10 rows where bioproject = "PRJNA983848" and tax_kingdom = "Thermoproteati"

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
15299341	15299341	PRJNA983848_P_NODE_117832_length_276_cov_1.743842_g111949_i0	PRJNA983848	117832	276	1.743842	4.81300392	root	1	Root_unresolved	Root_unresolved	505	1.62e-138	NTclustered	gi\|82618470\|gb\|DQ278118.1\|	29281	g111949	i0	99.638	103.927536231884	276	1	100	0	1	276	1248	973	Uncultured crenarchaeote clone OdenA-100ii 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer, complete sequence	blastn	28684	510	0.990196078431373	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
26899872	26899872	PRJNA983848_P_NODE_134981_length_256_cov_0.956284_g129098_i0	PRJNA983848	134981	256	0.956284	2.44808704	Nitrosopumilus sp.	2024843	Archaea	Archaea	54.7	2.53e-6	NR	MCH2405552.1	2024843	g129098	i0	60	0.52734375	45	14	48	3	104	226	220	264	MCH2405552.1 hypothetical protein [Nitrosopumilus sp.]	diamond	135	54.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
27500443	27500443	PRJNA983848_P_NODE_104163_length_296_cov_1.103139_g98280_i0	PRJNA983848	104163	296	1.103139	3.26529144	Nitrosopumilus sp.	2024843	Archaea	Archaea	75.9	1.88e-14	NR	MCH2405858.1	2024843	g98280	i0	41.4	0.881756756756757	87	50	87.2	1	263	6	98	184	MCH2405858.1 hypothetical protein [Nitrosopumilus sp.]	diamond	261	75.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
27658407	27658407	PRJNA983848_P_NODE_145044_length_249_cov_1.556818_g139161_i0	PRJNA983848	145044	249	1.556818	3.87647682	Nitrosopumilus sp.	2024843	Archaea	Archaea	96.7	9.05e-23	NR	MCH2405858.1	2024843	g139161	i0	56.2	0.879518072289157	73	32	88	0	3	221	79	151	MCH2405858.1 hypothetical protein [Nitrosopumilus sp.]	diamond	219	96.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
30753081	30753081	PRJNA983848_P_NODE_72894_length_368_cov_1.254237_g67011_i0	PRJNA983848	72894	368	1.254237	4.61559216	Nitrosopumilus sp.	2024843	Archaea	Archaea	95.1	6.01e-20	NR	MCH2405553.1	2024843	g67011	i0	37.4	1.85869565217391	115	69	93.8	1	367	23	54	165	MCH2405553.1 reverse transcriptase family protein [Nitrosopumilus sp.]	diamond	684	95.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31290147	31290147	PRJNA983848_P_NODE_132715_length_258_cov_1.978378_g126832_i0	PRJNA983848	132715	258	1.978378	5.10421524	Nitrosopumilus sp.	2024843	Archaea	Archaea	105	2.11e-24	NR	MCH2405553.1	2024843	g126832	i0	60	0.988372093023256	85	34	98.8	0	1	255	244	328	MCH2405553.1 reverse transcriptase family protein [Nitrosopumilus sp.]	diamond	255	105	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31321822	31321822	PRJNA983848_P_NODE_102155_length_299_cov_1.654867_g96272_i0	PRJNA983848	102155	299	1.654867	4.94805233	Nitrosopumilus sp.	2024843	Archaea	Archaea	58.5	1.79e-7	NR	MCH2405552.1	2024843	g96272	i0	46.6	0.581939799331104	58	29	56.2	1	6	173	220	277	MCH2405552.1 hypothetical protein [Nitrosopumilus sp.]	diamond	174	58.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31859458	31859458	PRJNA983848_P_NODE_101797_length_299_cov_6.097345_g95914_i0	PRJNA983848	101797	299	6.097345	18.23106155	Nitrosopumilus sp.	2024843	Archaea	Archaea	43.9	0.0198	NR	MCH2405858.1	2024843	g95914	i0	36.2	0.581939799331104	58	36	58.2	1	218	45	128	184	MCH2405858.1 hypothetical protein [Nitrosopumilus sp.]	diamond	174	43.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
32713110	32713110	PRJNA983848_P_NODE_160940_length_241_cov_2.380952_g155057_i0	PRJNA983848	160940	241	2.380952	5.73809432	Nitrosopumilus sp.	2024843	Archaea	Archaea	55.5	5.42e-7	NR	MCH2405858.1	2024843	g155057	i0	41.7	0.746887966804979	60	35	74.7	0	239	60	123	182	MCH2405858.1 hypothetical protein [Nitrosopumilus sp.]	diamond	180	55.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
32807584	32807584	PRJNA983848_P_NODE_45360_length_534_cov_5.464208_g39493_i0	PRJNA983848	45360	534	5.464208	29.17887072	Nitrosopumilus sp.	2024843	Archaea	Archaea	55.8	6.3e-6	NR	MCH2405858.1	2024843	g39493	i0	53.1	0.275280898876405	49	22	27.5	1	261	407	98	145	MCH2405858.1 hypothetical protein [Nitrosopumilus sp.]	diamond	147	55.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.

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