metadata: contig_metadata: 5 rows where tax_clade = "Luna-2 subcluster" and tax

5 rows where tax_clade = "Luna-2 subcluster" and tax_phylum = "Actinomycetota"

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_species
10079734	10079734	PRJNA630162_P_NODE_15568_length_476_cov_793.203747_g14072_i0	PRJNA630162	15568	476	793.203747	3775.64983572	Aurantimicrobium	1705353	Bacteria	Bacteria	549	1.3499999999999994e-151	NTclustered	gi\|45260656\|emb\|AJ507464.2\|	207604	g14072	i0	98.095	64.186974789916	315	6	66	0	1	315	498	184	Actinobacterium MWH-Wo1 16S rRNA gene, ITS1, and partial 23S rRNA gene, strain MWH-Wo1	blastn	30553	549	1	Bacteria	Luna-2 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	actinobacterium MWH-Wo1
13746241	13746241	PRJEB64798_P_NODE_13291_length_547_cov_5811.212851_g11647_i0	PRJEB64798	13291	547	5811.212851	31787.33429497	Aurantimicrobium	1705353	Bacteria	Bacteria	828	0	NTclustered	gi\|45260656\|emb\|AJ507464.2\|	207604	g11647	i0	94.757	68.2851919561243	534	25	97	3	1	532	544	12	Actinobacterium MWH-Wo1 16S rRNA gene, ITS1, and partial 23S rRNA gene, strain MWH-Wo1	blastn	37352	835	0.991616766467066	Bacteria	Luna-2 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	actinobacterium MWH-Wo1
16295568	16295568	PRJEB64798_P_NODE_15373_length_508_cov_3790.943355_g13686_i0	PRJEB64798	15373	508	3790.943355	19257.9922434	Aurantimicrobium	1705353	Bacteria	Bacteria	710	0	NTclustered	gi\|45260656\|emb\|AJ507464.2\|	207604	g13686	i0	92.57	66.505905511811	498	31	97	5	16	508	12	508	Actinobacterium MWH-Wo1 16S rRNA gene, ITS1, and partial 23S rRNA gene, strain MWH-Wo1	blastn	33785	717	0.99023709902371	Bacteria	Luna-2 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	actinobacterium MWH-Wo1
20119344	20119344	PRJEB64798_P_NODE_13296_length_547_cov_3130.510040_g11652_i0	PRJEB64798	13296	547	3130.51004	17123.8899188	Aurantimicrobium	1705353	Bacteria	Bacteria	822	0	NTclustered	gi\|45260656\|emb\|AJ507464.2\|	207604	g11652	i0	94.569	68.2778793418647	534	26	97	3	1	532	544	12	Actinobacterium MWH-Wo1 16S rRNA gene, ITS1, and partial 23S rRNA gene, strain MWH-Wo1	blastn	37348	830	0.990361445783133	Bacteria	Luna-2 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	actinobacterium MWH-Wo1
20292660	20292660	PRJNA674048_P_NODE_6816_length_382_cov_16.360360_g6613_i0	PRJNA674048	6816	382	16.36036	62.4965752	Aurantimicrobium	1705353	Bacteria	Bacteria	542	1.7699999999999999e-149	NTclustered	gi\|45260656\|emb\|AJ507464.2\|	207604	g6613	i0	98.377	78.3429319371728	308	5	81	0	1	308	494	187	Actinobacterium MWH-Wo1 16S rRNA gene, ITS1, and partial 23S rRNA gene, strain MWH-Wo1	blastn	29927	542	1	Bacteria	Luna-2 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	actinobacterium MWH-Wo1

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