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

10 rows where analysis = "blastn", bioproject = "PRJNA407087" and tax_phylum = "Chordata"

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
2357096	2357096	PRJNA407087_S_NODE_5242_length_225_cov_4.974490_g4779_i0	PRJNA407087	5242	225	4.97449	11.1926025	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.02	NTclustered	gi\|2596042956\|ref\|XM_035131187.2\|	8524	g4779	i0	100	1.99111111111111	28	0	12	0	73	100	1562	1589	PREDICTED: Zootoca vivipara myelin expression factor 2 (MYEF2), mRNA	blastn	448	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Zootoca	Zootoca vivipara
8068295	8068295	PRJNA407087_S_NODE_787_length_837_cov_7.383663_g501_i0	PRJNA407087	787	837	7.383663	61.80125931	Xenopus tropicalis	8364	Chordata	Chordata	1075	0	NTclustered	gi\|38512082\|gb\|BC061437.1\|	8364	g501	i0	89.893	56.1266427718041	841	77	100	5	1	837	851	15	Xenopus tropicalis 40S ribosomal protein S6, mRNA (cDNA clone MGC:76319 IMAGE:5380258), complete cds	blastn	46978	1075	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
10009739	10009739	PRJNA407087_S_NODE_5248_length_225_cov_3.454082_g4785_i0	PRJNA407087	5248	225	3.454082	7.7716845	Anura	8342	Chordata	Chordata	52.8	0.02	NTclustered	gi\|2019542844\|ref\|XM_040439790.1\|	8384	g4785	i0	100	0.373333333333333	28	0	12	0	7	34	250	223	PREDICTED: Bufo bufo eukaryotic translation initiation factor 3 subunit B (EIF3B), mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufo	Bufo bufo
10618865	10618865	PRJNA407087_S_NODE_1909_length_480_cov_3.917960_g1463_i0	PRJNA407087	1909	480	3.91796	18.806208	Acomys russatus	60746	Chordata	Chordata	60.2	2.79e-4	NTclustered	gi\|2318351005\|ref\|XM_051172399.1\|	60746	g1463	i0	94.872	7.01458333333333	39	1	8	1	231	268	18118	18080	PREDICTED: Acomys russatus adhesion G protein-coupled receptor V1 (Adgrv1), mRNA	blastn	3367	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Acomys	Acomys russatus
14443921	14443921	PRJNA407087_S_NODE_9752_length_152_cov_3.707317_g9289_i0	PRJNA407087	9752	152	3.707317	5.63512184	Styela clava	7725	Chordata	Chordata	191	2.52e-44	NTclustered	gi\|1981760527\|ref\|XM_039418685.1\|	7725	g9289	i0	89.542	34.6907894736842	153	13	100	3	1	152	351	201	PREDICTED: Styela clava actin, cytoplasmic-like (LOC120348531), transcript variant X3, mRNA	blastn	5273	191	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Stolidobranchia	Styelidae	Styela	Styela clava
19540722	19540722	PRJNA407087_S_NODE_2256_length_431_cov_3.370647_g1795_i0	PRJNA407087	2256	431	3.370647	14.52748857	Bos taurus	9913	Chordata	Chordata	385	3.61e-102	NTclustered	gi\|114155062\|gb\|AY563849.1\|	9913	g1795	i0	86.111	0.835266821345708	360	47	83	3	1	358	70	428	Bos taurus clone NG010008B20F06 mRNA, complete sequence	blastn	360	385	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
19540764	19540764	PRJNA407087_S_NODE_8476_length_165_cov_1.544118_g8013_i0	PRJNA407087	8476	165	1.544118	2.5477947	Taeniopygia guttata	59729	Chordata	Chordata	56.5	0.001	NTclustered	gi\|2043849737\|ref\|XM_041720520.1\|	59729	g8013	i0	92.308	0.236363636363636	39	3	24	0	112	150	1720	1682	PREDICTED: Taeniopygia guttata cell surface glycoprotein 1-like (LOC116809221), mRNA	blastn	39	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Estrildidae	Taeniopygia	Taeniopygia guttata
21483378	21483378	PRJNA407087_S_NODE_4317_length_263_cov_4.521368_g3854_i0	PRJNA407087	4317	263	4.521368	11.89119784	Passeriformes	9126	Chordata	Chordata	65.8	3.08e-6	NTclustered	gi\|2917587946\|emb\|OZ228645.1\|	50251	g3854	i0	97.368	2.48669201520913	38	1	14	0	226	263	4532112	4532075	Sitta europaea genome assembly, chromosome: 24	blastn	654	65.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sittidae	Sitta	Sitta europaea
23367071	23367071	PRJNA407087_S_NODE_6719_length_191_cov_4.037037_g6256_i0	PRJNA407087	6719	191	4.037037	7.71074067	Xenopus tropicalis	8364	Chordata	Chordata	270	4.17e-68	NTclustered	gi\|51895800\|gb\|BC080974.1\|	8364	g6256	i0	92.147	100.51832460733	191	15	100	0	1	191	897	707	Xenopus tropicalis hypothetical LOC493206, mRNA (cDNA clone IMAGE:6984500), partial cds	blastn	19199	270	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
24033378	24033378	PRJNA407087_S_NODE_6559_length_194_cov_3.406061_g6096_i0	PRJNA407087	6559	194	3.406061	6.60775834	Cricetidae	337677	Chordata	Chordata	52.8	0.017	NTclustered	gi\|2246065583\|ref\|XM_048442227.1\|	447135	g6096	i0	96.875	0.989690721649485	32	0	16	1	23	54	731	701	PREDICTED: Myodes glareolus bile acid receptor-like (LOC125405635), transcript variant X2, mRNA	blastn	192	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Myodes	Myodes glareolus

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