metadata: contig_metadata: 9 rows where bioproject = "PRJEB6054", tax_phylum = "Annelida" and tax

9 rows where bioproject = "PRJEB6054", tax_phylum = "Annelida" and tax_superkingdom = "Eukaryota"

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
25523132	25523132	PRJEB6054_S_NODE_3841_length_242_cov_563.125604_g3752_i0	PRJEB6054	3841	242	563.125604	1362.76396168	Lumbriculus sp. EZ-2	2480966	Annelida	Annelida	324	4.18e-84	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g3752	i0	99.438	71.5785123966942	178	1	74	0	65	242	3420	3243	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	17322	324	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
25658987	25658987	PRJEB6054_S_NODE_3434_length_252_cov_59384.700461_g3345_i0	PRJEB6054	3434	252	59384.700461	149649.44516172	Lumbriculus sp. EZ-2	2480966	Annelida	Annelida	324	4.39e-84	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g3345	i0	99.438	68.2896825396825	178	1	71	0	1	178	3243	3420	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	17209	324	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
25794920	25794920	PRJEB6054_S_NODE_13491_length_158_cov_3.764228_g13402_i0	PRJEB6054	13491	158	3.764228	5.94748024	Hirudo verbana	311461	Annelida	Annelida	100	4.6e-17	NTclustered	gi\|2918369714\|emb\|OZ237790.1\|	311461	g13402	i0	91.892	10.5886075949367	74	3	47	2	85	158	6008169	6008099	Hirudo verbana genome assembly, chromosome: 12	blastn	1673	100	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
25795053	25795053	PRJEB6054_S_NODE_3379_length_254_cov_1606.799087_g3290_i0	PRJEB6054	3379	254	1606.799087	4081.26968098	Lumbriculus sp. EZ-2	2480966	Annelida	Annelida	350	7.3e-92	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g3290	i0	99.479	69.0511811023622	192	1	76	0	63	254	3434	3243	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	17539	350	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
25931120	25931120	PRJEB6054_S_NODE_1116_length_365_cov_7.651515_g1028_i0	PRJEB6054	1116	365	7.651515	27.92802975	Aeolosoma sp. GG-2	55817	Annelida	Annelida	220	8.97e-53	NTclustered	gi\|342220097\|gb\|HQ691208.1\|	1071604	g1028	i0	79.118	34.4438356164384	340	55	90	11	24	351	14	349	Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	12572	220	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Aeolosomatidae	Aeolosoma	Aeolosoma sp. GG-2011
26203642	26203642	PRJEB6054_S_NODE_3838_length_242_cov_2691.700483_g3749_i0	PRJEB6054	3838	242	2691.700483	6513.91516886	Lumbriculus sp. EZ-2	2480966	Annelida	Annelida	324	4.18e-84	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g3749	i0	99.438	71.0082644628099	178	1	74	0	65	242	3420	3243	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	17184	324	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
26431776	26431776	PRJEB6054_S_NODE_4287_length_233_cov_63725.676768_g4198_i0	PRJEB6054	4287	233	63725.676768	148480.82686944	root	1	Root_unresolved	Root_unresolved	78.7	3.44e-10	NTclustered	gi\|440586614\|emb\|HE971740.1\|	6359	g4198	i0	97.826	19.1587982832618	46	0	19	1	4	48	1	46	Platynereis dumerilii mRNA for RRM domain protein Musashi (musashi gene)	blastn	4464	78.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
26475704	26475704	PRJEB6054_S_NODE_3336_length_255_cov_60896.968182_g3247_i0	PRJEB6054	3336	255	60896.968182	155287.2688641	Lumbriculus sp. EZ-2	2480966	Annelida	Annelida	327	3.44e-85	NTclustered	gi\|1494622620\|gb\|MK076419.1\|	2480966	g3247	i0	97.396	67.9607843137255	192	5	75	0	1	192	3243	3434	Lumbriculus sp. EZ-2019 isolate ANN_LUMva large subunit ribosomal RNA gene, partial sequence	blastn	17330	327	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Lumbriculida	Lumbriculidae	Lumbriculus	Lumbriculus sp. EZ-2019
26475756	26475756	PRJEB6054_S_NODE_4840_length_227_cov_1.723958_g4751_i0	PRJEB6054	4840	227	1.723958	3.91338466	Helobdella robusta	6412	Annelida	Annelida	54.7	0.006	NTclustered	gi\|85060524\|gb\|AC171133.2\|	6412	g4751	i0	100	0.127753303964758	29	0	13	0	93	121	101233	101261	Helobdella robusta clone CH306-1A4, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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