metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
722032	722032	PRJNA743294_P_NODE_3441_length_810_cov_4.279512_g3065_i0	PRJNA743294	3441	810	4.279512	34.6640472	Acropora digitifera	70779	Cnidaria	other_Eukaryota	198	9.88e-46	NTclustered	gi\|1005458426\|ref\|XM_015910863.1\|	70779	g3065	i0	76.039	3.87901234567901	409	83	50	13	20	421	651	1051	PREDICTED: Acropora digitifera ruvB-like 2 (LOC107345154), mRNA	blastn	3142	198	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
722217	722217	PRJNA743294_P_NODE_6301_length_618_cov_15.882569_g5851_i0	PRJNA743294	6301	618	15.882569	98.15427642	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	268	5.59e-67	NTclustered	gi\|1619698735\|ref\|XM_021060602.2\|	2652724	g5851	i0	78.922	53.2912621359223	408	68	64	13	207	602	422	21	PREDICTED: Exaiptasia diaphana histone H3 (LOC110253653), mRNA	blastn	32934	268	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
722238	722238	PRJNA743294_P_NODE_8981_length_525_cov_7.825221_g8525_i0	PRJNA743294	8981	525	7.825221	41.08241025	Relicanthus daphneae	1499622	Cnidaria	other_Eukaryota	124	1.0799999999999999e-23	NTclustered	gi\|636577297\|gb\|KJ483131.1\|	1499622	g8525	i0	90.526	14.9790476190476	95	8	18	1	432	525	397	303	Relicanthus daphneae isolate prp 28S large subunit ribosomal RNA gene, partial sequence	blastn	7864	124	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa		Relicanthidae	Relicanthus	Relicanthus daphneae
2473741	2473741	PRJNA743294_P_NODE_46782_length_252_cov_2.497207_g46326_i0	PRJNA743294	46782	252	2.497207	6.29296164	Pocillopora	46730	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|1524868685\|ref\|XM_027185810.1\|	46731	g46326	i0	100	0.222222222222222	28	0	11	0	187	214	1008	1035	PREDICTED: Pocillopora damicornis lipid droplet-associated hydrolase-like (LOC113669735), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
3273203	3273203	PRJNA743294_P_NODE_10703_length_484_cov_3.992701_g10247_i0	PRJNA743294	10703	484	3.992701	19.32467284	Xenia sp. Carnegie-2017	2897299	Cnidaria	other_Eukaryota	209	2.65e-49	NTclustered	gi\|2202658305\|ref\|XM_047001689.1\|	2897299	g10247	i0	79.153	1.88429752066116	307	56	63	6	103	408	444	145	PREDICTED: Xenia sp. Carnegie-2017 40S ribosomal protein S20-like (LOC124451055), mRNA	blastn	912	209	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Xeniidae	Xenia	Xenia sp. Carnegie-2017
3750050	3750050	PRJNA743294_P_NODE_29063_length_308_cov_1.842553_g28607_i0	PRJNA743294	29063	308	1.842553	5.67506324	Ectopleura	264051	Cnidaria	other_Eukaryota	172	2.12e-38	NTclustered	gi\|1032656006\|gb\|JN594044.2\|	264053	g28607	i0	86.25	49.1168831168831	160	21	52	1	149	308	2275	2433	Ectopleura wrighti voucher MHNGINVE27331 28S ribosomal RNA gene, partial sequence	blastn	15128	172	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Tubulariidae	Ectopleura	Ectopleura wrighti
5026617	5026617	PRJNA743294_P_NODE_7904_length_558_cov_1.958763_g7449_i0	PRJNA743294	7904	558	1.958763	10.92989754	Pocillopora	46730	Cnidaria	other_Eukaryota	73.1	4.22e-8	NTclustered	gi\|1524889038\|ref\|XM_027196639.1\|	46731	g7449	i0	100	2.98924731182796	39	0	7	0	105	143	669	707	PREDICTED: Pocillopora damicornis protein disulfide-isomerase A4-like (LOC113679674), mRNA	blastn	1668	73.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
7100953	7100953	PRJNA743294_P_NODE_7006_length_589_cov_5.147287_g6554_i0	PRJNA743294	7006	589	5.147287	30.31752043	Hydractinia symbiolongicarpus	13093	Cnidaria	other_Eukaryota	187	1.5299999999999998e-42	NTclustered	gi\|2518975374\|ref\|XM_057438511.1\|	13093	g6554	i0	80.932	6.58404074702886	236	45	40	0	303	538	401	166	PREDICTED: Hydractinia symbiolongicarpus dynein light chain 2, cytoplasmic (LOC130623008), mRNA	blastn	3878	187	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydractiniidae	Hydractinia	Hydractinia symbiolongicarpus
9650429	9650429	PRJNA743294_P_NODE_24548_length_332_cov_1.281853_g24092_i0	PRJNA743294	24548	332	1.281853	4.2557519599999996	Pocillopora verrucosa	203993	Cnidaria	other_Eukaryota	185	2.9599999999999995e-42	NTclustered	gi\|2751557535\|ref\|XM_059099431.2\|	203993	g24092	i0	78.909	4.07530120481928	275	56	83	2	59	332	691	418	PREDICTED: Pocillopora verrucosa ras-related protein ORAB-1 (LOC131782691), mRNA	blastn	1353	185	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora verrucosa
10926090	10926090	PRJNA743294_P_NODE_47609_length_251_cov_2.342697_g47153_i0	PRJNA743294	47609	251	2.342697	5.88016947	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2917940714\|emb\|OZ237561.1\|	6108	g47153	i0	100	0.111553784860558	28	0	11	0	63	90	6727922	6727895	Anemonia sulcata genome assembly, chromosome: 7	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
17300147	17300147	PRJNA743294_P_NODE_26814_length_319_cov_2.109756_g26358_i0	PRJNA743294	26814	319	2.109756	6.73012164	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	174	6.12e-39	NTclustered	gi\|2917940724\|emb\|OZ237563.1\|	6108	g26358	i0	81.905	7.27586206896552	210	34	65	4	112	319	3201023	3201230	Anemonia sulcata genome assembly, chromosome: 9	blastn	2321	174	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
19848982	19848982	PRJNA743294_P_NODE_2276_length_970_cov_5.334448_g1960_i0	PRJNA743294	2276	970	5.334448	51.7441456	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	56.5	0.008	NTclustered	gi\|2729098401\|ref\|XM_065212135.1\|	499914	g1960	i0	100	0.0309278350515464	30	0	3	0	702	731	503	532	PREDICTED: Rhopilema esculentum uncharacterized LOC135693604 (LOC135693604), partial mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
19849261	19849261	PRJNA743294_P_NODE_60356_length_210_cov_6.328467_g59900_i0	PRJNA743294	60356	210	6.328467	13.2897807	Parvicapsula minibicornis	109801	Cnidaria	other_Eukaryota	130	8.280000000000001e-26	NTclustered	gi\|605060084\|gb\|KF874224.1\|	109801	g59900	i0	87.069	57.3333333333333	116	13	55	2	1	116	346	233	Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence	blastn	12040	130	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Parvicapsulidae	Parvicapsula	Parvicapsula minibicornis
20324761	20324761	PRJNA743294_P_NODE_35196_length_284_cov_1.265403_g34740_i0	PRJNA743294	35196	284	1.265403	3.59374452	Acropora	6127	Cnidaria	other_Eukaryota	62.1	4.36e-5	NTclustered	gi\|2113969570\|ref\|XM_029340922.2\|	45264	g34740	i0	85.246	0.644366197183099	61	7	21	2	2	61	1958	1899	PREDICTED: Acropora millepora ATP-binding cassette sub-family D member 2-like (LOC114962008), mRNA	blastn	183	62.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
21124684	21124684	PRJNA743294_P_NODE_44997_length_256_cov_1.125683_g44541_i0	PRJNA743294	44997	256	1.125683	2.88174848	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	95.3	3.81e-15	NTclustered	gi\|2729077900\|ref\|XM_065201292.1\|	499914	g44541	i0	82.407	0.83984375	108	19	42	0	46	153	264	157	PREDICTED: Rhopilema esculentum iron-sulfur cluster assembly scaffold protein IscU-like (LOC135685370), mRNA	blastn	215	95.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
22399572	22399572	PRJNA743294_P_NODE_42198_length_262_cov_9.582011_g41742_i0	PRJNA743294	42198	262	9.582011	25.10486882	Virgularia mirabilis	1399339	Cnidaria	other_Eukaryota	87.9	6.55e-13	NTclustered	gi\|2160785914\|gb\|OL741708.1\|	1399339	g41742	i0	100	17.4809160305344	47	0	18	0	1	47	5724	5770	Virgularia mirabilis voucher NMS.Z.2019.25.15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	4580	87.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleralcyonacea	Virgulariidae	Virgularia	Virgularia mirabilis

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