metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax_phylum = "Cnidaria"

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
192577	192577	PRJNA1078753_P_NODE_33341_length_247_cov_0.885057_g33145_i0	PRJNA1078753	33341	247	0.885057	2.18609079	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	58.4	4.8e-4	NTclustered	gi\|2917940720\|emb\|OZ237562.1\|	6108	g33145	i0	97.059	1.29554655870445	34	1	14	0	55	88	13425250	13425217	Anemonia sulcata genome assembly, chromosome: 8	blastn	320	58.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
2743422	2743422	PRJNA1078753_P_NODE_7003_length_407_cov_2.000000_g6807_i0	PRJNA1078753	7003	407	2	8.14	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	270	9.91e-68	NTclustered	gi\|2744777682\|ref\|XM_002168013.5\|	6087	g6807	i0	79.839	28.041769041769	372	73	91	2	37	407	1005	635	PREDICTED: Hydra vulgaris rRNA 2'-O-methyltransferase fibrillarin (LOC100212665), transcript variant X1, mRNA	blastn	11413	270	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
5295329	5295329	PRJNA1078753_P_NODE_24485_length_260_cov_2.754011_g24289_i0	PRJNA1078753	24485	260	2.754011	7.1604286	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	104	6.45e-18	NTclustered	gi\|1176084880\|ref\|XM_020757016.1\|	48498	g24289	i0	82.353	6.35	119	21	46	0	38	156	194	312	PREDICTED: Orbicella faveolata GTPase HRas (LOC110051044), mRNA	blastn	1651	104	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata
6120025	6120025	PRJNA1078753_P_NODE_18465_length_285_cov_1.320755_g18269_i0	PRJNA1078753	18465	285	1.320755	3.76415175	Opisthokonta	33154	Cnidaria	other_Eukaryota	56.5	0.002	NTclustered	gi\|2917940745\|emb\|OZ237569.1\|	6108	g18269	i0	89.13	5.79298245614035	46	3	15	2	212	255	12914149	12914194	Anemonia sulcata genome assembly, chromosome: 15	blastn	1651	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
11220312	11220312	PRJNA1078753_P_NODE_18549_length_285_cov_1.089623_g18353_i0	PRJNA1078753	18549	285	1.089623	3.10542555	Metazoa	33208	Cnidaria	other_Eukaryota	54.7	0.007	NTclustered	gi\|2917940687\|emb\|OZ237555.1\|	6108	g18353	i0	100	13.1473684210526	29	0	10	0	11	39	3463069	3463097	Anemonia sulcata genome assembly, chromosome: 1	blastn	3747	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
12946235	12946235	PRJNA1078753_P_NODE_18211_length_286_cov_1.333333_g18015_i0	PRJNA1078753	18211	286	1.333333	3.81333238	Eunicella cavolini	317547	Cnidaria	other_Eukaryota	54.7	0.007	NTclustered	gi\|2918369563\|emb\|OZ237729.1\|	317547	g18015	i0	100	0.101398601398601	29	0	10	0	89	117	1399049	1399077	Eunicella cavolini genome assembly, chromosome: 13	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Eunicellidae	Eunicella	Eunicella cavolini
12946319	12946319	PRJNA1078753_P_NODE_2831_length_594_cov_3.719770_g2639_i0	PRJNA1078753	2831	594	3.71977	22.0954338	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	446	2.31e-120	NTclustered	gi\|2782899435\|ref\|XM_067068137.1\|	252671	g2639	i0	80.789	151.616161616162	583	101	97	11	1	577	687	110	PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA	blastn	90060	446	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
14221157	14221157	PRJNA1078753_P_NODE_12092_length_332_cov_1.760618_g11896_i0	PRJNA1078753	12092	332	1.760618	5.84525176	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	154	8.33e-33	NTclustered	gi\|2744834012\|ref\|XM_012705347.3\|	6087	g11896	i0	79.717	42.4909638554217	212	43	64	0	10	221	2255	2466	PREDICTED: Hydra vulgaris sodium/potassium-transporting ATPase subunit alpha-like (LOC100197585), mRNA	blastn	14107	154	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
18044330	18044330	PRJNA1078753_P_NODE_2955_length_584_cov_2.174168_g2763_i0	PRJNA1078753	2955	584	2.174168	12.69714112	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	340	1.1e-88	NTclustered	gi\|2782931191\|ref\|XM_067074155.1\|	252671	g2763	i0	79.43	35.7893835616438	491	94	84	5	32	519	165	651	PREDICTED: Clytia hemisphaerica ADP-ribosylation factor 2 (LOC136817831), mRNA	blastn	20901	340	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
24418378	24418378	PRJNA1078753_P_NODE_17660_length_288_cov_1.548837_g17464_i0	PRJNA1078753	17660	288	1.548837	4.46065056	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	241	5.3e-59	NTclustered	gi\|2782847639\|ref\|XM_067056506.1\|	252671	g17464	i0	85.345	70.4270833333333	232	34	81	0	28	259	382	151	PREDICTED: Clytia hemisphaerica histone H3 (LOC136799799), mRNA	blastn	20283	241	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica

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