metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
290145	290145	PRJNA1146029_P_NODE_2161_length_589_cov_1.750000_g1888_i0	PRJNA1146029	2161	589	1.75	10.3075	Glycera tridactyla	104710	Annelida	Annelida	255	4.13e-63	NTclustered	gi\|324105254\|gb\|HQ729957.1\|	104710	g1888	i0	78.78	1.85398981324278	377	78	64	2	7	382	501	126	Glycera tridactyla ribosomal protein rpl6 mRNA, partial cds	blastn	1092	255	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Glyceridae	Glycera	Glycera tridactyla
4117227	4117227	PRJNA1146029_P_NODE_664_length_1112_cov_75.622714_g489_i0	PRJNA1146029	664	1112	75.622714	840.92457968	Aeolosoma sp. GG-2011	1071604	Annelida	Annelida	359	5.95e-94	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g489	i0	81.25	17.0269784172662	464	70	41	12	537	988	14	472	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	18934	359	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
9218236	9218236	PRJNA1146029_P_NODE_5968_length_360_cov_1.222997_g5690_i0	PRJNA1146029	5968	360	1.222997	4.4027892	Aeolosoma sp. THS-2006	397537	Annelida	Annelida	350	1.08e-91	NTclustered	gi\|112144441\|gb\|DQ813345.1\|	397537	g5690	i0	84.167	78.5916666666667	360	57	100	0	1	360	68	427	Aeolosoma sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds	blastn	28293	350	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. THS-2006
11236923	11236923	PRJNA1146029_P_NODE_4909_length_391_cov_1.415094_g4631_i0	PRJNA1146029	4909	391	1.415094	5.53301754	Polynoidae	46593	Annelida	Annelida	86.1	3.69e-12	NTclustered	gi\|2054260827\|gb\|MZ131647.1\|	862921	g4631	i0	77.564	9.80051150895141	156	26	39	8	109	261	10319	10170	Arctonoe vittata mitochondrion, complete genome	blastn	3832	86.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Polynoidae	Arctonoe	Arctonoe vittata
14318902	14318902	PRJNA1146029_P_NODE_11992_length_278_cov_1.375610_g11711_i0	PRJNA1146029	11992	278	1.37561	3.8241958	Hirudo verbana	311461	Annelida	Annelida	52.8	0.026	NTclustered	gi\|2918369620\|emb\|OZ237782.1\|	311461	g11711	i0	100	0.100719424460432	28	0	10	0	251	278	13761102	13761075	Hirudo verbana genome assembly, chromosome: 4	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
18141912	18141912	PRJNA1146029_P_NODE_3535_length_454_cov_1.897638_g3257_i0	PRJNA1146029	3535	454	1.897638	8.61527652	Platynereis dumerilii	6359	Annelida	Annelida	265	5.19e-66	NTclustered	gi\|83307378\|emb\|CT033352.1\|	6359	g3257	i0	80.882	8.36123348017621	340	61	74	4	3	340	117	454	Platynereis dumerilii EST IB0AAA22AA06FM1	blastn	3796	265	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
21966860	21966860	PRJNA1146029_P_NODE_13438_length_269_cov_1.178571_g13157_i0	PRJNA1146029	13438	269	1.178571	3.17035599	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	124	5.15e-24	NTclustered	gi\|2920003257\|emb\|OZ238860.1\|	1046305	g13157	i0	78.5	1.57620817843866	200	36	73	6	40	235	30178048	30177852	Ailoscolex lacteospumosus genome assembly, chromosome: 1	blastn	424	124	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
21966980	21966980	PRJNA1146029_P_NODE_2058_length_605_cov_1.672932_g1786_i0	PRJNA1146029	2058	605	1.672932	10.1212386	Eurythoe complanata	167815	Annelida	Annelida	422	3.96e-113	NTclustered	gi\|158187819\|gb\|EU124994.1\|	167815	g1786	i0	79.693	4.85454545454545	586	115	97	4	11	594	120	703	Eurythoe complanata ribosomal protein rps3a mRNA, complete cds	blastn	2937	422	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Eunicida	Amphinomidae	Eurythoe	Eurythoe complanata
21967023	21967023	PRJNA1146029_P_NODE_3458_length_459_cov_3.080311_g3180_i0	PRJNA1146029	3458	459	3.080311	14.13862749	Aeolosoma viride	394736	Annelida	Annelida	438	2.9299999999999993e-118	NTclustered	gi\|1151119859\|gb\|KY079093.1\|	394736	g3180	i0	90.606	72.8257080610022	330	31	72	0	5	334	398	69	Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds	blastn	33427	438	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma viride
23242549	23242549	PRJNA1146029_P_NODE_3119_length_483_cov_1.702439_g2842_i0	PRJNA1146029	3119	483	1.702439	8.22278037	Arenicola marina	6344	Annelida	Annelida	270	1.1899999999999998e-67	NTclustered	gi\|158187777\|gb\|EU124973.1\|	6344	g2842	i0	80.27	54.6273291925466	370	63	76	7	84	448	113	477	Arenicola marina ribosomal protein rpl23a mRNA, partial cds	blastn	26385	270	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
23242645	23242645	PRJNA1146029_P_NODE_8799_length_306_cov_2.163090_g8518_i0	PRJNA1146029	8799	306	2.16309	6.6190554	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	265	3.37e-66	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g8518	i0	83.391	31.8104575163399	289	44	94	4	20	306	23625577	23625291	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	9734	265	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus
24516086	24516086	PRJNA1146029_P_NODE_3460_length_459_cov_2.720207_g3182_i0	PRJNA1146029	3460	459	2.720207	12.48575013	Ailoscolex lacteospumosus	1046305	Annelida	Annelida	124	9.31e-24	NTclustered	gi\|2920003545\|emb\|OZ238868.1\|	1046305	g3182	i0	74.582	0.651416122004357	299	68	64	7	1	295	17674753	17675047	Ailoscolex lacteospumosus genome assembly, chromosome: 9	blastn	299	124	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Ailoscolecidae	Ailoscolex	Ailoscolex lacteospumosus

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