metadata: contig_metadata: 6 rows where bioproject = "PRJNA454503", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA454503", 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
442116	442116	PRJNA454503_P_NODE_18901_length_274_cov_1.220657_g18572_i0	PRJNA454503	18901	274	1.220657	3.34460018	Platynereis dumerilii	6359	Annelida	Annelida	233	8.37e-57	NTclustered	gi\|672425693\|gb\|KJ834012.1\|	6359	g18572	i0	83.012	89.5839416058394	259	42	94	2	17	274	1697	1440	Platynereis dumerilii myosin heavy chain (Mhc) mRNA, partial cds	blastn	24546	233	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Phyllodocida	Nereididae	Platynereis	Platynereis dumerilii
8095781	8095781	PRJNA454503_P_NODE_58127_length_210_cov_0.872483_g57798_i0	PRJNA454503	58127	210	0.872483	1.8322143	Opisthokonta	33154	Annelida	Annelida	107	8.61e-27	NR	XP_009024801.1	6412	g57798	i0	84.4	39.9	64	10	91.4	0	208	17	8	71	XP_009024801.1 hypothetical protein HELRODRAFT_155141 [Helobdella robusta]	diamond	8379	107	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
9370257	9370257	PRJNA454503_P_NODE_39208_length_228_cov_1.167665_g38879_i0	PRJNA454503	39208	228	1.167665	2.6622762	Mesenchytraeus cf. pedatus SL-2017	2052678	Annelida	Annelida	183	6.909999999999998e-42	NTclustered	gi\|1275874787\|gb\|KU728824.2\|	2052678	g38879	i0	82.547	74.140350877193	212	33	92	4	19	228	783	574	Mesenchytraeus cf. pedatus SL-2017 glyceraldehyde-3-phosphate dehydrogenase mRNA, complete cds	blastn	16904	183	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Enchytraeida	Enchytraeidae	Mesenchytraeus	Mesenchytraeus cf. pedatus SL-2017
22119152	22119152	PRJNA454503_P_NODE_55458_length_211_cov_0.866667_g55129_i0	PRJNA454503	55458	211	0.866667	1.82866737	Hirudo verbana	311461	Annelida	Annelida	54.7	0.005	NTclustered	gi\|2918369710\|emb\|OZ237789.1\|	311461	g55129	i0	100	1.35071090047393	29	0	14	0	132	160	1570098	1570126	Hirudo verbana genome assembly, chromosome: 11	blastn	285	54.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Hirudinida	Hirudinidae	Hirudo	Hirudo verbana
28039962	28039962	PRJNA454503_P_NODE_33105_length_235_cov_1.494253_g32776_i0	PRJNA454503	33105	235	1.494253	3.51149455	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	162	2.0299999999999998e-48	NR	CAH1780222.1	6347	g32776	i0	100	170.272340425532	78	0	99.6	0	234	1	112	189	CAH1780222.1 unnamed protein product [Owenia fusiformis]	diamond	40014	162	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
29886739	29886739	PRJNA454503_P_NODE_55831_length_211_cov_0.866667_g55502_i0	PRJNA454503	55831	211	0.866667	1.82866737	Capitella teleta	283909	Annelida	Annelida	55.1	9.66e-7	NR	ELU07327.1	283909	g55502	i0	71.4	0.497630331753554	35	9	48.3	1	108	209	8	42	ELU07327.1 hypothetical protein CAPTEDRAFT_104207 [Capitella teleta]	diamond	105	55.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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