contig_metadata
12 rows where bioproject = "PRJNA704949", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2465396 | 2465396 | PRJNA704949_P_NODE_655382_length_334_cov_1.607018_g640056_i0 | PRJNA704949 | 655382 | 334 | 1.607018 | 5.36744012 | Cloacibacillus | 508459 | Bacteria | Bacteria | 575 | 1.5099999999999999e-159 | NTclustered | gi|1050315908|gb|CP016757.1| | 1197717 | g640056 | i0 | 99.682 | 4.95808383233533 | 314 | 1 | 94 | 0 | 21 | 334 | 1266519 | 1266832 | Cloacibacillus porcorum strain CL-84 chromosome, complete genome | blastn | 1656 | 575 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus porcorum | ||
| 7069501 | 7069501 | PRJNA704949_P_NODE_1610066_length_192_cov_1.090909_g1594727_i0 | PRJNA704949 | 1610066 | 192 | 1.090909 | 2.09454528 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 307 | 3.2e-79 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g1594727 | i0 | 98.837 | 1.79166666666667 | 172 | 2 | 90 | 0 | 1 | 172 | 2645832 | 2646003 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 344 | 307 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 17276765 | 17276765 | PRJNA704949_P_NODE_55754_length_1023_cov_16.987680_g10342_i5 | PRJNA704949 | 55754 | 1023 | 16.98768 | 173.7839664 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 183 | 1.06e-50 | NR | MFA5457364.1 | 2053624 | g10342 | i5 | 50.5 | 0.586510263929619 | 200 | 95 | 58.4 | 2 | 1020 | 424 | 166 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 600 | 183 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 25415676 | 25415676 | PRJNA704949_P_NODE_364520_length_449_cov_1.967500_g349493_i0 | PRJNA704949 | 364520 | 449 | 1.9675 | 8.834075 | Bacteria | 2 | Bacteria | Bacteria | 787 | 0 | NTclustered | gi|1050315908|gb|CP016757.1| | 1197717 | g349493 | i0 | 99.767 | 4.80400890868597 | 429 | 1 | 96 | 0 | 1 | 429 | 1267268 | 1266840 | Cloacibacillus porcorum strain CL-84 chromosome, complete genome | blastn | 2157 | 787 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus porcorum | ||
| 27588951 | 27588951 | PRJNA704949_P_NODE_44284_length_1151_cov_15.139746_g10342_i4 | PRJNA704949 | 44284 | 1151 | 15.139746 | 174.25847646 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 183 | 3.44e-50 | NR | MFA5457364.1 | 2053624 | g10342 | i4 | 50.5 | 0.52128583840139 | 200 | 95 | 51.9 | 2 | 4 | 600 | 166 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 600 | 183 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 28409626 | 28409626 | PRJNA704949_P_NODE_18386_length_2076_cov_12.718303_g10342_i1 | PRJNA704949 | 18386 | 2076 | 12.718303 | 264.03197028 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 310 | 1.55e-95 | NR | MFA5457364.1 | 2053624 | g10342 | i1 | 45 | 0.536127167630058 | 371 | 194 | 53.5 | 4 | 1187 | 78 | 1 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 1113 | 310 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 28609996 | 28609996 | PRJNA704949_P_NODE_927407_length_272_cov_3.479821_g912073_i0 | PRJNA704949 | 927407 | 272 | 3.479821 | 9.46511312 | Jonquetella | 428711 | Bacteria | Bacteria | 42.7 | 0.048 | NR | WP_008522938.1 | 428711 | g912073 | i0 | 42.9 | 1.08088235294118 | 49 | 28 | 54 | 0 | 9 | 155 | 102 | 150 | WP_008522938.1 MULTISPECIES: ABC transporter ATP-binding protein [Jonquetella] | diamond | 294 | 42.7 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | |||
| 29841254 | 29841254 | PRJNA704949_P_NODE_1369911_length_213_cov_1.585366_g1354573_i0 | PRJNA704949 | 1369911 | 213 | 1.585366 | 3.37682958 | Bacteria | 2 | Bacteria | Bacteria | 54.3 | 2.06e-6 | NR | WP_050792463.1 | 81412 | g1354573 | i0 | 66.7 | 5.43661971830986 | 36 | 12 | 50.7 | 0 | 5 | 112 | 215 | 250 | WP_050792463.1 methyl-accepting chemotaxis protein [Aminomonas paucivorans] | diamond | 1158 | 54.7 | 0.992687385740402 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Aminomonas | Aminomonas paucivorans | ||
| 30304716 | 30304716 | PRJNA704949_P_NODE_17432_length_2170_cov_10.169731_g10342_i0 | PRJNA704949 | 17432 | 2170 | 10.169731 | 220.6831627 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 183 | 2.0899999999999999e-47 | NR | MFA5457364.1 | 2053624 | g10342 | i0 | 50.5 | 0.276497695852535 | 200 | 95 | 27.5 | 2 | 4 | 600 | 166 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 600 | 183 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30714973 | 30714973 | PRJNA704949_P_NODE_18454_length_2070_cov_13.243444_g10342_i2 | PRJNA704949 | 18454 | 2070 | 13.243444 | 274.1392908 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 315 | 2.45e-97 | NR | MFA5457364.1 | 2053624 | g10342 | i2 | 45.3 | 0.53768115942029 | 371 | 191 | 53.3 | 5 | 890 | 1993 | 1 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 1113 | 315 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 31315462 | 31315462 | PRJNA704949_P_NODE_18455_length_2070_cov_12.938149_g10342_i3 | PRJNA704949 | 18455 | 2070 | 12.938149 | 267.8196843 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 311 | 7.459999999999998e-96 | NR | MFA5457364.1 | 2053624 | g10342 | i3 | 45.7 | 0.539130434782609 | 372 | 188 | 53.3 | 7 | 890 | 1993 | 1 | 362 | MFA5457364.1 transposase [Synergistaceae bacterium] | diamond | 1116 | 311 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 32528686 | 32528686 | PRJNA704949_P_NODE_1151939_length_238_cov_1.761905_g1136603_i0 | PRJNA704949 | 1151939 | 238 | 1.761905 | 4.1933339 | Cloacibacillus | 508459 | Bacteria | Bacteria | 42.7 | 0.0337 | NR | WP_300265332.1 | 889794 | g1136603 | i0 | 41.9 | 1.08403361344538 | 43 | 25 | 54.2 | 0 | 164 | 36 | 63 | 105 | WP_300265332.1 ABC transporter substrate-binding protein [uncultured Cloacibacillus sp.] | diamond | 258 | 42.7 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | uncultured Cloacibacillus sp. |
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);;