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

16 rows where analysis = "blastn", bioproject = "PRJNA529924" 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
2392725	2392725	PRJNA529924_P_NODE_3802_length_202_cov_2.184971_g3628_i0	PRJNA529924	3802	202	2.184971	4.41364142	Opisthokonta	33154	Chordata	Chordata	58.4	3.78e-4	NTclustered	gi\|1679814366\|ref\|XM_029483858.1\|	10089	g3628	i0	89.13	9.51485148514852	46	5	23	0	153	198	2438	2483	PREDICTED: Mus caroli upstream binding transcription factor (Ubtf), mRNA	blastn	1922	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
3054242	3054242	PRJNA529924_P_NODE_3163_length_239_cov_1.885714_g2989_i0	PRJNA529924	3163	239	1.885714	4.50685646	Mus musculus	10090	Chordata	Chordata	54.7	0.006	NTclustered	gi\|354797950\|gb\|JN962451.1\|	10090	g2989	i0	100	0.242677824267782	29	0	12	0	15	43	30972	31000	Mus musculus targeted KO-first, conditional ready, lacZ-tagged mutant allele Vps37d:tm2a(EUCOMM)Wtsi; transgenic	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
5607003	5607003	PRJNA529924_P_NODE_1025_length_584_cov_32.016216_g872_i0	PRJNA529924	1025	584	32.016216	186.97470144	Lampetra planeri	7750	Chordata	Chordata	63.9	2.67e-5	NTclustered	gi\|2805745495\|emb\|OZ078522.1\|	7750	g872	i0	93.023	0.563356164383562	43	3	7	0	254	296	3272563	3272521	Lampetra planeri genome assembly, chromosome: 37	blastn	329	63.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
5607026	5607026	PRJNA529924_P_NODE_3625_length_210_cov_1.701657_g3451_i0	PRJNA529924	3625	210	1.701657	3.5734797	Phyllostomus discolor	89673	Chordata	Chordata	137	4.95e-28	NTclustered	gi\|1899635224\|ref\|XM_028530061.2\|	89673	g3451	i0	81.988	34.847619047619	161	29	77	0	49	209	124	284	PREDICTED: Phyllostomus discolor small nuclear ribonucleoprotein D2 polypeptide (SNRPD2), mRNA	blastn	7318	137	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Chiroptera	Phyllostomidae	Phyllostomus	Phyllostomus discolor
6880907	6880907	PRJNA529924_P_NODE_3366_length_224_cov_1.866667_g3192_i0	PRJNA529924	3366	224	1.866667	4.18133408	Cynocephalus volans	110931	Chordata	Chordata	58.4	4.28e-4	NTclustered	gi\|2676494438\|ref\|XM_063081739.1\|	110931	g3192	i0	97.059	0.303571428571429	34	1	15	0	140	173	947	980	PREDICTED: Cynocephalus volans ral guanine nucleotide dissociation stimulator (RALGDS), transcript variant X2, mRNA	blastn	68	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Dermoptera	Cynocephalidae	Cynocephalus	Cynocephalus volans
10045757	10045757	PRJNA529924_P_NODE_2488_length_297_cov_1.559701_g2314_i0	PRJNA529924	2488	297	1.559701	4.63231197	Artiodactyla	91561	Chordata	Chordata	52.8	0.028	NTclustered	gi\|1741490040\|ref\|XM_022554496.2\|	9749	g2314	i0	94.118	2.4983164983165	34	2	11	0	82	115	795	762	PREDICTED: Delphinapterus leucas chromosome unknown C15orf40 homolog (CUNH15orf40), mRNA	blastn	742	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Monodontidae	Delphinapterus	Delphinapterus leucas
11320323	11320323	PRJNA529924_P_NODE_1009_length_589_cov_2.542857_g857_i0	PRJNA529924	1009	589	2.542857	14.97742773	Mus	10088	Chordata	Chordata	1088	0	NTclustered	gi\|846387786\|dbj\|LC061991.1\|	10090	g857	i0	100	100	589	0	100	0	1	589	1269	681	Mus musculus mitochondrion DNA, including ATP6, COX3, tRNA-Gly, ND3, tRNA-Arg, ND4L, ND4 genes, complete sequence, sequence_id: (8070..10988)_18	blastn	58900	1088	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
14532123	14532123	PRJNA529924_P_NODE_3272_length_231_cov_1.846535_g3098_i0	PRJNA529924	3272	231	1.846535	4.26549585	Phalacrocorax carbo	9209	Chordata	Chordata	174	4.22e-39	NTclustered	gi\|2716895773\|ref\|XM_064453768.1\|	9209	g3098	i0	84.571	43.8398268398268	175	27	76	0	1	175	1246	1420	PREDICTED: Phalacrocorax carbo SEC61 translocon subunit alpha 1 (SEC61A1), mRNA	blastn	10127	174	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Suliformes	Phalacrocoracidae	Phalacrocorax	Phalacrocorax carbo
15805880	15805880	PRJNA529924_P_NODE_4033_length_192_cov_2.595092_g3859_i0	PRJNA529924	4033	192	2.595092	4.98257664	Pristiophorus japonicus	55135	Chordata	Chordata	54.7	0.005	NTclustered	gi\|2891066811\|ref\|XM_070885675.1\|	55135	g3859	i0	94.286	0.729166666666667	35	2	18	0	44	78	3822	3856	PREDICTED: Pristiophorus japonicus adenylate kinase 9 (ak9), transcript variant X4, mRNA	blastn	140	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes		Pristiophoridae	Pristiophorus	Pristiophorus japonicus
17695206	17695206	PRJNA529924_P_NODE_334_length_1092_cov_3.711195_g257_i0	PRJNA529924	334	1092	3.711195	40.5262494	Metazoa	33208	Chordata	Chordata	54.7	0.031	NTclustered	gi\|2805739099\|emb\|OZ078460.1\|	7748	g257	i0	87.755	0.142857142857143	49	2	4	2	294	340	3096829	3096783	Lampetra fluviatilis genome assembly, chromosome: 57	blastn	156	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
19629254	19629254	PRJNA529924_P_NODE_4796_length_160_cov_1.877863_g4622_i0	PRJNA529924	4796	160	1.877863	3.0045808	Gekko japonicus	146911	Chordata	Chordata	121	3.59e-23	NTclustered	gi\|975123481\|ref\|XM_015421900.1\|	146911	g4622	i0	81.507	2.05	146	27	91	0	3	148	183	328	PREDICTED: Gekko japonicus tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein, epsilon (YWHAE), transcript variant X2, mRNA	blastn	328	121	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Gekkonidae	Gekko	Gekko japonicus
20905340	20905340	PRJNA529924_P_NODE_2117_length_340_cov_1.758842_g1943_i0	PRJNA529924	2117	340	1.758842	5.9800628	Branchiostoma lanceolatum	7740	Chordata	Chordata	237	8.26e-58	NTclustered	gi\|2770724951\|ref\|XM_066443415.1\|	7740	g1943	i0	78.886	33.1058823529412	341	64	100	4	1	340	719	1052	PREDICTED: Branchiostoma lanceolatum transitional endoplasmic reticulum ATPase (LOC136445413), transcript variant X3, mRNA	blastn	11256	237	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
20905342	20905342	PRJNA529924_P_NODE_2697_length_276_cov_2.846154_g2523_i0	PRJNA529924	2697	276	2.846154	7.85538504	Mus musculus	10090	Chordata	Chordata	54.7	0.007	NTclustered	gi\|2553880601\|ref\|NG_222840.1\|	10090	g2523	i0	100	0.311594202898551	29	0	11	0	107	135	520	548	Mus musculus STARR-seq mESC enhancer starr_37565 (LOC131386949) on chromosome 14	blastn	86	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
20905348	20905348	PRJNA529924_P_NODE_4497_length_174_cov_2.420690_g4323_i0	PRJNA529924	4497	174	2.42069	4.2120006	Lethenteron reissneri	7753	Chordata	Chordata	171	3.87e-38	NTclustered	gi\|2635878808\|ref\|XM_061564990.1\|	7753	g4323	i0	89.051	9.33333333333333	137	15	79	0	9	145	2040	1904	PREDICTED: Lethenteron reissneri transitional endoplasmic reticulum ATPase (LOC133350548), mRNA	blastn	1624	171	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
22179937	22179937	PRJNA529924_P_NODE_4378_length_179_cov_2.113333_g4204_i0	PRJNA529924	4378	179	2.113333	3.78286607	Pristiophorus japonicus	55135	Chordata	Chordata	132	1.89e-26	NTclustered	gi\|2891055656\|ref\|XM_070879849.1\|	55135	g4204	i0	80.791	5.72067039106145	177	26	98	2	1	176	406	575	PREDICTED: Pristiophorus japonicus proteasome subunit alpha type-2 (LOC139263794), mRNA	blastn	1024	132	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes		Pristiophoridae	Pristiophorus	Pristiophorus japonicus
24069165	24069165	PRJNA529924_P_NODE_3379_length_223_cov_1.896907_g3205_i0	PRJNA529924	3379	223	1.896907	4.23010261	Passeriformes	9126	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2312819819\|ref\|XM_050983998.1\|	9135	g3205	i0	96.875	4.42152466367713	32	1	14	0	192	223	549	518	PREDICTED: Serinus canaria keratin, type II cytoskeletal 1-like (LOC103823901), transcript variant X4, mRNA	blastn	986	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Serinus	Serinus canaria

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