metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Ascomycota"

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
27121018	27121018	PRJNA998413_S_NODE_4342_length_286_cov_1.201794_g4311_i0	PRJNA998413	4342	286	1.201794	3.43713084	Sarocladium implicatum	1610689	Fungi	Fungi	43.5	0.0331	NR	KAH8172320.1	1610689	g4311	i0	79.2	0.251748251748252	24	5	25.2	0	1	72	495	518	KAH8172320.1 reverse transcriptase (RNA-dependent DNA polymerase) domain-containing protein [Sarocladium implicatum]	diamond	72	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
27721968	27721968	PRJNA998413_S_NODE_7804_length_240_cov_1.892655_g7773_i0	PRJNA998413	7804	240	1.892655	4.542372	Sarocladium strictum	5046	Fungi	Fungi	51.2	2.56e-5	NR	KAL2211635.1	5046	g7773	i0	89.7	0.3625	29	3	36.3	0	89	175	202	230	KAL2211635.1 hypothetical protein CC79DRAFT_1363933 [Sarocladium strictum]	diamond	87	51.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28447916	28447916	PRJNA998413_S_NODE_12446_length_212_cov_0.899329_g12415_i0	PRJNA998413	12446	212	0.899329	1.90657748	Sarocladium strictum	5046	Fungi	Fungi	83.2	6.12e-17	NR	KAL2211892.1	5046	g12415	i0	87.5	0.566037735849057	40	5	56.6	0	211	92	287	326	KAL2211892.1 nicotinamide N-methyltransferase [Sarocladium strictum]	diamond	120	83.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28479358	28479358	PRJNA998413_S_NODE_4206_length_288_cov_2.697778_g4175_i0	PRJNA998413	4206	288	2.697778	7.76960064	Ophiocordyceps polyrhachis-furcata BCC 54312	1330021	Fungi	Fungi	82.4	7.32e-17	NR	RCI16660.1	1330021	g4175	i0	58.5	0.854166666666667	82	33	84.4	1	276	34	135	216	RCI16660.1 hypothetical protein L249_3291 [Ophiocordyceps polyrhachis-furcata BCC 54312]	diamond	246	82.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps polyrhachis-furcata
29148616	29148616	PRJNA998413_S_NODE_9709_length_224_cov_1.664596_g9678_i0	PRJNA998413	9709	224	1.664596	3.72869504	Eukaryota	2759	Fungi	Fungi	52	1.58e-5	NR	QDS68068.1	50376	g9678	i0	57.5	3.83035714285714	40	17	53.6	0	3	122	160	199	QDS68068.1 hypothetical protein FKW77_009870 [Venturia effusa]	diamond	858	52.4	0.99236641221374	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Venturiales	Venturiaceae	Venturia	Venturia effusa
30500485	30500485	PRJNA998413_S_NODE_6993_length_248_cov_2.443243_g6962_i0	PRJNA998413	6993	248	2.443243	6.05924264	Sarocladium strictum	5046	Fungi	Fungi	72	4.59e-13	NR	KAK0383648.1	5046	g6962	i0	69.6	0.67741935483871	56	17	67.7	0	1	168	171	226	KAK0383648.1 hypothetical protein NLU13_9559 [Sarocladium strictum]	diamond	168	72	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31290315	31290315	PRJNA998413_S_NODE_7295_length_245_cov_1.840659_g7264_i0	PRJNA998413	7295	245	1.840659	4.50961455	Sarocladium strictum	5046	Fungi	Fungi	87.8	1.06e-19	NR	KAK0385511.1	5046	g7264	i0	65	0.73469387755102	60	21	73.5	0	6	185	107	166	KAK0385511.1 hypothetical protein NLU13_6691 [Sarocladium strictum]	diamond	180	87.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
32176406	32176406	PRJNA998413_S_NODE_6178_length_257_cov_2.530928_g6147_i0	PRJNA998413	6178	257	2.530928	6.50448496	Sarocladium strictum	5046	Fungi	Fungi	49.7	1.03e-4	NR	KAL2214572.1	5046	g6147	i0	100	0.280155642023346	24	0	28	0	1	72	189	212	KAL2214572.1 hypothetical protein CC79DRAFT_151479 [Sarocladium strictum]	diamond	72	49.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum

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