metadata: contig_metadata: 8 rows where bioproject = "PRJNA1034995" and tax

8 rows where bioproject = "PRJNA1034995" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4835731	4835731	PRJNA1034995_S_NODE_40064_length_204_cov_17.204969_g39908_i0	PRJNA1034995	40064	204	17.204969	35.09813676	root	1	Root_unresolved	Root_unresolved	65.8	2.29e-6	NTclustered	gi\|1572541187\|emb\|LR135910.1\|	1462426	g39908	i0	97.368	17.3774509803922	38	1	19	0	158	195	24532	24569	uncultured Aenigmarchaeota archaeon genomic DNA containing deoA-rbcL-e2b2 region region	blastn	3545	65.8	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota					uncultured Aenigmarchaeota archaeon
10371703	10371703	PRJNA1034995_S_NODE_32849_length_248_cov_5.887805_g32693_i0	PRJNA1034995	32849	248	5.887805	14.6017564	uncultured crenarchaeote	29281	Archaea	Archaea	357	4.24e-94	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g32693	i0	95.133	74.3225806451613	226	11	91	0	1	226	40742	40517	Uncultured crenarchaeote genomic fragment 54d9	blastn	18432	357	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
12922160	12922160	PRJNA1034995_S_NODE_31051_length_261_cov_30.614679_g30895_i0	PRJNA1034995	31051	261	30.614679	79.90431219	Fervidicoccus fontis	683846	Archaea	Archaea	52.8	0.024	NTclustered	gi\|383794914\|gb\|CP003423.1\|	1163730	g30895	i0	100	0.10727969348659	28	0	11	0	179	206	1010413	1010440	Fervidicoccus fontis Kam940, complete genome	blastn	28	52.8	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Fervidicoccales	Fervidicoccaceae	Fervidicoccus	Fervidicoccus fontis
27477557	27477557	PRJNA1034995_S_NODE_36163_length_226_cov_7.322404_g36007_i0	PRJNA1034995	36163	226	7.322404	16.54863304	archaeon	1906665	Archaea	Archaea	46.6	6.6e-4	NR	NCP98113.1	1906665	g36007	i0	33.8	0.86283185840708	65	38	86.3	1	198	4	57	116	NCP98113.1 hypothetical protein [archaeon]	diamond	195	46.6	1	Archaea							archaeon
27951235	27951235	PRJNA1034995_S_NODE_31765_length_256_cov_8.563380_g31609_i0	PRJNA1034995	31765	256	8.56338	21.9222528	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	169	8.36e-51	NR	HET7242983.1	2169593	g31609	i0	98.7	2.77734375	79	1	92.6	0	19	255	115	193	HET7242983.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	711	169	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28266688	28266688	PRJNA1034995_S_NODE_41306_length_198_cov_10.961290_g41150_i0	PRJNA1034995	41306	198	10.96129	21.7033542	archaeon	1906665	Archaea	Archaea	62	1.91e-9	NR	NCQ52251.1	1906665	g41150	i0	50	0.939393939393939	62	30	93.9	1	3	188	144	204	NCQ52251.1 hypothetical protein [archaeon]	diamond	186	62	1	Archaea							archaeon
28298398	28298398	PRJNA1034995_S_NODE_29926_length_270_cov_7.748899_g29770_i0	PRJNA1034995	29926	270	7.748899	20.9220273	archaeon	1906665	Archaea	Archaea	106	1.74e-27	NR	NCQ52295.1	1906665	g29770	i0	60.8	0.877777777777778	79	31	87.8	0	33	269	1	79	NCQ52295.1 hypothetical protein [archaeon]	diamond	237	106	1	Archaea							archaeon
28740527	28740527	PRJNA1034995_S_NODE_38607_length_212_cov_7.307692_g38451_i0	PRJNA1034995	38607	212	7.307692	15.49230704	archaeon	1906665	Archaea	Archaea	52.8	7.02e-6	NR	MDP2438891.1	1906665	g38451	i0	52.9	0.721698113207547	51	24	72.2	0	187	35	323	373	MDP2438891.1 hypothetical protein [archaeon]	diamond	153	52.8	1	Archaea							archaeon

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