metadata: contig_metadata: 9 rows where bioproject = "PRJNA1240804", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA1240804", tax_clade = "Opisthokonta" 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
347091	347091	PRJNA1240804_P_NODE_129121_length_165_cov_1.672414_g128755_i0	PRJNA1240804	129121	165	1.672414	2.7594831	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	56.5	0.001	NTclustered	gi\|2920003527\|emb\|OZ238867.1\|	1046305	g128755	i0	94.595	16.3575757575758	37	1	22	1	130	165	4649927	4649963	Ailoscolex lacteospumosus genome assembly, chromosome: 8	blastn	2699	56.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
1050020	1050020	PRJNA1240804_P_NODE_150801_length_162_cov_0.920354_g150435_i0	PRJNA1240804	150801	162	0.920354	1.49097348	Pontoscolex	195580	Annelida	Annelida	207	2.72e-49	NTclustered	gi\|674656338\|gb\|KJ912259.1\|	195581	g150435	i0	93.103	90.0123456790123	145	4	90	4	4	148	602	464	Pontoscolex corethrurus isolate MPL398 28S ribosomal RNA gene, partial sequence	blastn	14582	207	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Glossoscolecidae	Pontoscolex	Pontoscolex corethrurus
1621812	1621812	PRJNA1240804_P_NODE_128282_length_166_cov_0.888889_g127916_i0	PRJNA1240804	128282	166	0.888889	1.47555574	Bonellia sp. (in: spoonworms)	104708	Annelida	Annelida	93.5	8.19e-15	NTclustered	gi\|6049734\|gb\|AF185229.1\|	104708	g127916	i0	89.333	138.265060240964	75	6	45	2	14	87	12	85	Bonellia sp. U2 small nuclear RNA, partial sequence	blastn	22952	93.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Echiuroidea	Bonelliidae	Bonellia	Bonellia sp. (in: spoonworms)
2899565	2899565	PRJNA1240804_P_NODE_65143_length_199_cov_0.946667_g64777_i0	PRJNA1240804	65143	199	0.946667	1.88386733	Proceraea cornuta	122240	Annelida	Annelida	76.8	1.02e-9	NTclustered	gi\|11494214\|gb\|AF212165.1\|AF212165	122240	g64777	i0	91.228	6.23115577889447	57	3	28	2	10	65	4781	4836	Proceraea cornuta internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	1240	76.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Syllidae	Proceraea	Proceraea cornuta
12528635	12528635	PRJNA1240804_P_NODE_140210_length_163_cov_2.535088_g139844_i0	PRJNA1240804	140210	163	2.535088	4.13219344	Lumbricidae	6392	Annelida	Annelida	246	5.8099999999999995e-61	NTclustered	gi\|383088835\|gb\|JQ739962.1\|	6396	g139844	i0	96.644	91.4110429447853	149	4	91	1	3	151	647	500	Eisenia fetida isolate H22 28S ribosomal RNA gene, partial sequence	blastn	14900	246	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia fetida
13803495	13803495	PRJNA1240804_P_NODE_20591_length_308_cov_2.243243_g20225_i0	PRJNA1240804	20591	308	2.243243	6.90918844	Metazoa	33208	Annelida	Annelida	113	1.3e-20	NTclustered	gi\|1294255823\|gb\|MG642145.1\|	223748	g20225	i0	89.888	27.7792207792208	89	8	29	1	220	308	601	514	Mesenchytraeus solifugus isolate Byron large subunit ribosomal RNA gene, partial sequence	blastn	8556	113	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Mesenchytraeus	Mesenchytraeus solifugus
18901681	18901681	PRJNA1240804_P_NODE_38455_length_241_cov_2.203125_g38089_i0	PRJNA1240804	38455	241	2.203125	5.30953125	Crassiclitellata	2803884	Annelida	Annelida	289	1.52e-73	NTclustered	gi\|11494215\|gb\|AF212166.1\|AF212166	6396	g38089	i0	89.778	33.49377593361	225	23	93	0	3	227	3622	3398	Eisenia fetida 28S ribosomal RNA gene, partial sequence	blastn	8072	289	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia fetida
22727166	22727166	PRJNA1240804_P_NODE_46018_length_225_cov_3.136364_g45652_i0	PRJNA1240804	46018	225	3.136364	7.056819	Megascolecidae	6400	Annelida	Annelida	285	1.81e-72	NTclustered	gi\|401022067\|gb\|JX177848.1\|	914164	g45652	i0	98.182	74.4	165	0	73	3	1	165	162	1	Microscolex dubius voucher 01_UFSM_28S 28S ribosomal RNA gene, partial sequence	blastn	16740	287	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Megascolecidae	Microscolex	Microscolex dubius
24575492	24575492	PRJNA1240804_P_NODE_88420_length_181_cov_1.143939_g88054_i0	PRJNA1240804	88420	181	1.143939	2.07052959	Microscolex dubius	914164	Annelida	Annelida	296	6.43e-76	NTclustered	gi\|401022067\|gb\|JX177848.1\|	914164	g88054	i0	98.795	91.9281767955801	166	2	92	0	3	168	550	385	Microscolex dubius voucher 01_UFSM_28S 28S ribosomal RNA gene, partial sequence	blastn	16639	296	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Megascolecidae	Microscolex	Microscolex dubius

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