metadata: contig_metadata: 6 rows where bioproject = "PRJNA1245487" and tax

6 rows where bioproject = "PRJNA1245487" and tax_phylum = "Nematoda"

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
2902011	2902011	PRJNA1245487_P_NODE_3423_length_676_cov_2.436153_g3097_i0	PRJNA1245487	3423	676	2.436153	16.46839428	Meloidogyne graminicola	189291	Nematoda	Nematoda	112	4.31e-26	NR	AVZ46778.1	189291	g3097	i0	51.5	0.576923076923077	130	62	57.2	1	534	148	117	246	AVZ46778.1 hypothetical protein [Meloidogyne graminicola]	diamond	390	112	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Meloidogynidae	Meloidogyne	Meloidogyne graminicola
8704057	8704057	PRJNA1245487_P_NODE_11807_length_340_cov_3.486891_g11469_i0	PRJNA1245487	11807	340	3.486891	11.8554294	Chromadorea	119089	Nematoda	Nematoda	322	2.22e-83	NTclustered	gi\|32527518\|gb\|AY210806.1\|	6252	g11469	i0	83.871	99.2941176470588	341	51	100	3	1	340	2224	2561	Ascaris lumbricoides 5.8S ribosomal RNA and 28S ribosomal RNA genes, partial sequence	blastn	33760	322	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Ascarididae	Ascaris	Ascaris lumbricoides
19477146	19477146	PRJNA1245487_P_NODE_15376_length_288_cov_1.600000_g15038_i0	PRJNA1245487	15376	288	1.6	4.608	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	1.75e-27	NR	KAH7709244.1	70226	g15038	i0	60.6	8.86458333333333	94	37	97.9	0	3	284	731	824	KAH7709244.1 P-type ATPase [Aphelenchoides avenae]	diamond	2553	116	0.991379310344828	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides avenae
19477209	19477209	PRJNA1245487_P_NODE_19336_length_252_cov_0.871508_g18998_i0	PRJNA1245487	19336	252	0.871508	2.19620016	Paracanthonchus caecus	73922	Nematoda	Nematoda	215	2.75e-51	NTclustered	gi\|2130729776\|gb\|OL416396.1\|	73922	g18998	i0	82.857	98.5079365079365	245	37	96	5	1	243	1989	1748	Paracanthonchus caecus isolate Pc-OVN-2021 large subunit ribosomal RNA gene, partial sequence	blastn	24824	215	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Chromadorida	Cyatholaimidae	Paracanthonchus	Paracanthonchus caecus
20752629	20752629	PRJNA1245487_P_NODE_20237_length_248_cov_4.508571_g19899_i0	PRJNA1245487	20237	248	4.508571	11.18125608	Paracanthonchus caecus	73922	Nematoda	Nematoda	132	2.8e-26	NTclustered	gi\|2130729776\|gb\|OL416396.1\|	73922	g19899	i0	77.729	3.74596774193548	229	42	90	9	27	248	1781	1555	Paracanthonchus caecus isolate Pc-OVN-2021 large subunit ribosomal RNA gene, partial sequence	blastn	929	132	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Chromadorida	Cyatholaimidae	Paracanthonchus	Paracanthonchus caecus
27421472	27421472	PRJNA1245487_P_NODE_8263_length_425_cov_1.758523_g7925_i0	PRJNA1245487	8263	425	1.758523	7.47372275	Aphelenchoides bicaudatus	293665	Nematoda	Nematoda	156	8.269999999999999e-45	NR	KAI6182696.1	293665	g7925	i0	64.8	4.29882352941176	122	43	86.1	0	366	1	15	136	KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus]	diamond	1827	156	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Aphelenchoididae	Aphelenchoides	Aphelenchoides bicaudatus

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