metadata: contig_metadata: 15 rows where bioproject = "PRJNA929922" and tax

15 rows where bioproject = "PRJNA929922" 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
2181229	2181229	PRJNA929922_P_NODE_124922_length_248_cov_0.880000_g124382_i0	PRJNA929922	124922	248	0.88	2.1824	Rhopilema esculentum	499914	Cnidaria	other_Eukaryota	52.8	0.022	NTclustered	gi\|2729092880\|ref\|XM_065209192.1\|	499914	g124382	i0	100	0.112903225806452	28	0	11	0	219	246	1503	1476	PREDICTED: Rhopilema esculentum serine/threonine-protein kinase ULK4-like (LOC135691353), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Scyphozoa	Rhizostomeae	Rhizostomatidae	Rhopilema	Rhopilema esculentum
6357747	6357747	PRJNA929922_P_NODE_36345_length_355_cov_1.404255_g35805_i0	PRJNA929922	36345	355	1.404255	4.98510525	Acropora	6127	Cnidaria	other_Eukaryota	52.8	0.034	NTclustered	gi\|2114117970\|ref\|XM_029344511.2\|	45264	g35805	i0	100	0.157746478873239	28	0	8	0	140	167	4829	4802	PREDICTED: Acropora millepora sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like (LOC114964975), mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
9834187	9834187	PRJNA929922_P_NODE_142748_length_245_cov_0.872093_g142208_i0	PRJNA929922	142748	245	0.872093	2.13662785	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|1778060746\|ref\|XM_031711846.1\|	6105	g142208	i0	92.308	0.159183673469388	39	2	16	1	72	109	831	793	PREDICTED: Actinia tenebrosa QRFP-like peptide receptor (LOC116302524), mRNA	blastn	39	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
13659039	13659039	PRJNA929922_P_NODE_101491_length_255_cov_1.664835_g100951_i0	PRJNA929922	101491	255	1.664835	4.24532925	Anemonia sulcata	6108	Cnidaria	other_Eukaryota	52.8	0.023	NTclustered	gi\|2917940756\|emb\|OZ237571.1\|	6108	g100951	i0	100	0.109803921568627	28	0	11	0	110	137	7670927	7670900	Anemonia sulcata genome assembly, chromosome: 17	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Anemonia	Anemonia sulcata
14935414	14935414	PRJNA929922_P_NODE_77592_length_282_cov_1.105263_g77052_i0	PRJNA929922	77592	282	1.105263	3.11684166	Acropora digitifera	70779	Cnidaria	other_Eukaryota	52.8	0.026	NTclustered	gi\|1005446366\|ref\|XM_015904991.1\|	70779	g77052	i0	100	0.099290780141844	28	0	10	0	50	77	1839	1812	PREDICTED: Acropora digitifera uncharacterized LOC107339686 (LOC107339686), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora digitifera
16208382	16208382	PRJNA929922_P_NODE_104073_length_253_cov_0.972222_g103533_i0	PRJNA929922	104073	253	0.972222	2.45972166	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	54.7	0.006	NTclustered	gi\|1778051379\|ref\|XM_031707284.1\|	6105	g103533	i0	87.5	0.189723320158103	48	4	19	2	197	243	869	915	PREDICTED: Actinia tenebrosa ER degradation-enhancing alpha-mannosidase-like protein 1 (LOC116298741), mRNA	blastn	48	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
20380033	20380033	PRJNA929922_P_NODE_28136_length_383_cov_0.832258_g27596_i0	PRJNA929922	28136	383	0.832258	3.18754814	Pocilloporidae	46729	Cnidaria	other_Eukaryota	52.8	0.037	NTclustered	gi\|1524850784\|ref\|XM_027183365.1\|	46731	g27596	i0	100	0.29242819843342	28	0	7	0	169	196	310	283	PREDICTED: Pocillopora damicornis pyridoxal phosphate homeostasis protein-like (LOC113667433), transcript variant X2, mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Pocillopora	Pocillopora damicornis
27372887	27372887	PRJNA929922_P_NODE_131703_length_247_cov_0.885057_g131163_i0	PRJNA929922	131703	247	0.885057	2.18609079	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	47	0.00126	NR	CAB3994205.1	317549	g131163	i0	54.5	2.73279352226721	33	15	40.1	0	216	118	463	495	CAB3994205.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	675	47	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
28958594	28958594	PRJNA929922_P_NODE_119088_length_249_cov_0.875000_g118548_i0	PRJNA929922	119088	249	0.875	2.17875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	3.55e-4	NR	KAK2562587.1	6130	g118548	i0	42.9	2.2289156626506	49	27	59	1	172	26	96	143	KAK2562587.1 hypothetical protein P5673_014272 [Acropora cervicornis]	diamond	555	48.9	0.991820040899796	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora cervicornis
29109315	29109315	PRJNA929922_P_NODE_118008_length_249_cov_0.875000_g117468_i0	PRJNA929922	118008	249	0.875	2.17875	Stylophora pistillata	50429	Cnidaria	other_Eukaryota	60.1	3.2e-8	NR	PFX15504.1	50429	g117468	i0	41	2.85542168674699	78	46	94	0	240	7	469	546	PFX15504.1 putative RNA-directed DNA polymerase from transposon BS [Stylophora pistillata]	diamond	711	60.5	0.993388429752066	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Pocilloporidae	Stylophora	Stylophora pistillata
30025089	30025089	PRJNA929922_P_NODE_162811_length_241_cov_0.916667_g162271_i0	PRJNA929922	162811	241	0.916667	2.20916747	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	43.9	0.0141	NR	CAB4032949.1	317549	g162271	i0	36.3	1.43153526970954	80	48	99.6	2	2	241	349	425	CAB4032949.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	345	43.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
30088012	30088012	PRJNA929922_P_NODE_145612_length_244_cov_0.900585_g145072_i0	PRJNA929922	145612	244	0.900585	2.1974274	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	84.3	8.81e-17	NR	CAB3977153.1	317549	g145072	i0	56.2	12.8237704918033	73	32	89.8	0	1	219	411	483	CAB3977153.1 Hypothetical predicted protein [Paramuricea clavata]	diamond	3129	84.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31162056	31162056	PRJNA929922_P_NODE_120715_length_249_cov_0.875000_g120175_i0	PRJNA929922	120715	249	0.875	2.17875	Nematostella vectensis	45351	Cnidaria	other_Eukaryota	43.1	0.0288	NR	XP_048582196.1	45351	g120175	i0	32.9	0.91566265060241	76	46	85.5	2	234	22	52	127	XP_048582196.1 LOW QUALITY PROTEIN: uncharacterized protein LOC5500105 [Nematostella vectensis]	diamond	228	43.1	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Edwardsiidae	Nematostella	Nematostella vectensis
31668319	31668319	PRJNA929922_P_NODE_31437_length_370_cov_1.555556_g30897_i0	PRJNA929922	31437	370	1.555556	5.7555572	Paramuricea clavata	317549	Cnidaria	other_Eukaryota	49.7	5.56e-4	NR	CAB4040946.1	317549	g30897	i0	31.8	0.867567567567568	107	67	84.3	2	312	1	379	482	CAB4040946.1 Transposon TX1 uncharacterized 149 kDa, partial [Paramuricea clavata]	diamond	321	49.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Malacalcyonacea	Plexauridae	Paramuricea	Paramuricea clavata
31763243	31763243	PRJNA929922_P_NODE_158517_length_242_cov_0.911243_g157977_i0	PRJNA929922	158517	242	0.911243	2.20520806	Actinostola sp. cb2	3060491	Cnidaria	other_Eukaryota	53.9	4.25e-6	NR	KAK3753750.1	3060491	g157977	i0	37.2	0.966942148760331	78	47	96.7	2	8	241	360	435	KAK3753750.1 hypothetical protein QZH41_005245 [Actinostola sp. cb2023]	diamond	234	53.9	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actinostolidae	Actinostola	Actinostola sp. cb2023

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