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

10 rows where analysis = "blastn", bioproject = "PRJNA1175041" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5420677	5420677	PRJNA1175041_P_NODE_98305_length_248_cov_0.868571_g95437_i0	PRJNA1175041	98305	248	0.868571	2.15405608	Corynebacterium hadale	2026255	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g95437	i0	100	385.064516129032	248	0	100	0	1	248	1273267	1273514	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	95496	459	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
8694045	8694045	PRJNA1175041_P_NODE_46807_length_467_cov_1.446701_g43941_i0	PRJNA1175041	46807	467	1.446701	6.75609367	Corynebacterium	1716	Bacteria	Bacteria	841	0	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g43941	i0	99.355	366.758029978587	465	1	99	1	1	465	293904	294366	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	171276	841	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
9245502	9245502	PRJNA1175041_P_NODE_99028_length_247_cov_0.873563_g96160_i0	PRJNA1175041	99028	247	0.873563	2.15770061	Schaalia odontolytica	1660	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|1663040979\|gb\|CP040006.1\|	1660	g96160	i0	98.571	0.283400809716599	70	1	28	0	1	70	1127189	1127258	Schaalia odontolytica strain XH001 chromosome, complete genome	blastn	70	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
9969264	9969264	PRJNA1175041_P_NODE_99408_length_247_cov_0.862069_g96540_i0	PRJNA1175041	99408	247	0.862069	2.12931043	Bifidobacterium	1678	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2450724931\|gb\|CP118598.1\|	1679	g96540	i0	99.595	8	247	1	100	0	1	247	1222869	1223115	Bifidobacterium longum subsp. longum strain F2 chromosome, complete genome	blastn	1976	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
13794446	13794446	PRJNA1175041_P_NODE_96051_length_250_cov_1.000000_g93183_i0	PRJNA1175041	96051	250	1	2.5	Geodermatophilaceae	85030	Bacteria	Bacteria	302	2.04e-77	NTclustered	gi\|507148190\|ref\|NR_102997.1\|	138336	g93183	i0	88.538	241.064	253	24	100	5	1	250	1652	1402	Blastococcus saxobsidens strain DD2 23S ribosomal RNA gene, complete sequence	blastn	60266	303	0.996699669966997	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Blastococcus	Blastococcus saxobsidens
14346520	14346520	PRJNA1175041_P_NODE_90452_length_265_cov_0.973958_g87584_i0	PRJNA1175041	90452	265	0.973958	2.5809887	Corynebacterium gottingense	2041036	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2869851930\|gb\|CP175790.1\|	2041036	g87584	i0	99.623	362.581132075472	265	1	100	0	1	265	244019	244283	Corynebacterium gottingense strain YSMAA1_1_F6 chromosome, complete genome	blastn	96084	484	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
16893568	16893568	PRJNA1175041_P_NODE_105694_length_241_cov_0.904762_g102826_i0	PRJNA1175041	105694	241	0.904762	2.18047642	Streptomyces sp. 11x1	3038642	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2591930018\|gb\|CP122458.1\|	3038642	g102826	i0	96.875	0.132780082987552	32	0	13	1	91	122	5456664	5456634	Streptomyces sp. 11x1 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. 11x1
22718040	22718040	PRJNA1175041_P_NODE_79638_length_295_cov_1.063063_g76770_i0	PRJNA1175041	79638	295	1.063063	3.13603585	Corynebacterium	1716	Bacteria	Bacteria	512	1.04e-140	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g76770	i0	97.966	433.840677966102	295	6	100	0	1	295	735100	735394	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	127983	512	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale
22718041	22718041	PRJNA1175041_P_NODE_79918_length_294_cov_1.262443_g77050_i0	PRJNA1175041	79918	294	1.262443	3.71158242	Corynebacterium	1716	Bacteria	Bacteria	514	2.8899999999999997e-141	NTclustered	gi\|2869815348\|gb\|CP175785.1\|	1979527	g77050	i0	98.299	370.585034013605	294	3	100	2	1	294	545944	546235	Corynebacterium kefirresidentii strain YSMAA1_2_B7 chromosome, complete genome	blastn	108952	514	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
22718057	22718057	PRJNA1175041_P_NODE_99958_length_246_cov_0.878613_g97090_i0	PRJNA1175041	99958	246	0.878613	2.16138798	Corynebacterium	1716	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2537331151\|gb\|CP047655.1\|	2026255	g97090	i0	97.154	4.00813008130081	246	7	100	0	1	246	17556	17311	Corynebacterium hadale strain DSM 105365 chromosome, complete genome	blastn	986	416	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium hadale

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