metadata: contig_metadata: 8 rows where bioproject = "PRJNA669701", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA669701", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

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
1912232	1912232	PRJNA669701_P_NODE_64842_length_306_cov_1.321888_g64447_i0	PRJNA669701	64842	306	1.321888	4.04497728	Hirudo verbana	311461	Annelida	Annelida	54.7	0.008	NTclustered	gi\|2918369718\|emb\|OZ237791.1\|	311461	g64447	i0	96.875	0.209150326797386	32	1	10	0	44	75	7947858	7947889	Hirudo verbana genome assembly, chromosome: 13	blastn	64	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
2440001	2440001	PRJNA669701_P_NODE_86322_length_274_cov_2.482587_g85927_i0	PRJNA669701	86322	274	2.482587	6.80228838	Metazoa	33208	Annelida	Annelida	209	1.41e-49	NTclustered	gi\|1068288397\|gb\|KU728766.1\|	6390	g85927	i0	80.97	77.1021897810219	268	47	97	4	8	273	1082	817	Enchytraeus albidus mitochondrial ATP synthase subunit beta precursor, mRNA, partial cds; nuclear gene for mitochondrial product	blastn	21126	209	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Enchytraeus	Enchytraeus albidus
4463759	4463759	PRJNA669701_P_NODE_45804_length_353_cov_1.100000_g45409_i0	PRJNA669701	45804	353	1.1	3.883	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	65.8	4.29e-6	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g45409	i0	100	1.1643059490085	35	0	10	0	34	68	22690197	22690163	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	411	65.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
4464364	4464364	PRJNA669701_P_NODE_91624_length_268_cov_1.579487_g91229_i0	PRJNA669701	91624	268	1.579487	4.23302516	Hirudo verbana	311461	Annelida	Annelida	52.8	0.025	NTclustered	gi\|2918369693\|emb\|OZ237785.1\|	311461	g91229	i0	100	0.417910447761194	28	0	10	0	30	57	2109487	2109514	Hirudo verbana genome assembly, chromosome: 7	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
4992285	4992285	PRJNA669701_P_NODE_146904_length_229_cov_2.711538_g146509_i0	PRJNA669701	146904	229	2.711538	6.20942202	Opisthokonta	33154	Annelida	Annelida	111	3.32e-20	NTclustered	gi\|675851743\|ref\|XM_009013184.1\|	6412	g146509	i0	81.752	37.7423580786026	137	21	59	4	39	173	299	165	Helobdella robusta hypothetical protein partial mRNA	blastn	8643	111	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
10840281	10840281	PRJNA669701_P_NODE_75509_length_287_cov_2.037383_g75114_i0	PRJNA669701	75509	287	2.037383	5.84728921	Nais communis	188228	Annelida	Annelida	129	1.82e-33	NR	QUT13270.1	188228	g75114	i0	66.7	6.38675958188153	87	29	90.9	0	7	267	167	253	QUT13270.1 cytochrome b [Nais communis]	diamond	1833	129	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Nais	Nais communis
27303031	27303031	PRJNA669701_P_NODE_36923_length_388_cov_2.790476_g36528_i0	PRJNA669701	36923	388	2.790476	10.82704688	Helobdella robusta	6412	Annelida	Annelida	73.2	7.71e-13	NR	XP_009010058.1	6412	g36528	i0	62.3	2.96134020618557	53	20	41	0	21	179	88	140	XP_009010058.1 hypothetical protein HELRODRAFT_166577 [Helobdella robusta]	diamond	1149	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30378386	30378386	PRJNA669701_P_NODE_66592_length_302_cov_3.082969_g66197_i0	PRJNA669701	66592	302	3.082969	9.31056638	Metazoa	33208	Annelida	Annelida	70.1	7.86e-12	NR	CAH1783365.1	6347	g66197	i0	37	2.98013245033113	100	63	99.3	0	3	302	127	226	CAH1783365.1 unnamed protein product [Owenia fusiformis]	diamond	900	70.5	0.994326241134752	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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