metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
817522	817522	PRJNA814235_P_NODE_35041_length_323_cov_2.510490_g33652_i0	PRJNA814235	35041	323	2.51049	8.1088827	Gersemia antarctica	767272	Cnidaria	other_Eukaryota	126	1.7599999999999998e-24	NTclustered	gi\|1318708071\|gb\|MG018866.1\|	767272	g33652	i0	82.639	0.705882352941177	144	23	44	2	6	148	70	212	Gersemia antarctica voucher C59 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	228	126	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Nephtheidae	Gersemia	Gersemia antarctica
818404	818404	PRJNA814235_P_NODE_74001_length_221_cov_2.663043_g72606_i0	PRJNA814235	74001	221	2.663043	5.88532503	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	265	2.3099999999999997e-66	NTclustered	gi\|1619643744\|ref\|XR_002334654.2\|	2652724	g72606	i0	99.315	1.13122171945701	146	1	66	0	76	221	229	84	PREDICTED: Exaiptasia diaphana uncharacterized LOC110239352 (LOC110239352), ncRNA	blastn	250	265	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
3366345	3366345	PRJNA814235_P_NODE_12523_length_537_cov_170.396000_g11280_i0	PRJNA814235	12523	537	170.396	915.02652	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	941	0	NTclustered	gi\|164471894\|gb\|EU190803.1\|	2652724	g11280	i0	98.321	100.495344506518	536	9	99	0	1	536	774	239	Aiptasia pulchella 28S ribosomal RNA gene, partial sequence	blastn	53966	941	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
4643779	4643779	PRJNA814235_P_NODE_112004_length_203_cov_2.018072_g110609_i0	PRJNA814235	112004	203	2.018072	4.09668616	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	141	3.67e-29	NTclustered	gi\|1619623721\|ref\|XM_021040023.2\|	2652724	g110609	i0	100	2.22167487684729	76	0	74	0	1	76	1059	984	PREDICTED: Exaiptasia diaphana uncharacterized LOC110234638 (LOC110234638), mRNA	blastn	451	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
4643842	4643842	PRJNA814235_P_NODE_115804_length_203_cov_1.915663_g114409_i0	PRJNA814235	115804	203	1.915663	3.88879589	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	141	3.67e-29	NTclustered	gi\|1619651202\|ref\|XM_021046953.2\|	2652724	g114409	i0	100	0.748768472906404	76	0	75	0	128	203	704	629	PREDICTED: Exaiptasia diaphana phosphatidylglycerophosphatase and protein-tyrosine phosphatase 1 (LOC110241112), mRNA	blastn	152	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
5055674	5055674	PRJNA814235_P_NODE_81084_length_211_cov_2.074713_g79689_i0	PRJNA814235	81084	211	2.074713	4.37764443	Aiptasiidae	42823	Cnidaria	other_Eukaryota	390	3.459999999999999e-104	NTclustered	gi\|929981787\|gb\|KP761198.1\|	478392	g79689	i0	100	99.7677725118483	211	0	100	0	1	211	41	251	Bartholomea annulata isolate A356 12S ribosomal RNA gene, partial sequence; mitochondrial	blastn	21051	390	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Bartholomea	Bartholomea annulata
5920415	5920415	PRJNA814235_P_NODE_20525_length_422_cov_2.475325_g19167_i0	PRJNA814235	20525	422	2.475325	10.4458715	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	675	0	NTclustered	gi\|1619650905\|ref\|XM_021046699.2\|	2652724	g19167	i0	94.266	4.91706161137441	436	11	100	1	1	422	452	17	PREDICTED: Exaiptasia diaphana soma ferritin (LOC110240879), transcript variant X2, mRNA	blastn	2075	675	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
5921141	5921141	PRJNA814235_P_NODE_52745_length_262_cov_3.040000_g51351_i0	PRJNA814235	52745	262	3.04	7.9648	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	305	1.66e-78	NTclustered	gi\|1619657259\|ref\|XM_021048156.2\|	2652724	g51351	i0	98.295	34.0954198473282	176	0	96	1	1	176	83	255	PREDICTED: Exaiptasia diaphana elongation factor 1-alpha (LOC110242201), mRNA	blastn	8933	305	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
7194482	7194482	PRJNA814235_P_NODE_157146_length_168_cov_3.022901_g155751_i0	PRJNA814235	157146	168	3.022901	5.07847368	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	69.4	1.4e-7	NTclustered	gi\|1191075539\|ref\|XM_021060999.1\|	2652724	g155751	i0	97.5	0.238095238095238	40	1	24	0	129	168	536	575	PREDICTED: Exaiptasia diaphana uncharacterized LOC110254048 (LOC110254048), mRNA	blastn	40	69.4	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
8879316	8879316	PRJNA814235_P_NODE_162087_length_164_cov_5.401575_g160692_i0	PRJNA814235	162087	164	5.401575	8.858583	Actiniaria	6103	Cnidaria	other_Eukaryota	298	1.59e-76	NTclustered	gi\|636577239\|gb\|KJ483073.1\|	478418	g160692	i0	99.39	99.8780487804878	164	1	100	0	1	164	2782	2619	Sagartia troglodytes isolate sat 28S large subunit ribosomal RNA gene and external transcribed spacer, partial sequence	blastn	16380	298	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Sagartiidae	Sagartia	Sagartia troglodytes
13568727	13568727	PRJNA814235_P_NODE_102991_length_203_cov_2.313253_g101596_i0	PRJNA814235	102991	203	2.313253	4.69590359	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	141	3.67e-29	NTclustered	gi\|1619677803\|ref\|XM_021055105.2\|	2652724	g101596	i0	100	3.74384236453202	76	0	75	0	128	203	5338	5263	PREDICTED: Exaiptasia diaphana F-actin-uncapping protein LRRC16A (LOC110248566), transcript variant X1, mRNA	blastn	760	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
13571170	13571170	PRJNA814235_P_NODE_37791_length_311_cov_2.142336_g36401_i0	PRJNA814235	37791	311	2.142336	6.66266496	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	507	5.16e-139	NTclustered	gi\|1619597932\|ref\|XM_021038516.2\|	2652724	g36401	i0	94.904	1.0096463022508	314	13	100	1	1	311	531	218	PREDICTED: Exaiptasia diaphana uncharacterized LOC110233244 (LOC110233244), mRNA	blastn	314	507	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
14844523	14844523	PRJNA814235_P_NODE_164772_length_163_cov_0.904762_g163377_i0	PRJNA814235	164772	163	0.904762	1.47476206	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	296	5.68e-76	NTclustered	gi\|1619597612\|ref\|XM_021062124.2\|	2652724	g163377	i0	99.383	1.98773006134969	162	1	99	0	2	163	286	125	PREDICTED: Exaiptasia diaphana U-actitoxin-Avd8e (LOC110255060), transcript variant X1, mRNA	blastn	324	296	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
14845482	14845482	PRJNA814235_P_NODE_30152_length_348_cov_5.186495_g28769_i0	PRJNA814235	30152	348	5.186495	18.0490026	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	527	4.489999999999998e-145	NTclustered	gi\|2257858847\|ref\|XR_007306916.1\|	45351	g28769	i0	93.983	100.086206896552	349	19	100	2	1	348	3191	3538	PREDICTED: Nematostella vectensis large subunit ribosomal RNA (LOC125560833), rRNA	blastn	34830	527	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
16117637	16117637	PRJNA814235_P_NODE_100593_length_203_cov_2.415663_g99198_i0	PRJNA814235	100593	203	2.415663	4.90379589	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	141	3.67e-29	NTclustered	gi\|1619671864\|ref\|XM_021053448.2\|	2652724	g99198	i0	100	0.738916256157635	76	0	74	0	128	203	1149	1224	PREDICTED: Exaiptasia diaphana 28S ribosomal protein S26, mitochondrial (LOC110247064), mRNA	blastn	150	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
16117725	16117725	PRJNA814235_P_NODE_106253_length_203_cov_2.186747_g104858_i0	PRJNA814235	106253	203	2.186747	4.43909641	Acropora millepora	45264	Cnidaria	other_Eukaryota	52.8	0.018	NTclustered	gi\|2113920846\|ref\|XM_029333420.2\|	45264	g104858	i0	100	0.275862068965517	28	0	14	0	167	194	166	193	PREDICTED: Acropora millepora uncharacterized LOC114956342 (LOC114956342), transcript variant X1, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
16118169	16118169	PRJNA814235_P_NODE_130493_length_194_cov_2.898089_g129098_i0	PRJNA814235	130493	194	2.898089	5.62229266	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	244	2.57e-60	NTclustered	gi\|2744885076\|ref\|XM_065808675.1\|	6087	g129098	i0	98.551	19.0721649484536	138	2	71	0	57	194	622	485	PREDICTED: Hydra vulgaris uncharacterized LOC136086379 (LOC136086379), mRNA	blastn	3700	244	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
16118759	16118759	PRJNA814235_P_NODE_155313_length_170_cov_1.729323_g153918_i0	PRJNA814235	155313	170	1.729323	2.9398491	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	315	1.64e-81	NTclustered	gi\|1619686288\|ref\|XM_021057113.2\|	2652724	g153918	i0	100	1.98823529411765	170	0	100	0	1	170	69	238	PREDICTED: Exaiptasia diaphana 60S ribosomal protein L21 (LOC110250505), mRNA	blastn	338	315	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
16120663	16120663	PRJNA814235_P_NODE_57573_length_251_cov_1.532710_g56179_i0	PRJNA814235	57573	251	1.53271	3.8471021	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	399	7.049999999999999e-107	NTclustered	gi\|1619650904\|ref\|XM_021046698.2\|	2652724	g56179	i0	97.083	1.45816733067729	240	2	96	1	12	251	732	498	PREDICTED: Exaiptasia diaphana soma ferritin (LOC110240879), transcript variant X1, mRNA	blastn	366	399	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
17394449	17394449	PRJNA814235_P_NODE_149834_length_175_cov_0.913043_g148439_i0	PRJNA814235	149834	175	0.913043	1.59782525	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	318	1.32e-82	NTclustered	gi\|1619699304\|ref\|XM_021061037.2\|	2652724	g148439	i0	99.429	54.1142857142857	175	1	100	0	1	175	202	28	PREDICTED: Exaiptasia diaphana 60S acidic ribosomal protein P2 (LOC110254079), mRNA	blastn	9470	318	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
19943766	19943766	PRJNA814235_P_NODE_200376_length_150_cov_2.929204_g198981_i0	PRJNA814235	200376	150	2.929204	4.393806	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	141	2.53e-29	NTclustered	gi\|1619682969\|ref\|XM_021056002.2\|	2652724	g198981	i0	100	1.00666666666667	76	0	100	0	1	76	919	844	PREDICTED: Exaiptasia diaphana polyadenylate-binding protein 4-like (LOC110249432), mRNA	blastn	151	141	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
19944041	19944041	PRJNA814235_P_NODE_30916_length_344_cov_3.029316_g29532_i0	PRJNA814235	30916	344	3.029316	10.42084704	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	582	9.329999999999999e-162	NTclustered	gi\|1619674238\|ref\|XM_021053548.2\|	2652724	g29532	i0	96.512	1	344	9	100	2	1	344	623	963	PREDICTED: Exaiptasia diaphana uncharacterized LOC110247154 (LOC110247154), mRNA	blastn	344	582	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
23770497	23770497	PRJNA814235_P_NODE_58579_length_248_cov_6.639810_g57185_i0	PRJNA814235	58579	248	6.63981	16.4667288	Ostiactis pearseae	1499620	Cnidaria	other_Eukaryota	431	2.47e-116	NTclustered	gi\|164471932\|gb\|EU190841.1\|	1499620	g57185	i0	97.992	91.508064516129	249	4	100	1	1	248	259	11	Anthosactis pearseae 28S ribosomal RNA gene, partial sequence	blastn	22694	431	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Ostiactinidae	Ostiactis	Ostiactis pearseae

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